May 2013

Friday, May 31, 2013

Re: Error 0: Unable to execute statement

We are working on making that better. :-)

-- Razvan ME

On Fri, May 31, 2013 at 9:39 AM, Martin Nonnenmacher <nonnenmacher@halfreal.de> wrote:

Sorry, I just found out that the instance is working, but the error report is insufficient. My test-queries queried an unindexed column in a table with several million entries and I guess the request just took too long or something like that. If I query indexed columns everything works fine. However, I think it would be very helpful to get the real error message (timeout, out of memory, something like that) instead of an unexpected error.

--
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.

Re: Error 0: Unable to execute statement

Sorry, I just found out that the instance is working, but the error report is insufficient. My test-queries queried an unindexed column in a table with several million entries and I guess the request just took too long or something like that. If I query indexed columns everything works fine. However, I think it would be very helpful to get the real error message (timeout, out of memory, something like that) instead of an unexpected error.

Error 0: Unable to execute statement

Hi,

I can't access the data in my Cloud SQL instance anymore. When I try to run a query in the SQL Prompt after a while those errors appear:

An unexpected error has occurred. We're looking into it.
Error 0: Unable to execute statement

The database worked for some days and suddenly stopped working for my App Engine application and from the SQL Prompt. Please contact me, because I don't want to post my instance name publicly.

Sunday, May 26, 2013

iPhone App - 20/20 Vision

iPhone App - 20/20 Vision - http://2020visioniphoneapp4.weebly.com

--
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.

Thursday, May 23, 2013

Re: Seems quite expensive to host Wordpress on AppEngine, with Google Cloud SQL

Its worth pointing out that for $10.80/m you get your own dedicated database, replicated in multiple availability zones, and a very highly scalable application server. Users should bear this in mind when working out if Google App Engine + Cloud SQL is the right solution for them

On Thu, May 23, 2013 at 6:02 PM, Ionel Roiban <apache.servers@gmail.com> wrote:

At Google I/O it was announced PHP as the latest supported runtime for Google App Engine. This is especially useful for PHP developers who want the automatic scalability. And, yes, WordPress can be ported over to work with Google App Engine: https://developers.google.com/appengine/articles/wordpress

Looking at the billing model it seems quite expensive to host a single Wordpress Website on Google's App Engine.

If we go by the package billing plans it will cost at least $11.16/month for a very light Wordpress instance and more than $45.26/month for anything above.

