Re: sql statement works in local mysql dev instance, but not with google cloud sql

Thank you so much Shilendra and Rob.  Shilendra's advice to check my JDK was the solution,  I was using the default openjdk6 which comes with Ubuntu 12.04.  When I changed my Eclipse appengine project to use sun-jdk-6, the error went away.  Strange indeed.  Rob, I'll save your debugging approach for my next problem.  Thank you both!

Re: Very SLow - 500 error

On Thu, May 31, 2012 at 9:57 AM, Balamurugan Mahendran <b2m@a-cti.com> wrote:

My app was not able to connect to Backend from this morning, getting no response or 500 error. Is this known issue?

No issues that we're aware of.  Please provide more details:

- instance name

- app name

- stacktrace and/or error message including the time

Thanks,

Ken

Re: sql statement works in local mysql dev instance, but not with google cloud sql

Try logging '[' + someid + "]" and also the byte values of each

something like:

System.out.println("value=[" + someid + "]; bytes=" + Arrays.toString(someid.getBytes("UTF-8"));

Rob

On Thu, May 31, 2012 at 11:02 AM, elmor <eric@ejahn.net> wrote:

pstmt.setString(1, someid);

Re: sql statement works in local mysql dev instance, but not with google cloud sql

Okay, I'll work on a test case next, but I think I'm doing something very stupid and obviously wrong.  In my code above if I replace the code above

pstmt.setString(1, someid);

with

pstmt.setString(1, "3459");

Or any hard-coded String value for a number then it works fine with Google Cloud SQL.   Normally I get the value for someid from the http request method below, which has been working great, except for this small issue.

public String getRecord(@QueryParam("id") String id) {

    String someid = id;

...

  

Thanks again for any insight.  

El jueves, 31 de mayo de 2012 13:51:57 UTC-4, Rob escribió:

I've not seen this, a reproducible test case would help.

Re: sql statement works in local mysql dev instance, but not with google cloud sql

I've not seen this, a reproducible test case would help.

Rob

On Thu, May 31, 2012 at 9:52 AM, elmor <eric@ejahn.net> wrote:

When using the latest Appengine/Google plugin for Eclipse, I'm seeing a difference in how my local MySQL dev database and Google Cloud SQL behave.

I'm doing:

String stmt = "SELECT somefield FROM sometable WHERE somekey=?";

PreparedStatement pstmt = (PreparedStatement)conn.prepareStatement(stmt);

pstmt.setString(1, someid);

ResultSet rs = pstmt.executeQuery();

It runs locally, but the query returns no results when run from the cloud.  The databases are exactly the same and the query works when I use a static SQL statement in the code, instead of one that uses the setString() symbol replacement as above.  Has anyone seen this before, and if so, how should I change my code, so that it works on Google Cloud SQL as well as MySQL?  Thanks in advance!

Re: sql statement works in local mysql dev instance, but not with google cloud sql

Thursday, 31 of May 2012 13:36:19 UTC-4, Shilendra wrote:

which jdk you r use for

I'm using appengine-java-sdk-1.6.5

Re: sql statement works in local mysql dev instance, but not with google cloud sql

which jdk you r use for

On Thu, May 31, 2012 at 10:22 PM, elmor <eric@ejahn.net> wrote:

When using the latest Appengine/Google plugin for Eclipse, I'm seeing a difference in how my local MySQL dev database and Google Cloud SQL behave.

I'm doing:

String stmt = "SELECT somefield FROM sometable WHERE somekey=?";

PreparedStatement pstmt = (PreparedStatement)conn.prepareStatement(stmt);

pstmt.setString(1, someid);

ResultSet rs = pstmt.executeQuery();

It runs locally, but the query returns no results when run from the cloud.  The databases are exactly the same and the query works when I use a static SQL statement in the code, instead of one that uses the setString() symbol replacement as above.  Has anyone seen this before, and if so, how should I change my code, so that it works on Google Cloud SQL as well as MySQL?  Thanks in advance!

--
Regards & Thanks
Shilendra Sharma
+919891343808
shilendra.bk@gmail.com

Very SLow - 500 error

My app was not able to connect to Backend from this morning, getting no response or 500 error. Is this known issue?

Just saw memcached has issue on status page, but I do not see for CLoud Sql.

Thanks,

Bala

sql statement works in local mysql dev instance, but not with google cloud sql

When using the latest Appengine/Google plugin for Eclipse, I'm seeing a difference in how my local MySQL dev database and Google Cloud SQL behave.

I'm doing:

 

String stmt = "SELECT somefield FROM sometable WHERE somekey=?";

PreparedStatement pstmt = (PreparedStatement)conn.prepareStatement(stmt);

pstmt.setString(1, someid);

ResultSet rs = pstmt.executeQuery();

 

It runs locally, but the query returns no results when run from the cloud.  The databases are exactly the same and the query works when I use a static SQL statement in the code, instead of one that uses the setString() symbol replacement as above.  Has anyone seen this before, and if so, how should I change my code, so that it works on Google Cloud SQL as well as MySQL?  Thanks in advance!

Re: Pricing for Google Cloud SQL

Joe,

Is it expected in the future to be any free quota for open source projects?


Thanks

El dijous 10 de maig de 2012 18:51:20 UTC+2, Joe Faith va escriure:

Dear Cloud SQL Users

From June 12th 2012 use of the Google Cloud SQL service will be charged. Two billing plans are available: packages and per use.

More details about these plans are here https://developers.google.com/cloud-sql/docs/billing. If you still have questions then check the FAQs. Note that if you are just a light user of the service then opting for the per use billing plan will enable you to get started with a cloud hosted, multiply replicated, MySQL service for about a dollar per month.

What do I do now?
If you would like to use your Cloud SQL instances after June 12th 2012 you will need to enable billing for your projects before then by signing in to the Google APIs console (https://code.google.com/apis/console) and clicking the Billing tab. You can then choose (or change) the billing plan for your instances from the console. Your instances will not be available after June 12th if you do not enable billing beforehand. Note that usage will not be charged until June 12th, even if you enable billing before then.

Joe

--
Joe Faith | Product Manager | Google Cloud

This email is being sent to you because you are subscribed to the google-cloud-sql-announce or google-cloud-sql-discuss email list. To change your subscription, please visit https://groups.google.com/group/google-cloud-sql-discuss or https://groups.google.com/group/google-cloud-sql-announce

© 2012 Google Inc. 1600 Amphitheatre Parkway, Mountain View, CA 94043

You've received this mandatory service announcement email to update you about important changes to the Google Cloud SQL product.

El dijous 10 de maig de 2012 18:51:20 UTC+2, Joe Faith va escriure:

Dear Cloud SQL Users

From June 12th 2012 use of the Google Cloud SQL service will be charged. Two billing plans are available: packages and per use.

More details about these plans are here https://developers.google.com/cloud-sql/docs/billing. If you still have questions then check the FAQs. Note that if you are just a light user of the service then opting for the per use billing plan will enable you to get started with a cloud hosted, multiply replicated, MySQL service for about a dollar per month.

What do I do now?
If you would like to use your Cloud SQL instances after June 12th 2012 you will need to enable billing for your projects before then by signing in to the Google APIs console (https://code.google.com/apis/console) and clicking the Billing tab. You can then choose (or change) the billing plan for your instances from the console. Your instances will not be available after June 12th if you do not enable billing beforehand. Note that usage will not be charged until June 12th, even if you enable billing before then.

Joe

--
Joe Faith | Product Manager | Google Cloud

This email is being sent to you because you are subscribed to the google-cloud-sql-announce or google-cloud-sql-discuss email list. To change your subscription, please visit https://groups.google.com/group/google-cloud-sql-discuss or https://groups.google.com/group/google-cloud-sql-announce

© 2012 Google Inc. 1600 Amphitheatre Parkway, Mountain View, CA 94043

You've received this mandatory service announcement email to update you about important changes to the Google Cloud SQL product.

Re: You have reached the maximum number of authorized applications for this instance

For D1 instance, the max limit is 1. You have to upgrade to D2 or above to add authorize more applications.

- Amit

On Tue, May 29, 2012 at 9:11 PM, Lucemia Chen <lucemia@gmail.com> wrote:

I think we can have three authorized applications for each instance previously. 

After I create a new instance today, I try to add the second authorized application. I got this error message.

Does CloudSQL change it's rule?

You have reached the maximum number of authorized applications for this instance

You have reached the maximum number of authorized applications for this instance

I think we can have three authorized applications for each instance previously. 

After I create a new instance today, I try to add the second authorized application. I got this error message.

Does CloudSQL change it's rule?

You have reached the maximum number of authorized applications for this instance

Re: A quick question about "Check missing values in multiple fields"

On Mon, May 28, 2012 at 5:15 AM, Kenneth Zhang <kennethrrr@gmail.com> wrote:

Hi, I have a question about using SQL to check the missing values of over 400 fields (PostgreSQL database). I really don't want to run a select sentence for each field. I wonder if there is a more efficient way to do it? Your help will be appreciated!  

This seems like a good question for stackoverflow.com.  Tag it with mysql.

Ken

A quick question about "Check missing values in multiple fields"

Hi, I have a question about using SQL to check the missing values of over 400 fields (PostgreSQL database). I really don't want to run a select sentence for each field. I wonder if there is a more efficient way to do it? Your help will be appreciated!  

Re: Cloud SQL Python Driver Errors Change

Very pleased to see this :D

On Thursday, May 24, 2012 11:24:33 AM UTC-7, Joe Faith wrote:

As from today there will be a slight change in the behavior of the Cloud SQL Python DBAPI driver.

All errors from the database will be thrown as a DatabaseError or one of the subclasses. In particular an "Invalid connection id." error will become a DatabaseError rather than the subclass of OperationalError. 

Please ensure your code is catching DatabaseError and not just OperationalError.

thanks

-- 

Joe Faith | Product Manager | Google Cloud

Re: Can add a credit card for the project

Hi Patrice

I'll get back to you off-thread.

In general, if there are billing problems with the service then the email you receive from Google Checkout should include an email link for reporting problems.

J

On Wed, May 23, 2012 at 3:50 PM, Patrice De Saint Steban <patrice@desaintsteban.fr> wrote:

I'm trying to readd the same credit card, but the invoices is canceled.

There are no error message, but we receive an email after that say :

Google canceled your order. You have not been debited.
Reason: Other (provide description below)
  Order Date: May 14, 2012 3:44 p.m. UTC +02:00
  Google Order # 510774827059538 - Google Inc. Command. No07961592113451586495.1073277527.243476
  Delivery status Qty Item Price
   Items canceled a Google APIs - Outstanding balance for project: $ 0.00https://code.google.com/apis/console/shp?frag=project:121196761127:billing
Tax: $ 0.00
Total: $ 0.00
Order canceled - Your card has not been charged.

Patrice de Saint Steban

On Thu, May 24, 2012 at 12:27 AM, Tony Tseng <ttt@google.com> wrote:

Hi,

Did you mean to say that google wallet won't let you use a different credit card? Is there any error message?

On Wed, May 23, 2012 at 3:21 PM, Patrice De Saint Steban <patou.de.saint.steban@gmail.com> wrote:

I have a Google API project for use the Cloud SQL Database. 

I had already added a credit card (personal credit card) for activate the Cloud Storage with the free 5 GO.

As the Cloud SQL will become paid version, and I want to change to credit card of the company. so I cancel the first credit card for add the new company credit card.

But the command is canceled and we don't know why ?

We have a $0 invoice, is it the problem ?

How can we add the credit card for activate the paid version of Google Cloud SQL on the 12th of June.

Cordially

Patrice

--
Joe Faith | Product Manager | Google Cloud

Cloud SQL Python Driver Errors Change

As from today there will be a slight change in the behavior of the Cloud SQL Python DBAPI driver.

All errors from the database will be thrown as a DatabaseError or one of the subclasses. In particular an "Invalid connection id." error will become a DatabaseError rather than the subclass of OperationalError. 

Please ensure your code is catching DatabaseError and not just OperationalError.

thanks

-- 

Joe Faith | Product Manager | Google Cloud

Re: Can add a credit card for the project

But, for add the new credit card, we disable the billing.
And we can't add the new credit card.

Le 24 mai 2012 01:09, "Tony Tseng" <ttt@google.com> a écrit :

As long as billing is enabled in your API console project, your Google Cloud SQL instance will not be disabled on June 12th. 

On Wed, May 23, 2012 at 3:50 PM, Patrice De Saint Steban <patrice@desaintsteban.fr> wrote:

I'm trying to readd the same credit card, but the invoices is canceled.

There are no error message, but we receive an email after that say :

Google canceled your order. You have not been debited.
Reason: Other (provide description below)
  Order Date: May 14, 2012 3:44 p.m. UTC +02:00
  Google Order # 510774827059538 - Google Inc. Command. No07961592113451586495.1073277527.243476
  Delivery status Qty Item Price
   Items canceled a Google APIs - Outstanding balance for project: $ 0.00https://code.google.com/apis/console/shp?frag=project:121196761127:billing
Tax: $ 0.00
Total: $ 0.00
Order canceled - Your card has not been charged.

Patrice de Saint Steban

On Thu, May 24, 2012 at 12:27 AM, Tony Tseng <ttt@google.com> wrote:

Hi,

Did you mean to say that google wallet won't let you use a different credit card? Is there any error message?

On Wed, May 23, 2012 at 3:21 PM, Patrice De Saint Steban <patou.de.saint.steban@gmail.com> wrote:

I have a Google API project for use the Cloud SQL Database. 

I had already added a credit card (personal credit card) for activate the Cloud Storage with the free 5 GO.

As the Cloud SQL will become paid version, and I want to change to credit card of the company. so I cancel the first credit card for add the new company credit card.

But the command is canceled and we don't know why ?

We have a $0 invoice, is it the problem ?

How can we add the credit card for activate the paid version of Google Cloud SQL on the 12th of June.

Cordially

Patrice

Re: Can add a credit card for the project

As long as billing is enabled in your API console project, your Google Cloud SQL instance will not be disabled on June 12th. 

On Wed, May 23, 2012 at 3:50 PM, Patrice De Saint Steban <patrice@desaintsteban.fr> wrote:

I'm trying to readd the same credit card, but the invoices is canceled.

There are no error message, but we receive an email after that say :

Google canceled your order. You have not been debited.
Reason: Other (provide description below)
  Order Date: May 14, 2012 3:44 p.m. UTC +02:00
  Google Order # 510774827059538 - Google Inc. Command. No07961592113451586495.1073277527.243476
  Delivery status Qty Item Price
   Items canceled a Google APIs - Outstanding balance for project: $ 0.00https://code.google.com/apis/console/shp?frag=project:121196761127:billing
Tax: $ 0.00
Total: $ 0.00
Order canceled - Your card has not been charged.

Patrice de Saint Steban

On Thu, May 24, 2012 at 12:27 AM, Tony Tseng <ttt@google.com> wrote:

Hi,

Did you mean to say that google wallet won't let you use a different credit card? Is there any error message?

On Wed, May 23, 2012 at 3:21 PM, Patrice De Saint Steban <patou.de.saint.steban@gmail.com> wrote:

I have a Google API project for use the Cloud SQL Database. 

I had already added a credit card (personal credit card) for activate the Cloud Storage with the free 5 GO.

As the Cloud SQL will become paid version, and I want to change to credit card of the company. so I cancel the first credit card for add the new company credit card.

But the command is canceled and we don't know why ?

We have a $0 invoice, is it the problem ?

How can we add the credit card for activate the paid version of Google Cloud SQL on the 12th of June.

Cordially

Patrice

Re: Partitions not supported?

great, thanks!

Rob

On Wed, May 23, 2012 at 3:57 PM, Mauricio Aristizabal <aristim@gmail.com> wrote:

Thanks Rob for the prompt response.  Issue logged:

http://code.google.com/p/googlecloudsql/issues/detail?id=38

Re: Partitions not supported?

Thanks Rob for the prompt response.  Issue logged:

http://code.google.com/p/googlecloudsql/issues/detail?id=38

Re: Can add a credit card for the project

I'm trying to readd the same credit card, but the invoices is canceled.

There are no error message, but we receive an email after that say :

Google canceled your order. You have not been debited.
Reason: Other (provide description below)
  Order Date: May 14, 2012 3:44 p.m. UTC +02:00
  Google Order # 510774827059538 - Google Inc. Command. No07961592113451586495.1073277527.243476
  Delivery status Qty Item Price
   Items canceled a Google APIs - Outstanding balance for project: $ 0.00https://code.google.com/apis/console/shp?frag=project:121196761127:billing
Tax: $ 0.00
Total: $ 0.00
Order canceled - Your card has not been charged.

Patrice de Saint Steban

On Thu, May 24, 2012 at 12:27 AM, Tony Tseng <ttt@google.com> wrote:

Hi,

Did you mean to say that google wallet won't let you use a different credit card? Is there any error message?

On Wed, May 23, 2012 at 3:21 PM, Patrice De Saint Steban <patou.de.saint.steban@gmail.com> wrote:

I have a Google API project for use the Cloud SQL Database. 

I had already added a credit card (personal credit card) for activate the Cloud Storage with the free 5 GO.

As the Cloud SQL will become paid version, and I want to change to credit card of the company. so I cancel the first credit card for add the new company credit card.

But the command is canceled and we don't know why ?

We have a $0 invoice, is it the problem ?

How can we add the credit card for activate the paid version of Google Cloud SQL on the 12th of June.

Cordially

Patrice

Re: Can add a credit card for the project

Hi,

Did you mean to say that google wallet won't let you use a different credit card? Is there any error message?

On Wed, May 23, 2012 at 3:21 PM, Patrice De Saint Steban <patou.de.saint.steban@gmail.com> wrote:

I have a Google API project for use the Cloud SQL Database. 

I had already added a credit card (personal credit card) for activate the Cloud Storage with the free 5 GO.

As the Cloud SQL will become paid version, and I want to change to credit card of the company. so I cancel the first credit card for add the new company credit card.

But the command is canceled and we don't know why ?

We have a $0 invoice, is it the problem ?

How can we add the credit card for activate the paid version of Google Cloud SQL on the 12th of June.

Cordially

Patrice

Can add a credit card for the project

I have a Google API project for use the Cloud SQL Database. 

I had already added a credit card (personal credit card) for activate the Cloud Storage with the free 5 GO.

As the Cloud SQL will become paid version, and I want to change to credit card of the company. so I cancel the first credit card for add the new company credit card.

But the command is canceled and we don't know why ?

We have a $0 invoice, is it the problem ?

How can we add the credit card for activate the paid version of Google Cloud SQL on the 12th of June.

Cordially

Patrice

Re: Partitions not supported?

And our tracker is: 

http://code.google.com/p/googlecloudsql/issues/list

Thanks!

Rob

On Wed, May 23, 2012 at 2:24 PM, Rob Clevenger <rcleveng@google.com> wrote:

Hi,

Feel free to log an issue in our tracker, I'm not sure why it's not enabled.

Rob

On Wed, May 23, 2012 at 12:59 PM, Mauricio Aristizabal <aristim@gmail.com> wrote:

I asked this about a month ago and got no response.  I see googlers are very active now in this group, so hopefully they can address this.

Will partitioning not be supported?  When I try to create a table like so:

CREATE TABLE `x` (

  `x` int(11) unsigned NOT NULL,

  `y` varchar(255) NOT NULL,

  PRIMARY KEY `pk_x` (`x`, `y`),

  KEY `idx_y` (`y`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

PARTITION BY KEY (y)

PARTITIONS 100;

I get 

Error 1290: The MySQL server is running with the --skip-partition option so it cannot execute this statement 

I hope this is only temporary, otherwise it will really hamstring my app as it grows.  Also, this isn't documented as one of the mysql commands not supported and it makes me wonder how many other things in CloudSQL are going to be non-standard.

thanks in advance.

-Mauricio

Re: Partitions not supported?

Hi,

Feel free to log an issue in our tracker, I'm not sure why it's not enabled.

Rob

On Wed, May 23, 2012 at 12:59 PM, Mauricio Aristizabal <aristim@gmail.com> wrote:

I asked this about a month ago and got no response.  I see googlers are very active now in this group, so hopefully they can address this.

Will partitioning not be supported?  When I try to create a table like so:

CREATE TABLE `x` (

  `x` int(11) unsigned NOT NULL,

  `y` varchar(255) NOT NULL,

  PRIMARY KEY `pk_x` (`x`, `y`),

  KEY `idx_y` (`y`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

PARTITION BY KEY (y)

PARTITIONS 100;

I get 

Error 1290: The MySQL server is running with the --skip-partition option so it cannot execute this statement 

I hope this is only temporary, otherwise it will really hamstring my app as it grows.  Also, this isn't documented as one of the mysql commands not supported and it makes me wonder how many other things in CloudSQL are going to be non-standard.

thanks in advance.

-Mauricio

Re: Uploading error from very small test mysql.sql dump file

I think i figured out that if i just run small portions of my larger
dump.sql file, the data imports just fine. so, i'm not too worried
about the initial errors when trying to import the entire database via
the gui on the Google Cloud SQL site. At this point, all appears well
for me.

On May 23, 1:54 pm, jca <jason.and...@mnhs.org> wrote:
> greetings, i'm just trying to get started with this stuff.  each step
> seems to be an uphill battle, but i'm finally at a point where i can
> attempt to create some sql data in Google Cloud SQL...and alas,
> another wall.
>
> i have a very small mysql dump file called videopostcard.sql in my
> bucket called gs://mhs.  i've tried and failed to upload several
> larger dump files but this file is very small and simple, yet still
> throws same log error upon upload attempt via Actions->Import button
> on GCSql page.  Successfully followed all of these instructions:https://developers.google.com/cloud-sql/docs/import_export#migrate
>
> the log always shows something like:
> Failed to import gs://mhs/videopostcard.sql: An unknown problem
> occurred (ERROR_RDBMS)

Partitions not supported?

I asked this about a month ago and got no response.  I see googlers are very active now in this group, so hopefully they can address this.

Will partitioning not be supported?  When I try to create a table like so:

CREATE TABLE `x` (

  `x` int(11) unsigned NOT NULL,

  `y` varchar(255) NOT NULL,

  PRIMARY KEY `pk_x` (`x`, `y`),

  KEY `idx_y` (`y`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

PARTITION BY KEY (y)

PARTITIONS 100;

I get 

Error 1290: The MySQL server is running with the --skip-partition option so it cannot execute this statement 

I hope this is only temporary, otherwise it will really hamstring my app as it grows.  Also, this isn't documented as one of the mysql commands not supported and it makes me wonder how many other things in CloudSQL are going to be non-standard.

thanks in advance.

-Mauricio

Uploading error from very small test mysql.sql dump file

greetings, i'm just trying to get started with this stuff. each step
seems to be an uphill battle, but i'm finally at a point where i can
attempt to create some sql data in Google Cloud SQL...and alas,
another wall.

i have a very small mysql dump file called videopostcard.sql in my
bucket called gs://mhs. i've tried and failed to upload several
larger dump files but this file is very small and simple, yet still
throws same log error upon upload attempt via Actions->Import button
on GCSql page. Successfully followed all of these instructions:
https://developers.google.com/cloud-sql/docs/import_export#migrate

the log always shows something like:
Failed to import gs://mhs/videopostcard.sql: An unknown problem
occurred (ERROR_RDBMS)

Re: Running Data Nucleus JDO 3.0.x with Google Cloud SQL

Well, I've searched high and low for such a flag and haven't found
it.

I've managed to convert all my queries to JDOQL, but there is one that
I would still like to use SQL, as there is some optimization that I
can't seem to accomplish with JDOQL.


On May 22, 8:39 pm, Rob Clevenger <rclev...@google.com> wrote:
> That's odd, I wonder if there's a flag or setting to disable using a new
> thread for this...
>
> Rob
>
>
>
>
>
>
>
> On Tue, Apr 24, 2012 at 10:09 AM, Alan <alanswee...@gmail.com> wrote:
> > Thanks to this Thread, I am successfully using DataNucleus JDO with
> > Google Cloud.
>
> > I am having one problem:
>
> > If I try to use SQL directly for a query:
> > Query query = pm.newQuery("javax.jdo.query.SQL", querySQL);
>
> > DataNucleus tries to spawn a Thread to execute the query.
>
> > Caused by: java.security.AccessControlException: access denied
> > (java.lang.RuntimePermission modifyThreadGroup)
> >        at
>
> > java.security.AccessControlContext.checkPermission(AccessControlContext.java:
> > 323)
> >        at
> > java.security.AccessController.checkPermission(AccessController.java:
> > 546)
> >        at java.lang.SecurityManager.checkPermission(SecurityManager.java:
> > 532)
> >        at com.google.appengine.tools.development.DevAppServerFactory
> > $CustomSecurityManager.checkPermission(DevAppServerFactory.java:252)
> >        at com.google.appengine.tools.development.DevAppServerFactory
> > $CustomSecurityManager.checkAccess(DevAppServerFactory.java:277)
> >        at java.lang.ThreadGroup.checkAccess(ThreadGroup.java:299)
> >        at java.lang.Thread.init(Thread.java:332)
> >        at java.lang.Thread.<init>(Thread.java:391)
> >        at org.datanucleus.store.query.Query.performExecuteTask(Query.java:
> > 1669)
> >        at
> > org.datanucleus.store.rdbms.query.SQLQuery.performExecute(SQLQuery.java:
> > 259)
> >        at org.datanucleus.store.query.Query.executeQuery(Query.java:1489)
> >        at
>
> > org.datanucleus.store.query.AbstractSQLQuery.executeWithArray(AbstractSQLQuery.java:
> > 287)
> >        at org.datanucleus.store.query.Query.execute(Query.java:1344)
> >        at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:221)
>
> > This is not a problem with the default JDOQL queries.
>
> > Anyone have a solution for this?  I have one query that I need to use
> > mysql SQL with that won't work with JDOQL.
>
> > On Mar 26, 9:50 am, Feliks Khantsis <doom...@gmail.com> wrote:
> > > Yes, you must download datanucleus access platform 1.1.5 rdbms, and add
> > the
> > > datanucleus-rdbms-1.1.5.jar to your classpath
>
> > > On Friday, March 2, 2012 4:51:03 PM UTC+2, Christoph wrote:
>
> > > > Dear Study,
>
> > > > thank you for posting your jdoconfig.xml. However I run into the
> > problem
> > > > that the code doesn't run on Google App Engine. It creates the
> > following
> > > > error message:
>
> > > > Caused by: javax.jdo.JDOFatalUserException: No available StoreManager
> > found for the datastore URL key "jdbc". Please make sure you have all
> > relevant plugins in the CLASSPATH (e.g datanucleus-rdbms?,
> > datanucleus-db4o?), and consider setting the persistence property
> > "datanucleus.storeManagerType" to the type of store you are using e.g
> > rdbms, db4o
> > > > NestedThrowables:
> > > > org.datanucleus.exceptions.NucleusUserException: No available
> > StoreManager found for the datastore URL key "jdbc". Please make sure you
> > have all relevant plugins in the CLASSPATH (e.g datanucleus-rdbms?,
> > datanucleus-db4o?), and consider setting the persistence property
> > "datanucleus.storeManagerType" to the type of store you are using e.g
> > rdbms, db4o
>
> > > > However directly accessing the database via JDBC and SQL works!
>
> > > > So it seems that something for datanucleus is missing within the app
> > > > engine libraries. I added no special libraries and used version 1.6.3.
>
> > > > Thank you very much for your help in advance.
>
> > > > Christoph
>
> > > > Am Mittwoch, 26. Oktober 2011 18:27:02 UTC+2 schrieb Study:
>
> > > >> You can try my jdoconfig.xml
>
> > > >> it works with built-in GAE JDO without using newer version JDO
>
> > > >> <?xml version="1.0" encoding="utf-8"?>
> > > >> <jdoconfig xmlns="http://java.sun.com/xml/ns/jdo/jdoconfig"
> > > >>    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > > >>    xsi:noNamespaceSchemaLocation="http://java.sun.com/xml/ns/jdo/
> > > >> jdoconfig">
>
> > > >>    <persistence-manager-factory name="transactions-optional">
> > > >>        <property name="javax.jdo.PersistenceManagerFactoryClass"
> > > >>            value="org.datanucleus.jdo.JDOPersistenceManagerFactory"/>
> > > >>        <property name="javax.jdo.option.ConnectionDriverName"
> > > >> value="com.google.appengine.api.rdbms.AppEngineDriver"/>
> > > >>        <property name="javax.jdo.option.ConnectionURL"
> > > >> value="jdbc:google:rdbms://instance_name/database_name"/>
> > > >>        <property name="javax.jdo.option.NontransactionalRead"
> > > >> value="true"/>
> > > >>        <property name="javax.jdo.option.NontransactionalWrite"
> > > >> value="true"/>
> > > >>        <property name="javax.jdo.option.RetainValues" value="true"/>
>
> > > >>        <property name="datanucleus.metadata.validate" value="false"/>
> > > >>        <property name="datanucleus.autoCreateSchema" value="true"/>
> > > >>        <property name="datanucleus.validateTables" value="false"/>
> > > >>        <property name="datanucleus.validateConstraints" value="false"/
>
> > > >>        <property name="datanucleus.appengine.autoCreateDatastoreTxns"
> > > >> value="true"/>
> > > >>    </persistence-manager-factory>
> > > >> </jdoconfig>
>
> > > >> On Oct 24, 5:11 am, J N <jngcl...@gmail.com> wrote:
> > > >> > Hi
> > > >> > I am trying to figure out how to run Data Nucleus with Google Cloud
> > > >> > SQL. I am running into trouble due to class conflicts with the built
> > > >> > in app-engine JDO (which also uses data nucleus for persistence to
> > the
> > > >> > google data store.
>
> > > >> > Has anyone of you tried this. I am hoping that there is a way to
> > make
> > > >> > this work. If you have worked on this  I will appreciate it very
> > much
> > > >> > if you share your experience. A working example would obviously be
> > the
> > > >> > best thing :-) Thanks in advance.
>
> > > >> > Regards
>
> > > > Am Mittwoch, 26. Oktober 2011 18:27:02 UTC+2 schrieb Study:
>
> > > >> You can try my jdoconfig.xml
>
> > > >> it works with built-in GAE JDO without using newer version JDO
>
> > > >> <?xml version="1.0" encoding="utf-8"?>
> > > >> <jdoconfig xmlns="http://java.sun.com/xml/ns/jdo/jdoconfig"
> > > >>    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > > >>    xsi:noNamespaceSchemaLocation="http://java.sun.com/xml/ns/jdo/
> > > >> jdoconfig">
>
> > > >>    <persistence-manager-factory name="transactions-optional">
> > > >>        <property name="javax.jdo.PersistenceManagerFactoryClass"
> > > >>            value="org.datanucleus.jdo.JDOPersistenceManagerFactory"/>
> > > >>        <property name="javax.jdo.option.ConnectionDriverName"
> > > >> value="com.google.appengine.api.rdbms.AppEngineDriver"/>
> > > >>        <property name="javax.jdo.option.ConnectionURL"
> > > >> value="jdbc:google:rdbms://instance_name/database_name"/>
> > > >>        <property name="javax.jdo.option.NontransactionalRead"
> > > >> value="true"/>
> > > >>        <property name="javax.jdo.option.NontransactionalWrite"
> > > >> value="true"/>
> > > >>        <property name="javax.jdo.option.RetainValues" value="true"/>
>
> > > >>        <property name="datanucleus.metadata.validate" value="false"/>
> > > >>        <property name="datanucleus.autoCreateSchema" value="true"/>
> > > >>        <property name="datanucleus.validateTables" value="false"/>
> > > >>        <property name="datanucleus.validateConstraints" value="false"/
>
> > > >>        <property name="datanucleus.appengine.autoCreateDatastoreTxns"
> > > >> value="true"/>
> > > >>    </persistence-manager-factory>
> > > >> </jdoconfig>
>
> > > >> On Oct 24, 5:11 am, J N <jngcl...@gmail.com> wrote:
> > > >> > Hi
> > > >> > I am trying to figure out how to run Data Nucleus with Google Cloud
> > > >> > SQL. I am running into trouble due to class conflicts with the built
> > > >> > in app-engine JDO (which also uses data nucleus for persistence to
> > the
> > > >> > google data store.
>
> > > >> > Has anyone of you tried this. I am hoping that there is a way to
> > make
> > > >> > this work. If you have worked on this  I will appreciate it very
> > much
> > > >> > if you share your experience. A working example would obviously be
> > the
> > > >> > best thing :-) Thanks in advance.
>
> > > >> > Regards
>
> > > > Am Mittwoch, 26. Oktober 2011 18:27:02 UTC+2 schrieb Study:
>
> > > >> You can try my jdoconfig.xml
>
> > > >> it works with built-in GAE JDO without using newer version JDO
>
> > > >> <?xml version="1.0" encoding="utf-8"?>
> > > >> <jdoconfig xmlns="http://java.sun.com/xml/ns/jdo/jdoconfig"
> > > >>    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > > >>    xsi:noNamespaceSchemaLocation="http://java.sun.com/xml/ns/jdo/
> > > >> jdoconfig">
>
> > > >>    <persistence-manager-factory name="transactions-optional">
> > > >>        <property name="javax.jdo.PersistenceManagerFactoryClass"
> > > >>            value="org.datanucleus.jdo.JDOPersistenceManagerFactory"/>
> > > >>        <property name="javax.jdo.option.ConnectionDriverName"
> > > >> value="com.google.appengine.api.rdbms.AppEngineDriver"/>
> > > >>        <property name="javax.jdo.option.ConnectionURL"
> > > >> value="jdbc:google:rdbms://instance_name/database_name"/>
> > > >>        <property name="javax.jdo.option.NontransactionalRead"
> > > >> value="true"/>
> > > >>        <property name="javax.jdo.option.NontransactionalWrite"
> > > >> value="true"/>
> > > >>        <property name="javax.jdo.option.RetainValues" value="true"/>
>
> > > >>        <property name="datanucleus.metadata.validate" value="false"/>
> > > >>        <property name="datanucleus.autoCreateSchema" value="true"/>
> > > >>        <property name="datanucleus.validateTables" value="false"/>
> > > >>        <property name="datanucleus.validateConstraints" value="false"/
>
> > > >>        <property
>
> ...
>
> read more »