解决Tersus 2.0.3.1版本报JDBC连接失败的错误

沈思博

2023-12-01

关于下面错误的解决方法：

Tersus 2.0.3.1 Studio是自动把HSQLDB迁入到工具的。

首先查找工程文件的/database目录下*.properties的HSQLDB的版本是多少，根据版本到

http://sourceforge.net/projects/hsqldb/files/hsqldb/下载对应的版本，然后把hsqldb.jar替换到

安装目录下\plugins\tersus.utils_2.0.3\db-lib的hsqldb.jar，这样就不会报下面的错误了。用了2个小时解决这个问题。

This is the error :

INFO 2011-03-16 15:54:53,984 [Worker-1] Initializing WebContext #1

INFO 2011-03-16 15:54:53,984 [Worker-1] WebContext #1 initialized in 0 ms.

ERROR 2011-03-16 15:54:54,406 [Worker-1] Request ID:20110316-15:54:53:968 [Worker-1]

java.lang.RuntimeException: Failed to create connection to DataSource jdbc/Main

at tersus.runtime.SQLUtils.connectToDataSource(SQLUtils.java:140)

at tersus.runtime.SQLUtils.tableExists(SQLUtils.java:46)

at tersus.runtime.RuntimeContext.cacheUpdateTableExits(RuntimeContext.java:387)

at tersus.runtime.RuntimeContext.permissionCacheExists(RuntimeContext.java:377)

at tersus.runtime.RuntimeContext.clearPermissionCacheIfNeeded(RuntimeContext.java:364)

at tersus.runtime.ContextPool.getContext(ContextPool.java:440)

at tersus.webapp.ContextPool.getContext(ContextPool.java:819)

at tersus.runtime.ContextPool.startUp(ContextPool.java:228)

at tersus.webapp.ContextPool.initAndStartup(ContextPool.java:223)

at tersus.webapp.ContextPool.contextInitialized(ContextPool.java:211)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)

at tersus.appserver.ApplicationServer.start(ApplicationServer.java:383)

at tersus.appserver.ui.LaunchApplicationActionDelegate$1.run(LaunchApplicationActionDelegate.java:115)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (wrong database file version)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)

at tersus.runtime.SQLUtils.connectToDataSource(SQLUtils.java:136)

... 17 more

Caused by: java.sql.SQLException: wrong database file version

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)

at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)

at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)

at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)

... 19 more

Caused by: org.hsqldb.HsqlException: wrong database file version

at org.hsqldb.error.Error.error(Unknown Source)

at org.hsqldb.persist.HsqlDatabaseProperties.load(Unknown Source)

at org.hsqldb.persist.Logger.openPersistence(Unknown Source)

at org.hsqldb.Database.reopen(Unknown Source)

at org.hsqldb.Database.open(Unknown Source)

at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)

at org.hsqldb.DatabaseManager.newSession(Unknown Source)

... 26 more

ERROR 2011-03-16 15:54:54,406 [Worker-1] Startup failed