Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

JDBC Connection test error with Oracle 9i and WAS 6.0.1.2

47 views
Skip to first unread message

stephan...@accenture.com

unread,
Jun 30, 2005, 11:14:30 AM6/30/05
to
Hi,

when testing a JDBC connection we receive the following error:

Test connection failed for data source test on server nodeagent at node
amststwaspe00Node01 with the following exception: java.lang.Exception:
java.sql.SQLException: invalid arguments in callDSRA0010E: SQL State = null, Error Code = 17,433. View JVM logs for further details.

It seems this error results from a username/password that is "empty", although the alias configuration seems correct.

Configuration
- WAS V6.0.1.2
- We have configured a cluster.
- Properly created an alias in JAAS/J2C through admin console
- In "global security", eneabled Tickbox: "Enforce fine grained JCA Security", and all others disabled.

logfile:
[6/30/05 9:21:24:583 MEST] 000008be SystemErr R java.lang.Exception:
java.sql.SQLException: invalid arguments in callDSRA0010E: SQL State = null, Error Code = 17,433
at
com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurat
ionHelper.java:2168)
at sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource
2(DataSourceConfigHelperMBean.java:528)
at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceC
onfigHelperMBean.java:456)
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:324)
at
javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBe
an.java:1366)
at
javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.jav
a:1012)
at
mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanSer
verInterceptor.java:233)
at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
at
mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanS
erverInterceptor.java:86)
at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
at
mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(Cont
extClassLoaderMBeanServerInterceptor.java:167)
at mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1249)
at
com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:901)
at
com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java
:118)
at
com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:817)
at
com.ibm.ws.management.connector.AdminServiceDelegator.invoke(AdminServiceDel
egator.java:139)
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:324)
at
com.ibm.ws.management.connector.soap.SOAPConnector.invoke(SOAPConnector.java
:330)
at
com.ibm.ws.management.connector.soap.SOAPConnector.service(SOAPConnector.jav
a:198)
at
com.ibm.ws.management.connector.soap.SOAPConnection.handleRequest(SOAPConnec
tion.java:55)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:680)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:484)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1394)

[6/30/05 9:21:24:584 MEST] 000008be SystemErr R at
com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurat
ionHelper.java:2168)
[6/30/05 9:21:24:584 MEST] 000008be SystemErr R at
sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
[6/30/05 9:21:24:585 MEST] 000008be SystemErr R at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
java:25)
[6/30/05 9:21:24:585 MEST] 000008be SystemErr R at
java.lang.reflect.Method.invoke(Method.java:324)
[6/30/05 9:21:24:585 MEST] 000008be SystemErr R at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource
2(DataSourceConfigHelperMBean.java:528)
[6/30/05 9:21:24:585 MEST] 000008be SystemErr R at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceC
onfigHelperMBean.java:456)
[6/30/05 9:21:24:585 MEST] 000008be SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[6/30/05 9:21:24:585 MEST] 000008be SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
[6/30/05 9:21:24:586 MEST] 000008be SystemErr R at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
java:25)
[6/30/05 9:21:24:586 MEST] 000008be SystemErr R at
java.lang.reflect.Method.invoke(Method.java:324)
[6/30/05 9:21:24:586 MEST] 000008be SystemErr R at
javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBe
an.java:1366)
[6/30/05 9:21:24:586 MEST] 000008be SystemErr R at
javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.jav
a:1012)
[6/30/05 9:21:24:586 MEST] 000008be SystemErr R at
mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanSer
verInterceptor.java:233)
[6/30/05 9:21:24:586 MEST] 000008be SystemErr R at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
[6/30/05 9:21:24:586 MEST] 000008be SystemErr R at
mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanS
erverInterceptor.java:86)
[6/30/05 9:21:24:587 MEST] 000008be SystemErr R at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
[6/30/05 9:21:24:587 MEST] 000008be SystemErr R at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
[6/30/05 9:21:24:587 MEST] 000008be SystemErr R at
mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(Cont
extClassLoaderMBeanServerInterceptor.java:167)
[6/30/05 9:21:24:587 MEST] 000008be SystemErr R at
mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1249)
[6/30/05 9:21:24:587 MEST] 000008be SystemErr R at
com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:901)
[6/30/05 9:21:24:587 MEST] 000008be SystemErr R at
com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java
:118)
[6/30/05 9:21:24:588 MEST] 000008be SystemErr R at
com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:817)
[6/30/05 9:21:24:588 MEST] 000008be SystemErr R at
com.ibm.ws.management.connector.AdminServiceDelegator.invoke(AdminServiceDel
egator.java:139)
[6/30/05 9:21:24:588 MEST] 000008be SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[6/30/05 9:21:24:588 MEST] 000008be SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
[6/30/05 9:21:24:588 MEST] 000008be SystemErr R at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
java:25)
[6/30/05 9:21:24:588 MEST] 000008be SystemErr R at
java.lang.reflect.Method.invoke(Method.java:324)
[6/30/05 9:21:24:589 MEST] 000008be SystemErr R at
com.ibm.ws.management.connector.soap.SOAPConnector.invoke(SOAPConnector.java
:330)
[6/30/05 9:21:24:589 MEST] 000008be SystemErr R at
com.ibm.ws.management.connector.soap.SOAPConnector.service(SOAPConnector.jav
a:198)
[6/30/05 9:21:24:589 MEST] 000008be SystemErr R at
com.ibm.ws.management.connector.soap.SOAPConnection.handleRequest(SOAPConnec
tion.java:55)
[6/30/05 9:21:24:589 MEST] 000008be SystemErr R at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:680)
[6/30/05 9:21:24:589 MEST] 000008be SystemErr R at
com.ibm.ws.http.HttpConnection.run(HttpConnection.java:484)
[6/30/05 9:21:24:589 MEST] 000008be SystemErr R at
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1394)
[6/30/05 9:21:24:607 MEST] 000008be SystemErr R java.lang.Exception:
java.sql.SQLException: invalid arguments in callDSRA0010E: SQL State = null, Error Code = 17,433
at
com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurat
ionHelper.java:2168)
at sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource
2(DataSourceConfigHelperMBean.java:528)
at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceC
onfigHelperMBean.java:456)
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:324)
at
javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBe
an.java:1366)
at
javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.jav
a:1012)
at
mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanSer
verInterceptor.java:233)
at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
at
mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanS
erverInterceptor.java:86)
at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
at
mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(Cont
extClassLoaderMBeanServerInterceptor.java:167)
at mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1249)
at
com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:901)
at
com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java
:118)
at
com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:817)
at
com.ibm.ws.management.connector.AdminServiceDelegator.invoke(AdminServiceDel
egator.java:139)
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:324)
at
com.ibm.ws.management.connector.soap.SOAPConnector.invoke(SOAPConnector.java
:330)
at
com.ibm.ws.management.connector.soap.SOAPConnector.service(SOAPConnector.jav
a:198)
at
com.ibm.ws.management.connector.soap.SOAPConnection.handleRequest(SOAPConnec
tion.java:55)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:680)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:484)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1394)

