Utilisation d'une DataSource
Version: jBoss 4.0.1 & mysql 4.0.23.
Fichier de configuration :
~/jboss/server/app/deploy/app-ds.xml
<datasources> <local-tx-datasource> <jndi-name>MySqlDS</jndi-name> <connection-url>jdbc:mysql://localhost:3306/nom_db</connection-url> <driver-class>org.gjt.mm.mysql.Driver</driver-class> <user-name>user_db</user-name> <password>pass_db</password> <connection-property name="autoReconnect">true</connection-property> <!-- Typemapping for JBoss 4.0 --> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources>
Code d'appel de la connexion à la base de donnée
DataSource ds = null; try { initCtx = new InitialContext(); ds = (DataSource) initCtx.lookup("java:MySqlDS"); con = ds.getConnection (); } catch (SQLException e) { e.printStackTrace(); } catch (NamingException e) { e.printStackTrace(); }