April 2013

Tuesday, April 30, 2013

Re: Budget limits / quota

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

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 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: Budget limits / quota

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.

Budget limits / quota

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!

Friday, April 26, 2013

Hibernate SessionFactory error

Hi all,

this exception is happening if try access the application at same browser when the session timeout and when a new deploy is done.

Help???

javax.servlet.ServletException: java.lang.RuntimeException: java.io.InvalidObjectException: Could not find a SessionFactory [uuid=bdab03e3-5aab-4a79-ac52-0033fc4f4871,name=null]
at com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java:268)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:923)
at com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequestParser.java:76)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceRequest(JettyServletEngineAdapter.java:146)
at com.google.apphosting.runtime.JavaRuntime$RequestRunnable.run(JavaRuntime.java:438)
at com.google.tracing.TraceContext$TraceContextRunnable.runInContext(TraceContext.java:480)
at com.google.tracing.TraceContext$TraceContextRunnable$1.run(TraceContext.java:487)
at com.google.tracing.TraceContext.runInContext(TraceContext.java:774)
at com.google.tracing.TraceContext$DoInTraceContext.runInContext(TraceContext.java:751)
at com.google.tracing.TraceContext$AbstractTraceContextCallback.runInInheritedContextNoUnref(TraceContext.java:342)
at com.google.tracing.TraceContext$AbstractTraceContextCallback.runInInheritedContext(TraceContext.java:334)
at com.google.tracing.TraceContext$TraceContextRunnable.run(TraceContext.java:484)
at com.google.apphosting.runtime.ThreadGroupPool$PoolEntry.run(ThreadGroupPool.java:251)
at java.lang.Thread.run(Thread.java:679)
Caused by: java.lang.RuntimeException: java.io.InvalidObjectException: Could not find a SessionFactory [uuid=bdab03e3-5aab-4a79-ac52-0033fc4f4871,name=null]
at com.google.apphosting.runtime.SessionManagerUtil.deserialize(SessionManagerUtil.java:57)
at com.google.apphosting.runtime.jetty.MemcacheSessionStore.getSession(MemcacheSessionStore.java:39)
at com.google.apphosting.runtime.jetty.SessionManager.loadSession(SessionManager.java:327)
at com.google.apphosting.runtime.jetty.SessionManager.getSession(SessionManager.java:301)
at org.mortbay.jetty.servlet.AbstractSessionManager.getHttpSession(AbstractSessionManager.java:237)
at org.mortbay.jetty.servlet.SessionHandler.setRequestedId(SessionHandler.java:246)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:136)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
at com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java:266)
... 17 more
Caused by: java.io.InvalidObjectException: Could not find a SessionFactory [uuid=bdab03e3-5aab-4a79-ac52-0033fc4f4871,name=null]
at org.hibernate.internal.SessionFactoryImpl.locateSessionFactoryOnDeserialization(SessionFactoryImpl.java:1765)
at org.hibernate.internal.SessionFactoryImpl.readResolve(SessionFactoryImpl.java:1745)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at java.io.ObjectStreamClass.invokeReadResolve(ObjectStreamClass.java:1078)
at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1827)
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1394)
at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:2011)
at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1935)
at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1818)
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1394)
at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:2011)
at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1935)
at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1818)
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1394)
at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:2011)
at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1935)
at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1818)
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1394)
at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:2011)
at java.io.ObjectInputStream.defaultReadObject(ObjectInputStream.java:524)
at org.springframework.aop.framework.AdvisedSupport.readObject(AdvisedSupport.java:550)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:991)
at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1913)
at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1818)
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1394)
at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:2011)
at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1935)
at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1818)
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1394)
at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:2011)
at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1935)
at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1818)
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1394)
at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:2011)
at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1935)
at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1818)
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1394)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:395)
at java.util.HashMap.readObject(HashMap.java:1047)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:991)
at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1913)
at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1818)
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1394)
at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:2011)
at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1935)
at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1818)
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1394)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:395)
at com.google.apphosting.runtime.SessionManagerUtil.deserialize(SessionManagerUtil.java:55)
... 26 more

Wednesday, April 24, 2013

Re: 100GB inclusive of deleted rows?

If you're using innodb (which is the recommended engine), then yes, since it does not free the space from deleted rows:

http://stackoverflow.com/questions/1270944/mysql-innodb-not-releasing-disk-space-after-deleting-data-rows-from-table

