I've check the forum and followed the every steps but with no success. Please help.
This is the instruction of connecting to a mysql database:
1. place your db driver in <jboss_home>\server\default\lib
2. copy mysql-service.xml file from <jboss_home>\docs\examples\jca to <jboss_home>\server\default\deploy directory.
3. Do not use DefaultDS name for your datasource since Hyperion is using it. I used MysqlDS.
4. lookup java:MysqlDS
I hope it works for you
Initially I named PostgreDS, I tried every combination.
in the server log it bound to java:/PostgreDS
[PostgreDS] Bound connection factory for resource adapter 'JBoss LocalTransaction JDBC Wrapper' to JNDI name 'java:/PostgreDS'
your jndi properties you are setting in code are preventing you from finding anything bound in the java: context which is in vm only. Including localhost port 1099 forces the lookup to go outside the vm so java:/ cannot be found.
I did with or without the properties.
Can you tell me how I can achieve the goal?
I have been having the same problem with Sybase, I tried 3.0.4 and 3.0.6 with tomcat and about... a billion variations on the sybase-service.xml and associated config files.
I just downloaded Jboss 3.0.6 with JbossWeb vs. tomcat, changed the ip/port/uname&pw in sybase-service.xml and put it in server/all/deploy, started jboss and it worked.. it just worked. I think it is something in the tomcat setup/version that is causing all of these "not bound" errors (but this is only my 1st experience with jboss, so take it for what its worth).