Hi,
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)
<data-source>
<dbname>SBXTK_RCMONITOR_DS</dbname>
<driver>macromedia.jdbc.MacromediaDriver</driver>
<url>jdbc:macromedia:sybase://abvkp.us.nsroot.net:4100;databaseName=RCMonitorDB</url>
<username>xyz</username>
<password>zyz</password>
<encrypted>true</encrypted>
<encryption-class>jrun.security.JRunCrypterForTwofish</encryption-cla ss>
<native-results>true</native-results>
<remove-on-exceptions>true</remove-on-exceptions>
<pool-statements>true</pool-statements>
<initial-connections>1</initial-connections>
<connection-timeout>1200</connection-timeout>
<pool-retry>30</pool-retry>
<transaction-timeout>20</transaction-timeout>
<cache-enabled>false</cache-enabled>
<cache-size>5</cache-size>
<cache-refresh-interval>30</cache-refresh-interval>
<jndi-name>SBXTK_RCMONITOR_DS</jndi-name>
<poolname>Pool</poolname>
<minimum-size>0</minimum-size>
<maximum-size>2147483647</maximum-size>
<user-timeout>20</user-timeout>
<skimmer-frequency>420</skimmer-frequency>
<shrink-by>5</shrink-by>
<maximum-soft>true</maximum-soft>
<debugging>false</debugging>
<disable-pooling>false</disable-pooling>
<description />
<isolation-level>READ_COMMITTED</isolation-level>
</data-source>
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.
Regards
Preethi.
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.
Regards
Preethi.
North America
Europe, Middle East and Africa
Asia Pacific