On Wed, Apr 24, 2013 at 7:29 AM, JS Jensen <jsjensen@gmail.com> wrote:

As to the 100GB per instance storage, is this inclusive of deleted rows?
--
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.

100GB inclusive of deleted rows?

As to the 100GB per instance storage, is this inclusive of deleted rows?

Tuesday, April 23, 2013

R package JDBC dbWriteTable painfully slow

Hello, i am on ubunto 64-bit R package and have connected to the google mysql cloud with the RJDBC package. This creates a java based mysql connection to the google cloud db. I am on fios internet. db reads from the cloud are fantasticly fast. dbWriteTable is painfully slow - like 10 minutes per table creation. The ubunto system monitor is showing about 90kib/s sending and 16.1 kib/s receiving during the app connection to cloud while the app is creating a writing data to the new table. Verizon speed test is showing 8 mbps send and 16 mb receive on the ethernet connection.

Why is the dbWriteTable command so painfully slow? Is there a buffer setting/cache/replication setting i need to change. I appears to me that the cloud db is creating the latency which is crushing the write speed.

Once establishing the core dataset - updates will be much smaller. So this is a one time thing - like turn off replication while i create the table?

google cloud sql command line tool will go crazy while enter a long statement

Am I the only one experience this issue?

While I try to enter a long query (but only one statement) in the command line tool, the command line tool will go crazy!

I find out it always happened while a statement contains the same characters as line character limit and I want to insert some character in the statement. the cursor will `replace` the character on screen instead of trigger wordwrap correctly.

I find out it happened in linux, windows and mac environment as well.

CONVERT_TZ returning NULL

Hi

In one of our projects, I wanted to do timezone conversion from server
timezone to user time zone. I planned to use convert_tz function but
its not working on Google cloud sql.

I tried - select convert_tz(now(), 'UTC', 'US/Eastern') which returns
NULL

The timezone tables also return nothing - select * from time_zone;

I guess they are not populated. Can someone suggest how to do timezone
conversion on Google Cloud sql?

Thanks in advance.

- Naresh

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

Monday, April 22, 2013

Re: questions about automation

Hi Nicolás

Its not currently possible to do this automatically within Cloud SQL.

An alternative would be to insert the data row-by-row from a simple application running on your own server, however this might not be practical for very large amounts of data.

On Sat, Apr 20, 2013 at 11:06 AM, Nicolás Ormeño Rojas <ni.ormeno@gmail.com> wrote:

I'm reading about "Google Cloud SQL" and I have the following questions, you can automate the data import?.

For example, currently my system do the following:

1. - They download information from a FTP. Example: wget ftp://xxxx.rar
2. - Decompress the rar and generate a CSV
3. - CSV Import the database

This process is done every day and are about 15 CSV

Best Regards

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

Sunday, April 21, 2013

Re: Sync data from Google spreadsheet to Cloud SQL using Google Apps Script

Thanks Sonal, I really appreciate you sending that through.

Matt

On 18 April 2013 14:51, SonalB <sonal.bante@accenture.com> wrote:

Hi Matt,

Please try out this code. It worked for me. Sorry I could not document it well, in case you find it difficult to understand, please drop me a note and I will explain that snippet.

