Hello,
When you deploy your application, Orion creates a subdirectory with the name
of the app under application-deployments. You should see another
subdirectory with the name of your ejb jar file. So for example if you have
an app named myApp and myApp.ear contains myEJB.jar, then you should see
<orion-home>/application-deployments/myApp/myEJB.jar/orion-ejb-jar.xml
This file is automatically created by Orion and can be changed to suit your
needs. For each entity bean deployed, there will be an entry here:
<entity-deployment name="Cabinet" location="Cabinet"
wrapper="CabinetHome_EntityHomeWrapper7" table="cab"
data-source="jdbc/SQLServerDS" validity-timeout="20000">
....
</entity-deployment>
For more info, look at the documentation for this file:
http://www.orionserver.com/docs/orion-ejb-jar.xml.html
--Deepak
-----Original Message-----
From: Frank Eggink [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 12:28 AM
To: Orion-Interest
Subject: RE: How to select an other datasource then the default one?
Ralph and others,
My datasources.xml 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
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:HypersonicSQL:./database/DB"
connection-driver="org.hsql.jdbcDriver"
username="xxx"
password="xxx"
/>
<data-source
name="Default data-source"
class="com.evermind.sql.ConnectionDataSource"
location="jdbc/TestDS"
pooled-location="jdbc/TestPooledDS"
xa-location="jdbc/xa/TestXADS"
ejb-location="jdbc/TestEJBDS"
url="jdbc:HypersonicSQL:./database/Test"
connection-driver="org.hsql.jdbcDriver"
username="xxx"
password="xxx"
/>
</data-sources>
Guess there is not much wrong in that. The trouble I have is making the
application point to the right datasource. Using CMP I would expect you can
add some option somewhere to tell the server to use that connection, but
where do I need to put the great 'use-this-datasource' option?
Orion-application.xml seemed logical to me.
Frank
On Wednesday, October 11, 2000 8:41 PM, Ralph Crawford
[SMTP:[EMAIL PROTECTED]] wrote:
> Here's an example of a data-sources.xml file with two different
> datasources...
>
> <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:oracle:thin:@blah.domain.com:1521:dbinstance"
> connection-driver="oracle.jdbc.driver.OracleDriver"
> username="username"
> password="password"
> />
>
> <data-source
> name="Othert data-source"
> class="com.evermind.sql.ConnectionDataSource"
> location="jdbc/OtherDS"
> pooled-location="jdbc/OtherPooledDS"
> url="jdbc:postgresql://blah.domain.com:5432/postgres"
> connection-driver="postgresql.Driver"
> username="username"
> password="password"
> />
>
> Obviously, in this case, I've got both the Oracle and Postgres drivers in
my
> orion/lib directory. Then when you want to get a pooled connection,
you'd
> use...
>
> connection = ((javax.sql.DataSource)
> ctx.lookup("jdbc/DefaultPooledDS")).getConnection();
>
>
> and if you wanted to use the other database, you'd use jdbc/OtherPooledDS
> instead of jdbc/DefaultPooledDS.
>
> Hope this helps.
>
> Ralph
>
>
> >From: Frank Eggink <[EMAIL PROTECTED]>
> >Reply-To: Orion-Interest <[EMAIL PROTECTED]>
> >To: Orion-Interest <[EMAIL PROTECTED]>
> >Subject: How to select an other datasource then the default one?
> >Date: Wed, 11 Oct 2000 15:19:04 +0200
> >MIME-Version: 1.0
> >Received: from [195.84.237.200] by hotmail.com (3.2) with ESMTP id
> >MHotMailBBADCD3A0024D82197D8C354EDC808540; Wed Oct 11 08:07:44 2000
> >Received: from druid.evermind.net (IDENT:[EMAIL PROTECTED]
> >[127.0.0.1])by druid.evermind.net (8.9.3/8.9.3) with SMTP id
PAA10617;Wed,
> >11 Oct 2000 15:26:20 -0100
> >Received: from post.mail.nl.demon.net (post-10.mail.nl.demon.net
> >[194.159.73.20])by paladin.evermind.net (8.9.3/8.9.3) with ESMTP id
> >QAA06513for <[EMAIL PROTECTED]>; Wed, 11 Oct 2000 16:22:12
> >-0400
> >Received: from [212.238.78.167] (helo=barabas)by post.mail.nl.demon.net
> >with smtp (Exim 3.14 #2)id 13jLql-0003J1-00for
> >[EMAIL PROTECTED]; Wed, 11 Oct 2000 13:23:15 +0000
> >Received: by localhost with Microsoft MAPI; Wed, 11 Oct 2000 15:19:18
+0200
> >From [EMAIL PROTECTED] Wed Oct 11 08:11:44 2000
> >Message-ID: <[EMAIL PROTECTED]>
> >Organization: De Frisse Jongens
> >X-Mailer: Orion ListServer
> >Sender: [EMAIL PROTECTED]
> >
> >Hi, How do you select a different datasource?
> >
> >I have defined a second data source in the datasources.xml file. Also I
> >have added "default-data-source="jdbc/TestEJBDS" to the
> >orion-application.xml file in the application-deployments/<application>
> >directory, as suggested by the manual.
> >
> >It doesn't work though,
> >Frank
> >
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
>
