>>>
I have built a trigger (see attach) and, when I try to insert a new row that
not satisfy the 1st condition, the error thrown is right (SAP DBTech SQL:
[-30000] Invalid role in trigger: ROLE_INSERT), but if the new row does not
satisfy one of the other conditions, the error thrown is strange
(java.lang.StringIndexOutOfBoundsException: String index out of range: 88
at java.lang.String.<init>(String.java:366)
at java.lang.String.<init>(String.java:411)
at
com.sap.dbtech.util.StructuredBytes.getString(StructuredBytes.java:203)
at
com.sap.dbtech.util.MemIndirection.getString(MemIndirection.java:81)
at
com.sap.dbtech.jdbc.packet.ReplyPacket.getErrorMsg(ReplyPacket.java:200)
<<<
The attachment with the trigger source was missing, but could it be that
you're using STOP (rc) without passing a message text as well? The JDBC
driver should handle this more gracefully. If you did pass a message text,
then an excerpt from the VTrace (http://sapdb.2scale.net/moin.cgi/VTrace)
would be helpful.
Daniel
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
