平台启动测试

zrz512

2013-12-09 14:42:00 加载模块：/SA/OPM/logic/code/orgSynchronize ...
jlog error!2013-12-09 14:42:01
javax.servlet.ServletException: 业务服务器初始化失败：执行ksql:SELECT p FROM SA_
OPPerson p where p.sValidState=1时出错！
        at com.justep.business.server.BusinessServerServlet.init(Unknown Source)

        at com.justep.x.bs.BusinessServerServlet.init(Unknown Source)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:1173)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:99
3)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:4350)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
659)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:5
19)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT p FROM SA_
OPPerson p where p.sValidState=1时出错！
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown So
urce)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown So
urce)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown So
urce)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at com.justep.business.server.BusinessServer.init1(Native Method)
        at com.justep.business.server.BusinessServer.init(Unknown Source)
        ... 19 more
Caused by: com.justep.exception.SystemException: 在/system/data模块下连接数据库
出错！
        at com.justep.system.data.Transaction.getConnection(Unknown Source)
        at com.justep.system.data.Transaction.getConnection(Unknown Source)
        at com.justep.model.ModelUtils.getConnection(Unknown Source)
        ... 25 more
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create Poolabl
eConnectionFactory (Network error IOException: Connection refused: connect)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionF
actory(BasicDataSource.java:1549)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDat
aSource.java:1388)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSo
urce.java:1044)
        at com.justep.system.data.Transaction.getConnectionWithJndi(Unknown Sour
ce)
        ... 28 more
Caused by: java.sql.SQLException: Network error IOException: Connection refused:
connect
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java
:372)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java
:50)
        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
        at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(
DriverConnectionFactory.java:38)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(Pool
ableConnectionFactory.java:582)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory
(BasicDataSource.java:1556)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionF
actory(BasicDataSource.java:1545)
        ... 31 more
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:367)
        at java.net.Socket.connect(Socket.java:524)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSoc
ket.java:289)
        at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:250)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java
:297)
        ... 37 more
2013-12-9 14:42:01 org.apache.catalina.startup.HostConfig deployDescriptor


我的报这个错误。是数据库错误么？

Geek_X

数据源是否配好？
MySql是否启动？
是否先启动数据库，再启动tomcat？

sue

是访问数据库有问题
修改数据源的时候推荐通过studio“窗口——首选项——Studio配置——数据源修改

zrz512

@Geek_X 启动好了。
如果输入  SELECT p FROM SA_OPPerson p where p.sValidState=1 会报错。
输入 SELECT * FROM SA_OPPerson  有数据

zrz512

找到原因了。
一开始准备用SQL2K的数据库。
开发工具中看到数据库指向错了。
用配置初始化其它数据库。bat选b恢复设置就好。