时间戳

首页 > 解决方案 > 在 Eclipse 中连接到 derby 数据库

java - 在 Eclipse 中连接到 derby 数据库

问题描述

我需要使用 eclipse 建立一个 derby 数据库连接。这是我的代码-

'String driver = "org.apache.derby.jdbc.ClientDriver";
 String dbName="jdbcDemoDB";
// define the Derby connection URL to use 
String connectionURL = "jdbc:derby://localhost:1527/" + dbName+";create=true";
Connection conn = null;'
try {
        conn = DriverManager.getConnection(connectionURL);       
        System.out.println("Connected to database " + dbName);
        s = conn.createStatement();
}
catch (Throwable e)  {   
        /*       Catch all exceptions and pass them to 
         *       the Throwable.printStackTrace method  */
        System.out.println(" . . . exception thrown:");
        e.printStackTrace(System.out);
     }

我从代码中得到一个异常（conn=DriverManager.getConnection(connectionURL)）：

`java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at com.sid.WwdClientExample.main(WwdClientExample.java:57)
Caused by: org.apache.derby.client.am.DisconnectException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
at org.apache.derby.client.net.NetAgent.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source)
at org.apache.derby.client.am.Connection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)'

我已将 derby jar 文件包含在我的 WEB-INF/lib 文件夹中。我是德比的新手，我想尝试与德比建立联系。

任何帮助表示赞赏。

标签： javaeclipsejvmderby

解决方案

推荐阅读