I have set up the data-sources.xml file using Oracle, following the
advice of Magnus R. at orion, the result looks like:
<?xml version="1.0"?>
<!DOCTYPE data-sources PUBLIC "Orion data-sources"
"http://www.orionserver.com/dtds/data-sources.dtd">
<data-sources>
<data-source
class="com.evermind.sql.ConnectionDataSource"
connection-driver="oracle.jdbc.driver.OracleDriver"
connection-retry-interval="1"
ejb-location="jdbc/OracleEJBDS"
inactivity-timeout="30"
location="jdbc/OracleDS"
max-connect-attempts="3"
max-connections="100"
name="oracle-inst1"
password="change_on_install"
pooled-location="jdbc/OraclePooledDS"
schema="database-schemas/oracle.xml"
url="jdbc:oracle:thin:@localhost:1521:inst1"
username="sys"
xa-location="jdbc/xa/OracleXADS"
/>
</data-sources>
With this data-sources file I don't even have a java:comp/jdbc
Context, much less the right entries. I am unable to verify
that a class named ConnectionDataSource even exists.
Magnus said to use the jdbc/OracleEJBDS source for connections,
claiming they would be automatically pooled. So far I'm not
getting anywhere!
Ideas?
Gary