|

楼主 |
发表于 2016-8-5 17:32:06
|
显示全部楼层
本帖最后由 simonllf 于 2016-8-5 17:41 编辑
后来我重新设了一个数据源就少了不少错误。。但还是提示上面的错误。。。看提示是几个数据表的问题。。是哪里没设好?raise exception,sql is:
SELECT * FROM Volume
ERROR 17:37:02,923 Search knownledge object error, sql is SELECT * FROM Volume
java.sql.SQLException: Table not found in statement [SELECT * FROM Volume]
at com.datanew.db.DNJDBCDataset.executeSQL(DNJDBCDataset.java:609)
at com.datanew.db.DNJDBCDataset.open(DNJDBCDataset.java:259)
at com.datanew.db.DNJDBCDataset.open(DNJDBCDataset.java:203)
at com.datanew.knowledge.sql.HSqldbStorageManager.search(HSqldbStorageManager.java:888)
at com.datanew.knowledge.sql.HSqldbStorageManager.search(HSqldbStorageManager.java:837)
at com.datanew.knowledge.sql.HSqldbStorageManager.search(HSqldbStorageManager.java:803)
at com.datanew.knowledge.sql.HSqldbStorageManager.search(HSqldbStorageManager.java:779)
at com.datanew.knowledge.pool.AbstractDeserializationCondition.deserializeObjects(AbstractDeserializationCondition.java:138)
at com.datanew.knowledge.pool.AbstractDNObjectPool.fillAll(AbstractDNObjectPool.java:486)
at com.datanew.knowledge.pool.VolumePool.fillAll(VolumePool.java:79)
at com.datanew.knowledge.pool.AbstractDNObjectPool.getCache(AbstractDNObjectPool.java:429)
at com.datanew.knowledge.pool.AbstractDNObjectPool.getAllObject(AbstractDNObjectPool.java:150)
at com.datanew.knowledge.pool.VolumePool.getAllObject(VolumePool.java:153)
at com.datanew.util.DBConnPoolUtil.refreshDNServerKnowledgeConnPool(DBConnPoolUtil.java:142)
at com.datanew.InitServlet.init(InitServlet.java:154)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1213)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4425)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4738)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
raise exception,sql is:
SELECT * FROM FileProperty WHERE fileType='con'
ERROR 17:37:02,923 Search knownledge object error, sql is SELECT * FROM FileProperty WHERE fileType='con'
java.sql.SQLException: Table not found in statement [SELECT * FROM FileProperty]
at com.datanew.db.DNJDBCDataset.executeSQL(DNJDBCDataset.java:609)
at com.datanew.db.DNJDBCDataset.open(DNJDBCDataset.java:259)
at com.datanew.db.DNJDBCDataset.open(DNJDBCDataset.java:203)
at com.datanew.knowledge.sql.HSqldbStorageManager.search(HSqldbStorageManager.java:888)
at com.datanew.knowledge.sql.HSqldbStorageManager.search(HSqldbStorageManager.java:837)
at com.datanew.knowledge.sql.HSqldbStorageManager.search(HSqldbStorageManager.java:803)
at com.datanew.knowledge.sql.HSqldbStorageManager.search(HSqldbStorageManager.java:779)
at com.datanew.util.DBConnPoolUtil.refreshBusinessVolumePools(DBConnPoolUtil.java:225)
at com.datanew.util.DBConnPoolUtil.refreshAllBusinessVolumeConnPool(DBConnPoolUtil.java:206)
at com.datanew.InitServlet.init(InitServlet.java:155)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1213)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4425)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4738)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
raise exception,sql is:
select count(*) as tableCount from ObjectParams
2016-08-05 17:37:02,939 **************Welcome to HappyServer,Now,please initialize it first.**************
八月 05, 2016 5:37:03 下午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory ROOT
八月 05, 2016 5:37:04 下午 org.apache.coyote.http11.Http11Protocol start
信息: Starting Coyote HTTP/1.1 on http-687
八月 05, 2016 5:37:04 下午 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
八月 05, 2016 5:37:04 下午 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/63 config=null
八月 05, 2016 5:37:04 下午 org.apache.catalina.startup.Catalina start
信息: Server startup in 34239 ms
|
|