OracleDS not bound, but it was until I set up SSL...

[jafarnham]

I feel like I'm going a bit crazy here... I'm running JBoss 3.0 with Tomcat & Jboss.net, and connecting to an Oracle 8i datasource. Until yesterday, I had absolutely no problem connecting to the Oracle datasource under the name 'java:/OracleDS'. The only change I made (or remember making...) yesterday was to edit tomcat4-service.xml and jboss-service.xml so that Tomcat runs with SSL. Now, the exact same piece of code fails, with an error message saying that OracleDS is not bound. However, from the JBoss output, it looks like it still is being bound. The output below is the result of redeploying oracle-service.xml, then trying to access the datasource. I've also included the oracle-service.xml file, most of which came straight out of a post in these forums I think. I would greatly appreciate hearing from anyone who has dealt with something similar, or who can point me to the stupid mistake that I am undoubtedly making. Thanks!

10:09:38,640 INFO [MainDeployer] Undeploying file:/var/jboss/server/all/deploy/oracle-service.xml
10:09:38,641 INFO [JBossManagedConnectionPool] Stopping
10:09:38,641 INFO [JBossManagedConnectionPool] Stopped
10:09:38,642 INFO [LocalTxConnectionManager] Destroying
10:09:38,776 INFO [LocalTxConnectionManager] Destroyed
10:09:38,778 INFO [JBossManagedConnectionPool] Destroying
10:09:38,779 INFO [JBossManagedConnectionPool] Destroyed
10:09:38,783 INFO [MainDeployer] Cleaned Deployment file:/var/jboss/server/all/deploy/oracle-service.xml
10:09:38,785 INFO [MainDeployer] Undeployed file:/var/jboss/server/all/deploy/oracle-service.xml
10:09:38,787 INFO [MainDeployer] Starting deployment of package: file:/var/jboss/server/all/deploy/oracle-service.xml
10:09:39,064 WARN [ServiceController] jboss.jca:service=LocalTxDS,name=OracleDS does not implement any Service methods
10:09:39,067 INFO [JBossManagedConnectionPool] Creating
10:09:39,068 INFO [JBossManagedConnectionPool] Created
10:09:39,070 INFO [JBossManagedConnectionPool] Starting
10:09:39,072 INFO [JBossManagedConnectionPool] Started
10:09:39,073 INFO [MainDeployer] Successfully completed deployment of package: file:/var/jboss/server/all/deploy/oracle-service.xml
10:09:49,472 INFO [Engine] JBossAxisServlet: init
10:09:49,957 INFO [JaasSecurityManagerService] Created securityMgr=org.jboss.security.plugins.JaasSecurityDomain@da2737
10:09:49,960 INFO [JaasSecurityManagerService] setCachePolicy, c=org.jboss.util.TimedCachePolicy@4492fb
10:09:49,962 INFO [JaasSecurityManagerService] Added other, org.jboss.security.plugins.SecurityDomainContext@dd4c8 to map
10:09:50,976 INFO [STDOUT] javax.ejb.CreateException: Can't load requested account
10:09:51,210 INFO [STDOUT] java.sql.SQLException: Connection failure: javax.naming.NameNotFoundException: OracleDS not bound
10:09:51,212 INFO [STDOUT] Create: javax.ejb.CreateException

<?xml version="1.0" encoding="UTF-8"?>




<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->

OracleDS


<config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@sunshine:1521:ORCL</config-property>
<config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
<!--set these only if you want only default logins, not through JAAS -->
<config-property name="UserName" type="java.lang.String">username</config-property>
<config-property name="Password" type="java.lang.String">password</config-property>




<!--Below here are advanced properties -->
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper



<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->

0
50
5000
15
ByContainer



<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager
java:/TransactionManager

<!--make the rar deploy! hack till better deployment-->
jboss.jca:service=RARDeployer

[davidjencks]

Well, there's something wrong somewhere with your oracle-service.xml, since you aren't seeing the log message "...bound to java:/OracleDS"

If you upgraded to a later version of jboss, such as 3.0.1 or Branch_3_0, the
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager

should be
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager

Other than that, I hope you keep your entire project under version control.

[jafarnham]

Thanks for the response. Switching

<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager

to

<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager

worked for me. Thanks!

[sslkalpesh]

if you have shifted from jboss-3.0.0RC1 to jboss-3.0.0_tomcat-4.0.3 then the deployment descriptor has changed a little. check these 3 things

1)classes12.jar is in %jbosshome%\lib
2)if you are using LocalTxConnectionManager then put the jboss-local-jdbc.rar in server\deploy directory
3) the DS configuration have changed a little
now

<config-property>
<config-property-name>ConnectionURL</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>jdbc:oracle:thin:@alpro:1521:alysida</config-property-value>
</config-property>


is changed to
<config-property name="" type="" value="">