Hope this gets to Andreas:
Thanks! I simply needed to include my driver in jboss.conf like so, in
addition to the XADataSourceLoader tag:
<MLET CODE = "org.jboss.jdbc.JdbcProvider"
ARCHIVE="jboss.jar,idb.jar,hsql.jar,mm.mysql-2.0.2-bin.jar,classes12.zip"
CODEBASE="../../lib/ext/">
</MLET>
This doesn't appear to be in the documentation (unless I missed it). If
JBoss folks could add this requirement as part of the XADatasource section,
perhaps that will help others avoid this confusion in the future. Just a
suggestion.
Justin
[EMAIL PROTECTED]
-----Original Message-----
From: Andreas Werner [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 2:28 AM
To: JBoss-User
Subject: Re: [jBoss-User] Need help with Oracle/CMP
Hello Justin,
I'm using the combination of JBoss and Oracle.
My jboss.conf looks like this
<MLET CODE="org.jboss.jdbc.XADataSourceLoader"
ARCHIVE="jboss.jar,classes12.zip" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="OracleDB">
^^^^^^^^^^^^^
<ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
it seems to me as you have forgotten to specify/copy the Oracle JDBC
driver to
/jboss/lib/ext/
If you are using the JDBC driver for Oracle 8.1.6 you may run into new
problems
this driver has a bug in the setObject() method of prepared statements
which are
used within JBoss, a workaround is to use the JDBC driver for Oracle
8.1.7.
Andreas Werner
Justin Peck wrote:
>
> Hello all,
>
> I am running jboss-2.0-FINAL with Tomcat in the same VM on Windows NT 4.0.
> I have recently been experimenting with CMP using an Oracle database
> instance. I followed the instructions found at JBoss -> Documentation and
> have edited jboss.properties, jboss.conf, and jboss.jcml. I get the
> following response from the console when starting up JBoss. Could someone
> possibly lend a hand?
>
> One last interesting note before the config files/console dump: When I go
> back to look at jboss.jcml, my entry below has magically disappeared (is
> this file generated on startup?) Have you experienced this before? Any
> light you can shed will be appreciated...
>
> jboss.conf addition:
> <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
> CODEBASE="../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="DefaultDS">
> <ARG TYPE="java.lang.String"
> VALUE="oracle.jdbc.xa.client.OracleXADataSource">
> </MLET>
>
> jboss.properties:
> jboss.xa.xidclass=oracle.jdbc.xa.OracleXid
> jdbc.drivers=org.hsql.jdbcDriver,oracle.jdbc.driver.OracleDriver
>
> jboss.jcml
> <mbean name="DefaultDomain:service=XADataSource,name=DefaultDS">
> <attribute
> name="URL">jdbc:oracle:thin:@host.domain.com:1521:AIRFRAME</attribute>
> <attribute name="JDBCUser">scott</attribute>
> <attribute name="Password">tiger</attribute>
> </mbean>
>
> Excerpt from console:
> ...
> [SpyderMQ] Initializing
> [SpyderMQ] Initialized
> javax.management.ReflectionException: The MBean class could not be loaded
by
> the specified loader
> at
>
com.sun.management.jmx.MBeanServerImpl.createMBean(MBeanServerImpl.java:754)
> at javax.management.loading.MLet.getMBeansFromURL(MLet.java:540)
> at javax.management.loading.MLet.getMBeansFromURL(MLet.java:369)
> at org.jboss.Main.<init>(Main.java:119)
> at org.jboss.Main$1.run(Main.java:87)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.jboss.Main.main(Main.java:83)
> [EmbeddedTomcat] Starting
> [EmbeddedTomcat] Testing if Tomcat is present....
> [EmbeddedTomcat] OK
> [EmbeddedTomcat] ContextManager: Adding context Ctx( )
> [EmbeddedTomcat] path="" :jsp: init
> [EmbeddedTomcat] PoolTcpConnector: Starting HttpConnectionHandler on 8080
> [EmbeddedTomcat] Started
> ...
>
> Thanks in advance!
>
> Justin Peck
> APsoftware
> [EMAIL PROTECTED]
> 801.443.3000 x3988
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
