Hi,
Thanks for the suggestions...
I checked 1 and 2 and it seems to follow the manuel.
I saw that the line:
DataSource ds = (DataSource) ctx.lookup("java:/MySqlDS");
in getUsersPassword, returns null.
mysql-ds.xml in the deploy folder:
<datasources>
| <local-tx-datasource>
| <jndi-name>MySqlDS</jndi-name>
| <use-java-context>true</use-java-context>
|
| <connection-url>jdbc:mysql://host:3306/mydb</connection-url>
| <!--driver-class>org.gjt.mm.mysql.Driver</driver-class-->
| <driver-class>com.mysql.jdbc.Driver</driver-class>
| <user-name>me</user-name>
| <password>secret</password>
|
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
| <!-- should only be used on drivers after 3.22.1 with "ping" support
|
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
| -->
| <!-- sql to call when connection is created -->
|
| <!--new-connection-sql>xxx</new-connection-sql-->
| <!-- -->
| <!-- sql to call on an existing pooled connection when it is obtained
from pool - MySQLValidConnectionChecker is preferred for newer drivers
| <check-valid-connection-sql>some arbitrary
sql</check-valid-connection-sql>
| -->
| <!--security-domain>enetemployer</security-domain-->
| <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml
(optional) -->
| <metadata>
| <type-mapping>mySQL</type-mapping>
| </metadata>
| </local-tx-datasource>
| </datasources>
I can see the MySqlDS MBean using th jmx-console the bind name property:
java:MySqlDS but still cannot be found.
If I set use-java-context to false and lookup without the java:/ I gett stack
overfllow...
any insight will be greatlly appreciated.
Thanks,
TEFRON.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3950758#3950758
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3950758
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
