subject:"RE\: How to select an other datasource then the default one\?"

RE: How to select an other datasource then the default one?

2000-10-12 Thread Frank Eggink


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 +
 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.

RE: How to select an other datasource then the default one?

2000-10-12 Thread Goel, Deepak


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="2"

/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

Re: How to select an other datasource then the default one?

2000-10-11 Thread Ralph Crawford


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 +
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.

RE: How to select an other datasource then the default one?

RE: How to select an other datasource then the default one?

Re: How to select an other datasource then the default one?

3 matches

Site Navigation

Mail list logo

Footer information