org.apache.derby.jdbc.ClientDriver;无法连接

Question

无法连接。使用org.apache.derby.jdbc.ClientDriver (derby SQL错误:ERRORCODE: 40000, SQLSTATE: XJ040, SQLERRMC:使用类加载器sun.misc启动数据库"sample"失败)无法建立到jdbc:derby://localhost:1527/sample的连接。启动器$AppClassLoader@1d44bcfa，详情见下一个异常。:: SQLSTATE: XSLAN)。

Answer 1

在进行连接时，应该将其放入try/catch中。例如(我使用Java 8和oracle SQLDeveloper):

String dbURL="jdbc:oracle:thin:@localhost:1521:xe";
String username = "system";
String password = "root";

try{
Connection connection = DriverManager.getConnection(dbURL,username,password);
System.out.println("Connected to Oracle database server");

String sql = "INSERT INTO USERS (name,email,password)" + "VALUES('eu', '[e-mail]', 'eu')";
Statement statement = connection.createStatement();
int rows = statement.executeUpdate(sql);
if(rows >0){
System.out.println("A row has been inserted");
}

connection.close();
}catch (SQLException e){
System.out.println("ERROR");
}

总是检查正确的密码和用户名。希望这对你有所帮助。: D