In standardjbosscmp-jdbc.xml
<jbosscmp-jdbc>
<defaults>
<datasource>java:/OracleDS</datasource>
<datasource-mapping>Oracle9i</datasource-mapping>
Look down in the file to find which datasource-mapping applies to your
server configuration
In oracle-ds.xml
<datasources>
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
Get rid of /deploy/hsqldb-ds.xml
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of DEVEDJIAN
Laurent
Sent: Thursday, December 02, 2004 4:19 PM
To: '[EMAIL PROTECTED]'
Subject: [JBoss-user] Help to configure datasource to oracle db.
Hi,
Sorry to post this message but I try and try again without success a way
to
configure an test my access to an oracle database.
I read documentation and exemple on the doc folder. But I have always
the
same problem.
I use the default profile.
I have a database oracle, and I install classes12.zip in the lib
directory
for the JDBC driver.
In the file .\server\default\jboss-service.xml I made this change
<mbean code="org.jboss.tm.XidFactory" name="jboss:service=XidFactory">
<attribute name="Pad">true</attribute>
</mbean>
I create the file oracle-ds.xml directory .\server\default\deploy
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>nameOfMyConnection</jndi-name>
<connection-url>jdbc:oracle:thin:@myServer:myPort:mySID</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>myUser</user-name>
<password>myPassword</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.Orac
leEx
ceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>Oracle8</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
I don't know what king of argument I must put on the
standardjbosscmp-jdbc.xml file, is that correct?
<defaults>
<datasource>java:/OracleDS</datasource>
Be sure that all parameter SID, login, password, port, Server are
corrects,
I test them with SQL Plus.
Any comments are welcome.
Regards,
Laurent
Computer Resources International (Luxembourg) SA
Tel: + 352 42 44 77. Fax: +352 42 44 45
DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. If you
are not the intended recipient, any disclosure, copying, or
distribution of the message, or any action or omission taken by you in
reliance on it, is prohibited and may be unlawful. Please immediately
contact the sender if you have received this message in error.
Thank you.
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://productguide.itmanagersjournal.com/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://productguide.itmanagersjournal.com/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
