The data source declarations look fine.
The issue is that by default EJBs in Orion use the jdbc/DefaultEJBDS data
source. If you want to use one of your other sources then you need to deploy
the app, stop Orion and edit orion-ejb-jar.xml in the
application-deployments tree and change the data-source="jdbc/DefaultEJBDS"
attribute to point at your new source.
Once you have the orion-ejb-jar.xml correct, copy it to the application in
the orion directory and it will be copied every time the app is deployed.
e.g.
applications
myApp
myApp-ejb
META-INF
ejb-jar.xml
orion
orion-ejb-jar.xml
Dave Smith
Senior Team Leader
Aristocrat Technologies Australia Pty Ltd
mailto:[EMAIL PROTECTED]
-----Original Message-----
From: Juan Pablo Lorandi [mailto:[EMAIL PROTECTED]]
Sent: Monday, 17 July 2000 23:39
To: Orion-Interest
Subject:
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
