Make sure that the JNDI name under the SybaseDS in the ManagedConnectionFactory section is set properly.
Should look something like this:
<config-property name="ConnectionURL" type="java.lang.String">jdbc:sybase:Tds:your.sybase.server:2025/yourdatabasename</config-property>
<config-property name="DriverClass" type="java.lang.String">com.sybase.jdbc2.jdbc.SybDriver</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 -->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
Yes, my sybase-service.xml file looks exactly like that.
study the part of server.log where your datasource mbeans are getting deployed. For me, there has always been a hint so I can find what is wrong.
I using 3.0 and having the same problem what other files will have to be change other then the ones already mentioned. Due I have to change the standardjaws.xml file to match the JBOSSCMP-JDBC.xml file
It seems that I'm still pointing to the default Hypersonic database thanks for any info.
ridgway -- put the driver in server/[config]/lib, not lib.
Then make sure the datasource is really being set up, all 3 mbeans are started, and the ds is bound in jndi before you deploy your app.
AlexB -- standardjaws is for cmp1.1 beans using the cmp1.1 dtd in ejb-jar.xml. standardjbosscmp-jdbc.xml is for using with the cmp2 dtd. (may change soon to always use standardjbosscmp-jdbc.xml, but look on the cmp forum for stuff like this)
I am having similar problems. After deploying a sybase-service.xml file I found that the MBeans are all deployed in the management console, but the sybase DS MBean was not started! After starting it manually, the JNDI name was registered and I could retrieve it. Did you check, if your beans are all started?
How do I configure the service to auto-start?
It seems that JBoss cannot find the com.sybase.jdbc2.jdbc.SybDriver class, inspite the jconn2.jar file is in the [config]/lib directory :-(
The mbeans should have started automatically. Look carefully in server.log to see if there is an explanation from when jboss tried to start them.