function writeToDB() {
var connString ="jdbc:google:rdbms://"; //add your instance name after '//'
var databaseName = "use testdb";
var conn = Jdbc.getCloudSqlConnection(connString);
var stmt = conn.createStatement();
var rs = stmt.execute(databaseName);

rs = stmt.executeQuery("SELECT column_name FROM information_schema.columns WHERE table_name = 'test_table'");

var columnCount = rs.getMetaData().getColumnCount();
var dbColsNameArray = new Array();
while(rs.next()) {
    for( var i = 1; i <= columnCount; i++ ){
      dbColsNameArray.push(rs.getString(i));
      columnName = rs.getMetaData().getColumnName(i);
    }
}

var colNameStr = "";
var finalColNameStr = "";
var valueStr = "";
var finalValueStr ="";
var arraylen = dbColsNameArray.length;
Logger.log("before len::"+arraylen);
//Logic that will dynamically create the prepared statement with column names
for(i = 1;i< arraylen; i++)
{
    colNameStr =   dbColsNameArray[i];
    valueStr = "?,";

    if(i==(arraylen-1))
    {
      colNameStr = colNameStr;
      valueStr = "?";
    }
    else
    {
      colNameStr = colNameStr+",";

    }

    if("".equals(finalColNameStr)){
      finalColNameStr = colNameStr;
    }
    else{
      finalColNameStr = finalColNameStr+colNameStr;
    }
    finalValueStr = finalValueStr+valueStr;
    Logger.log("\n finalValueStr::"+finalValueStr);
}

conn.setAutoCommit(false);
var insertQry = "insert into test_table (";
insertQry = insertQry+finalColNameStr+") values (" +finalValueStr+")";
Logger.log("insertQry::"+insertQry);

stmt = conn.prepareStatement(insertQry);

var noOfCols = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getDataRange().getLastColumn();
var noOfrows = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getDataRange().getLastRow();
var values = SpreadsheetApp.getActiveSheet().getRange(2,1,noOfrows,noOfCols).getValues();
var counter = 0;

Logger.log("noOfCols::"+noOfCols+ "noOfrows::"+noOfrows);
var rowsleng= noOfrows-1;
Logger.log("\nrowsleng::::::"+rowsleng);
var colValue = "";
var tempDate = "";

try{
    for (var i = 0; i < rowsleng; i++)
    {
      for(var j = 0; j< noOfCols; j++)
      {
        counter = j+1;
        colValue = values[i][j];

        stmt.setObject(counter,colValue.toString());
      }
      stmt.addBatch();
    }
    var res = stmt.executeBatch();
    conn.commit();
}catch(exception){
    Logger.log(exception);
}
conn.close();
}

Regards,
Sonal

On Wednesday, April 17, 2013 11:47:03 PM UTC+5:30, Matt C wrote:
Hi Sonal,

I have the example JDBC code running successfully, but the example does not show how to read data FROM a spreadsheet INTO Cloud SQL, only how to generate auto-incremented integers within the script and send them to SQL. However, it does show how to copy data from SQL into a spreadsheet.

Basically, I don't know how to modify the example code to extract a range from my spreadsheet.

The example code I'm using is from this page - https://developers.google.com/apps-script/jdbc. You will see that getActiveSpreadsheet only appears on the second example, not the first.

Many thanks,

Matt

On 17 April 2013 07:15, SonalB <sonal...@accenture.com> wrote:

Hi Matt,

Yes. I have written the functionality to read and write data from Cloud SQL to Google spreadsheet. The logic reads data dynamically and writes the output to Google Spreadsheet.

Please share what you are trying to accomplish or issues encountered. This would help me in suggesting how you can proceed further.

Regards,
Sonal

On Tuesday, April 16, 2013 11:39:29 PM UTC+5:30, Matt C wrote:
Hi Sonal,
How far have you got with your project? I want to do exactly the same thing. I have been experimenting with Google's example JDBC code and understand the general idea, but have now hit the limit of my abilities. I would be extremely grateful if you could offer some assistance.

Many thanks,
Matt

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

Saturday, April 20, 2013

questions about automation

I'm reading about "Google Cloud SQL" and I have the following questions, you can automate the data import?.

For example, currently my system do the following:

1. - They download information from a FTP. Example: wget ftp://xxxx.rar

2. - Decompress the rar and generate a CSV

3. - CSV Import the database

This process is done every day and are about 15 CSV

Best Regards

Thursday, April 18, 2013

Export data from GSQL command-line tool

Although exporting the complete database might be convenient in some cases, for our application this can be time consuming, i.e.: https://developers.google.com/cloud-sql/docs/import_export#exporting

Is there a convenient way to export a database or a table directly from the GSQL command-line tool?

Many thanks

Re: DB Accidentally deleted

Hi Fausto

I'll get in touch off-thread

On Thu, Apr 18, 2013 at 12:58 PM, Fausto Fusaro <fausto.fusaro@injenia.it> wrote:

Hello,
I have accidentally deleted my Cloud SQL instance with all its data. My last backup is old and now I cannot retrieve its scheduled backup. I have to restore my instance, how can I do this? It's really imporant.

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.

--
Joe Faith | Product Manager | Google Cloud

DB Accidentally deleted

Hello,

I have accidentally deleted my Cloud SQL instance with all its data. My last backup is old and now I cannot retrieve its scheduled backup. I have to restore my instance, how can I do this? It's really imporant.

Thank you!!!

Re: Sync data from Google spreadsheet to Cloud SQL using Google Apps Script

Hi Matt,

