Hi all,
I am using JBOSS v2.2.2 with embedded tomcat v3.2.2
I've written a bean which inserts a data in database.
By default, JBOSS uses Hypersonic datasource & the table
gets created in Hypersonic database. Now I want to use
Oracle 8.0.3.0.0 as a backend.
For that purpose, I've added the following in jboss.jcml
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">sun.jdbc.odbc.JdbcOdbcDriver</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:odbc:jboss_odbc1</attribute>
<attribute name="JDBCUser">scott</attribute>
<attribute name="Password">tiger</attribute>
</mbean>
I've also created a dsn "jboss_odbc1" through ODBC which points
to Oracle ODBC Driver.
On Hypersonic database, my bean gets deployed perfectly. But on
changing the standardjaws.xml file as shown below
<datasource>java:/OracleDB</datasource>
<type-mapping>Oracle8</type-mapping>
my bean doesn't get deployed. It gives the following error:
[JAWS] Initializing JAWS plugin for Product
[JAWS] Loading standardjaws.xml :
file:/E:/jboss/conf/default/standardjaws.xml
[Container factory] java.sql.SQLException: [Microsoft][ODBC driver for
Oracle]Driver not capable
[Container factory] at
sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
[Container factory] at
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
Can anyone help me in this matter ????
Thanks & Regards,
- Prashant
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
