Guys.. I can't properly set up my db conn with my Oracle 8.1.5 DB
Here's it:
<?xml version="1.0"?>
<!DOCTYPE data-sources PUBLIC "Orion data-sources"
"http://www.orionserver.com/dtds/data-sources.dtd">
<data-sources>
<!--
An example DataSource that uses an ordinary JDBC-driver to
create the connections,
to install; set the proper URL to the db, specify the
db-driver name and
unrem the below section. This creates all the needed kinds
of data-sources, transactional, pooled and EJB-aware
sources.
-->
<!--data-source
name="Default data-source"
class="com.evermind.sql.ConnectionDataSource"
location="jdbc/DefaultDS"
pooled-location="jdbc/DefaultPooledDS"
xa-location="jdbc/xa/DefaultXADS"
ejb-location="jdbc/DefaultEJBDS"
url="jdbc:odbc:EJB"
connection-driver="sun.jdbc.odbc.JdbcOdbcDriver"
username="xxx"
password="yyy"
/-->
<data-source
name="SEDS"
class="com.evermind.sql.ConnectionDataSource"
location="jdbc/SEDS"
pooled-location="jdbc/PooledSEDS"
xa-location="jdbc/xa/XASEDS"
ejb-location="jdbc/EJBSEDS"
url="jdbc:oracle:thin:@192.168.2.187:1521:DB0009"
connection-driver="oracle.jdbc.driver.OracleDriver"
username="PRODU"
password="PRODU"
schema="database-schemas/oracle.xml"
/>
<data-source
name="SessionDS"
class="com.evermind.sql.ConnectionDataSource"
location="ejb/SessionDS"
pooled-location="ejb/PooledSessionDS"
xa-location="ejb/XASessionDS"
xa-source-location="ejb/XASSessionDS"
ejb-location="ejb/EJBSessionDS"
url="jdbc:oracle:thin:@192.168.2.187:1521:DB0009"
connection-driver="oracle.jdbc.driver.OracleDriver"
username="PRODU"
password="PRODU"
schema="database-schemas/oracle.xml"
/>
</data-sources>
The schema is the one that ships with orion
what's worng with this? anyone had problems with CMP and oracle
TIA
Rifle