Please try out this code. It worked for me. Sorry I could not document it well, in case you find it difficult to understand, please drop me a note and I will explain that snippet.

function writeToDB() {
var connString ="jdbc:google:rdbms://"; //add your instance name after '//'
var databaseName = "use testdb";
var conn = Jdbc.getCloudSqlConnection(connString);
var stmt = conn.createStatement();
var rs = stmt.execute(databaseName);

rs = stmt.executeQuery("SELECT column_name FROM information_schema.columns WHERE table_name = 'test_table'");

var columnCount = rs.getMetaData().getColumnCount();
var dbColsNameArray = new Array();
while(rs.next()) {
    for( var i = 1; i <= columnCount; i++ ){
      dbColsNameArray.push(rs.getString(i));
      columnName = rs.getMetaData().getColumnName(i);
    }
}

var colNameStr = "";
var finalColNameStr = "";
var valueStr = "";
var finalValueStr ="";
var arraylen = dbColsNameArray.length;
Logger.log("before len::"+arraylen);
//Logic that will dynamically create the prepared statement with column names
for(i = 1;i< arraylen; i++)
{
    colNameStr =   dbColsNameArray[i];
    valueStr = "?,";

    if(i==(arraylen-1))
    {
      colNameStr = colNameStr;
      valueStr = "?";
    }
    else
    {
      colNameStr = colNameStr+",";

    }

    if("".equals(finalColNameStr)){
      finalColNameStr = colNameStr;
    }
    else{
      finalColNameStr = finalColNameStr+colNameStr;
    }
    finalValueStr = finalValueStr+valueStr;
    Logger.log("\n finalValueStr::"+finalValueStr);
}

conn.setAutoCommit(false);
var insertQry = "insert into test_table (";
insertQry = insertQry+finalColNameStr+") values (" +finalValueStr+")";
Logger.log("insertQry::"+insertQry);

stmt = conn.prepareStatement(insertQry);

var noOfCols = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getDataRange().getLastColumn();
var noOfrows = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getDataRange().getLastRow();
var values = SpreadsheetApp.getActiveSheet().getRange(2,1,noOfrows,noOfCols).getValues();
var counter = 0;

Logger.log("noOfCols::"+noOfCols+ "noOfrows::"+noOfrows);
var rowsleng= noOfrows-1;
Logger.log("\nrowsleng::::::"+rowsleng);
var colValue = "";
var tempDate = "";

try{
    for (var i = 0; i < rowsleng; i++)
    {
      for(var j = 0; j< noOfCols; j++)
      {
        counter = j+1;
        colValue = values[i][j];

        stmt.setObject(counter,colValue.toString());
      }
      stmt.addBatch();
    }
    var res = stmt.executeBatch();
    conn.commit();
}catch(exception){
    Logger.log(exception);
}
conn.close();
}

Regards,
Sonal

On Wednesday, April 17, 2013 11:47:03 PM UTC+5:30, Matt C wrote:

Hi Sonal,

I have the example JDBC code running successfully, but the example does not show how to read data FROM a spreadsheet INTO Cloud SQL, only how to generate auto-incremented integers within the script and send them to SQL. However, it does show how to copy data from SQL into a spreadsheet.

Basically, I don't know how to modify the example code to extract a range from my spreadsheet.

The example code I'm using is from this page - https://developers.google.com/apps-script/jdbc. You will see that getActiveSpreadsheet only appears on the second example, not the first.

Many thanks,

Matt

On 17 April 2013 07:15, SonalB <sonal...@accenture.com> wrote:

Hi Matt,

Yes. I have written the functionality to read and write data from Cloud SQL to Google spreadsheet. The logic reads data dynamically and writes the output to Google Spreadsheet.

Please share what you are trying to accomplish or issues encountered. This would help me in suggesting how you can proceed further.

Regards,
Sonal

On Tuesday, April 16, 2013 11:39:29 PM UTC+5:30, Matt C wrote:
Hi Sonal,
How far have you got with your project? I want to do exactly the same thing. I have been experimenting with Google's example JDBC code and understand the general idea, but have now hit the limit of my abilities. I would be extremely grateful if you could offer some assistance.

Many thanks,
Matt

--
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, April 17, 2013

Re: GAE No connectivity to local dev MySQL instance with data nucleus

Hi James,

Yes, I completely agree. We should improve the docs. Thanks for the feedback.

