RE: [jBoss-User] installing ORACLE JDBC,

2001-03-16 Thread Michael Marr


This is how I got it working...


Bean Code:
  InitialContext context = new InitialContext();
  Datasource ds = (DataSource)
context.lookup("java:comp/env/jdbc/OracleDB");

jboss.jcml has the following:

  OracleDB
  oracle.jdbc.xa.client.OracleXADataSource
  jdbc:oracle:thin:@localhost:1521:ORCL
  scott
  tiger


ejb-jar.xml is the following:

  

  JBossTestBeano
  jbosstest.TestDBHome
  jbosstest.TestDB
  jbosstest.TestDBBean
  Stateless
  Bean
  
jdbc/OracleDB
javax.sql.DataSource
Container
  

  


jboss.xml is the following:

  

  OracleDB
  jdbc/OracleDB

  


Michael...



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Todd Bowker
Sent: Friday, March 16, 2001 2:21 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: [jBoss-User] installing ORACLE JDBC,


Here is a more complete list of everything I've done.

I have jboss 2.1 binary distribution.
I have my oracle jar file in lib/ext directory.
No changes for jboss.conf.

Two changes for jboss.jcml:

One for the JdbcProvider. I took out the hypersonic driver because I don't
start it and I added the oracle driver.


  
 oracle.jdbc.driver.OracleDriver,org.enhydra.instantdb.jdbc.id
bDriver
  



Other change is for Oracle DataSource:



  
   OracleDB
   org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l
   
   jdbc:oracle:thin:@domain:1521:instance
   120
   user
   2
   pass
   false
   false
   false
   true
   12
   180
   false
   false
   1.0
   1
 

I don't get any errors when I start the server and the console tells me it
started OracleDB.


good luck




-Original Message-
From: Reynir Hübner [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 11:17 AM
To: JBoss-User
Subject: RE: [jBoss-User] installing ORACLE JDBC,


thank you,
I´ve tried this but still get the same error...

so any other ideas ?

-r



-Original Message-
From: Todd Bowker [mailto:[EMAIL PROTECTED]]
Sent: 16. mars 2001 17:05
To: JBoss-User
Subject: RE: [jBoss-User] installing ORACLE JDBC,


The DataSourceClass attribute doesn't look right.
This is how I have mine configured, and I'm also using oracle:

 org.opentools.minerva.jdbc.xa.wrapper.XADataSourc
eImp
l



-Original Message-
From: Reynir Hübner [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 8:54 AM
To: [EMAIL PROTECTED]
Subject: [jBoss-User] installing ORACLE JDBC,


Hello,

I´m very new to jBoss and I´m trying to connect jBoss 2.1 to Oracle 8i
with the JDBC thin client.
I´m getting an error like this, and I´m wondering how to understand it:

[isdb] Starting
[isdb] XA Connection pool isdb bound to java:/isdb
[isdb] Stopped
[isdb] java.lang.NullPointerException
[isdb]  at
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataS
ource.java:165)
... etc

this is what I have in the jboss.jcml file :

 
   isdb
   oracle.jdbc.xa.client.OracleXADataSource
   jdbc:oracle:thin:@computer.domain.com:1521:isdb
   system
   
 

and I also specify the driver jboss.jcml,
all according to the message :
http://www.mail-archive.com/jboss-user@list.working-dogs.com/msg12921.ht
ml


ok, please tell me what I´m doing wrong.
regards,


Reynir Hübner
[EMAIL PROTECTED]







--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]


--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]



--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]


--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]



___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user



RE: [jBoss-User] installing ORACLE JDBC,

2001-03-16 Thread Todd Bowker

Here is a more complete list of everything I've done.

I have jboss 2.1 binary distribution.
I have my oracle jar file in lib/ext directory.
No changes for jboss.conf.

Two changes for jboss.jcml:

One for the JdbcProvider. I took out the hypersonic driver because I don't
start it and I added the oracle driver.


  
 oracle.jdbc.driver.OracleDriver,org.enhydra.instantdb.jdbc.id
bDriver
  



Other change is for Oracle DataSource:



  
   OracleDB
   org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l
   
   jdbc:oracle:thin:@domain:1521:instance
   120
   user
   2
   pass
   false
   false
   false
   true
   12
   180
   false
   false
   1.0
   1
 

I don't get any errors when I start the server and the console tells me it
started OracleDB.


good luck




-Original Message-
From: Reynir Hübner [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 11:17 AM
To: JBoss-User
Subject: RE: [jBoss-User] installing ORACLE JDBC, 


thank you, 
I´ve tried this but still get the same error... 

so any other ideas ?

-r



-Original Message-
From: Todd Bowker [mailto:[EMAIL PROTECTED]]
Sent: 16. mars 2001 17:05
To: JBoss-User
Subject: RE: [jBoss-User] installing ORACLE JDBC, 


The DataSourceClass attribute doesn't look right.
This is how I have mine configured, and I'm also using oracle:

 org.opentools.minerva.jdbc.xa.wrapper.XADataSourc
eImp
l



-Original Message-
From: Reynir Hübner [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 8:54 AM
To: [EMAIL PROTECTED]
Subject: [jBoss-User] installing ORACLE JDBC, 


Hello, 

I´m very new to jBoss and I´m trying to connect jBoss 2.1 to Oracle 8i
with the JDBC thin client.
I´m getting an error like this, and I´m wondering how to understand it: 

[isdb] Starting
[isdb] XA Connection pool isdb bound to java:/isdb
[isdb] Stopped
[isdb] java.lang.NullPointerException
[isdb]  at
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataS
ource.java:165)
... etc

this is what I have in the jboss.jcml file : 

 
   isdb
   oracle.jdbc.xa.client.OracleXADataSource
   jdbc:oracle:thin:@computer.domain.com:1521:isdb
   system
   
 

and I also specify the driver jboss.jcml,
all according to the message :
http://www.mail-archive.com/jboss-user@list.working-dogs.com/msg12921.ht
ml


ok, please tell me what I´m doing wrong. 
regards, 


Reynir Hübner
[EMAIL PROTECTED]







--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]


--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]



--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]


--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]