rapid-framework 连接 oracle时的一个bug

最新推荐文章于 2024-11-21 16:41:06 发布

最新推荐文章于 2024-11-21 16:41:06 发布 · 221 阅读

文章标签：

#Oracle #Java #JDBC #SQL #thread

java 专栏收录该内容

79 篇文章

订阅专栏

本文介绍了解决Oracle数据库中ORA-01424错误的方法，该错误通常由于系统表读取过程中出现非法字符引起。文章提供了具体的代码修改建议，通过过滤特定字符来避免异常。

在连接oracle数据库时报错:

Exception in thread "main" java.lang.RuntimeException: create table object error,tableName:BIN$Z/lzLZsvmqzgQKjAyQEZdw==$0
	at cn.org.rapid_framework.generator.provider.db.DbTableFactory.createTable(DbTableFactory.java:115)
	at cn.org.rapid_framework.generator.provider.db.DbTableFactory.getAllTables(DbTableFactory.java:124)
	at cn.org.rapid_framework.generator.provider.db.DbTableFactory.getAllTables(DbTableFactory.java:81)
	at cn.org.rapid_framework.generator.GeneratorFacade.printAllTableNames(GeneratorFacade.java:25)
	at cn.org.rapid_framework.generator.GeneratorMain.main(GeneratorMain.java:13)
Caused by: java.sql.SQLException: ORA-01424: missing or illegal character following the escape character

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
	at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198)
	at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2400)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
	at oracle.jdbc.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:2569)
	at cn.org.rapid_framework.generator.provider.db.DbTableFactory.getColumnsResultSet(DbTableFactory.java:342)
	at cn.org.rapid_framework.generator.provider.db.DbTableFactory.getTableColumns(DbTableFactory.java:294)
	at cn.org.rapid_framework.generator.provider.db.DbTableFactory.retriveTableColumns(DbTableFactory.java:278)
	at cn.org.rapid_framework.generator.provider.db.DbTableFactory.createTable(DbTableFactory.java:109)
	... 4 more

问题在于把系统表也读了出来,解决办法:

在createTable(Connection conn, ResultSet rs)

方法里加判断

if(realTableName.indexOf("$")>0)

return null;

在getAllTables方法里加

if(table != null)

tables.add(table);