Databases
StackOverflow2013
Postsdbo
POJava Google App Engine and Google Cloud SQL running on local dev server
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJava Google App Engine and Google Cloud SQL running on local dev server
    text
    copied!<p>I've been researching a solution to this all week and while there have been solutions to similar problems there are none that address and rectify this problem directly.</p> <p>I have created a web application project using Google App Engine and Google Cloud SQL. Running the GAE application using the eclipse Google plugin and a local MySQL server the application works great.</p> <p>When running the application from the command line using:-</p> <pre><code>sudo /opt/appengine-java-sdk-1.6.1/bin/dev_appserver.sh --jvm_flag=-Drdbms.server=local --jvm_flag=-Drdbms.driver=com.mysql.jdbc.Driver --jvm_flag=-Drdbms.url=jdbc:mysql://localhost:3306/twincam?user=root --port=7070 /home/ben/workspace/Twincam/war </code></pre> <p>I get the following:-</p> <pre><code>java.lang.IllegalStateException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at com.google.appengine.api.rdbms.dev.LocalRdbmsServiceLocalDriver.registerDriver(LocalRdbmsServiceLocalDriver.java:95) </code></pre> <p>I have the classpath referencing the mysql-connector.jar located in /Twincam/war/WEB-INF/lib/mysql-connector-java-5.1.18-bin.jar referenced by my user library as in the following .classpath file and directory structure :-</p> <pre><code> &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;classpath&gt; &lt;classpathentry kind="src" path="src"/&gt; &lt;classpathentry kind="con" path="com.google.appengine.eclipse.core.GAE_CONTAINER"/&gt; &lt;classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/&gt; &lt;classpathentry kind="lib" path="war/WEB-INF/lib/mysql-connector-java-5.1.18-bin.jar"/&gt; &lt;classpathentry kind="lib" path="war/WEB-INF/lib/gson-2.1-javadoc.jar"/&gt; &lt;classpathentry kind="lib" path="war/WEB-INF/lib/gson-2.1-sources.jar"/&gt; &lt;classpathentry kind="lib" path="war/WEB-INF/lib/gson-2.1.jar"/&gt; &lt;classpathentry kind="output" path="war/WEB-INF/classes"/&gt; &lt;/classpath&gt; </code></pre> <hr> <p><img src="https://i.stack.imgur.com/uY4PT.png" alt="enter image description here"></p> <p>Update: I checked file permissions and all are set at the default 664 so I'm confident that this is not the problem.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload