My application runs with Jrun and my Jrun resources.xml has certain datasources declared for Sybase databases.
One of them is as below:(which is causing the problem)
When i run my Jrun. I get the following in my log
10/06 04:36:10 info JRunDataSource bound to JNDI under name SBXUS_ZOS_DEV_DS
10/06 04:36:10 info JRun DataSourceService: Created JDBC XA Connection Pool named SBXUS_ZOS_DEV_DS
10/06 04:36:10 info JRunDataSource bound to JNDI under name SBX_REQUESTS_DS
10/06 04:36:10 info JRun DataSourceService: Created JDBC XA Connection Pool named SBX_REQUESTS_DS
10/06 04:36:10 info JRun DataSourceService: Created JDBC XA Connection Pool named SBXTK_RCMONITOR_DS
And when i try to establish connection thru my code
Exception while caching datasource SBXTK_RCMONITOR_DS due to No such binding: SBXTK_RCMONITOR_DSjavax.naming.NameNotFoundException: No such binding: SBXTK_RCMONITOR_DS
I've two questions.
1. When i run my jrun: why is my SBXTK_RCMONITOR_DS not getting bound with a JNDI name while other datasources are not bound. Am i wrong somewhere in specifiying the datasource?
2. Why am i running into exception when i try to access this datasource.. I'm able to connect to the database successfully through my Aqua DataStudio tool which we are using .
Please help. Thanks in advance.
Adding to it... Does this issue have anything to do with LDAP ??
Message was edited by: Preethi Sivakumar
I Got a lead to this issue.
When i observed my JRUN logs i saw this:
10/07 04:30:58 error SQLException while attempting to connect: java.sql.SQLException: [Macromedia][Sybase JDBC Driver][Sybase]Attempt to locate entry in sysdatabases for database 'ZSBX' by name failed - no entry found under that name. Make sure that name is entered properly.
java.sql.SQLException: [Macromedia][Sybase JDBC Driver][Sybase]Attempt to locate entry in sysdatabases for database 'ZSBX' by name failed - no entry found under that name. Make sure that name is entered properly.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.sybase.tds.SybaseTDSRequest.processErrorToken(Unknown Source)
at macromedia.jdbc.sybase.tds.SybaseTDSRequest.processReplyToken(Unknown Source)
at macromedia.jdbc.sybase.tds.SybaseTDSLoginRequest.processReplyToken(Un known Source)
at macromedia.jdbc.sybase.tds.SybaseTDSRequest.processReply(Unknown Source)
and the funniest part is that : database 'ZSBX' database doesn;t exsit in taht server. It exists in someother server which is also registerd in my computer.
I verified twice if i've given my URL properly and it is right.
Now my question is : Why is it not searching for the Database : RCMonitorDB which i've specified and searching for 'ZSBX' which doesn't exist.
Could any one please atleast help me now? am really stuck. please Help.