Cannot insert explicit value for identity column

Classic Servoy
1

Hi guys,

I am having some trouble with MSSQL database…this database is not ours and I cannot alter it’s structure.
There is a table with a PK
mxAppointmentID nchar (newid()) which results in something like this 09ee47f6-b872-4411-8710-82721e8ce3b7

I am using in Servoy the sequence type db identity, which usually fixes the problem…but I am still getting
save failed for 1 or more records
> com.servoy.j2db.dataprocessing.DataException: Cannot insert explicit value for identity column in table ‘Appointments’ when IDENTITY_INSERT is set to OFF.

Does anyone has a clue? Thankx in advance

I am using Version: 5.2.4 - build 1006

2

What if you set the Sequence to ‘None’ and select the ‘Database Default’ option?

3

ROCLASI:
What if you set the Sequence to ‘None’ and select the ‘Database Default’ option?

Unfortunately…that doesn’t work either…
There is also an mxAppointmentNo (not a pk) of the type int identity. I used sequence type db indentity on this column
I have tried all sort of combinations by now. And also used your suggestion…but still Servoy won’t insert a row

4

Could it be that some columnnames are interferring?
there are columnames with these names in this table.
start
end
size
type

5

Tweetie,

Servoy does not have problems with column names that are keyword, they will be quoted in the sql we generate.

The error you get means that Servoy is supplying a value for a column in the sql statement but the db does not allow that.
There are 2 situations that Servoy skips a column in the insert statement:

  1. the column is a db-identity column
  2. the column is marked as ‘database managed’

Have a look at the columns in the table.
The pk should be db-identity (is also seems to be a uuid column, so also check the UUID flag in the table editor for this column)
Mark the other columns that should be skipped in the insert by setting AutoEnter->SystemValue->DatabaseManaged

Rob

6

Thankx for the reply.
But also this seems not to work.

I even made a new form…just created a record…did not touch anything and did a savedata()…it returns false.
the data does noet appear in the db

7

What is the exception in the logs?
maybe now you have some non-nullable fields not entered?

Also look at the failing sql and try to figure out what sql should work, then we can see how to configure Servoy to get the correct sql.

Rob

8

I set the PK to db_identy & flag UUID (mxAppointmentID )
and i set mxAppointmentNo to database managed

I am now getting

save failed for 1 or more records
 > com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.dataprocessing.DataException: Error converting data type nvarchar to numeric. Error converting data type nvarchar to numeric.

There are only 2 non-nullable fields…and those are exactly the columns mentioned above (mxAppointmentID & mxAppointmentNo)

9

Not sure if this will help, but this is error in the servoy log

