I have followed the same steps that you have mentioned and faced the same problem.
Please reply ASAP
I am also facing the same error... Still looking for some help to get it resolved.
have you tried:
<!--set these only if you want only default logins, not through JAAS -->
Thanks for your time.
Now, I am getting the following message on the console. Could you please have a look:
10:03:42,237 INFO [MainDeployer] Starting deployment of package: file:/Q:/jboss
10:03:42,487 WARN [ServiceController] jboss.jca:service=LocalTxDS,name=OracleDS
does not implement any Service methods
10:03:42,487 INFO [JBossManagedConnectionPool] Creating
10:03:42,487 INFO [JBossManagedConnectionPool] Created
10:03:42,503 INFO [JBossManagedConnectionPool] Starting
10:03:42,503 INFO [JBossManagedConnectionPool] Started
10:03:42,503 INFO [MainDeployer] Deployed package: file:/Q:/jboss-3.0.4/jboss-3
10:03:42,596 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean ope
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:
Incompletely deployed packages:
MBeans waiting for classes:
MBeans waiting for other MBeans:
I Depend On: jboss.jca:service=LocalTxDS,name=OracleDS
Depends On Me: ]
I think you can't change the connection url from jdbc:oracle:oci8:@tc to jdbc:oracle:thin:mytest/mytest@myserver:1521:ora817 because you are not using oracle thin driver (oracle.jdbc.driver.OracleDriver).
You are using oracle.jdbc.xa.client.OracleXADataSource (<config-property name="XADataSourceClass" type="java.lang.String">oracle.jdbc.xa.client.OracleXADataSource</config-property>).
That did'nt make any difference to me, I'm as stuck as you guys. Let's join our brains!!!
Even if you would be able to configure oracle xa datasource, JBoss 3.0.x does not support oracle in XA. Oracle provides pretty crapy xa drivers and we were not able to workaround all their (known) problems until 3.2. If you really need to do XA then you should get latest 3.2 from cvs, compile and use either oracle-xa-sirvice.xml or new simplified datasource configuration oracle-xa-ds.xml.
As for URL strings you can use either "jdbc:oracle:oci8:@hoststring" or "jdbc:oracle:thin:@youroraclehost:1521:yoursid". oci8 (a.k.a type 2) driver MUST be used you are using LOBs.
Thanks for the response...
I installed JBoss 3.2.0 Beta version and was able to setup an Oracle datasource (Non-XA) pretty easily. But now the problem is that I don't see any established Oracle database connections.
Does JBoss need to be restarted after datasource creation for taking connections??
Also, my XA Oracle datasource does not work.. It gives me error.
my issue it that the JBoss does not respect my jaws.xml settings. therefore I had to change the names at the beginnings of
maybe just the jaws change is needed but I didnt test yet.
I moved to JBoss 3.2 Beta and was able to setup an Oracle Non-XA datasource quickly.
I am still working on configuring Oracle XA datasource.