File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

neat way to send excpetion back to java

 
manish ahuja
Ranch Hand
Posts: 312
  • 0
  • Mark post as helpful
  • send pies
  • 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
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • 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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic