Sql exceptionUnique Constraint violation on WebLogic 6.1
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   pushp_ABROL
Posted On:   Monday, July 28, 2003 09:36 AM

Encountered a Oracle exception due to unique constraint violation. Corrected the sequence to solve the problem but the server logs still keep showing the same exception and exception still keeps occuring. If I to insert records into the same table using sql prompt it works but via the application using the same sql it does not work. Is there a caching of sql exception in the server . Weblogic is using JDBC connection pool for connection pool. What could be the cause of this error and what is the solution?

Re: Sql exceptionUnique Constraint violation on WebLogic 6.1

Posted By:   Christopher_Koenigsberg  
Posted On:   Monday, July 28, 2003 12:07 PM

Actually the problem could even be cacheing of the sequence values, not cacheing of exceptions.... make sure your sequences are created with no cacheing ("NOCACHE").

About | Sitemap | Contact