On Wed, Apr 17, 2013 at 7:14 AM, James May <jmay@bizznetworxonline.com> wrote:

I think I see the gap in the documentation. I think the bridge needs to be setup on the JPA page for google app engine to include a section for setting up the persistence.xml for google cloud sql. There are separate pages for google cloud sql documentation, but they don't include the persistence.xml config and only explain what to select for the settings in the eclipse plugin. There is also a page which is completely irrelevant because it talks about basic JPA setup inside of Eclipse using EclipseLink. Also, none of the pages talk about where to copy certain jar files. Like the mysql.jar file in the impl folder. You have to do a search to find posts about that placement. It would be better to have all of that in that newly documented section.

On Wednesday, April 17, 2013 10:00:17 AM UTC-4, James May wrote:
Takashi,

I will give that a try. Strange thing is that I have read and searched on line for quite a while and I didn't find any documentation that said to remove that line. My understanding was that the vm arguments were supposed to be used in the connection. The documentation for JPA in the Google App Engine documentation tell us to put that line in the persistence.xml.

https://developers.google.com/appengine/docs/java/datastore/jpa/overview-dn2#Setting_Up_JPA_2_0

Maybe the documentation needs to be updated to include what you should do for local mysql instances? Also, the two lines you have declared are for the instance running in the cloud. Will these two settings trigger the use of the vm arguments for the local mysql database since the google app engine storage will not be used?

Thanks.
James

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

Takashi Matsuo | Developers Programs Engineer | tmatsuo@google.com

Re: Sync data from Google spreadsheet to Cloud SQL using Google Apps Script

Hi Sonal,

I have the example JDBC code running successfully, but the example does not show how to read data FROM a spreadsheet INTO Cloud SQL, only how to generate auto-incremented integers within the script and send them to SQL. However, it does show how to copy data from SQL into a spreadsheet.

Basically, I don't know how to modify the example code to extract a range from my spreadsheet.

The example code I'm using is from this page - https://developers.google.com/apps-script/jdbc. You will see that getActiveSpreadsheet only appears on the second example, not the first.

Many thanks,

Matt

On 17 April 2013 07:15, SonalB <sonal.bante@accenture.com> wrote:

Hi Matt,

Yes. I have written the functionality to read and write data from Cloud SQL to Google spreadsheet. The logic reads data dynamically and writes the output to Google Spreadsheet.

Please share what you are trying to accomplish or issues encountered. This would help me in suggesting how you can proceed further.

Regards,
Sonal

On Tuesday, April 16, 2013 11:39:29 PM UTC+5:30, Matt C wrote:
Hi Sonal,
How far have you got with your project? I want to do exactly the same thing. I have been experimenting with Google's example JDBC code and understand the general idea, but have now hit the limit of my abilities. I would be extremely grateful if you could offer some assistance.

Many thanks,
Matt

--
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: GAE No connectivity to local dev MySQL instance with data nucleus

I think I see the gap in the documentation. I think the bridge needs to be setup on the JPA page for google app engine to include a section for setting up the persistence.xml for google cloud sql. There are separate pages for google cloud sql documentation, but they don't include the persistence.xml config and only explain what to select for the settings in the eclipse plugin. There is also a page which is completely irrelevant because it talks about basic JPA setup inside of Eclipse using EclipseLink. Also, none of the pages talk about where to copy certain jar files. Like the mysql.jar file in the impl folder. You have to do a search to find posts about that placement. It would be better to have all of that in that newly documented section.

On Wednesday, April 17, 2013 10:00:17 AM UTC-4, James May wrote:

Takashi,

I will give that a try. Strange thing is that I have read and searched on line for quite a while and I didn't find any documentation that said to remove that line. My understanding was that the vm arguments were supposed to be used in the connection. The documentation for JPA in the Google App Engine documentation tell us to put that line in the persistence.xml.

https://developers.google.com/appengine/docs/java/datastore/jpa/overview-dn2#Setting_Up_JPA_2_0

Maybe the documentation needs to be updated to include what you should do for local mysql instances? Also, the two lines you have declared are for the instance running in the cloud. Will these two settings trigger the use of the vm arguments for the local mysql database since the google app engine storage will not be used?

Thanks.
James

Re: GAE No connectivity to local dev MySQL instance with data nucleus

Takashi,

