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
DRIVER JAR: google_sql.jar (This is the jar used by the Google SQL Command Line Tool)
DRIVER CLASS: com.google.cloud.sql.Driver
USER: (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_1
java.sql.SQLInvalidAuthorizationSpecException: boss::NOT_AUTHORIZED: Not authorized to access instance: proy-laz:tmp-sio:mina
at 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