Home » Developer & Programmer » JDeveloper, Java & XML » Websphere with Oracle 9i
Websphere with Oracle 9i [message #91048] Thu, 07 March 2002 01:14 Go to next message
sulinder singh
Messages: 10
Registered: January 2002
Junior Member
Hi,
We r using websphere with Oracle 9i.
Connection pooling feature is enabled in Websphere
connection is established using Oracle's JDBC Drivers.

The problem is when we do any database manipulation using Oracle stored procedure it gives and error as subtransaction not allowed,The above error comes only when using EJB.

where as the same code works with Oracle 8.1.7.
(WE hv downlaoded the latest jdbc drivers from Oracle technet).

Are there any addiional grants to be given in Oracle for Websphere or any other specific tunning required.?

Can anyone throw some light on this , or gv some specfic links to oracle with websphere.

Thanks a Lot in Advance

Sulinder Singh
Re: Websphere with Oracle 9i [message #91188 is a reply to message #91048] Mon, 20 May 2002 06:26 Go to previous messageGo to next message
A G
Messages: 1
Registered: May 2002
Junior Member
Dear Sulinder,

Can you tell me how you setup your ORACLE datasource in WebSphere?

What did you specify under:
1. URL Prefix - for ORACLE driver definition
2. JNDI name
3. Database name

Thanks!
Re: Websphere with Oracle 9i [message #91202 is a reply to message #91048] Sat, 25 May 2002 19:09 Go to previous messageGo to next message
sulinder singh
Messages: 10
Registered: January 2002
Junior Member
Hi,
Following are the details
1. URL Prefix - for ORACLE driver definition
jdbc:thin:oracle:@Hostname:Port
2. JNDI name
jdbc/<DATASOURCE> - DataSource Created in Webasphere
3. Database name
service name of the database created in oracle

Thanks and Regards

Sulinder Singh
Re: Websphere with Oracle 9i [message #91454 is a reply to message #91048] Fri, 13 September 2002 00:14 Go to previous message
Tushar
Messages: 17
Registered: November 2001
Junior Member
Hi,

I need your help,

How you set the class path for the oracle jdbc driver.

Thanks in advance

Tushar
Previous Topic: Re: Bigger type length than Maximum
Next Topic: Re: sample test questions for OCP exams IZO-501/502/504/505
Goto Forum:
  


Current Time: Sat Jul 24 15:48:17 CDT 2021