I will give that a try. Strange thing is that I have read and searched on line for quite a while and I didn't find any documentation that said to remove that line. My understanding was that the vm arguments were supposed to be used in the connection. The documentation for JPA in the Google App Engine documentation tell us to put that line in the persistence.xml.

https://developers.google.com/appengine/docs/java/datastore/jpa/overview-dn2#Setting_Up_JPA_2_0

Maybe the documentation needs to be updated to include what you should do for local mysql instances? Also, the two lines you have declared are for the instance running in the cloud. Will these two settings trigger the use of the vm arguments for the local mysql database since the google app engine storage will not be used?

Thanks.

James

Re: GAE No connectivity to local dev MySQL instance with data nucleus

Hi James,

I think the following element:

<property name="datanucleus.ConnectionURL" value="appengine"/>

is the culprit. This is a setting to use App Engine datastore as the storage layer.

In my case, I managed to make it work by the following:

edit your persistence.xml

<properties>


<property name="javax.persistence.jdbc.driver" value="com.google.appengine.api.rdbms.AppEngineDriver" />
<property name="javax.persistence.jdbc.url" value="jdbc:google:rdbms://your_instance_name/database_name" />

</properties>

Put datanucleus-rdbms-x.y.z.jar to the `war/WEB-INF/lib` directory if you haven't
Put mysql-connector-java-x.y.z-bin.jar to the `appengine-sdk/lib/impl` directory if you haven't

Can you try this first?

On Tue, Apr 16, 2013 at 7:08 AM, James May <jmay@bizznetworxonline.com> wrote:

No, I did not. The dev environment that I have is an older environment (older version of eclipse, os) and I had some additional plugins etc... installed. I am going to try one more thing and create a fresh new environment and try to get it to work. I am probably going to switch to Amazon Elastic Beanstalk if I can't get this to work this time around. I don't have time to be messing around with nonsense. I sent out an request to Google to pay the $150 per month support cost. I have had no contact by email or phone. So, that tells me they are catering to bigger clients or this product is not ready for prime time or its a side project for Google. I will let you know if the new environment works.

On Friday, April 12, 2013 5:27:18 PM UTC-4, Nicola Blaine wrote:

Hi

I think I have the same issue. Did you get a solution in the end?

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

Takashi Matsuo | Developers Programs Engineer | tmatsuo@google.com

Tuesday, April 16, 2013

Re: Sync data from Google spreadsheet to Cloud SQL using Google Apps Script

Hi Matt,

Yes. I have written the functionality to read and write data from Cloud SQL to Google spreadsheet. The logic reads data dynamically and writes the output to Google Spreadsheet.

Please share what you are trying to accomplish or issues encountered. This would help me in suggesting how you can proceed further.

Regards,
Sonal

On Tuesday, April 16, 2013 11:39:29 PM UTC+5:30, Matt C wrote:

Hi Sonal,
How far have you got with your project? I want to do exactly the same thing. I have been experimenting with Google's example JDBC code and understand the general idea, but have now hit the limit of my abilities. I would be extremely grateful if you could offer some assistance.
Many thanks,
Matt

Re: Sync data from Google spreadsheet to Cloud SQL using Google Apps Script

Hi Sonal,

How far have you got with your project? I want to do exactly the same thing. I have been experimenting with Google's example JDBC code and understand the general idea, but have now hit the limit of my abilities. I would be extremely grateful if you could offer some assistance.

Many thanks,

Matt

Re: GAE No connectivity to local dev MySQL instance with data nucleus

Hi James

Very sorry to hear your having problems with this.

I'll follow up off-thread

On Tue, Apr 16, 2013 at 7:08 AM, James May <jmay@bizznetworxonline.com> wrote:

No, I did not. The dev environment that I have is an older environment (older version of eclipse, os) and I had some additional plugins etc... installed. I am going to try one more thing and create a fresh new environment and try to get it to work. I am probably going to switch to Amazon Elastic Beanstalk if I can't get this to work this time around. I don't have time to be messing around with nonsense. I sent out an request to Google to pay the $150 per month support cost. I have had no contact by email or phone. So, that tells me they are catering to bigger clients or this product is not ready for prime time or its a side project for Google. I will let you know if the new environment works.

On Friday, April 12, 2013 5:27:18 PM UTC-4, Nicola Blaine wrote:

Hi

I think I have the same issue. Did you get a solution in the end?

--
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: GAE No connectivity to local dev MySQL instance with data nucleus

