troubleshooting Question

cachedRowSet SQLException

Avatar of dboyd6868
dboyd6868 asked on
19 Comments1 Solution1029 ViewsLast Modified:
Hey all,

I know i have asked this question in this forum before but i kinda of need a soultion so though i would see if some fresh eyes would know.

I am using a cachedRowSet

And I am just wondering when I execute an acceptChanges(con) command that causes a jdbc error to occur e.g insert nulls into columns that don’t allow nulls.

Is there any way to get the jdbc error message?

I get this exception printed to the command line by the cachedRowSetImp

java.sql.SQLException: Cannot insert the value NULL into column ‘ratio’, table 'Tuning.dbo.PROPERTY'; column does not allow nulls. INSERT fails.

And this exception thrown

javax.sql.rowset.spi.SyncProviderException: 5 conflicts while synchronizing

I really want to catch the first exception or at least be able to get the errorCode /error message

Does anyone know if is/is not possible to get this error because from what I have seen it is not possible

if there is no soultion which i assume there isn't as i have looked. I am wondering if another imp of cached row set would be ok

anyone have any other impl of cachedRowSet that they know works?

I am using Suns java 5 update 6 version
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 19 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 19 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros