Guest User

Untitled

a guest
Feb 5th, 2018
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. try {
  2. //DriverManager.registerDriver(com.mysql.jdbc.Driver);
  3. String DBUrl = String.format("jdbc:mysql://google/%s?cloudSqlInstance=%s&"
  4. + "socketFactory=com.google.cloud.sql.mysql.SocketFactory",
  5. databaseName,instanceConnectionName);
  6. Connection DbConn = DriverManager.getConnection(DBUrl,DBUser,DBPwd);
  7. } catch(SQLException ex) {
  8. System.out.println("Database Connection Error."+ex.getMessage());
  9. }
  10.  
  11. try {
  12. // -- Use cloud sql remote ip address say x.x.x.x
  13. String DBUrl = String.format("jdbc:mysql://x.x.x.x:3306/%s",databaseName);
  14. Connection DbConn = DriverManager.getConnection(DBUrl,DBUser,DBPwd);
  15. } catch(SQLException ex) {
  16. System.out.println("Database Connection Error."+ex.getMessage());
  17. }
Add Comment
Please, Sign In to add comment