No, I did not. The dev environment that I have is an older environment (older version of eclipse, os) and I had some additional plugins etc... installed. I am going to try one more thing and create a fresh new environment and try to get it to work. I am probably going to switch to Amazon Elastic Beanstalk if I can't get this to work this time around. I don't have time to be messing around with nonsense. I sent out an request to Google to pay the $150 per month support cost. I have had no contact by email or phone. So, that tells me they are catering to bigger clients or this product is not ready for prime time or its a side project for Google. I will let you know if the new environment works.

On Friday, April 12, 2013 5:27:18 PM UTC-4, Nicola Blaine wrote:

Hi

I think I have the same issue. Did you get a solution in the end?

Friday, April 12, 2013

Re: GAE No connectivity to local dev MySQL instance with data nucleus

Hi

I think I have the same issue. Did you get a solution in the end?

Sunday, April 7, 2013

Re: Error..please help me..you can not create new instance because billing is disabled...

Before creating the instance you must enable the billing first, Then only you can create instance. Enable the billing in the "Billing" option.

Tnx,

CL.

On Monday, April 8, 2013 11:36:57 AM UTC+5:30, amol bhoj wrote:

you can not create new instance because billing is disabled...

Re: Error..please help me..you can not create new instance because billing is disabled...

Hi there,

Do you have billing enabled? If so, was it enabled recently? Billing can take a little while to activate.

On Sun, Apr 7, 2013 at 11:06 PM, amol bhoj <amolbhoj7506@gmail.com> wrote:

you can not create new instance because billing is disabled...

--
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: Cannot create new instance (billing not enabled)

Hello Avraam,

Looks like you were able to create an instance today. Please let us know if that's still an issue.

On Sun, Apr 7, 2013 at 10:46 AM, Avraam Mauridis <avraammauridis@gmail.com> wrote:

I have the same problem,

Project Number 502789777557
Project ID
tiagorazoti

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

Error..please help me..you can not create new instance because billing is disabled...

you can not create new instance because billing is disabled...

Re: Cannot create new instance (billing not enabled)

same problem can you help me..
project id=x7-subtle-odyssey-r

On Sunday, 4 November 2012 13:33:59 UTC-8, Mike Drummond wrote:

I'm receiving the following error when attempting to create a new instance: "you cannot create new instances because billing is disabled".
I can confirm billing is enabled.
Project number: 411892037600

Re: External access via python API?

Hi Luca

We don't currently support an external Python API, but you can access the external JDBC connector using JayDeBeAPI or similar

On Sat, Apr 6, 2013 at 2:17 PM, Luca de Alfaro <luca.de.alfaro@gmail.com> wrote:

I read in https://developers.google.com/cloud-sql/docs/external about the Java API to connect to Google Cloud SQL.
Is there a way to connect also using a Python API?

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.

--
Joe Faith | Product Manager | Google Cloud

Re: How many backups are kept?

Hi Luca

7 days backups are stored without charge at the moment, but the 'subtle degradation' use case is an interesting one for us to consider.

thanks

On Sat, Apr 6, 2013 at 10:37 AM, Luca de Alfaro <luca.de.alfaro@gmail.com> wrote:

How many of the daily automated backups are kept?

I would gladly pay more to keep e.g. 5 daily, 4 weekly, 6 monthly backups, if the price of keeping them is similar to the price on Google Storage.

This is purely as a wish; I know I can take additional backups simply by clicking on "export data".
Having the additional backups would be useful not so much in case of catastrophic data loss (in which case I would restore the latest backup), but in case I have some subtle problem that I don't notice immediately, and that I need to correct by going back to some older version of the data. For that to be useful, however, I would really need to have the ability to restore the backup in a _different_ database, so that I can then write some code that compares the two and does whatever fixes necessary.

Obviously this is a low priority food for thought; so far I am quite happy simply exporting a copy of the DB before doing important code changes.

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.

--
Joe Faith | Product Manager | Google Cloud

Re: Cannot create new instance (billing not enabled)

I have the same problem,

Project Number	502789777557
Project ID	tiagorazoti

Saturday, April 6, 2013

External access via python API?

I read in https://developers.google.com/cloud-sql/docs/external about the Java API to connect to Google Cloud SQL.

Is there a way to connect also using a Python API?

Luca

How many backups are kept?

How many of the daily automated backups are kept?

