Jboss 3.0.2 and Oracle 8i Datasource

[serafy]

I'm using Jboss for the first time, I’m trying to configure it to work with Oracle 8.1.7 (8i).

I’ve used the downloaded binaries and copied oracle-service.xml file to deploy directory.

Unfortunately, I’m getting this error:

13:34:10,894 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:

Incompletely deployed packages:

MBeans waiting for classes:

MBeans waiting for other MBeans:
[ObjectName: jboss.jca:service=LocalTxCM,name=OracleDS
state: CONFIGURED
I Depend On: jboss.jca:service=LocalTxDS,name=OracleDS
jboss.jca:service=LocalTxPool,name=OracleDS
jboss.jca:service=CachedConnectionManager
jboss.security:service=JaasSecurityManager
jboss.jca:service=RARDeployer

Depends On Me: , ObjectName: jboss.jca:service=LocalTxDS,name=OracleDS
state: CONFIGURED
I Depend On: jboss.jca:service=RARDeployment,
name=JBoss LocalTransaction JDBC Wrapper

Depends On Me: jboss.jca:service=LocalTxCM,name=OracleDS
]

[koomiv]

did you change ?
jdbc:oracle:thin:@youroraclehost:1521:yoursid
did you add oracle jdbc driver in run.bat ?
JBOSS_CLASSPATH=%JBOSS_CLASSPATH%;%JAVAC_JAR%;%RUNJAR%;%JBOSS_HOME%\lib\classes12.zip

[serafy]

Thanks a lot for your reply.. :)

Yes I did.
Do I need to build Jboss for oracle to work ?

my oracle-service.xml file:
<?xml version="1.0" encoding="UTF-8"?>



<!-- ConnectionManager setup for Oracle dbs -->
<!-- Build jmx-api (build/build.sh all) and view for config documentation -->
<!-- Thanks to Steven -->




<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->


OracleDS



<config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@localhost:1521:IFLOW</config-property>
<config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
<config-property name="UserName" type="java.lang.String">caseware</config-property>
<config-property name="Password" type="java.lang.String">caseware</config-property>




<!--Below here are advanced properties -->
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">
jboss.jca:service=RARDeployment,
name=JBoss LocalTransaction JDBC Wrapper




<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->


0
50
5000
15
<!--criteria indicates if Subject (from security domain) or app supplied
parameters (such as from getConnection(user, pw)) are used to distinguish
connections in the pool. Choices are
ByContainerAndApplication (use both),
ByContainer (use Subject),
ByApplication (use app supplied params only),
ByNothing (all connections are equivalent, usually if adapter supports
reauthentication)-->
ByContainer



<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager

java:/TransactionManager

<!--make the rar deploy! hack till better deployment-->
jboss.jca:service=RARDeployer

[koomiv]

place the oracle-service.xml in the default/deploy directory you'll see the connection when jboss starts

[cardenizen]

I have also been trying for many hours to get the simplest workbook example (ex04_1) to run with mysql and oracle. Apparently I've been taking on too much for a novice (like trying to get itracker - http://sourceforge.net/projects/itracker installed).

My setup:
JBoss distribution - JBoss-3.0.2.zip
JSDK distribution - j2sdk-1_4_1-windows-i586.exe
jdbc drivers - mm.mysql-2.0.14-bin.jar and classes12.zip

These are ALL the changed I made:
1. added the jdbc drivers to bin/run.bat

2. changed the ex04_1 build.xml to point directly to the jboss directory (also removed JBOSS_HOME env variable). Just make sure property jboss.home gets set properly.

3. copied mysql-service.xml from docs/examples/jca to server/default/deploy and removed hsqldb-service.xml. In mysql-service changed the ConnectionURL config-property to jdbc:mysql://localhost:3306/mysql and added the appropriate UserName and Password in their config-property tags.

4. in server/default/conf/standardjaws.xml changed
java:/DefaultDS
<type-mapping>Hypersonic SQL</type-mapping>
to
java:/MySqlDS
<type-mapping>mySQL</type-mapping>

5. in server/default/conf/standardjbosscmp-jdbc.xml changed
java:/DefaultDS
<datasource-mapping>Hypersonic SQL</datasource-mapping>
to
java:/MySqlDS
<datasource-mapping>mySQL</datasource-mapping>

6. started the server with run.bat (did not use "-c all")

7. in the ex04_1
ant
(sucessfully deployed CabinEJB)
ant run.client_41a
(added the master suite record)
ant run.client_41b
(added 99 suite records)

I followed the same procedure to run this agiainst the oracle db.


Regards,
Dennis