[6/30/05 9:21:24:608 MEST] 000008be SystemErr R at
com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurat
ionHelper.java:2168)
[6/30/05 9:21:24:608 MEST] 000008be SystemErr R at
sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
[6/30/05 9:21:24:608 MEST] 000008be SystemErr R at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
java:25)
[6/30/05 9:21:24:608 MEST] 000008be SystemErr R at
java.lang.reflect.Method.invoke(Method.java:324)
[6/30/05 9:21:24:609 MEST] 000008be SystemErr R at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource
2(DataSourceConfigHelperMBean.java:528)
[6/30/05 9:21:24:609 MEST] 000008be SystemErr R at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceC
onfigHelperMBean.java:456)
[6/30/05 9:21:24:609 MEST] 000008be SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[6/30/05 9:21:24:609 MEST] 000008be SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
[6/30/05 9:21:24:609 MEST] 000008be SystemErr R at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
java:25)
[6/30/05 9:21:24:609 MEST] 000008be SystemErr R at
java.lang.reflect.Method.invoke(Method.java:324)
[6/30/05 9:21:24:609 MEST] 000008be SystemErr R at
javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBe
an.java:1366)
[6/30/05 9:21:24:610 MEST] 000008be SystemErr R at
javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.jav
a:1012)
[6/30/05 9:21:24:610 MEST] 000008be SystemErr R at
mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanSer
verInterceptor.java:233)
[6/30/05 9:21:24:610 MEST] 000008be SystemErr R at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
[6/30/05 9:21:24:610 MEST] 000008be SystemErr R at
mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanS
erverInterceptor.java:86)
[6/30/05 9:21:24:610 MEST] 000008be SystemErr R at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
[6/30/05 9:21:24:610 MEST] 000008be SystemErr R at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
[6/30/05 9:21:24:611 MEST] 000008be SystemErr R at
mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(Cont
extClassLoaderMBeanServerInterceptor.java:167)
[6/30/05 9:21:24:611 MEST] 000008be SystemErr R at
mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1249)
[6/30/05 9:21:24:611 MEST] 000008be SystemErr R at
com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:901)
[6/30/05 9:21:24:611 MEST] 000008be SystemErr R at
com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java
:118)
[6/30/05 9:21:24:611 MEST] 000008be SystemErr R at
com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:817)
[6/30/05 9:21:24:611 MEST] 000008be SystemErr R at
com.ibm.ws.management.connector.AdminServiceDelegator.invoke(AdminServiceDel
egator.java:139)
[6/30/05 9:21:24:611 MEST] 000008be SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[6/30/05 9:21:24:612 MEST] 000008be SystemErr R at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
[6/30/05 9:21:24:612 MEST] 000008be SystemErr R at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
java:25)
[6/30/05 9:21:24:612 MEST] 000008be SystemErr R at
java.lang.reflect.Method.invoke(Method.java:324)
[6/30/05 9:21:24:612 MEST] 000008be SystemErr R at
com.ibm.ws.management.connector.soap.SOAPConnector.invoke(SOAPConnector.java
:330)
[6/30/05 9:21:24:612 MEST] 000008be SystemErr R at
com.ibm.ws.management.connector.soap.SOAPConnector.service(SOAPConnector.jav
a:198)
[6/30/05 9:21:24:612 MEST] 000008be SystemErr R at
com.ibm.ws.management.connector.soap.SOAPConnection.handleRequest(SOAPConnec
tion.java:55)
[6/30/05 9:21:24:613 MEST] 000008be SystemErr R at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:680)
[6/30/05 9:21:24:613 MEST] 000008be SystemErr R at
com.ibm.ws.http.HttpConnection.run(HttpConnection.java:484)
[6/30/05 9:21:24:613 MEST] 000008be SystemErr R at
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1394)


