I have a WAR file which runs fine on IBM websphere, now I want to run it on jboss. I am able to run a static website by putting it in the deploy folder, but for the dynamic website I need to make an oracle connection. Can any one please help where all I need to make changes. I am not using EJB's do I still need jbosscmp-jdbc.xm?
You need to deploy oracle-ds.xml for making connection with oracle database. No need to change hsqldb-ds.xml. Are you facing any kind of error while deploying you war? If so, please post the entire error log along with the changes that you have done in JBoss.
Joined: Dec 20, 2010
I am sorry but I am new to jboss, do I need to have oracle-datasource.xml in my WAR file?
Among the long error logs, 'jdbc not bound' caught my eye.
I have made following changes in jboss:
in default/deploy/ hsqldb-ds.xml I have added,
<!-- The login and password -->
and in default/conf/ standardjbosscmp-jdbc.xml <datasource>java:/MYCoreDS</datasource>
I have taken the above elements from datasource file produced by my jdev
Also I have put classes12.jar in jboss lib folder and also in my WAR file.
uttam kumar wrote:You need to deploy oracle-ds.xml for making connection with oracle database. No need to change hsqldb-ds.xml. Are you facing any kind of error while deploying you war? If so, please post the entire error log along with the changes that you have done in JBoss.
Clearly, its better to have TNS set up properly.
<!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
<!-- Checks the Oracle error codes and messages for fatal errors -->
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
<!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->