BMP JBoss - Oracle Connections through DataSource

[David Rocks]

Hi,
I have a few beans in JBoss that are BMP. Just now i am getting a connection through a typical piece of JDBC - Driver Manager etc which i am aware is totally the wrong way to go about this. the BMP are working fine so the database connection from JBoss is fine.
I am aware that there is a connection pool that i can access, through JNDI i think.
can anybody show me a code example or something 'cos the jboss forums are down and i cannot find anything anywhere.
thanks in advance
david

[Mikalai Zaikin]

Hello.
We are using the following approach in our project :

public class ConnectionManager {
private static final String DataSourceName = "java:/OracleDS";
private static final Category log =
Category.getInstance(ConnectionManager.class);
public static Connection getConnection() {
Properties props = new Properties();
DataSource ds = null;
Connection conn = null;
try {
InitialContext initContext = new InitialContext(props);
log.debug("context initialized : " + initContext.toString());
ds = (DataSource) initContext.lookup(DataSourceName);
log.debug("datasource initialized : " + ds.toString());
conn = ds.getConnection();
log.debug("connection initialized : " + conn.toString());
} catch (Exception e) {
log.error("fatal error during connection creating" + e.toString());
}
return conn;
}
}

jaws.xml

 <datasource>java:/OracleDS</datasource>
 <type-mapping>Oracle8</type-mapping>
 <debug>false</debug>

jboss.jcml

<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=OracleDB">
  <attribute name="PoolName">OracleDS</attribute>
  <attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
  <attribute name="URL">jdbc:oracle:thin:@server_name:1521:db_name</attribute>
  <attribute name="JDBCUser">user</attribute>
  <attribute name="Password">paswword</attribute>
  <attribute name="MinSize">10</attribute>
  <attribute name="MaxSize">100</attribute>
  <attribute name="Blocking">false</attribute>
  <attribute name="TransactionIsolation">TRANSACTION_SERIALIZABLE</attribute>
</mbean>

Everything works stable.
Hope, this code helps you.
Mikalai.
[ June 06, 2002: Message edited by: Mikalai Zaikin ]

[Mikalai Zaikin]

Just add:
versions of JBoss are 2.4.3 and 2.4.4

[Mikalai Zaikin]

jboss.jcml

  
  <!-- ==================================================================== -->
  <!-- JDBC                                                                 -->
  <!-- ==================================================================== -->
  <mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
     <attribute name="Drivers">org.hsqldb.jdbcDriver,oracle.jdbc.driver.OracleDriver</attribute>
  </mbean>