2011-01-13 18:32:55,095 ERROR [AWT-EventQueue-0] com.servoy.j2db.util.Debug - select top 2 CreationTime, LastModificationTime, IconIndex, , Attachments, Sensitivity, MessageClass, Importance, EntryID, Body, ReminderMinutesBeforeStart, ReminderOverrideDefault, ReminderPlaySound, ReminderSoundFile, ReminderSet, BillingInformation, Mileage, Companies, [Start], [End], BusyStatus, Location, Duration, RecurrenceState, ResponseStatus, ReplyTime, IsRecurring, Organizer, RecurrencePattern, RecurrenceType, Subject, Contacts, mxAppointmentID, LastModificationTimeSQL, SoftDelete, Categories, mxStoreID, mxComplete, mxStatus, mxRegarding, mxCategory, mxJournal, mxPrimaryUser, mxPrimaryCompany, mxPrimaryContact, mxPrimaryOpportunity, mxPrimaryTeam, mxSearchKey, HTMLBody, mxConfirm, mxCompanyID, mxUserID, mxContactID, mxTeamID, [Type], ExtIdentity, CustomerID, Mailbox, AllDayEvent, External_AppointmentID, Label, mxAppointmentNo, RequiredAttendees, OptionalAttendees, Resources, SenderEmailAddress, SenderName, MeetingStatus, TimeZone, TimeZoneID, PatternEndDate from Appointments where mxAppointmentID = ? parameters: [10322 ,type: java.math.BigDecimal]java.sql.SQLException: Error converting data type nvarchar to numeric.
```and

2011-01-13 18:32:55,095 ERROR [AWT-EventQueue-0] com.servoy.j2db.util.Debug - Error executing sql: insert into Appointments (IconIndex, [Size], Attachments, Sensitivity, MessageClass, Importance, EntryID, Body, ReminderMinutesBeforeStart, ReminderOverrideDefault, ReminderPlaySound, ReminderSoundFile, ReminderSet, BillingInformation, Mileage, Companies, [Start], [End], BusyStatus, Location, Duration, RecurrenceState, ResponseStatus, ReplyTime, IsRecurring, Organizer, RecurrencePattern, RecurrenceType, Subject, Contacts, LastModificationTimeSQL, SoftDelete, Categories, mxStoreID, mxComplete, mxStatus, mxRegarding, mxCategory, mxJournal, mxPrimaryUser, mxPrimaryCompany, mxPrimaryContact, mxPrimaryOpportunity, mxPrimaryTeam, mxSearchKey, HTMLBody, mxConfirm, mxCompanyID, mxUserID, mxContactID, mxTeamID, [Type], ExtIdentity, CustomerID, Mailbox, AllDayEvent, External_AppointmentID, Label, RequiredAttendees, OptionalAttendees, Resources, SenderEmailAddress, SenderName, MeetingStatus, TimeZone, TimeZoneID, PatternEndDate) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) select scope_identity() with params: [NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: -7 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 2 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 2005 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: -7 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 2005 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: -7 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: -6 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue]
com.servoy.j2db.dataprocessing.DataException: Error converting data type nvarchar to numeric.

10

Tweetie,

The mxAppointmentID is queried with value 10322 in stead of a uuid value.
Do you know where that value comes from?

Rob

11

rgansevles:
The mxAppointmentID is queried with value 10322 in stead of a uuid value.
Do you know where that value comes from?

It looks like a value from mxAppointmentNo
But I am not putting that value in.

Like I stated before…I made a new form, created a row…and saved it…that’s it.

12

Can you show the sql exception stack trace of the insert?

Rob

13 
2011-01-17 09:53:23,341 ERROR [AWT-EventQueue-0] com.servoy.j2db.util.Debug - Error executing sql: insert into Appointments (IconIndex, [Size], Attachments, Sensitivity, MessageClass, Importance, EntryID, Body, ReminderMinutesBeforeStart, ReminderOverrideDefault, ReminderPlaySound, ReminderSoundFile, ReminderSet, BillingInformation, Mileage, Companies, [Start], [End], BusyStatus, Location, Duration, RecurrenceState, ResponseStatus, ReplyTime, IsRecurring, Organizer, RecurrencePattern, RecurrenceType, Subject, Contacts, LastModificationTimeSQL, SoftDelete, Categories, mxStoreID, mxComplete, mxStatus, mxRegarding, mxCategory, mxJournal, mxPrimaryUser, mxPrimaryCompany, mxPrimaryContact, mxPrimaryOpportunity, mxPrimaryTeam, mxSearchKey, HTMLBody, mxConfirm, mxCompanyID, mxUserID, mxContactID, mxTeamID, [Type], ExtIdentity, CustomerID, Mailbox, AllDayEvent, External_AppointmentID, Label, RequiredAttendees, OptionalAttendees, Resources, SenderEmailAddress, SenderName, MeetingStatus, TimeZone, TimeZoneID, PatternEndDate) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) select scope_identity() with params: [NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: -7 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 2 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 2005 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: -7 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 2005 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: -7 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: -6 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 5 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue]
com.servoy.j2db.dataprocessing.DataException: Error converting data type nvarchar to numeric.
	at com.servoy.j2db.dblayer.Zb.Za(Zb.java:104)
	at com.servoy.j2db.server.Zc.Zo.Za(Zo.java:974)
	at com.servoy.j2db.dataprocessing.Zu.Za(Zu.java:605)
	at com.servoy.j2db.dataprocessing.Zu.performUpdates(Zu.java:917)
	at com.servoy.j2db.dataprocessing.EditRecordList.stopEditing(EditRecordList.java:465)
	at com.servoy.j2db.dataprocessing.EditRecordList.stopEditing(EditRecordList.java:166)
	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_saveData(JSDatabaseManager.java:1707)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:179)
	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:353)
	at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3666)
	at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2680)
	at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:166)
	at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:387)
	at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3127)
	at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:165)
	at com.servoy.j2db.scripting.ScriptEngine.executeFunction(ScriptEngine.java:458)
	at com.servoy.j2db.debug.RemoteDebugScriptEngine.executeFunction(RemoteDebugScriptEngine.java:382)
	at com.servoy.j2db.FormController.executeFunction(FormController.java:3977)
	at com.servoy.j2db.FormController.executeFunction(FormController.java:3865)
	at com.servoy.j2db.FormController.executeFunction(FormController.java:3787)
	at com.servoy.j2db.FormController$ScriptExecuter.executeFunction(FormController.java:3642)
	at com.servoy.j2db.ui.BaseEventExecutor.fireEventCommand(BaseEventExecutor.java:272)
	at com.servoy.j2db.ui.BaseEventExecutor.fireActionCommand(BaseEventExecutor.java:217)
	at com.servoy.j2db.ui.BaseEventExecutor.fireActionCommand(BaseEventExecutor.java:212)
	at com.servoy.j2db.smart.dataui.AbstractScriptButton$2.actionPerformed(AbstractScriptButton.java:826)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
14

Sorry, i meant the sql exception just above or below this one

Rob