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