EAserver - PB10 Components with Oracle JDBC on EAS 5.3.0

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

PB10 Components with Oracle JDBC on EAS 5.3.0

Stephen C.

2005-11-09, 1:24 pm

Hi, there

I have several components running on PB 10.2.0, Oracle 9i
and EAServer 5.3.0 (built 53016) using Oracle OCI connection
cache and they are fine. Recently, I try to upgrade the
connection cache to JDBC for stability reasons. After I've
changed connection cache from OCI to JDBC (Oracle 9i JDBC
thin driver), most components still work, but only one
doesn't. This component (requires new transaction) is
called by a root component (requires transaction) and this
component calls an Oracle stored procedure. I check the
server log, and I find out the some error: syntax error near
sp_xxxx, but the database connection seems OK. If I change
back to connection cache with OCI, everything works fine.
Could somebody help me out or give some suggestions?

P.S. the components were upgraged from PB7 to 10 and
EAServer 4.2 to EAServer 5.3.0.

Many thanks
Stephen C.

Sponsored Links