OraFAQ Forum: JDeveloper, Java & XML » Websphere with Oracle 9i

Home » Developer & Programmer » JDeveloper, Java & XML » Websphere with Oracle 9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Websphere with Oracle 9i [message #91048]

Thu, 07 March 2002 01:14

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

Report message to a moderator

Re: Websphere with Oracle 9i [message #91188 is a reply to message #91048]

Mon, 20 May 2002 06:26

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!

Report message to a moderator

Re: Websphere with Oracle 9i [message #91202 is a reply to message #91048]

Sat, 25 May 2002 19:09

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

Report message to a moderator

Re: Websphere with Oracle 9i [message #91454 is a reply to message #91048]

Fri, 13 September 2002 00:14

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 14 07:53:15 CDT 2026