NutzCN Logo
问答 sqlite数据源 执行Daos.migration出错
发布于 2663天前 作者 belialofking 1436 次浏览 复制 上一个帖子 下一个帖子
标签:

2017-1-19 12:3:44.442 DEBUG [main] migration Table 'tbl_group' fail!
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "show": syntax error)
at org.sqlite.core.DB.newSQLException(DB.java:890)
at org.sqlite.core.DB.newSQLException(DB.java:901)
at org.sqlite.core.DB.throwex(DB.java:868)
at org.sqlite.core.NativeDB.prepare(Native Method)
at org.sqlite.core.DB.prepare(DB.java:211)
at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:40)
at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:29)
at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:18)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:47)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:254)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:226)
at org.nutz.dao.impl.jdbc.AbstractJdbcExpert.getIndexNames(AbstractJdbcExpert.java:470)
at org.nutz.dao.util.Daos$4.invoke(Daos.java:808)
at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158)
at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125)
at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
at org.nutz.dao.util.Daos.migration(Daos.java:765)
at org.nutz.dao.util.Daos.migration(Daos.java:690)
at simplenote.DbManager.(DbManager.java:22)
at simplenote.DbManager.(DbManager.java:16)
at simplenote.GroupDao.queryListByParent(GroupDao.java:26)
at simplenote.SimpleNodeApp.initTree(SimpleNodeApp.java:144)
at simplenote.SimpleNodeApp.main(SimpleNodeApp.java:34)
Daos.migration(dao, Group.class, true, true, true);
最后一个参数为true时出错
版本 1.r.60

3 回复

sqlite的话就别迁移索引了。。。

推荐用h2database,1mb的jar,纯java,jdbc兼容性很好

我自己用不到,只是发现了提一下

@belialofking 嗯嗯,看来加点判断比较好

添加回复
请先登陆
回到顶部