Can I sort blogs by the age of their starters?
DataSource connection problem
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > Software, Computer Help > DataSource connection problem 25 July 2008 19:57:30

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

DataSource connection problem

C.Moreno 25 July 2008 19:57:30
 Hello:

I have a problem when I define a DataSource (Oracle JDBC Provider
without XA) and I try to assign a user and password in a
"Component-managed authentication alias" before defined in "J2EE
Connector Architecture (J2C) authentication data entries".

My problem is when I try to do a test connection. The error in the
administrative console is:

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

And the log file of my nodeagent is the next:

[11/30/05 11:04:42:563 CET] 00006208 DataSourceCon E DSRA8040I:
Failed to connect to the DataSource. Encountered "":
java.lang.Exception­: java.sql.SQLExcepti­on: invalid arguments in
callDSRA0010E: SQL State = null, Error Code = 17,433
at
com.ibm.ws.rsadapte­r.DSConfigurationHel­per.testConnectionFo­rGUI(DSConfiguration­Helper.java:2227)
at sun.reflect.Generat­edMethodAccessor187.­invoke(Unknown
Source)
at
sun.reflect.Delegat­ingMethodAccessorImp­l.invoke(DelegatingM­ethodAccessorImpl.ja­va(Compiled
Code))
at java.lang.reflect.M­ethod.invoke(Method.­java(Compiled Code))
at
com.ibm.ws.manageme­nt.DataSourceConfigH­elperMBean.testConne­ctionToDataSource2(D­ataSourceConfigHelpe­rMBean.java:528)
at
com.ibm.ws.manageme­nt.DataSourceConfigH­elperMBean.testConne­ction(DataSourceConf­igHelperMBean.java:4­56)
at sun.reflect.NativeM­ethodAccessorImpl.in­voke0(Native Method)
at
sun.reflect.NativeM­ethodAccessorImpl.in­voke(NativeMethodAcc­essorImpl.java(Compi­led
Code))
at
sun.reflect.NativeM­ethodAccessorImpl.in­voke(NativeMethodAcc­essorImpl.java(Compi­led
Code))
at
sun.reflect.Delegat­ingMethodAccessorImp­l.invoke(DelegatingM­ethodAccessorImpl.ja­va(Compiled
Code))
at java.lang.reflect.M­ethod.invoke(Method.­java(Compiled Code))
at
javax.management.mo­delmbean.RequiredMod­elMBean.invokeMethod­(RequiredModelMBean.­java(Compiled
Code))
at
javax.management.mo­delmbean.RequiredMod­elMBean.invoke(Requi­redModelMBean.java(C­ompiled
Code))
at
mx4j.server.interce­ptor.InvokerMBeanSer­verInterceptor.invok­e(InvokerMBeanServer­Interceptor.java(Com­piled
Code))
at
mx4j.server.interce­ptor.DefaultMBeanSer­verInterceptor.invok­e(DefaultMBeanServer­Interceptor.java(Inl­ined
Compiled Code))
at
mx4j.server.interce­ptor.SecurityMBeanSe­rverInterceptor.invo­ke(SecurityMBeanServ­erInterceptor.java(C­ompiled
Code))
at
mx4j.server.interce­ptor.DefaultMBeanSer­verInterceptor.invok­e(DefaultMBeanServer­Interceptor.java(Com­piled
Code))
at
mx4j.server.interce­ptor.DefaultMBeanSer­verInterceptor.invok­e(DefaultMBeanServer­Interceptor.java(Inl­ined
Compiled Code))
at
mx4j.server.interce­ptor.ContextClassLoa­derMBeanServerInterc­eptor.invoke(Context­ClassLoaderMBeanServ­erInterceptor.java(C­ompiled
Code))
at
mx4j.server.MX4JMBe­anServer.invoke(MX4J­MBeanServer.java(Com­piled Code))
at
com.ibm.ws.manageme­nt.AdminServiceImpl$­1.run(AdminServiceIm­pl.java(Compiled
Code))
at
com.ibm.ws.security­.util.AccessControll­er.doPrivileged(Acce­ssController.java(Co­mpiled
Code))
at
com.ibm.ws.manageme­nt.AdminServiceImpl.­invoke(AdminServiceI­mpl.java(Compiled
Code))
at
com.ibm.ws.manageme­nt.connector.AdminSe­rviceDelegator.invok­e(AdminServiceDelega­tor.java(Compiled
Code))
at sun.reflect.Generat­edMethodAccessor64.i­nvoke(Unknown Source)
at
sun.reflect.Delegat­ingMethodAccessorImp­l.invoke(DelegatingM­ethodAccessorImpl.ja­va(Compiled
Code))
at java.lang.reflect.M­ethod.invoke(Method.­java(Compiled Code))
at
com.ibm.ws.manageme­nt.connector.soap.SO­APConnector.invoke(S­OAPConnector.java(Co­mpiled
Code))
at
com.ibm.ws.manageme­nt.connector.soap.SO­APConnector.service(­SOAPConnector.java(C­ompiled
Code))
at
com.ibm.ws.manageme­nt.connector.soap.SO­APConnection.handleR­equest(SOAPConnectio­n.java(Compiled
Code))
at
com.ibm.ws.http.Htt­pConnection.readAndH­andleRequest(HttpCon­nection.java(Compile­d
Code))
at
com.ibm.ws.http.Htt­pConnection.run(Http­Connection.java(Comp­iled Code))
at
com.ibm.ws.util.Thr­eadPool$Worker.run(T­hreadPool.java(Compi­led Code))
.

I have been searching information in Internet and I found this
error.They said that it is a problem with the JDBC connection because
the machine doesn't close the connection correctly and the connection
remains open.

The curious is that if I write the user and password as custom
properties the connection works fine. Then I supose that the JDBC
connection is not the problem.

Anybody has the same problem or know a solution?

Thanks in advance.

c.

Add comment
Guest 17 April 2008 12:33:23 permanent link ]
 http://www.webserver­talk.com/archive80-2­005-10-1244713.html
Add comment
Guest 25 July 2008 19:57:30 permanent link ]
 I've been told it is the J2C user not getting picked up. Bounce the DM and the node agent and resync the cluster/servers.
Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > Software, Computer Help > DataSource connection problem 25 July 2008 19:57:30

see also:
Select for update, locks and…
Re: Denormalizing during select
Grant / Revoke functionality
пройди тесты:
see also:
Hi People!
Popup window in AJAX
LG Flatron L1750SQ

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .