(求助！)Jfinal连接oracle数据库自动生成model的问题

Xyw
2017-03-26 15:11

错误信息：

然后debug跟踪sql语句

发现表名少啦双引号。求助怎么解决

项目：JFinal

评论区

JFinal

2017-03-26 17:15

这个表名比较特殊，建议通过创建 MyOracleDialect extends OracleDialect，覆盖掉其中的 forTableBuilderDoBuild() 方法，将下面的这一行改一下：
return "select * from " + tableName + " where rownum < 1";

改成如下：
return "select * from \"" + tableName + "\" where rownum < 1";

最后通过 generator.setDialect(new MyOracleDialect()) 进行方言的切换

Xyw

2017-03-26 20:45

@JFinal 收到哎呀我怎么没想到我还想说去重新弄jar包的

Xyw

2017-03-26 20:46

@JFinal 谢谢！

JFinal

2017-03-26 20:48

@Xyw jfinal 的大部分组件都是可以扩展的

sjb

2017-03-28 17:56

大神们帮我看看我的是什么问题，，同样也是oracle数据库的
Build TableMeta ...
Exception in thread "main" java.lang.RuntimeException: primaryKey required by active record pattern
at com.jfinal.plugin.activerecord.generator.MetaBuilder.buildPrimaryKey(MetaBuilder.java:199)
at com.jfinal.plugin.activerecord.generator.MetaBuilder.build(MetaBuilder.java:96)
at com.jfinal.plugin.activerecord.generator.Generator.generate(Generator.java:217)
at com.sztr.model._JFinalDemoGenerator.main(_JFinalDemoGenerator.java:56)

sjb

2017-03-28 18:00

貌似是某个表没有主键的意思？

JFinal

2017-03-28 18:05

@sjb 没有主键的表不要去生成：generator.addExcludeTable(tableName)

sjb

2017-03-28 18:27

Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: 流已被关闭
at com.jfinal.plugin.activerecord.generator.DataDictionaryGenerator.rebuildColumnMetas(DataDictionaryGenerator.java:205)
at com.jfinal.plugin.activerecord.generator.DataDictionaryGenerator.generate(DataDictionaryGenerator.java:61)
at com.jfinal.plugin.activerecord.generator.Generator.generate(Generator.java:234)
at com.sztr.model._JFinalDemoGenerator.main(_JFinalDemoGenerator.java:56)
Caused by: java.sql.SQLException: 流已被关闭
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.LongAccessor.getBytes(LongAccessor.java:151)
at oracle.jdbc.driver.LongAccessor.getString(LongAccessor.java:193)
at oracle.jdbc.driver.T4CLongAccessor.getString(T4CLongAccessor.java:422)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:397)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1515)
at com.jfinal.plugin.activerecord.generator.DataDictionaryGenerator.rebuildColumnMetas(DataDictionaryGenerator.java:179)
... 3 more