• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

neat way to send excpetion back to java

 
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all
We have certain j2ee components (jsp, servlets)
which invoke our stored procedures in Oracle databse
in our plsql code we log the exception in an error log table
. we dont raise it as we dont explicitly have commit & rollback in our stored procs.
if we raise ,the entry in the error log is rolled back
all transaction mgmt is handled by Java.
What i want to acheive is a neat way to communicate the exception bak to JAVA
Rgrds
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Manish,
If your version of Oracle supports it (sorry, I saw no details of your Oracle version in your post), you can use an "autonomous transaction" to insert a row into your log table. Just do a search for "autonomous transaction" at the following Web sites:
http://otn.oracle.com
http://asktom.oracle.com
http://metalink.oracle.com
http://tahiti.oracle.com
http://forums.oracle.com
Good Luck,
Avi.
[ November 20, 2003: Message edited by: Avi Abrami ]
 
manish ahuja
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Avi
Regarding Oracle version , its 817
I have tried pragma autonomous_transaction for logging errors into a error log table & then raise it bak to java
but we are using Weblogic(which is configured in such a way) that any commits, rollbacks or pragma autonomous_transaction i have on the database side , the weblogic throws an error
Rgrds
 
reply
    Bookmark Topic Watch Topic
  • New Topic