unknown database in jdbc

warner95

New Member
I am using JDBC and new to it. but I keep getting this runtime exception:\[code\] connecting to psysical database... com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'kholofelodb'at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.lang.reflect.Constructor.newInstance(Constructor.java:525)at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)at com.mysql.jdbc.Util.getInstance(Util.java:386)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943)at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113)at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1308)at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2336)at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.lang.reflect.Constructor.newInstance(Constructor.java:525)at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)at java.sql.DriverManager.getConnection(DriverManager.java:579)at java.sql.DriverManager.getConnection(DriverManager.java:221)at com.psybergate.database.SimbleCode.main(SimbleCode.java:22)\[/code\]Here is the gave code\[code\]try { String connectionURL = "jdbc:mysql://localhost:3306/kholofelodb"; Class.forName("com.mysql.jdbc.Driver"); System.out.println("connecting to psysical database..."); Connection conn = DriverManager.getConnection(connectionURL, USER, PASS); Statement statement = conn.createStatement(); System.out.println("Connection has been made"); Scanner keyBoardScanner = new Scanner(System.in); System.out.println("Enter table name:"); String tableName = keyBoardScanner.nextLine(); System.out.println("Creating table..."); statement.executeQuery("create table " + tableName + " (name , age ,salary)"); System.out.println("Table successfully created"); System.out.println("Inserting data into the table ..."); statement.executeUpdate("insert into " + tableName + "values (kholofelo , 21 , 9969696)"); } \[/code\]how do I get this code to work? I am only a beginner with JDBC.... for the above code; PASS = "passowrd", USER = "root"I had a problem with port which it was fixed through this sitethanks a lot
 
Top