我可以将Derby EmbeddedDriver与Java教程中指定的CachedRowSet示例一起使用吗？

Question

在JDBC教程中，有几个示例java程序可以运行。Ant目标runcrs不运行。当我在嵌入式驱动程序模式下使用Derby提供的代码时，crs上出现错误。执行：

try {
  crs.setUsername(settings.userName);
  crs.setPassword(settings.password);
  crs.setUrl(settings.urlString);
  crs.setCommand("select * from MERCH_INVENTORY");

  // Setting the page size to 4, such that we
  // get the data in chunks of 4 rows @ a time.
  crs.setPageSize(100);

  // Now get the first set of data
  crs.execute(); // Throws exception. No suitable driver found.

[java] Found item 6914: Cookbook (12)
[java] Found item 123456: TableCloth (14)
[java] java.sql.SQLException: No suitable driver found for jdbc:derby:testdb
[java]    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702)
[java]    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
[java]    at java.sql.rowset/com.sun.rowset.internal.CachedRowSetReader.connect(CachedRowSetReader.java:340)
[java]    at java.sql.rowset/com.sun.rowset.internal.CachedRowSetReader.readData(CachedRowSetReader.java:157)
[java]    at java.sql.rowset/com.sun.rowset.CachedRowSetImpl.execute(CachedRowSetImpl.java:809)
[java]    at java.sql.rowset/com.sun.rowset.CachedRowSetImpl.execute(CachedRowSetImpl.java:1435)
[java]    at com.oracle.tutorial.jdbc.CachedRowSetSample.testPaging(CachedRowSetSample.java:98)
[java]    at com.oracle.tutorial.jdbc.CachedRowSetSample.main(CachedRowSetSample.java:254)
[java] SQLState: 08001
[java] Error Code: 0
[java] Message: No suitable driver found for jdbc:derby:testdb

在放弃并寻求解决方案之前，我看了下面的帖子。它们涵盖了非嵌入式（客户端-服务器）实现，它们不涵盖CachedRowSet接口。通常解决方案是检查derby.jar是否在类路径上。（我检查了——运气不好。此外，驱动程序显然正在加载，因为非RowSet功能正在工作，例如，找到项目123456。）

臭名昭著的爪哇。sql。SQLException：找不到合适的驱动程序-覆盖derby的客户机/服务器实现

SQLException:未找到适合jdbc的驱动程序：derby://localhost:1527-客户端服务器，未嵌入

没有为JDBC DERBY找到合适的驱动程序错误-不是行集实例化

没有为jdbc找到合适的驱动程序：derby://localhost:1527/prosto-客户端/服务器，未嵌入

http://apache-database.10148.n7.nabble.com/No-suitable-driver-found-for-jdbc-derby-td108280.html-使用类。forName；没有划船

JDBC embedded Derby:未找到合适的驱动程序-根本原因：连接字符串语法错误

java.sql.SQL异常：没有找到适合jdbc： derby的驱动程序：-根原因：类路径

Answer 1

事实证明，这些教程可能最近没有用Derby的嵌入式驱动程序进行过测试。通过将连接对象传递给不同的执行方法重载，代码毫无例外地执行：

...

public CachedRowSetSample(Connection connArg,
                        JDBCTutorialUtilities settingsArg) {
  super();
  this.con = connArg;

...

try {
  crs.setUsername(settings.userName);
  crs.setPassword(settings.password);
  crs.setUrl(settings.urlString);
  crs.setCommand("select * from MERCH_INVENTORY");

  // Setting the page size to 4, such that we
  // get the data in chunks of 4 rows @ a time.
  crs.setPageSize(100);

  // Now get the first set of data
  crs.execute(con); // Executes without error       // add 'con' (the connection object) as an arg

  ...