首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >使用JNDI实现Tomcat上的IBM IMS连接

使用JNDI实现Tomcat上的IBM IMS连接
EN

Stack Overflow用户
提问于 2017-12-07 07:29:39
回答 1查看 516关注 0票数 0

我们正在从WAS8迁移到Tomcat8。在Tomcat中,我们需要在Java中使用JNDI为IMS建立连接。

我面临着为IMS的JNDI连接创建" url“的问题,下面是IMS jar给出的url结构

对于"jdbc:ims://datastoreServer:port/databaseName:property=value;"; 4 driverType 4

对于"jdbc:ims:databaseName:property=value;"; 2 driverType 2

这就是我所创造的

代码语言:javascript
运行
复制
jdbc:ims://xx.xx.xxx.com:4034;datastoreName=XXX34;dpsbOnCommit=true;

但是它给了我连接过程中的错误

代码语言:javascript
运行
复制
Dec 07, 2017 12:55:30 PM org.apache.naming.NamingContext lookup
WARNING: Unexpected exception resolving reference
java.sql.SQLException: Invalid URL syntax: databaseName not specified properly. Correct syntax: jdbc:ims://datastoreServer[:port]/databaseName[:property=value;]
    at com.ibm.ims.jdbc.IMSDriver.parseOptionalPortNumber(IMSDriver.java:1031)
    at com.ibm.ims.jdbc.IMSDriver.connect(IMSDriver.java:211)
    at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:307)
    at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:200)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:708)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:642)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:464)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:141)
    at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:115)
    at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:102)
    at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:553)
    at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:241)
    at org.apache.naming.factory.FactoryBase.getObjectInstance(FactoryBase.java:94)
    at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:841)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:152)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:829)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:152)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:829)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:152)

上面的问题看起来通过正确的url param解决了,但是现在我得到了错误。

代码语言:javascript
运行
复制
java.sql.SQLException: An error occurred reading from the socket input stream: java.net.SocketException: Software caused connection abort: recv failed.
    at com.ibm.ims.jdbc.ConnectionImpl.init(ConnectionImpl.java:309)
    at com.ibm.ims.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:95)
    at com.ibm.ims.jdbc.IMSDriver.connect(IMSDriver.java:450)
    at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:307)
    at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:200)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:708)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:642)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:464)
    at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:141)
    at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:115)
    at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:102)
    at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:553)
    at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:241)
    at org.apache.naming.factory.FactoryBase.getObjectInstance(FactoryBase.java:94)
    at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:841)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:152)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:829)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:166)
    at org.apache.catalina.core.NamingContextListener.addResource(NamingContextListener.java:1084)
    at org.apache.catalina.core.NamingContextListener.createNamingContext(NamingContextListener.java:663)
    at org.apache.catalina.core.NamingContextListener.lifecycleEvent(NamingContextListener.java:256)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:95)
    at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5154)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1408)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1398)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: com.ibm.ims.drda.base.DisconnectException: An error occurred reading from the socket input stream: java.net.SocketException: Software caused connection abort: recv failed.
    at com.ibm.ims.drda.t4.Reply.fill(Reply.java:801)
    at com.ibm.ims.drda.t4.Reply.ensureALayerDataInBuffer(Reply.java:752)
    at com.ibm.ims.drda.t4.Reply.readDssHeader(Reply.java:937)
    at com.ibm.ims.drda.t4.Reply.startSameIdChainParse(Reply.java:132)
    at com.ibm.ims.drda.t4.T4ConnectionReply.readExchangeServerAttributes(T4ConnectionReply.java:710)
    at com.ibm.ims.drda.t4.T4Connection.readServerAttributesAndKeyExchange(T4Connection.java:283)
    at com.ibm.ims.drda.t4.T4Connection.flowServerAttributesAndKeyExchange(T4Connection.java:263)
    at com.ibm.ims.drda.t4.T4Connection.flowDRDAConnect(T4Connection.java:248)
    at com.ibm.ims.drda.t4.T4Connection.flowConnect(T4Connection.java:231)
    at com.ibm.ims.drda.t4.T4Connection.initialize(T4Connection.java:218)
    at com.ibm.ims.drda.t4.T4Connection.<init>(T4Connection.java:84)
    at com.ibm.ims.drda.db.DRDAEngine.establishAuthenticatedSocketConnection(DRDAEngine.java:205)
    at com.ibm.ims.jdbc.ConnectionImpl.init(ConnectionImpl.java:258)
    ... 31 more
Caused by: java.net.SocketException: Software caused connection abort: recv failed
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(Unknown Source)
    at java.net.SocketInputStream.read(Unknown Source)
    at com.ibm.ims.drda.t4.Reply.fill(Reply.java:796)
    ... 43 more
EN

回答 1

Stack Overflow用户

发布于 2018-03-27 21:51:08

对于Type-4连接url:

代码语言:javascript
运行
复制
jdbc:ims://datastoreServer[:port]/databaseName[:property=value;]

如果您使用的是IMS目录,databaseName占位符应该替换为您的PSB名称

或使用

代码语言:javascript
运行
复制
class://your.fully.qualified.PSBNameDatabaseView

如果使用本地元数据文件

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/47689795

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档