On Fri, Jul 20, 2012 at 8:00 AM, Luis Esteban Acosta Zuñiga <luis.acostaz@gmail.com> wrote:
Good morning.I'm trying to connect to my Google Cloud SQL instance - database from Talend software.I add a JDBC Connection, with these parameters:JDBC URL: jdbc:google:rdbms:proy-laz:tmp-sio:mina
Double check that instance name. I don't think it exists.
Ken
DRIVER JAR: google_sql.jar (This is the jar used by the Google SQL Command Line Tool)DRIVER CLASS: com.google.cloud.sql.DriverUSER: (the same used and working from Eclipse App Engine Plugin)PASSWORD: (the same used and working from Eclipse App Engine Plugin)Whe I try to run the connection I get the next exception:Exception in component tJDBCConnection_1java.sql.SQLInvalidAuthorizationSpecException: boss::NOT_AUTHORIZED: Not authorized to access instance: proy-laz:tmp-sio:minaat com.google.cloud.sql.jdbc.internal.Exceptions.newSqlExceptionForApplicationError(Exceptions.java:192)at com.google.cloud.sql.jdbc.internal.Exceptions.newSqlException(Exceptions.java:211)at com.google.cloud.sql.jdbc.internal.SqlProtoClient.check(SqlProtoClient.java:158)at com.google.cloud.sql.jdbc.internal.SqlProtoClient.openConnection(SqlProtoClient.java:60)at com.google.cloud.sql.jdbc.Driver.connect(Driver.java:66)at com.google.cloud.sql.Driver.connectImpl(Driver.java:109)at com.google.cloud.sql.Driver.connect(Driver.java:98)at com.google.cloud.sql.Driver.connect(Driver.java:31)at java.sql.DriverManager.getConnection(Unknown Source)at java.sql.DriverManager.getConnection(Unknown Source)at talenddemosjava.connect_cloud_0_1.connect_cloud.tJDBCConnection_1Process(connect_cloud.java:279)at talenddemosjava.connect_cloud_0_1.connect_cloud.runJobInTOS(connect_cloud.java:620)at talenddemosjava.connect_cloud_0_1.connect_cloud.main(connect_cloud.java:488)I have already installed and configured the Command Line Tool and it works fine with the user and password used in this connection.Please, somebody knows if I need to configure anything else to get the connection working?Thanks in advance for your help.Regards.Lucho Acosta
No comments:
Post a Comment