0

I'm having a spring application with maven. I want to communicate with a cloud SQL MySQL database I have in GCP asynchronously.

I tried following the getting started code and wrote this:

    Connection connection = MySQLConnectionBuilder
      .createConnectionPool(
       "jdbc:mysql://google/$DB_NAME
  ?socketFactory=com.google.cloud.sql.mysql.SocketFactory
  &cloudSqlInstance=$PROJECT_ID:$PROJECT_LOCATION:$INSTANCE_NAME"
      );

    CompletableFuture<QueryResult> future = connection.sendPreparedStatement("select * from TABLE_NAME");
    return future;

However,I keep getting this error:

io.netty.channel.ConnectTimeoutException: connection timed out

Can someone please help me out here?

Nick
  • 4,820
  • 18
  • 31
  • 47
Diksha
  • 1

1 Answers1

0

I figured out the solution to this issue. Posting it so it might be useful to someone in future.

The reason why it wasn't connecting to the cloudSQL instance is because I was trying to connect to the cloudSQL instance directly. Using a cloud SQL proxy solved the issue for me.

Diksha
  • 1