Re: [JBoss-user] Problem in connecting to Oracle 8i using JBoss/Tomcat

[Sundaram Ramasamy]

in jboss.jcml change like this  <mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">      <attribute name="Drivers">oracle.jdbc.driver.OracleDriver</attribute>   </mbean>     <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=DefaultDS">     <attribute name="PoolName">DefaultDS</attribute>     <attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>     <attribute name="Properties"></attribute>     <attribute name="URL">jdbc:oracle:thin:@192.168.1.197:1521:A</attribute>     <attribute name="GCMinIdleTime">1200000</attribute>     <attribute name="JDBCUser">sti</attribute>     <attribute name="Password" >sti</attribute>     <attribute name="MaxSize">10</attribute>     <attribute name="GCEnabled">false</attribute>     <attribute name="InvalidateOnError">false</attribute>     <attribute name="TimestampUsed">false</attribute>     <attribute name="Blocking">true</attribute>     <attribute name="GCInterval">120000</attribute>     <attribute name="IdleTimeout">1800000</attribute>     <attribute name="IdleTimeoutEnabled">false</attribute>     <attribute name="LoggingEnabled">false</attribute>     <attribute name="MaxIdleTimeoutPercent">1.0</attribute>     <attribute name="MinSize">0</attribute>   </mbean> Give correct URL, user name and passowrd.   no need to have jboss.properites file.   bye  ----- Original Message ----- From: Kiran MN To: [EMAIL PROTECTED] Sent: Friday, November 09, 2001 6:27 AM Subject: [JBoss-user] Problem in connecting to Oracle 8i using JBoss/Tomcat Hello All,   Can any one tell me the procedure to to configure Oracle 8i ( ver is 8.1.5) on JBoss-2.4.3_tomcat-3.2.3.   I have followed the procedure given in the documentation...    The changes I made are:-  1. In the jboss.properties file I have added the following line jboss.xa.xidclass=oracle.jdbc.xa.OracleXid  2. In  jboss.jcml file I have included the following script  <mbean code="org.jboss.jdbc.JdbcProvider"name="DefaultDomain:service=JdbcProvider">      <attribute name="Drivers">oracle.jdbc.driver.OracleDriver</attribute>  </mbean>  <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=OracleDB">  <attribute name="PoolName">OracleDB</attribute>  <attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>[JBoss 2.4]  <attribute name="URL">jdbc:oracle:thin:@192.168.1.5:1521:numbers</attribute>  <attribute name="JDBCUser">scott</attribute>  <attribute name="Password">tiger</attribute> </mbean> copied  classes111_01.zip to lib/ext folder of Jboss.( my oracle8i version is 8.1.5....even if if copy classes12.zip still not working.) Please let me know any thing more I need to do to create Connection Pool for Oracle 8i.   Thanks in Advance -Kiran