官方DEMO _JFinalDemoGenerator 生成器报错 ORA-00911: 无效字符

Skip table :http-log30_TAB
Skip table :include47_TAB
Skip table :include66_TAB
Skip table :privilege107_TAB
Skip table :title103_TAB
Skip table :title93_TAB
Skip table :xdb-log13_TAB
Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: ORA-00911: 无效字符
at com.jfinal.plugin.activerecord.generator.MetaBuilder.build(MetaBuilder.java:102)
at com.jfinal.plugin.activerecord.generator.Generator.generate(Generator.java:262)
at com.minstone.sysconfig.builder._JFinalDemoGenerator.main(_JFinalDemoGenerator.java:50)
Caused by: java.sql.SQLException: ORA-00911: 无效字符
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1313)
at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:138)
at com.jfinal.plugin.activerecord.generator.MetaBuilder.buildColumnMetas(MetaBuilder.java:222)
at com.jfinal.plugin.activerecord.generator.MetaBuilder.build(MetaBuilder.java:97)
... 2 more


评论区

duoduozi

2018-05-03 18:00

调试发现 表名用单引号括起来的 , 语句在oracle 下执行失败
select * from `table_name` where 1 = 2;

JFinal

2018-05-03 22:09

@duoduozi 明显是没有设置方言,这个在文档中有:
activeRecordPlugin.setDialect(new OracleDialect());

MWL

2020-05-11 12:26

@JFinal @JFinal 我设置了方言还是报这个错误
怎么办

个人开发乎

2020-11-05 01:42

@MWL 我也有这个问题 咋解决了没?

xvzhang

2021-04-16 11:23

在生成器设置
generator.setDialect(new OracleDialect());

热门反馈

扫码入社