I put mysql-connector-java-5.1.14-bin.jar in default/lib dir,
created mysql-ds.xml in defautl/deploy
<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>prova</jndi-name> <connection-url>jdbc:mysql://localhost:3306/prova</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>root</user-name> <password>root</password> <!-- 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> --> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources>
but I have the error javax.naming.NameNotFoundException: prova not bound
both I use
ds = (DataSource) PortableRemoteObject.narrow(ictx.lookup("java:prova"), DataSource.class);
or
ds = (DataSource)ictx.lookup("prova");
"prova" is in the java: namespace but not in the Global JNDI Namespace
[.....]
+- prova (class: org.jboss.resource.adapter.jdbc.WrapperDataSource)
+- timedCacheFactory (class: javax.naming.Context)