I would gladly pay more to keep e.g. 5 daily, 4 weekly, 6 monthly backups, if the price of keeping them is similar to the price on Google Storage.

This is purely as a wish; I know I can take additional backups simply by clicking on "export data".

Having the additional backups would be useful not so much in case of catastrophic data loss (in which case I would restore the latest backup), but in case I have some subtle problem that I don't notice immediately, and that I need to correct by going back to some older version of the data. For that to be useful, however, I would really need to have the ability to restore the backup in a _different_ database, so that I can then write some code that compares the two and does whatever fixes necessary.

Obviously this is a low priority food for thought; so far I am quite happy simply exporting a copy of the DB before doing important code changes.

Luca

Thursday, April 4, 2013

Importing data into database

Hi,

I am unsure in starting up a Google Cloud SQL Database.

I want to take data from a website in xml format and upload this into my database. How can I do this on a daily basis automatically? Should I use something like Python?

Do I have to import the xml into my own mysql database on my home database and then import this into my google database?

Thanks

P Cal

Tuesday, April 2, 2013

Re: populate time zone table

Well, being able to do

CONVERT_TZ(dt, 'GMT', 'US/Eastern')

would be great. Why is this such an issue?

Re: issue in google cloud

Hello,

Could you provide more information? This stack trace isn't very useful. I cannot tell whether this is a issue with the app, with App Engine, or with Cloud SQL.

On Tue, Apr 2, 2013 at 12:19 AM, <glycus.technologies@gmail.com> wrote:

hi this is satish

I have made a Google App Engine project in Vaadin with google cloud sql database. I've tested it well on my local machine, without (any important) bugs. When I deploy it to GAE it also works for a certain time. Only after x hours it stops working (doing exactly the same as before and without changing anything to the code). If I deploy the project again, it is working again.When I take a look at the GAE logs it seems to be a 2013-03-25 10:26:03.071 com.vaadin.terminal.gwt.server.GAEApplicationServlet service: An exception occurred while servicing request. javax.servlet.ServletException: java.lang.RuntimeException at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.handleServiceException(AbstractApplicationServlet.java:1010) at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:548) at com.vaadin.terminal.gwt.server.GAEApplicationServlet.service(GAEApplicationServlet.java:239) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
java google-app-engine vaadin
--
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.

issue in google cloud

hi this is satish

I have made a Google App Engine project in Vaadin with google cloud sql database. I've tested it well on my local machine, without (any important) bugs. When I deploy it to GAE it also works for a certain time. Only after x hours it stops working (doing exactly the same as before and without changing anything to the code). If I deploy the project again, it is working again.When I take a look at the GAE logs it seems to be a 2013-03-25 10:26:03.071 com.vaadin.terminal.gwt.server.GAEApplicationServlet service: An exception occurred while servicing request. javax.servlet.ServletException: java.lang.RuntimeException at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.handleServiceException(AbstractApplicationServlet.java:1010) at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:548) at com.vaadin.terminal.gwt.server.GAEApplicationServlet.service(GAEApplicationServlet.java:239) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
java google-app-engine vaadin

Monday, April 1, 2013

Re: Are backups occurring for you? (not for me)

Thanks for the very quick reply -- and for the wonderful service!! (I love using Google Cloud SQL from appengine!).

I can confirm that a backup has run tonight.

Luca

On Sunday, March 31, 2013 11:53:15 AM UTC-7, Luca de Alfaro wrote:

On my D0 instance, backups are scheduled, but they never occur.
There is no message as to why.
I read that there should be a cloudsqladmin user, which is used to do backups.
Yet, on my D0 instance, and also on a D1 instance I created just for testing this, the command "select * from mysql.user" generates only the following users:

Host User
localhost root
127.0.0.1 root
::1 root
localhost

So I have two questions:

Do backups work for you?

Do you see the cloudsqladmin user listed?

Any suggestion on how to get backups to run would be appreciated.

Luca

Pages

Tuesday, April 30, 2013

Friday, April 26, 2013

Wednesday, April 24, 2013

Tuesday, April 23, 2013

Monday, April 22, 2013

Sunday, April 21, 2013

Saturday, April 20, 2013

Thursday, April 18, 2013

Wednesday, April 17, 2013

Tuesday, April 16, 2013

Friday, April 12, 2013

Sunday, April 7, 2013

Saturday, April 6, 2013

Thursday, April 4, 2013

Tuesday, April 2, 2013

Monday, April 1, 2013