I'm receiving the following exception when trying to obtain a connection from the pool:
java.sql.SQLException: JZ00L: Login failed
This is being returned from a Sybase ASA database which I am connecting to via JConnect. The user name and password I am supplying are correct so I am confused as to why I am receiving this return code. Does anyone else have any experience in establishing connections to Sybase databases? I have been able to do this within Orion without any problems so I am 100% convinced that it's a JBoss configuration issue on my part.
I've resolved this now. I was using the syntax of "/[dbName]" at the end of my connection url, when I should have been using "?SERVICENAME=[dbName]".