If you search the forums for the error you will find a patched jboss-local-jdbc.rar by djencks (for ver 3.0.4 or .6 i believe) that will fix it. I would alse suggest verifying the connection URL in your sybase-service file has the JCONNECT_VERSION parm set to 5 vs. 6, this resolved many problems with ejb/cmp for me. I know sybase also has a support case open for the set chained issue, dont know the status though as it was just a casual conv. with a support rep. There are many problems with sybase and jboss, if you search the forums you will find many solutions for problems you may not have encountered yet.
In your ejb-jar.xml for all those methods which use jdbc you can make them transactional with transaction-type = 'Required'. This should do it if making transactional will not cause any problems for you.
This worked, thanks.
We were already setting the JCONNECT_VERSION parm set to 5 and this did not solve the problem.
The error is fixed in JBoss 3.2 RC4, but other problems appear, relating to closing connections from the pool.
Unfortunately we couldn?t find the jboss-local-jdbc.rar patch by djencks. If anyone knows where to get it, please let me know. We will need to refine our transaction definitions later on anyway - not all methods need the "required" setting.