Exception in thread "main" java.sql.SQLSyntaxErrorException: Unknown database 'myDB'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:448)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at JDBCInsertExample.main(JDBCInsertExample.java:19)|
As the exception cleary states that the Database that you are trying to access using JDBC does not exist, there are multiple things that might go wrong,
Possible issues and fixes:- Make sure you have spelled the database name correctly.
- Database names are case-sensitive, make sure it matches with what is there in your Database (MySQL, Oracle, etc)
- Use database query to validate the database name,
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | my_uat | | mysql | | performance_schema | | sys | +--------------------+ 5 rows in set (0.07 sec)
- Make sure you are connecting to the right Database server (it could be you are on the wrong server uat/staging/local)
- Make sure the database port is correct
-
Have Questions? Post them here!
More Posts related to Java,
- Add two numbers using Java Generics
- Convert Java List to Json String using Jackson
- Convert Java Object to JSON using Jackson Library
- Java SE JDBC: Insert with PreparedStatement Example
- [Program] How to read three different values using Scanner in Java
- Java JDBC Batch Update Example with PreparedStatement
- Java Stream flatmap() Examples
- Save Java Object as JSON file using Jackson Library
- Java get day of the week as an int using DayOfWeek
- Create Nested Directories using Java Code
- Java JDBC Delete a Record in Database Table using PreparedStatement
- List of jars required for Struts2 project
- Convert Java Object to XML using Jackson Library
- Struts2 : java.lang.ClassNotFoundException: org.apache.commons.fileupload.RequestContext
- Java JDBC Get Id of the Inserted Record with AutoIncrement
- How to list all tables using Java JDBC
- Java Jackson ObjectMapper Class with Examples
- Fix: Maven - Failed to execute goal - Compilation failure - Source/Target option 5 is no longer supported. Use 7 or later
- Eclipse : The type java.lang.CharSequence cannot be resolved. Indirectly referenced from required .class files
- Formatting Double in Java [Examples]
- How to run Java Unit Test cases with Apache Maven?
- [fix] NullPointerException Cannot Invoke findById because Repository is null - Java Spring
- [Fix] java: integer number too large compilation error
- [Java] Read a File with UTF-8 Encoding
- How to detect Operating System using Java code
More Posts:
- Get the current timestamp in Java - Java
- Change Terminal Cursor Type in Mac (MacOS Shell) - MacOS
- How to remove unwanted Java imports in IntelliJ (alternative of eclipse Ctrl + Shift + O) - Eclipse
- Take input argument from command line in Python Programming - Python
- [Fix] Connect to Minecraft Remote Connect URL via https //aka.ms/remoteconnect - Microsoft
- Install Python on Alpine Linux - Docker - Docker
- macOS Ventura Login Item Added Google Chrome Notification - MacOS
- Pdf Text to Speech option in Mac OS X Preview App - Mac-OS-X