We use ejb-location, Location, xa-location and ejb-location all utilize different drivers
within Orion with different properties as far as transaction control and
connection pooling are concerned. We picked ejb-location because it seems to allow both transaction
control and connection pooling. The only way to see what it is doing seems to be by doing a jndi look up
by each of the names then printing out the class name of the resulting object,
then looking up in the Orion specific API documentation for each of those class
names to see what they do. The attachment has the data-sources.xml and InventoryBean.java that I
was using for testing. It shows that a thrown exception in the middle of a transaction will rollback
the transaction. Regards, Rob Lapensee Director of Technology Delfour Corporation [EMAIL PROTECTED] www.delfour.com -----Original
Message----- can location have a same
name? Your example seems to have a diferent name for location, xa-location,
ejb-location, etc.... Thanks for your valuable info.. Se Hee -----Original Message----- You will need to get the jdbc driver from oracle (www.oracle.com) get the classes12_01.zip (not
the classes111.zip). Then the data-sources.xml file in orion/config should
have something like the following as one of the data-source entries:
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="user1"
location="jdbc/OracleCoreDS"
xa-location="jdbc/xa/OracleXADS"
ejb-location="jdbc/Oracle"
connection-driver="oracle.jdbc.driver.OracleDriver"
username="user1"
password=”password1" url="jdbc:oracle:thin:@(description=(address=(host=192.1.1.1)(protocol=tcp)(port=1521))(connect_data=(sid=S1)))"
inactivity-timeout="30" /> then use “jdbc/Oracle” as the jndi lookup to get the
DataSource, then use the DataSource to get the jdbc Connection. Regards, Rob Lapensee Director of
Technology Delfour
Corporation [EMAIL PROTECTED] www.delfour.com -----Original
Message----- How do I set up the Orion to work with
Oracle? I am new to Orion (just downloaded) and try to make it to create
DataSource with Oracle.. Does Orion comes with its own JDBC Driver
for Oracle or should I should Oracle's driver? Thanks a lot for any comment and help.. Se Hee |
<?xml version=3D"1.0"?>=0A= <!DOCTYPE data-sources PUBLIC "Orion data-sources" = "http://www.orionserver.com/dtds/data-sources.dtd">=0A= =0A= <data-sources>=0A= <!--=0A= An example/default DataSource that uses an ordinary=0A= JDBC-driver (in this case hsql) to create the connections. =0A= This tag creates all the needed kinds=0A= of data-sources, transactional, pooled and EJB-aware sources.=0A= The source generally used in application code is the "EJB"=0A= one - it provides transactional safety and connection pooling.=0A= -->=0A= =0A= <!--=0A= <data-source=0A= class=3D"com.evermind.sql.DriverManagerDataSource"=0A= name=3D"Hypersonic"=0A= location=3D"jdbc/HypersonicCoreDS"=0A= xa-location=3D"jdbc/xa/HypersonicXADS"=0A= ejb-location=3D"jdbc/HypersonicDS"=0A= connection-driver=3D"org.hsql.jdbcDriver"=0A= username=3D"sa"=0A= password=3D""=0A= url=3D"jdbc:HypersonicSQL:./database/defaultdb"=0A= inactivity-timeout=3D"30"=0A= />=0A= -->=0A= =0A= <data-source=0A= class=3D"com.evermind.sql.DriverManagerDataSource"=0A= name=3D"Oracle"=0A= location=3D"jdbc/OracleCoreDS"=0A= xa-location=3D"jdbc/xa/OracleXADS"=0A= ejb-location=3D"jdbc/OracleDS"=0A= connection-driver=3D"oracle.jdbc.driver.OracleDriver"=0A= username=3D"user1"=0A= password=3D"password1"=0A= = url=3D"jdbc:oracle:thin:@(description=3D(address=3D(host=3D192.1.1.1)(pro= tocol=3Dtcp)(port=3D1521))(connect_data=3D(sid=3Djack)))"=0A= inactivity-timeout=3D"30"=0A= />=0A= =0A= </data-sources>=0A=