Szabolcs learns GAE

[szabolcs-learns-gae]

Cloud SQL - Connection refused

Finally, I’m in that phase that I would like to use a database (currently I read the data from a file). I choose the Cloud SQL, MySQL combination. I registered an instance and it automatically added my project to the access table. After I copied the example java code into my DAO. Here I’m. When I run the app then I always get the Connection Refused error message. I haven’t found the solution yet.

Based on the description, it should be enough that the application id is in the access table. I think it is enough, because the GAE instance is in the same infrastructure than the database in PROD. Therefore, the connection string in java should be like a localhost connection. And the example code also contains a ‘jdbc:mysql://localhost/database?user=root’ connections string. I think it is approved. So, no more action is necessary.

‘These must be located in the same region.’ The AppEngine instance and the SQL instance are in the same region.

Now, I’m moving my project into a freshly created Google Web Application project. Because I have some issue about the project structure, I hope it will help.

[szabolcs-learns-gae]

Okey, I think, I have a problem! I have read that it is because I’m using the newest appengine.1.9.18. But I’m not sure. I have to check the maven global repository that is this version there.

Anyone has any idea how can I add this jar to the classpath and if the man try to resolve it is unnecessary. Hmmm but how can I say it to the maven that please do not try to resolve this jar?

hmmm too many questions. I’m diving into these....

log:

[INFO] Retrieving Google App Engine Java SDK from Maven [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal com.google.appengine:appengine-maven-plugin:1.9.18:update (default-cli) on project fitness--tracking: Execution default-cli of goal com.google.appengine:appengine-maven-plugin:1.9.18:update failed. NoSuchElementException -> [Help 1]

[szabolcs-learns-gae]

Add Spring to your static GAE project

I had a poor static game project. I would like to push some live into it. So there is the list what you have to add into your project.

The pom.xml:

<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <packaging>war</packaging> <version>1</version> <artifactId>asd</artifactId> <appengine.app.version>1</appengine.app.version> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> </properties> <maven>3.1.0</maven> </prerequisites> <!-- Compile/runtime dependencies --> <dependency> <groupId>com.google.appengine</groupId> <artifactId>appengine-api-1.0-sdk</artifactId> <version>1.9.18</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>2.5</version> <scope>provided</scope> </dependency> <dependency> <groupId>jstl</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <!-- Spring related Dependencies --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aop</artifactId> <version>4.1.2.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-beans</artifactId> <version>4.1.2.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>4.1.2.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-core</artifactId> <version>4.1.2.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-expression</artifactId> <version>4.1.2.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-web</artifactId> <version>4.1.2.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>4.1.2.RELEASE</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12-beta-1</version> <scope>test</scope> </dependency> <dependency> <groupId>org.mockito</groupId> <artifactId>mockito-all</artifactId> <version>1.9.5</version> <scope>test</scope> </dependency> <dependency> <groupId>com.google.appengine</groupId> <artifactId>appengine-testing</artifactId> <version>1.9.10</version> <scope>test</scope> </dependency> <dependency> <groupId>com.google.appengine</groupId> <artifactId>appengine-api-stubs</artifactId> <version>1.9.10</version> <scope>test</scope> </dependency> </dependencies> <!-- for hot reload of the web application --> <outputDirectory>${project.build.directory}/${project.build.finalName}/WEB-INF/classes</outputDirectory> <pluginManagement> <plugins> <plugin> <groupId>org.codehaus.mojo</groupId> <artifactId>versions-maven-plugin</artifactId> <version>2.1</version> <executions> <execution> <phase>compile</phase> <goals> <goal>display-dependency-updates</goal> <goal>display-plugin-updates</goal> </goals> </execution> </executions> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <version>3.1</version> <artifactId>maven-compiler-plugin</artifactId> <configuration> <source>1.7</source> <target>1.7</target> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-war-plugin</artifactId> <version>2.4</version> <configuration> <archiveClasses>true</archiveClasses> <webResources> <!-- in order to interpolate version from pom into appengine-web.xml --> <resource> <directory>${basedir}/src/main/webapp/WEB-INF</directory> <filtering>true</filtering> <targetPath>WEB-INF</targetPath> </resource> </webResources> </configuration> </plugin> <groupId>com.google.appengine</groupId> <artifactId>appengine-maven-plugin</artifactId> <version>1.9.18</version> <configuration> <enableJarClasses>false</enableJarClasses> <!-- Comment in the below snippet to bind to all IPs instead of just localhost --> <!-- address>0.0.0.0</address> <port>8080</port --> <!-- Comment in the below snippet to enable local debugging with a remove debugger like those included with Eclipse or IntelliJ --> <!-- jvmFlags> <jvmFlag>-agentlib:jdwp=transport=dt_socket,address=8000,server=y,suspend=n</jvmFlag> </jvmFlags --> </configuration> </plugin> </plugins> </pluginManagement> </build> </project> <modelVersion>4.0.0</modelVersion> <groupId>app</groupId> <properties> <prerequisites> <dependencies> <!-- Test Dependencies --> <build> <plugin>

The web.xml:

<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5"> <display-name>Fitness Tracking</display-name> <description></description> <distributable /> <session-config> <session-timeout>120</session-timeout> </session-config> <servlet> <servlet-name>sign</servlet-name> <servlet-class>hu.szigyi.fitnesstracking.SignGuestbookServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>sign</servlet-name> <url-pattern>/sign</url-pattern> </servlet-mapping> <welcome-file-list> <welcome-file>index.html</welcome-file> <welcome-file>index.htm</welcome-file> </welcome-file-list> <display-name>fitness--tracking</display-name> <welcome-file-list> <welcome-file>index.html</welcome-file> <welcome-file>index.htm</welcome-file> <welcome-file>index.jsp</welcome-file> <welcome-file>default.html</welcome-file> <welcome-file>default.htm</welcome-file> <welcome-file>default.jsp</welcome-file> </welcome-file-list> </web-app>

[szabolcs-learns-gae]

If you want to generate a new gae project

You can generate a basic project from archetypes. Here are the commands.

$mvn archetype:generate -Dfilter=com.google.appengine:

select the skeleton-archetype from the list.

[szabolcs-learns-gae]

Szabolcs learns Google AppEngine

The purpose of this blog is to documenting the baby steps how getting started with Google AppEngine. What is the basic structure of a gae project. How deploy your webapp to a local or to a remote gae.