serveurweb:gestion_de_data_source

Utilisation d'une DataSource

Version: jBoss 4.0.1 & mysql 4.0.23.

~/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>
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();
}
  • serveurweb/gestion_de_data_source.txt
  • Dernière modification: 2018/10/13 14:59
  • (modification externe)