java.sql.SQLException: No database selected – why?

by

Before you can add a table, you first have to select a database.
you can create a new database with:

  CREATE DATABASE database_name

you can connect to a specific database with: 

String url = "jdbc:mysql://localhost/databasename";
String username = "test";
String password = "test";
Connection connection = DriverManager.getConnection(url, username, password);

More Related Contents:

  1. Connect Java to a MySQL database
  2. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  3. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  4. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  5. Can we connect remote MySQL database in Android using JDBC? [closed]
  6. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  7. Cannot issue data manipulation statements with executeQuery()
  8. Handling MySQL datetimes and timestamps in Java
  9. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  10. JDBC MySql connection pooling practices to avoid exhausted connection pool
  11. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  12. right syntax to use near ‘?’
  13. java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  14. Running a .sql script using MySQL with JDBC
  15. Java JDBC Access denied for user [closed]
  16. java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x91\xBD\xF0\x9F…’
  17. Passing parameters to a JDBC PreparedStatement
  18. JDBC character encoding
  19. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  20. JDBC returning MySQLSyntaxError Exception with correct statement
  21. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  22. MySQL connector error “The server time zone value Central European Time” [duplicate]
  23. com.mysql.jdbc.PacketTooBigException
  24. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server [duplicate]
  25. Should a database connection stay open all the time or only be opened when needed?
  26. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  27. Converting mysql table to spark dataset is very slow compared to same from csv file
  28. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  29. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  30. JDBC MySQL connection using Unix Socket

Leave a Comment