jakarta-ee - 无法在 Web Logic derby 数据源上执行语句

Question

我正在使用 WebLogic Server 访问数据库。我已通过管理控制台将数据库添加到我的 WebLogic Server 实例中。这是一个 apache derby 数据库。我能够在我的代码中建立连接，但是每次我尝试执行语句时都会出现异常：

java.sql.SQLSyntaxErrorException：架构 'WEBLOGIC' 不存在于 org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException（未知来源）

和别人聊天的时候，听说可能我的derby版本老了，不过我刚下载了最新的版本（10.14.2.0）。我还注意到 WLS 有它自己的 derby 目录 (Oracle_Home\wlserver\common\derby)，所以我尝试用最新版本替换那里的 lib 文件夹，但这没有任何帮助。

当我尝试执行我的语句时，我的 InsertStudents 方法中发生了异常。我完全迷失在这里。

  public class JNDIPrinter {
  private static String tableName = "student";
  // jdbc Connection
  private static Connection conn = null;
  private static Statement stmt = null;

  public void AddStudents() {
    Context ctx = null;
    try {
      conn = GetConnection();
      List<Student> students;

      students = new ArrayList<Student>(
          Arrays.asList(new Student("first1", "last1", "111-11-1111", "[e-mail]", "111 1st st", "user1", "pw1"),
              new Student("first2", "last2", "222-22-2222", "[e-mail]", "222 2nd st", "user2", "pw2"),
              new Student("first3", "last3", "333-33-3333", "[e-mail]", "333 3rd st", "user3", "pw3")));

      InsertStudents(students);
    } catch (Exception e) {
      System.out.println(e.toString());
    } finally {
      if (ctx != null) {
        try {
          ctx.close();
        } catch (NamingException e) {
          System.out.println("Failed to close context due to: " + e);
        }
      }
    }
  }

  private Connection GetConnection() throws NamingException, SQLException {
    Context ctx = null;
    String url = null;
    System.out.println(url);
    Hashtable env = new Hashtable();
    // This *required* property specifies the factory to be used
    // to create the context.
    env.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");

    if (url != null) {
      // This property specifies the URL of the WebLogic Server that will
      // provide the naming service. Defaults to t3://localhost:7001
      env.put(Context.PROVIDER_URL, url);
    }

    ctx = new InitialContext(env);
    System.out.println("Initial context created");
    DataSource ds = (javax.sql.DataSource) ctx.lookup("jhuDataSource");
    System.out.println("Datasource created");
    java.sql.Connection connection = (java.sql.Connection) ds.getConnection();
    return connection;
  }

  private void InsertStudents(List<Student> students) throws SQLException{
    try {
      for (Student student : students) {
        stmt = conn.createStatement();
        stmt.execute("insert into " + tableName + " values ('" 
                                                  + student.first_name + "','" 
                                                  + student.last_name +  "','" 
                                                  + student.ssn +       "','"
                                                  + student.email +     "','" 
                                                  + student.address +   "','" 
                                                  + student.userID +    "','" 
                                                  + student.password +  "')");
        stmt.close();
      }
    } catch (SQLException sqlExcept) {
      sqlExcept.printStackTrace();
    }
  }
}
```````

标签： jakarta-eeweblogicderby