-
1. Re: Datasource creation for oracle in JBOSS
joycewteng Dec 1, 2004 4:03 PM (in response to bonthus)Try if this works
(1) modify xxx-ds.xml
<local-tx-datasources>
<jndi-name>yourOracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@localhost:1521:EPS</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>yourUserName</user-name>
yourPwd
</local-tx-datasources>
(2) modify your method:
javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("java:/yourOracleDS");
(3) ensure oracle driver (i.e. classes12.jar) in JBOSS lib directory -
2. Re: Datasource creation for oracle in JBOSS
bonthus Dec 2, 2004 8:15 AM (in response to bonthus)thanks joy
i have tried ur option also but it was not working now also
every thing i have given was fine but i dont know y it was not working
while starting itself it is showing that no resource manager found for OracleDS i think datasource was not created yet
how can i do at this stage???? -
3. Re: Datasource creation for oracle in JBOSS
darranl Dec 2, 2004 8:21 AM (in response to bonthus)Try starting JBoss without your application or -ds.xml deployed.
Put the -ds.xml in the deploy folder, look at any messages on the console to see if it deployed.
Use JNDI View in jmx-console to check that the connection bound.
Only when you know that the connection has been bound correctly then deploy your session bean and see if you can make use of the connection. -
4. Re: Datasource creation for oracle in JBOSS
bonthus Dec 6, 2004 1:57 AM (in response to bonthus)thnk you all for helping me
finally i was got the reason why it was not deployed
the reason was small mistake in oracle-ds.xml
in place of<local-tx-datasource>
i have given<local-tx-datasources>
that was only mistake i was commited
by replacing it with proper word now it is working fine
thank you