Hi yeah you don't want
jdbc:oracle:thin:@sameer:1521:samora","scott","tiger"
but
jdbc:oracle:thin:@sameer:1521:samora
an uncomment the line
jboss.xa.xidclass=oracle.jdbc.xa.OracleXid
in jboss.properties
and change
<datasource>java:/DefaultDS</datasource>
<type-mapping>Hypersonic SQL</type-mapping>
in standardjaws.xml to
<datasource>java:/OracleDB</datasource>
<type-mapping>Oracle8</type-mapping>
and again make sure you have classes12.zip in lib/ext
hope this helps
----- Original Message -----
From: "Prashant Sarode" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 8:43 PM
Subject: [JBoss-user] Problem Connecting to Oracle v8.1.7
> Hi all,
> I want to use Oracle 8 as a backend instead of Hypersonic.
> I've changed the jboss.jcml file as shown below:
> <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.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
> l</attribute>
> <attribute
>
name="URL">jdbc:oracle:thin:@sameer:1521:samora","scott","tiger"</attribute>
> <attribute name="JDBCUser">scott</attribute>
> <attribute name="Password">tiger</attribute>
> </mbean>
>
> I m using Win NT OS with JBoss v2.2.2. & embedded Tomcat v3.2.2 & my
Oracle
> version is v8.1.7
> Is the DataSourceClass specified above is right ?????
> Coz I m getting following error :
>
> [OracleDB] XA Connection pool OracleDB bound to java:/OracleDB
> [OracleDB] Stopped
> [OracleDB] java.lang.NullPointerException
> [OracleDB] at
>
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSourc
> e.java:165)
> [OracleDB] at
>
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330)
> [OracleDB] at
> org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
>
> Pls pls help me !!!!!
>
> Thanks & Regards,
> - Prashant
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
