Topic
8 replies Latest Post - ‏2009-10-08T17:21:53Z by SystemAdmin
SystemAdmin
SystemAdmin
37422 Posts
ACCEPTED ANSWER

Pinned topic JDBC Connection test error with Oracle 9i and WAS 6.0.1.2

‏2005-06-30T15:14:30Z |
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)
Updated on 2009-10-08T17:21:53Z at 2009-10-08T17:21:53Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    37422 Posts
    ACCEPTED ANSWER

    Re: JDBC Connection test error with Oracle 9i and WAS 6.0.1.2

    ‏2005-06-30T20:34:32Z  in response to SystemAdmin
    stephan.roosli@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.
    • SystemAdmin
      SystemAdmin
      37422 Posts
      ACCEPTED ANSWER

      Re: JDBC Connection test error with Oracle 9i and WAS 6.0.1.2

      ‏2006-09-19T07:34:08Z  in response to SystemAdmin
      Check out the link - http://www.webservertalk.com/archive80-2005-10-1244713.html

      It worked for me...
  • SystemAdmin
    SystemAdmin
    37422 Posts
    ACCEPTED ANSWER

    Re: JDBC Connection test error with Oracle 9i and WAS 6.0.1.2

    ‏2006-09-22T13:39:18Z  in response to SystemAdmin

    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
    • SystemAdmin
      SystemAdmin
      37422 Posts
      ACCEPTED ANSWER

      Re: JDBC Connection test error with Oracle 9i and WAS 6.0.1.2

      ‏2006-09-26T10:05:02Z  in response to SystemAdmin
      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" <vockinger.2ejswb@mail.webservertalk.com> wrote in message
      news:vockinger.2ejswb@mail.webservertalk.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.
      >>
      >> 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
      >

      • SystemAdmin
        SystemAdmin
        37422 Posts
        ACCEPTED ANSWER

        Re: JDBC Connection test error with Oracle 9i and WAS 6.0.1.2

        ‏2008-05-29T15:36:51Z  in response to SystemAdmin
        Hi vockinger,

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

        We need to screw the IBM Developers !
    • SG2007
      SG2007
      1 Post
      ACCEPTED ANSWER

      Re: JDBC Connection test error with Oracle 9i and WAS 6.0.1.2

      ‏2009-03-10T17:50:58Z  in response to SystemAdmin
      Thanks Vockinger, You are right!
    • SystemAdmin
      SystemAdmin
      37422 Posts
      ACCEPTED ANSWER

      Re: JDBC Connection test error with Oracle 9i and WAS 6.0.1.2

      ‏2009-03-16T16:18:21Z  in response to SystemAdmin
      Yes. Restarting the nodeAgent resolved the issue. Many thanks
      • SystemAdmin
        SystemAdmin
        37422 Posts
        ACCEPTED ANSWER

        Re: JDBC Connection test error with Oracle 9i and WAS 6.0.1.2

        ‏2009-10-08T17:21:53Z  in response to SystemAdmin
        Correct, Restarting the nodeAgent has resolved the issue. thanks alot.