Would be interesting to run a live Wordpress blog and find out how expensive it will get with the "Per Use Billing Plan". While on this plan, just by running the cheapest D0 Database Instance (0.125GB RAM) ($0.025 per hour) it will cost $18/month. (No, your Wordpress site won't go without any visits for an 1 hour interval, which is required to put the database to sleep and avoid charging).

https://developers.google.com/cloud-sql/docs/billing

As soon as PHP runtime for AppEngine becomes available for general use, many Wordpress aficionados will find out the truth about this over-hyped solution.

I so much hope that someone can prove me wrong.

Good luck!

--
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.

--
Joe Faith | Product Manager | Google Cloud

Seems quite expensive to host Wordpress on AppEngine, with Google Cloud SQL

At Google I/O it was announced PHP as the latest supported runtime for Google App Engine. This is especially useful for PHP developers who want the automatic scalability. And, yes, WordPress can be ported over to work with Google App Engine: https://developers.google.com/appengine/articles/wordpress

Looking at the billing model it seems quite expensive to host a single Wordpress Website on Google's App Engine.

If we go by the package billing plans it will cost at least $11.16/month for a very light Wordpress instance and more than $45.26/month for anything above.

Would be interesting to run a live Wordpress blog and find out how expensive it will get with the "Per Use Billing Plan". While on this plan, just by running the cheapest D0 Database Instance (0.125GB RAM) ($0.025 per hour) it will cost $18/month. (No, your Wordpress site won't go without any visits for an 1 hour interval, which is required to put the database to sleep and avoid charging).

https://developers.google.com/cloud-sql/docs/billing

As soon as PHP runtime for AppEngine becomes available for general use, many Wordpress aficionados will find out the truth about this over-hyped solution.

I so much hope that someone can prove me wrong.

Good luck!

Seems quite expensive to host Wordpress on AppEngine, with Google Cloud SQL

At Google I/O, it was announced PHP as the latest supported runtime for Google App Engine. This is especially useful for PHP developers who want the automatic scalability. And, yes, WordPress be ported over to work with Google App Engine!

https://developers.google.com/appengine/articles/wordpress

Re: How to create new instance for existing project?

Thanks..

On Thursday, May 23, 2013 1:55:34 PM UTC+5:30, Razvan Musaloiu-E. wrote:

The instructions on how to create a new Cloud SQL instance are here:

https://developers.google.com/cloud-sql/docs/instances#request_a_sql_service_instance

-- Razvan ME

On Wed, May 22, 2013 at 11:20 PM, dhannababu nyros <dhanaba...@gmail.com> wrote:

I am new to google app engine.I am try to deploy the django CRUD application in google app engine.Is it necessary to create an instance for django CRUD application ?. I have enabled the billing for existing project. But how to create the instance. Please solve my problem. Thanks..
--
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.

Re: How to create new instance for existing project?

The instructions on how to create a new Cloud SQL instance are here:

https://developers.google.com/cloud-sql/docs/instances#request_a_sql_service_instance

-- Razvan ME

On Wed, May 22, 2013 at 11:20 PM, dhannababu nyros <dhanababu.nyros@gmail.com> wrote:

I am new to google app engine.I am try to deploy the django CRUD application in google app engine.Is it necessary to create an instance for django CRUD application ?. I have enabled the billing for existing project. But how to create the instance. Please solve my problem. Thanks..
--
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.

Wednesday, May 22, 2013

How to create new instance for existing project?

I am new to google app engine.I am try to deploy the django CRUD application in google app engine.Is it necessary to create an instance for django CRUD application ?. I have enabled the billing for existing project. But how to create the instance. Please solve my problem. Thanks..

Monday, May 20, 2013

Re: Google cloud Sql with appinventor

Thank you for your suggestion. Easy scaling is actually the main consideration in the solution I am working on. Will go through the mobile solutions on Google cloud and revert. Thank you all.

On Monday, May 20, 2013 8:16:26 PM UTC+1, Joe Faith wrote:

You can get more help building mobile solutions on Google Cloud here:

https://cloud.google.com/solutions/mobile

j

On Mon, May 20, 2013 at 8:29 AM, Tony Tseng <t...@google.com> wrote:

Do you mean http://www.appinventor.org/? That looks like a framework for building android applications. Our current recommendation is to use an App Engine application to proxy/transform the data to Cloud SQL.

On Sun, May 19, 2013 at 11:39 PM, mohammed ajala <hotor...@gmail.com> wrote:

Hello,

I just want to know if its possible and how to implement Appinventor with Google cloud sql.

Thank you.

--
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.

--
Joe Faith | Product Manager | Google Cloud

Re: Google cloud Sql with appinventor

You can get more help building mobile solutions on Google Cloud here:

https://cloud.google.com/solutions/mobile

On Mon, May 20, 2013 at 8:29 AM, Tony Tseng <ttt@google.com> wrote:

Do you mean http://www.appinventor.org/? That looks like a framework for building android applications. Our current recommendation is to use an App Engine application to proxy/transform the data to Cloud SQL.

On Sun, May 19, 2013 at 11:39 PM, mohammed ajala <hotoracle2@gmail.com> wrote:

Hello,

I just want to know if its possible and how to implement Appinventor with Google cloud sql.

Thank you.

--
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.

--
Joe Faith | Product Manager | Google Cloud

Re: Google cloud Sql with appinventor

Do you mean http://www.appinventor.org/? That looks like a framework for building android applications. Our current recommendation is to use an App Engine application to proxy/transform the data to Cloud SQL.

On Sun, May 19, 2013 at 11:39 PM, mohammed ajala <hotoracle2@gmail.com> wrote:

Hello,

I just want to know if its possible and how to implement Appinventor with Google cloud sql.

Thank you.

--
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.

Sunday, May 19, 2013

Google cloud Sql with appinventor

Hello,

I just want to know if its possible and how to implement Appinventor with Google cloud sql.

Thank you.

WATER DAMAGE GETTING BACK CONTACTS

My phone got soaked and I tried everything to try and get it to work but no use can cloud send me my contacts? i tried google takeout but i didn't get any of my contacts

Friday, May 17, 2013

Re: Help!! Error: System property rdbms.driver must be set.

Hi Venkatesh,

Did you try the same setting for connecting to the CloudSQL instance from the Eclipse DEV environment ?

I am still struggling with this.

Thanks,

Prasad

On Tuesday, May 14, 2013 11:29:49 PM UTC-4, Venkatesh Yerramsetty wrote:

Incase anyone is looking for this solution, we added system properties in app-engine-config.xml and modified datasource configuration to as shown below. this is not mentioned any where but this is the only solution worked for us.
We tried all the possiblilities mentioned in email thread and nothing worked. BTW we are using GAE 1.8.0

<system-properties>
<property name="java.util.logging.config.file" value="WEB-INF/logging.properties"/>
<property name="rdbms.driver" value="com.mysql.jdbc.Driver"/>
<property name="rdbms.server" value="local"/>
<property name="rdbms.url" value="jdbc:mysql://localhost:3306/instance?user=userName&password=pwd" />
</system-properties>

<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource"
p:driverClassName="com.google.appengine.api.rdbms.AppEngineDriver" p:url="jdbc:google:rdbms://localhost:3306/wtgdata"
/>

On Wednesday, October 12, 2011 12:24:59 AM UTC-5, mayixiaozi wrote:
While I am following the Example:
http://code.google.com/apis/sql/docs/developers_guide_java.html

and running the application, it returns:

HTTP ERROR 500
System property rdbms.driver must be set.

So i set the rdbms.driver in war/WEB-INF/appengine-web.xml,
add a property <property name="rdbms.driver"
value="com.google.appengine.api.rdbms.AppEngineDriver" />

The problem is the same!!

Anyone who knows how to fix this problem?? Thank you a lot!!! I really
need your guys help!!

Tuesday, May 14, 2013

Re: Help!! Error: System property rdbms.driver must be set.

Incase anyone is looking for this solution, we added system properties in app-engine-config.xml and modified datasource configuration to as shown below. this is not mentioned any where but this is the only solution worked for us.

We tried all the possiblilities mentioned in email thread and nothing worked. BTW we are using GAE 1.8.0

<system-properties>

</system-properties>

<bean id="dataSource"

class="org.springframework.jdbc.datasource.DriverManagerDataSource"

p:driverClassName="com.google.appengine.api.rdbms.AppEngineDriver" p:url="jdbc:google:rdbms://localhost:3306/wtgdata"

On Wednesday, October 12, 2011 12:24:59 AM UTC-5, mayixiaozi wrote:

While I am following the Example:
http://code.google.com/apis/sql/docs/developers_guide_java.html

and running the application, it returns:

HTTP ERROR 500
System property rdbms.driver must be set.

So i set the rdbms.driver in war/WEB-INF/appengine-web.xml,
add a property <property name="rdbms.driver"
value="com.google.appengine.api.rdbms.AppEngineDriver" />

The problem is the same!!

Anyone who knows how to fix this problem?? Thank you a lot!!! I really
need your guys help!!

Monday, May 13, 2013

Re: Budget limits / quota

Thanks Joe,

this help me!

On 04/30/2013 05:35 PM, Joe Faith wrote:

Hi Davide

I should just point out that both the per use and package plans have a limit on what you would pay for instance uptime per day (for example, $1.46 per day for a D1 instance). The only unbounded extras are for storage and IOs. By my estimation even a very determined DoS attack could only cost you an extra $2 per day for these at the very worst.

Hope this helps

J

On Tue, Apr 30, 2013 at 7:25 AM, Tony Tseng <ttt@google.com> wrote:

Hi Davide,
Unfortunately we don't currently have a daily/monthly budget limit yet.

On Tue, Apr 30, 2013 at 6:38 AM, Davide Montesin <davide.bz@gmail.com> wrote:

Hi,

I want understand if with Google Cloud SQL is possible to set up a max cost per day or month.

This because I want protect myself during testing service and in the future maybe protecting again
dos attack (that make me pay a lot of resources)...

Thanks in advance for any help!

--
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.

--
Joe Faith | Product Manager | Google Cloud
--
You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/D6YSB5UsGFs/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Friday, May 10, 2013

Re: Billing

Hi Gana

The major cost for Cloud SQL instances is for up time, rather than storage or network.

If you use the package option then even the most determined developer would find it hard to run up a bill much larger than expected.

On Fri, May 10, 2013 at 2:25 PM, Easwar Swaminathan <easwars@google.com> wrote:

Gana,

No. We don't currently have a feature to set a maximum cap amount. We might have something like that in the future, but it's not something that we are currently working on.

Thanks

On Fri, May 10, 2013 at 1:55 PM, javabuddy <javabuddy@gmail.com> wrote:

Can there be a maximum set on the amount that will be charged per month. So beyond that the service(instance) is not available.

I am afraid to have it to be open, a screw up from my developer and I dont want to be charged for some crazy amount.

I think App Engine has this feature to set for the cap amount.

Thanks
Gana

--
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.

--
Joe Faith | Product Manager | Google Cloud

Re: Billing

Gana,

No. We don't currently have a feature to set a maximum cap amount. We might have something like that in the future, but it's not something that we are currently working on.

Thanks

On Fri, May 10, 2013 at 1:55 PM, javabuddy <javabuddy@gmail.com> wrote:

Can there be a maximum set on the amount that will be charged per month. So beyond that the service(instance) is not available.

I am afraid to have it to be open, a screw up from my developer and I dont want to be charged for some crazy amount.

I think App Engine has this feature to set for the cap amount.

Thanks
Gana

--
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.

Billing

Can there be a maximum set on the amount that will be charged per month. So beyond that the service(instance) is not available.

I am afraid to have it to be open, a screw up from my developer and I dont want to be charged for some crazy amount.

I think App Engine has this feature to set for the cap amount.

Thanks

Gana

Thursday, May 9, 2013

Re: Having trouble creating Cloud SQL instance

We will work with you offline.

Thanks,

On Thu, May 9, 2013 at 6:06 PM, TwoHare <happycamperjack@gmail.com> wrote:

Hi,
I'm having trouble creating cloud sql instances. It's telling me that my billing is not enabled, but it is. Could you help me to look into this? Thank you.

--
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.

Having trouble creating Cloud SQL instance

Hi,

I'm having trouble creating cloud sql instances. It's telling me that my billing is not enabled, but it is. Could you help me to look into this? Thank you.

Re: Using of Jdbc.getConnection() statement in google apps script

Sorry about the late response.

I've posted my reply on http://stackoverflow.com/questions/16420495/using-of-jdbc-getconnection-statement-in-google-apps-script.

On Wed, May 8, 2013 at 9:55 PM, C L <chockalingam.r@ssomens.com> wrote:

Any Updates please....
--
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.

Re: How to convert to paying plan from free trial

The answer is yes to both of your questions. There is no action needed on your part if you want to keep using your Cloud SQL D0 instance.

If you do nothing, your D0 instance will incur charges starting on June 4. That'll happen automatically.

And you'll need to wait until June 4 to change D0 pricing plan to package.

On Thu, May 9, 2013 at 12:28 AM, Luca de Alfaro <luca.de.alfaro@gmail.com> wrote:

I have one instance of type D0 per-use that I am using for free as part of the free trial.

Come June 4, at the end of the trial, I would like to convert it to paid. I have already enabled billing, entered credit card information, etc etc.

So, I have two questions:
If I do nothing, I will start paying from June 4, correct? [Note: this would be perfect. I don't see any way to say "upgrade my free D0 to a paying D0" so I assume it will happen automatically]

If I want to go from D0 per-use to D0 package, I will have to wait until June 4, and do the change once I start to be billed, right?
I am asking these questions mainly because I received an email that seems to imply, from the tone, that I need to do something once the free trial ends. In fact, I suspect I don't need to do anything before June 4.

Many thanks from a very happy user,

Luca

--
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.

Re: End of Google Cloud SQL Free Trial

This is absolutely fantastic news.

Luca

On Tuesday, May 7, 2013 9:07:18 AM UTC-7, Joe Faith wrote:

Dear Cloud SQL Users

The current free trial of Cloud SQL is due to end on June 1st, as noted. But during the trial we got lots of feedback that you wanted low cost instances for light but continuous traffic. So we are going to keep the D0 instances available at a very low cost. As from June 4th D0 instances on the per use plan will be charged $0.025 per hour while the instance is being accessed. Instances converted to the package plan will be charged $0.36 per day. See the pricing documentation for more information.

We hope that you will continue to use and get benefit from the service. However, if you do not wish to continue using the service, we recommend you delete your instance before June 4th using the Google Cloud Console.

thanks

J

--
Joe Faith | Product Manager | Google Cloud

How to convert to paying plan from free trial

I have one instance of type D0 per-use that I am using for free as part of the free trial.

Come June 4, at the end of the trial, I would like to convert it to paid. I have already enabled billing, entered credit card information, etc etc.

So, I have two questions:

If I do nothing, I will start paying from June 4, correct? [Note: this would be perfect. I don't see any way to say "upgrade my free D0 to a paying D0" so I assume it will happen automatically]
If I want to go from D0 per-use to D0 package, I will have to wait until June 4, and do the change once I start to be billed, right?

I am asking these questions mainly because I received an email that seems to imply, from the tone, that I need to do something once the free trial ends. In fact, I suspect I don't need to do anything before June 4.

Many thanks from a very happy user,

Luca

Wednesday, May 8, 2013

Re: Using of Jdbc.getConnection() statement in google apps script

Any Updates please....

store procedure delimiters

I tried to create multiple store procedure at once but delimiters were not allowed due to mysql version which is running for google cloud sql is not supporting delimiters

i have used semicolon to separate the store procedure ,i have around 15 store procedure and tried to run it at once ....

i noticed that the last procedure only loaded to my schema other we left alone ....

help on this "how to load/create multiple store procedure at once in google cloud sql using cloud sql api or any sql client api like squirrel sql client "

Re: Connection Pool

Google Cloud SQL could signal the connection pool about a pending shutdown... Another (easy) solution would be to keep the database instance online while there are current connections. The user is paying for this instance hours so this would be no problem for Google ;)

Regards,

Roland

Op dinsdag 7 mei 2013 23:58:58 UTC+2 schreef Joe Faith het volgende:

Hi Roland

The discussion never ends!
I'd be interested in your use case or requirements.
In particular, since the time to create a new connection is similar to that required to test the liveness of an existing connection, then I'm not sure how a connection pool would help?

j

On Tue, May 7, 2013 at 1:11 PM, Roland Beuker <roland...@arcus-business.com> wrote:

Hello Joe,

Is this the end of this discussion or is Google developing some kind of connection pooling towards Google Cloud SQL?

Regards,

Roland

Op vrijdag 2 maart 2012 18:07:05 UTC+1 schreef Joe Faith het volgende:

Database connections in a cloud hosted environment should be managed differently to those on a conventional server. In particular, be aware that your database instance may be taken offline while not in use, and any pooled connections would be closed. We recommend that a new connection is created to service each HTTP request, and re-used for the duration of that request (since the time to create a new connection is similar to that required to test the liveness of an existing connection).

J

On Fri, Mar 2, 2012 at 1:16 AM, Rémi Bastide <remi.b...@gmail.com> wrote:
Good question ! I'm in need of the answer as well...

Le mardi 1 novembre 2011 19:44:30 UTC+1, javabuddy a écrit :
How to establish Connection Pool in GAE using AppEngineDriver in Cloud
SQL or native datastore??

Thanks

--
Joe Faith | Product Manager | Google Cloud

--
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.

--
Joe Faith | Product Manager | Google Cloud

Re: Google Cloud SQL with Hibernate and ... c3p0

Hello Joe,

I really hope this is an temporary/intermediate situation... A new connection for each request is very disadvantageous. What about a 'Google connection poo'l in the AppEngineDriver towards Google Cloud SQL? This connection pool is particular needed in the situations when we are using long (application wide) sessions...

This Google connection pool could be an easy port from existing available implementations...

Kind regards,

Roland Beuker

Arcus Solutions

06-33974573

On 7 May 2013 23:51, Joe Faith <joefaith@google.com> wrote:

Hope this helps:

https://developers.google.com/cloud-sql/faq#connections

How should I manage connections?
Database connections in a cloud hosted environment should be managed differently to those on a conventional server. In particular, be aware that your database instance may be taken offline while not in use, and any pooled connections would be closed. We recommend that a new connection is created to service each HTTP request, and re-used for the duration of that request (since the time to create a new connection is similar to that required to test the liveness of an existing connection).

On Tue, May 7, 2013 at 12:39 PM, Roland Beuker <roland.beuker@arcus-business.com> wrote:

I want to use Hibernate with Google Cloud SQL. With one connection its working, but when i try to use c3p0 for connection pooling i get a java.security.AccessControlException. The Hibernate documentation states it is important to use connection in a production environment. Is Google going to enable this connection pooling option on Google Cloud SQL?

Regards,

Roland Beuker

--
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.

--
Joe Faith | Product Manager | Google Cloud

--
You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/Xi6yrn0L1C0/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Tuesday, May 7, 2013

GPE cannot configure local MySQL?

I'm using Eclipse 3.8, GPE version 3.2.2. I'm trying to configure a local MySQL instance, but the MySQL configuration dialog box doesn't "accept" my input. I entered the host (localhost), port (default 3306), username (root) password (blank), the database name, and specified the .jar file.

Clicking "OK" does nothing; but it does seem to save my input. If I click Cancel and then "Configure" again, it has in fact retained my settings, but there's an error message at the top of the dialog ("Configure MySQL instance for local development server.")

Any way to get past this?

Re: Connection Pool

Hi Roland

The discussion never ends!

I'd be interested in your use case or requirements.

In particular, since the time to create a new connection is similar to that required to test the liveness of an existing connection, then I'm not sure how a connection pool would help?

On Tue, May 7, 2013 at 1:11 PM, Roland Beuker <roland.beuker@arcus-business.com> wrote:

Hello Joe,

Is this the end of this discussion or is Google developing some kind of connection pooling towards Google Cloud SQL?

Regards,

Roland

Op vrijdag 2 maart 2012 18:07:05 UTC+1 schreef Joe Faith het volgende:

Database connections in a cloud hosted environment should be managed differently to those on a conventional server. In particular, be aware that your database instance may be taken offline while not in use, and any pooled connections would be closed. We recommend that a new connection is created to service each HTTP request, and re-used for the duration of that request (since the time to create a new connection is similar to that required to test the liveness of an existing connection).

J

On Fri, Mar 2, 2012 at 1:16 AM, Rémi Bastide <remi.b...@gmail.com> wrote:
Good question ! I'm in need of the answer as well...

Le mardi 1 novembre 2011 19:44:30 UTC+1, javabuddy a écrit :
How to establish Connection Pool in GAE using AppEngineDriver in Cloud
SQL or native datastore??

Thanks

--
Joe Faith | Product Manager | Google Cloud

--
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.

--
Joe Faith | Product Manager | Google Cloud

Re: Google Cloud SQL with Hibernate and ... c3p0

Hope this helps:

https://developers.google.com/cloud-sql/faq#connections

How should I manage connections?

Database connections in a cloud hosted environment should be managed differently to those on a conventional server. In particular, be aware that your database instance may be taken offline while not in use, and any pooled connections would be closed. We recommend that a new connection is created to service each HTTP request, and re-used for the duration of that request (since the time to create a new connection is similar to that required to test the liveness of an existing connection).

On Tue, May 7, 2013 at 12:39 PM, Roland Beuker <roland.beuker@arcus-business.com> wrote:

I want to use Hibernate with Google Cloud SQL. With one connection its working, but when i try to use c3p0 for connection pooling i get a java.security.AccessControlException. The Hibernate documentation states it is important to use connection in a production environment. Is Google going to enable this connection pooling option on Google Cloud SQL?

Regards,

Roland Beuker

--
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.

--
Joe Faith | Product Manager | Google Cloud

Re: Connection Pool

Hello Joe,

Is this the end of this discussion or is Google developing some kind of connection pooling towards Google Cloud SQL?

Regards,

Roland

Op vrijdag 2 maart 2012 18:07:05 UTC+1 schreef Joe Faith het volgende:

Database connections in a cloud hosted environment should be managed differently to those on a conventional server. In particular, be aware that your database instance may be taken offline while not in use, and any pooled connections would be closed. We recommend that a new connection is created to service each HTTP request, and re-used for the duration of that request (since the time to create a new connection is similar to that required to test the liveness of an existing connection).

J

On Fri, Mar 2, 2012 at 1:16 AM, Rémi Bastide <remi.b...@gmail.com> wrote:
Good question ! I'm in need of the answer as well...

Le mardi 1 novembre 2011 19:44:30 UTC+1, javabuddy a écrit :
How to establish Connection Pool in GAE using AppEngineDriver in Cloud
SQL or native datastore??

Thanks

--
Joe Faith | Product Manager | Google Cloud

Google Cloud SQL with Hibernate and ... c3p0

I want to use Hibernate with Google Cloud SQL. With one connection its working, but when i try to use c3p0 for connection pooling i get a java.security.AccessControlException. The Hibernate documentation states it is important to use connection in a production environment. Is Google going to enable this connection pooling option on Google Cloud SQL?

Regards,

Roland Beuker

Re: How to delete SQL instance if it was suspended?

Hi Filip,

We will work with off the thread.

Thanks

Easwar

On Tue, May 7, 2013 at 9:45 AM, Filip Komaromi <komarac@gmail.com> wrote:

Sorry, I have the same problem. I have two Google cloud sql instances that are both suspended and I want to delete them. What should I do?
On Friday, November 30, 2012 10:27:31 PM UTC+1, Joe Faith wrote:

Hi Mike

we'll get back to you off-thread about this

J

On Thu, Nov 29, 2012 at 11:49 PM, mike <karnaukho...@gmail.com> wrote:

I've checked that...
The full picture of the situation: in September I have decided to run project on Google App Engine with Cloud SQL storage. I have chosen D1 pricing and begun studying the services. After certain personal circumstances I have abandoned that idea. The length of usage period was only two last weeks of September and my card was valid thru 09/12. So, I have decided that I would pay only for those two weeks.. Now I have to pay for October and November even when I didn't use DB at all.

What should I do now?
I suppose I have to change my card to valid one. After that billing would be enabled and I would be able to manage my instances. But could the accruals be revised by Google? I don't need any data in that instance anymore (actually, DB is empty).

Many thanks.

On Thursday, November 29, 2012 7:58:54 PM UTC+4, Razvan Musaloiu-E. wrote:

Can you please check that you have billing enabled?

-- Razvan ME

On Thu, Nov 29, 2012 at 7:20 AM, mike <karnaukho...@gmail.com> wrote:
Hi, I think I have the same issue...
Could you delete my suspended instance please [project:914128765070:sql:instance:asacloudstore:datastore]?

--
Joe Faith | Product Manager | Google Cloud

--
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.

Re: How to delete SQL instance if it was suspended?

Sorry, I have the same problem. I have two Google cloud sql instances that are both suspended and I want to delete them. What should I do?
On Friday, November 30, 2012 10:27:31 PM UTC+1, Joe Faith wrote:

Hi Mike

we'll get back to you off-thread about this

J

On Thu, Nov 29, 2012 at 11:49 PM, mike <karnaukho...@gmail.com> wrote:

I've checked that...
The full picture of the situation: in September I have decided to run project on Google App Engine with Cloud SQL storage. I have chosen D1 pricing and begun studying the services. After certain personal circumstances I have abandoned that idea. The length of usage period was only two last weeks of September and my card was valid thru 09/12. So, I have decided that I would pay only for those two weeks.. Now I have to pay for October and November even when I didn't use DB at all.

What should I do now?
I suppose I have to change my card to valid one. After that billing would be enabled and I would be able to manage my instances. But could the accruals be revised by Google? I don't need any data in that instance anymore (actually, DB is empty).

Many thanks.

On Thursday, November 29, 2012 7:58:54 PM UTC+4, Razvan Musaloiu-E. wrote:

Can you please check that you have billing enabled?

-- Razvan ME

On Thu, Nov 29, 2012 at 7:20 AM, mike <karnaukho...@gmail.com> wrote:
Hi, I think I have the same issue...
Could you delete my suspended instance please [project:914128765070:sql:instance:asacloudstore:datastore]?

--
Joe Faith | Product Manager | Google Cloud

End of Google Cloud SQL Free Trial

Dear Cloud SQL Users

The current free trial of Cloud SQL is due to end on June 1st, as noted. But during the trial we got lots of feedback that you wanted low cost instances for light but continuous traffic. So we are going to keep the D0 instances available at a very low cost. As from June 4th D0 instances on the per use plan will be charged $0.025 per hour while the instance is being accessed. Instances converted to the package plan will be charged $0.36 per day. See the pricing documentation for more information.

We hope that you will continue to use and get benefit from the service. However, if you do not wish to continue using the service, we recommend you delete your instance before June 4th using the Google Cloud Console.

thanks

--
Joe Faith | Product Manager | Google Cloud

Friday, May 3, 2013

Re: Can't create new instance

Hi Kiran,

Your project does not appear to have billing enabled. As Razvan said, you'll need to enable billing before you can create a new D0 instance.

On Fri, May 3, 2013 at 6:45 PM, kiran kumar <kyasa.ray@gmail.com> wrote:

Please help me out with this ! thank you

On Saturday, May 4, 2013 7:13:26 AM UTC+5:30, kiran kumar wrote:
I 'm unable to create an instance ... i get an error saying "You cannot create new instances because billing is disabled" . as given in the documentation i have selected D0 .
My project id : s-a-m-p

Project number : 976095065591

On Wednesday, August 1, 2012 3:49:00 AM UTC+5:30, jlemes wrote:
Hi,

I'm trying to create an new instance, however even after enabling I get an error saying "You cannot create new instances because billing is disabled", but the console shows that billing is enabled and active

My project id is "jslsolucoes" .

Another question : If my instance with 2 databases installeds get the maximum storage (10GB) i will payied just for aditional storage or i have to create a new instance and that new instance will access the same databases ?

--
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.

Re: Can't create new instance

Have you enabled billing? D0 is free but it requires the billing to be enabled.

-- Razvan ME

On Fri, May 3, 2013 at 6:45 PM, kiran kumar <kyasa.ray@gmail.com> wrote:

Please help me out with this ! thank you

On Saturday, May 4, 2013 7:13:26 AM UTC+5:30, kiran kumar wrote:
I 'm unable to create an instance ... i get an error saying "You cannot create new instances because billing is disabled" . as given in the documentation i have selected D0 .
My project id : s-a-m-p

Project number : 976095065591

On Wednesday, August 1, 2012 3:49:00 AM UTC+5:30, jlemes wrote:
Hi,

I'm trying to create an new instance, however even after enabling I get an error saying "You cannot create new instances because billing is disabled", but the console shows that billing is enabled and active

My project id is "jslsolucoes" .

Another question : If my instance with 2 databases installeds get the maximum storage (10GB) i will payied just for aditional storage or i have to create a new instance and that new instance will access the same databases ?

--
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.

Re: Can't create new instance

Please help me out with this ! thank you

On Saturday, May 4, 2013 7:13:26 AM UTC+5:30, kiran kumar wrote:

I 'm unable to create an instance ... i get an error saying "You cannot create new instances because billing is disabled" . as given in the documentation i have selected D0 .
My project id : s-a-m-p
Project number : 976095065591

On Wednesday, August 1, 2012 3:49:00 AM UTC+5:30, jlemes wrote:
Hi,

I'm trying to create an new instance, however even after enabling I get an error saying "You cannot create new instances because billing is disabled", but the console shows that billing is enabled and active

My project id is "jslsolucoes" .

Another question : If my instance with 2 databases installeds get the maximum storage (10GB) i will payied just for aditional storage or i have to create a new instance and that new instance will access the same databases ?

Pages

Friday, May 31, 2013

Sunday, May 26, 2013

Thursday, May 23, 2013

Wednesday, May 22, 2013

Monday, May 20, 2013

Sunday, May 19, 2013

Friday, May 17, 2013

Tuesday, May 14, 2013

Monday, May 13, 2013

Friday, May 10, 2013

Thursday, May 9, 2013

Wednesday, May 8, 2013

Tuesday, May 7, 2013

Friday, May 3, 2013