Actually I'm deploying a website for JBoss. Mi commitment is make this site to work with this databases:
ORACLE MYSQL SQL SERVER My fellow and me wrote the access to the database in a simple class (this project has no entity-beans). Servlets and a java application need access to database. Our current database is mysql. Finding out a way to configure access to database, I found that using JCA its possible to bind connections to databases using files with the name in the format *ds.xml. What I did is to work with a file I called DB-ds.xml (according JCA standard) and wrote an initial mysql configuration. Below is the content of this file: | <?xml version="1.0" encoding="UTF-8"?> | <!-- WEBCOMJAFL. Archivo de conexión a la base de datos. --> | <datasources> | <!-- Datasource config for MySQL using 3.0.9 available from: | http://www.mysql.com/downloads/api-jdbc-stable.html--> | <no-tx-datasource> | <jndi-name>comp/env/jdbc/WCJFDB</jndi-name> | <use-java-context>true</use-java-context> | <connection-url>jdbc:mysql://localhost/webcomjafl</connection-url> | <driver-class>com.mysql.jdbc.Driver</driver-class> | <user-name>webcomjafl</user-name> | <password></password> | <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name> | </no-tx-datasource> | </datasources> Data in this file is fine (user=webcomjafl, no password) After copying this file into server\default\deploy directory of JBoss, I got this message: 15:59:25,727 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca | :service=DataSourceBinding,name=comp/env/jdbc/WCJFDB' to JNDI name 'java:comp/env/jdbc/WCJFDB' What means that binding was successful. I've tried calling this resource (comp/env/jdbc/WCJFDB) from a java-test application, but I had an error message: before | javax.naming.NameNotFoundException: comp not bound | at org.jnp.server.NamingServer.getBinding(NamingServer.java:529) | at org.jnp.server.NamingServer.getBinding(NamingServer.java:537) | at org.jnp.server.NamingServer.getObject(NamingServer.java:543) | at org.jnp.server.NamingServer.lookup(NamingServer.java:267) | at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:625) | at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:587) | at javax.naming.InitialContext.lookup(InitialContext.java:392) | at devenet.com.workflow.DBConnectionTest.main(DBConnectionTest.java:38) This is my source code: public static void main(String[] args) { | try { | | InitialContext ctx = new InitialContext(); | System.out.println("before"); | Object connection = ctx.lookup("java:comp/env/jdbc/WCJFDB"); | System.out.println("after"); | | } catch (Exception e) { | // TODO Auto-generated catch block | e.printStackTrace(); | } | | } Notes: This is my jndi.properties file: ### JBossNS properties | java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory | java.naming.provider.url=jnp://localhost:1099 | java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces I've installed JBoss version 4.0.5, with all components (full), with jmx interfaces no secured (jmx-console.war, web-console.war, jmx-invoker-service, http invoker). I'll be thankful for any help. Néstor Arias View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3998407#3998407 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3998407 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