[6/30/05 9:21:24:590 MEST] 000008be DataSourceCon E DSRA8040I: Failed to
connect to the DataSource. Encountered "": java.lang.Exception:
java.sql.SQLException: invalid arguments in callDSRA0010E: SQL State = null, Error Code = 17,433
at
com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurat
ionHelper.java:2168)
at sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource
2(DataSourceConfigHelperMBean.java:528)
at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceC
onfigHelperMBean.java:456)
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:324)
at
javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBe
an.java:1366)
at
javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.jav
a:1012)
at
mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanSer
verInterceptor.java:233)
at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
at
mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanS
erverInterceptor.java:86)
at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
at
mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanSer
verInterceptor.java:128)
at
mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(Cont
extClassLoaderMBeanServerInterceptor.java:167)
at mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1249)
at
com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:901)
at
com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java
:118)
at
com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:817)
at
com.ibm.ws.management.connector.AdminServiceDelegator.invoke(AdminServiceDel
egator.java:139)
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:324)
at
com.ibm.ws.management.connector.soap.SOAPConnector.invoke(SOAPConnector.java
:330)
at
com.ibm.ws.management.connector.soap.SOAPConnector.service(SOAPConnector.jav
a:198)
at
com.ibm.ws.management.connector.soap.SOAPConnection.handleRequest(SOAPConnec
tion.java:55)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:680)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:484)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1394)


Paul Ilechko

unread,
Jun 30, 2005, 4:34:32 PM6/30/05
to
stephan...@accenture.com wrote:

> Hi,
>
> when testing a JDBC connection we receive the following error:
>
> Test connection failed for data source test on server nodeagent at node
> amststwaspe00Node01 with the following exception: java.lang.Exception:
> java.sql.SQLException: invalid arguments in callDSRA0010E: SQL State = null, Error Code = 17,433. View JVM logs for further details.
>

Why are you testing the datasource with the nodeagent? It looks like
you have a scoping problem, you probably defined the scope of the data
source to be the node for the nodeagent, instead of the node for a
cluster or an application server.

amber...@msn.com

unread,
Sep 19, 2006, 3:34:08 AM9/19/06
to
Check out the link - http://www.webservertalk.com/archive80-2005-10-1244713.html

It worked for me...

vockinger

unread,
Sep 22, 2006, 9:39:18 AM9/22/06
to

wrote:
> *Hi,

>
> when testing a JDBC connection we receive the following error:
>
> Test connection failed for data source test on server nodeagent at
> node
> amststwaspe00Node01 with the following exception:
> java.lang.Exception:
> java.sql.SQLException: invalid arguments in callDSRA0010E: SQL State
> = null, Error Code = 17,433. View JVM logs for further details.
>
> It seems this error results from a username/password that is "empty",
> although the alias configuration seems correct.
>
> Configuration
> - WAS V6.0.1.2
> - We have configured a cluster.
> - Properly created an alias in JAAS/J2C through admin console
> - In "global security", eneabled Tickbox: "Enforce fine grained JCA
> Security", and all others disabled.
> *

This may happen, when you use a newly created J2C username/password
entry. In this cause, the nodeagent have to be restarted to know this
J2C entry.
It is a bug in WebSphere in my opinion.
Best regards, Alfred

--
vockinger
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message1118528.html

Charly Oz

unread,
Sep 26, 2006, 6:05:02 AM9/26/06
to
If you're using a DM environment, you'll need to:
1) Restart the Deployment Manager
2) Restart the NodeAgent

for the J2C Authentication Alias changes to take effect.

HTH.

Charly.

"vockinger" <vockinge...@mail.webservertalk.com> wrote in message
news:vockinge...@mail.webservertalk.com...

shanmu...@yahoo.co.in

unread,
May 29, 2008, 11:36:51 AM5/29/08
to
Hi vockinger,

you are exactly right, me too restarted the nodes and things got worked. Thanks

We need to screw the IBM Developers

Mohan Keole

unread,
Mar 10, 2009, 1:50:58 PM3/10/09
to
Thanks Vockinger, You are right!

csara...@yahoo.com

unread,
Mar 16, 2009, 12:18:21 PM3/16/09
to
Yes. Restarting the nodeAgent resolved the issue. Many thanks

vt.ven...@gmail.com

unread,
Oct 8, 2009, 1:21:53 PM10/8/09
to
Correct, Restarting the nodeAgent has resolved the issue. thanks alot.
0 new messages