SQL2008R2上怎么部署X5studio

zhouhaijun_168

我是一个新手，我想学一下X5 studio。我下了安装包，按照快速说明运行了；“启动MySQL数据库”，“启动X5开发工具”运行tomcat：报错误，我打开SQL2008R2看后，数据库没有任何数据库生成；错误提示如下，求高手解决
JUSTEP_HOME in UIServer]: E:\X5.2.6_dev\X5.2.6
[JUSTEP_HOME in BusinessServer]: E:\X5.2.6_dev\X5.2.6
2013-12-15 20:08:30 BusinessServer debug mode --> true
许可信息
版本：开发版
2013-12-15 20:08:30 加载模块：/SA/OPM/system ...
2013-12-15 20:08:30 加载模块：/SA/OPM ...
2013-12-15 20:08:30 加载模块：/SA ...
2013-12-15 20:08:30 加载模块：/system/logic/action ...
2013-12-15 20:08:30 加载模块：/system/logic ...
2013-12-15 20:08:30 加载模块：/system ...
2013-12-15 20:08:30 加载模块：/system/data ...
2013-12-15 20:08:30 加载模块：/system/ontology ...
2013-12-15 20:08:30 加载模块：/system/logic/fn ...
2013-12-15 20:08:31 加载模块：/SA/OPM/logic/action ...
2013-12-15 20:08:31 加载模块：/SA/OPM/logic ...
2013-12-15 20:08:31 加载模块：/system/logic/code ...
2013-12-15 20:08:31 加载模块：/SA/OPM/logic/code ...
2013-12-15 20:08:31 加载模块：/SA/OPM/logic/code/orgSynchronize ...
2013-12-15 20:08:32 编码: JUSTEP150009; 提示: 业务服务器初始化出错
com.justep.exception.BusinessException: 编码: JUSTEP150009; 提示: 业务服务器初始化出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        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:993)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
        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:519)
        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(DelegatingMethodAccessorImpl.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.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT p FROM SA_OPPerson p where p.sValidState=1
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        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.BusinessException: 编码: JUSTEP150055; 提示: 在模块"/system/data"下获取数据库连接出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        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 PoolableConnectionFactory (Unable to get information from SQL Server: ..)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at com.justep.system.data.Transaction.getConnectionWithJndi(Unknown Source)
        ... 28 more
Caused by: java.sql.SQLException: Unable to get information from SQL Server: ..
        at net.sourceforge.jtds.jdbc.MSSqlServerInfo.<init>(MSSqlServerInfo.java:91)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:263)
        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(PoolableConnectionFactory.java:582)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
        ... 31 more
jlog error!

lixin_justep

mysql和sqlserver是两种数据库，请看安装部署说明或相关的用户手册

wangyutao

http://bbs.justep.com/forum.php? ... &extra=page%3D1
报的错，看上上面链接里面的2.11
就是数据库没连接上。

zhouhaijun_168

wangyutao 发表于 2013-12-16 10:19
http://bbs.justep.com/forum.php?mod=viewthread&tid=50894&extra=page%3D1
报的错，看上上面链接里面的2. ...

谢谢您。我一开始没有仔细看视频教程。我现在初始化一个数据库连接上了。

zhouhaijun_168

lixin_justep 发表于 2013-12-16 08:47
mysql和sqlserver是两种数据库，请看安装部署说明或相关的用户手册

谢谢你，我把两个数据库搞混了，现在搞定了。