Is there an example of getting a connection from a DB connection pool using 
Oracle (or any other db) and JBoss (for BMP or a session bean)? I have 
scanned the docs and archive, but couldn't find any.

I added the following to jboss.conf

<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="classes111b.zip" 
CODEBASE="../lib/ext/">
    <ARG TYPE="java.lang.String" VALUE="OraclePool">
    <ARG TYPE="java.lang.String" 
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>

and the following to jboss.jcml

        <mbean name="DefaultDomain:service=XADataSource,name=OraclePool">
            <attribute 
name="URL">jdbc:oracle:thin:@192.168.0.63:1521:MSDEV001</attribute>
            <attribute name="JDBCUser">ecrm</attribute>
            <attribute name="Password">judge44</attribute>
        </mbean>

I figured that I need to get the DataSource by doing a jndiCntx.looup but 
couldn't figure out what to pass as the lookup string parameter.

Can anyone help, or provide some sample code.

Thanks.

John


--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
List Help?:          [EMAIL PROTECTED]

Reply via email to