Tuesday, February 12, 2013

Re: Domain specific instance not connecting to Google Cloud SQL using Eclipse Java

It sounds like you need to add the properties to your run configuration to have the devapp server proxy the connection to a local mysql install. The command line arguments to use are mentioned in the document referenced.

Thanks,

Rob

On Mon, Feb 11, 2013 at 9:18 PM, Rob O <robo.owens@gmail.com> wrote:
Exception: Caused by: java.lang.IllegalStateException: System property rdbms.driver must be set.

Using example JDBC code from:
https://developers.google.com/appengine/docs/java/cloud-sql/developers-guide#using_the_java_development_server

Granted App Engine application access to Google Cloud SQL instance:
domain.com:project:instancedb

Using Eclipse Indigo Service Release 2, Mac OS X cocoa x86_64 java runtime 1.6.0, App Engine 1.7.4

Created database as
    c = DriverManager.getConnection("jdbc:google:rdbms://domain.com:project:instancedb/instancedb");
Using SQL prompt in Google API Console am able to access database, create tables and insert or select data.

RESULTS
The page at 127.0.0.1:8888 says: Exception: 500 The call failed on the server; see server log for details
Caused by: java.lang.IllegalStateException: System property rdbms.driver must be set.
    at com.google.appengine.api.rdbms.dev.LocalRdbmsServiceLocalDriver.registerDriver(LocalRdbmsServiceLocalDriver.java:80)
…..
.server.Rating_DB_Connect.insertRating(DB_Connect.java:26)
Where DB_Connect.java:26 is:
    c = DriverManager.getConnection("jdbc:google:rdbms://domain.com:project:instancedb/instancedb");


--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

No comments:

Post a Comment