指定了无效的 oracle url dsra0010e,数据源链接问题 求助

在Windows操作系统上的WAS 6.1集群环境中,遇到登录应用失败的问题,系统err.log显示DSRA0010E错误,提示调用中参数无效。尽管数据源配置和测试都成功,但用户登录时无法响应。错误堆栈涉及Spring JDBC、Oracle数据库连接和IBM WAS组件,可能的原因包括数据库连接参数、集群配置或JDBC驱动兼容性等。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

两台was做集群 版本6.1  操作系统windows   数据源已经配置好,测试是成功的,应用部署后,登录页面也能访问,但是输入用户名和密码,登录没有反应

systemerr.log 有报错信息,

[09-1-17 3:37:04:921 CST] 00000045 SystemErr     R  at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)

[09-1-19 9:29:13:656 CST] 00000045 SystemErr     R org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: 调用中无效的参数DSRA0010E: SQL 状态 = null,错误代码 = 17,433

java.sql.SQLException: 调用中无效的参数DSRA0010E: SQL 状态 = null,错误代码 = 17,433

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)

at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:184)

at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:371)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)

at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:169)

at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:149)

at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:95)

at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:63)

at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:920)

at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)

at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:957)

at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1602)

at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1217)

at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1895)

at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1570)

at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2338)

at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:910)

at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:600)

at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:449)

at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:418)

at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)

at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:462)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:528)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:561)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:579)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:589)

at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:619)

at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:629)

at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:656)

at com.timesontransfar.common.web.system.impl.LoginImpl.isStaffState(LoginImpl.java:746)

at com.timesontransfar.common.web.system.LoginAction.LoginSubmit(LoginAction.java:128)

at com.timesontransfar.common.web.system.LoginAction.doGet(LoginAction.java:52)

at com.timesontransfar.common.web.system.LoginAction.doPost(LoginAction.java:184)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1096)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1037)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:832)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:679)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:566)

at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)

at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)

at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:748)

at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1466)

at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:119)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)

at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值