Re: example of data-source.xml for Oracle 9i needed

2002-05-13 Thread Darren Senel

This is what I use:

data-source class=com.evermind.sql.DriverManagerDataSource
name=OracleDS 
location=jdbc/OracleCoreDS 
xa-location=jdbc/xa/OracleXADS 
ejb-location=jdbc/OracleDS 
connection-driver=oracle.jdbc.driver.OracleDriver 
username=dsenel 
password=mypassword 
url=jdbc:oracle:thin:@172.25.10.132:1521:mydb 
inactivity-timeout=30 
connection-retry-interval=1 / 

 [EMAIL PROTECTED] 05/13/02 03:51AM 
Hi all, 
may somebody provide me with example of of data-source.xml for Oracle
9i
that supports CMT (container managed transactions) for Orion 1.5.2 ?

Thank you in advance

ITC-M, SIS Company
Mr. Valeri Kireitchik 
Head of Application Software Department 

Fujitsu Siemens Computers Qualified Partner 
Microsoft Certified Partner 
Oracle Partner Program Member 

Surganova 24-406 
220012 Minsk 
Republic of Belarus 
ph.: +375 (17) 262 50 23 
fax: +375 (17) 262 55 91 
http://www.sis-group.com/ 






Re: example of data-source.xml for Oracle 9i needed

2002-05-13 Thread Matthew E. Porter

Darren:
  Does this configuration provide any sort of connection pooling?


-matthew

On Mon, 13 May 2002, Darren Senel wrote:

 This is what I use:

 data-source class=com.evermind.sql.DriverManagerDataSource
 name=OracleDS
 location=jdbc/OracleCoreDS
 xa-location=jdbc/xa/OracleXADS
 ejb-location=jdbc/OracleDS
 connection-driver=oracle.jdbc.driver.OracleDriver
 username=dsenel
 password=mypassword
 url=jdbc:oracle:thin:@172.25.10.132:1521:mydb
 inactivity-timeout=30
 connection-retry-interval=1 /

  [EMAIL PROTECTED] 05/13/02 03:51AM 
 Hi all,
 may somebody provide me with example of of data-source.xml for Oracle
 9i
 that supports CMT (container managed transactions) for Orion 1.5.2 ?

 Thank you in advance

 ITC-M, SIS Company
 Mr. Valeri Kireitchik
 Head of Application Software Department

 Fujitsu Siemens Computers Qualified Partner
 Microsoft Certified Partner
 Oracle Partner Program Member

 Surganova 24-406
 220012 Minsk
 Republic of Belarus
 ph.: +375 (17) 262 50 23
 fax: +375 (17) 262 55 91
 http://www.sis-group.com/









Re: example of data-source.xml for Oracle 9i needed

2002-05-13 Thread gottfried

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Mon, 13 May 2002, Matthew E. Porter wrote:

 Darren:
   Does this configuration provide any sort of connection pooling?

nop, the pooled-location is missing. we have setup a datasource
like this and i hope this is the correct way. sorry, but this
example is for oracle 8.1.7. i think this should also work for
oracle 9 but i am not sure.

data-source
class=com.evermind.sql.DriverManagerDataSource
name=Oracle Datasource MessageLogger
location=jdbc/MessageLogger
pooled-location=jdbc/pooled/MessageLogger
connection-driver=oracle.jdbc.driver.OracleDriver
username=user
password=pass
url=jdbc:oracle:thin:1.2.3.4:1521:DATABASE
max-connections=5
min-connections=2
inactivity-timeout=30
schema=database-schemas/oracle.xml /


- -- 
cu,
goofy

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: pgpenvelope 2.10.2 - http://pgpenvelope.sourceforge.net/

iD8DBQE84Jg1rMda10jkyDYRAqqFAKCyE+W8OQj8upIn1oSMee9NGfSDZQCglOhw
ErgUx741TU2GLU2xRSw823I=
=B1b9
-END PGP SIGNATURE-