免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3058 | 回复: 0
打印 上一主题 下一主题

安装IBM RPM时db2和tomcat怎么也搞不到一起,请求援助 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2012-06-27 09:58 |只看该作者 |倒序浏览
本帖最后由 xiueni 于 2012-06-27 10:02 编辑

webapps下是应用程序的war包IBMTRPM.war和rpm-rc.war   db2的用户是 db2admin/db2admin  IBM RPM用的数据库是IBMRPM
在config下建立一个文件 rpm.xml和 rpm-rc.xml

rpm.xml:


<?xml version="1.0" encoding="utf-8">
<Context reloadable="true">
<Resource
        auth="Container"
        name="jdbc/IBMRPM"
        type="javax.sql.DataSource"
        password="db2admin"
        driverClassName="com.ibm.db2.jcc.DB2Driver"
        maxIdle="2"
        maxWait="5000"
        username="db2admin"
        url="jdbc:db2://10.1.1.79:50000/IBMRPM"
        maxActive="4" />

        <!-- global configuration -->
<Environment name="useLdapAuthentication" type="java.lang.Boolean"
value="false" />
<Environment name="ldapConfiguration" type="java.lang.String"
value="java.naming.provider.url="ldaps://tstbluepages.mkm.can.ibm.com:636"
java.naming.factory.initial="com.sun.jndi.ldap.LdapCtxFactory"
java.naming.ldap.version="3"
java.naming.security.protocol="simple"
ldapsearchcontext="o=ibm.com"
ldapuseridattr="email"
ldapuserauthdn="distinguishedName" />

<!-- Web Services Configuration -->
<Environment name="webServicesSecurityEnabled"
type="java.lang.Boolean" value="True" />
<Environment name="webServicesEnabled" type="java.lang.Boolean"
value="True" />
<Environment name="webServicesUseSessionTimeout"
type="java.lang.String" value="false" />
<Environment name="webServicesSessionTimeoutDelayInSeconds"
type="java.lang.String" value="3600" />
<Environment name="webServicesUseApiSecurityFlagOnLogin"
type="java.lang.Boolean" value="True" />
<!-- Web UI configuration -->
<Environment name="serverDisplayName" type="java.lang.String"
value="RPM" />
<Environment name="helpSystemServer" type="java.lang.String"
value="">
</Environment>
<Environment name="rpmRestLocation" type="java.lang.String"
value="">
</Environment>
<Environment name="showDebugConsole" type="java.lang.Boolean"
value="false">
</Environment>
<!-- REST Configuration -->
<Environment name="databaseName" type="java.lang.String"
value="IBMRPM">
</Environment>
<!-- Delphi client broker configuration -->
<Environment value="" type="java.lang.String"
name="PjCPort" />
<Environment value="86000000" type="java.lang.String"
name="ExternalActionTimeout" />
<Environment value="" type="java.lang.String"
name="PjCProtocol" />
<Environment value="IBMRPM Alert" type="java.lang.String"
name="Subject" />
<Environment value="" type="java.lang.String"
name="KeepAliveCount" />
<Environment value="environment" type="java.lang.String"
name="ConfigurationSource" />
<Environment value="60000" type="java.lang.String"
name="WFSchedPollingInterval" />
<Environment value="" type="java.lang.String"
name="KeepAliveOn" />
<Environment value="" type="java.lang.String"
name="PjCHostName" />
<Environment value="na.relay.ibm.com" type="java.lang.String"
name="EmailHost" />
<Environment value="true" type="java.lang.String"
name="AlertsOn" />
<Environment value="" type="java.lang.String"
name="KeepAliveInterval" />
<Environment value="" type="java.lang.String"
name="PjCUsername" />
<Environment value="" type="java.lang.String"
name="PjCPassword" />
<Environment value="60000" type="java.lang.String"
name="SendInterval" />
<Environment value="RPMDATASOURCE" type="java.lang.String"
name="DSN" />
<Environment value="IBMRPM@tst.com" type="java.lang.String"
name="Sender" />
<Environment value="60000" type="java.lang.String"
name="WorkflowPollingInterval" />
</Context>


rpm-rc.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable="true">
        <Environment
                  description="URL for DataWarehouse Connection"
                  name="dwDriverURL"
                  type="java.lang.String"
                  value="jdbc:db2://localhost:50000/IBMRPM"/>
         <Environment
                description="JDBC Driver Class for DataWarehouse Connection"
                name="dwDriverClass"
                type="java.lang.String"
                value="com.ibm.db2.jcc.DB2Driver"/>
        <Resource
                auth="Container"
                description="resource"
                name="jdbc/RPMDATASOURCE"
                type="javax.sql.DataSource"
                password="db2admin"
                driverClassName="com.ibm.db2.jcc.DB2Driver"
                maxIdle="2"
                maxWait="5000"
                username="db2admin"
                url="jdbc:db2://localhost:50000/IBMRPM"
                maxActive="4" />
</Context>

这样有问题吗,**问题。让后用rpm客户端链接呢tomcat的log中如下 :

《tomcat5-stderr.2012-06-27.log》

2012-6-27 9:52:43 com.ibm.rpm.interfaces.impl.ManagerCaller handleException
严重: Internal error: Failed to fetch database timestamp.
Internal error: Failed to fetch database timestamp. - Severity: Error - Error ID: 400557
        at com.ibm.rpm.interfaces.impl.ManagerCaller.getDatabaseTimestamp(ManagerCaller.java:1795)
        at com.ibm.rpm.interfaces.impl.ManagerCaller.getDatabaseTimestamp(ManagerCaller.java:1759)
        at com.ibm.rpm.interfaces.impl.DefaultSessionUtility.getDatabaseTimestamp(DefaultSessionUtility.java:161)
        at com.ibm.rpm.interfaces.impl.DefaultSessionUtility.checkToTimeoutSessions(DefaultSessionUtility.java:187)
        at com.ibm.rpm.interfaces.impl.DefaultSessionUtility$TimeoutCheckThread.run(DefaultSessionUtility.java:761)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at com.ibm.rpm.framework.util.Manager.getConnectionFromDatasource(Manager.java:1094)
        at com.ibm.rpm.framework.util.Manager.getConnection(Manager.java:1063)
        at com.ibm.rpm.interfaces.impl.ManagerCaller.getDatabaseTimestamp(ManagerCaller.java:1771)
        ... 5 more
Caused by: java.lang.NullPointerException
        at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(Unknown Source)
        at java.sql.DriverManager.getDriver(Unknown Source)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
        ... 10 more


《catalina.2012-06-27.log》

2012-6-27 9:54:42 com.ibm.rpm.servlets.WorkflowThread run
严重: Unable to process external action(s).
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at com.ibm.rpm.servutil.jdbc.ConnectionPoolAppServer.setUpConnection(Unknown Source)
        at com.ibm.rpm.servutil.jdbc.ConnectionPoolAppServer.getConnection(Unknown Source)
        at com.ibm.rpm.servlets.WorkflowThread.getConnection(Unknown Source)
        at com.ibm.rpm.servlets.WorkflowThread.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
        at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(Unknown Source)
        at java.sql.DriverManager.getDriver(Unknown Source)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
        ... 7 more





早了好多种方法,但是都不成功
求助,谢谢
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP