I have created a connection to a sql 2005 server and then created a form with 2 fields, Id and Company from the company table. When running this form as smart client or web client i get : > com.servoy.j2db.dataprocessing.DataException: The value is not set for the parameter number 2. What did i wrong and what is parameter number 2? I followed the wiki tutorial video’s for creating my very first form and can’t find a solution on the internet.
Do you have a primary key in your table?
I have the same problems, I try to connect to an mssql database whilst using servoy 6.0.0b2 build 1209.
In the server log I see the following
2011-05-11 15:40 AWT-EventQueue-0 ERROR com.servoy.j2db.util.Debug Throwable
com.servoy.j2db.dataprocessing.DataException: Parameter #2 has not been set.
at com.servoy.j2db.dblayer.Zb.Za(Zb.java:122)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:88)
at com.servoy.j2db.dataprocessing.Zu.Za(Zu.java:421)
at com.servoy.j2db.dataprocessing.Zu.Za(Zu.java:1056)
at com.servoy.j2db.dataprocessing.Zu.performQuery(Zu.java:110)
at com.servoy.j2db.debug.ProfileDataServer.performQuery(ProfileDataServer.java:273)
at com.servoy.j2db.dataprocessing.FoundSet.refreshFromDBInternal(FoundSet.java:382)
at com.servoy.j2db.dataprocessing.FoundSet.browseAll(FoundSet.java:273)
at com.servoy.j2db.dataprocessing.FoundSet.loadAllRecords(FoundSet.java:249)
at com.servoy.j2db.FormController.loadAllRecordsImpl(FormController.java:2154)
at com.servoy.j2db.FormController$3.run(FormController.java:3091)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at com.servoy.j2db.util.SwingHelper.dispatchEvents(SwingHelper.java:153)
at com.servoy.j2db.smart.J2DBClient$23.run(J2DBClient.java:2941)
at java.awt.event.InvocationEvent.dispatch(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)
2011-05-11 15:40 AWT-EventQueue-0 ERROR com.servoy.j2db.util.Debug WITH query AS (select ROW_NUMBER() OVER (order by is_inspection_id asc) as hibernate_row_nr, is_inspection_id from is_inspection ) SELECT * FROM query WHERE hibernate_row_nr BETWEEN ? AND ? parameters: [201 ,type: java.lang.Integer]
java.sql.SQLException: Parameter #2 has not been set.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:635)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:775)
at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.servoy.j2db.Za.Zf.invoke(Zf.java:13)
at $Proxy0.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at com.servoy.j2db.dataprocessing.Zu.Za(Zu.java:758)
at com.servoy.j2db.dataprocessing.Zu.Za(Zu.java:199)
at com.servoy.j2db.dataprocessing.Zu.Za(Zu.java:1056)
at com.servoy.j2db.dataprocessing.Zu.performQuery(Zu.java:110)
at com.servoy.j2db.debug.ProfileDataServer.performQuery(ProfileDataServer.java:273)
at com.servoy.j2db.dataprocessing.FoundSet.refreshFromDBInternal(FoundSet.java:382)
at com.servoy.j2db.dataprocessing.FoundSet.browseAll(FoundSet.java:273)
at com.servoy.j2db.dataprocessing.FoundSet.loadAllRecords(FoundSet.java:249)
at com.servoy.j2db.FormController.loadAllRecordsImpl(FormController.java:2154)
at com.servoy.j2db.FormController$3.run(FormController.java:3091)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at com.servoy.j2db.util.SwingHelper.dispatchEvents(SwingHelper.java:153)
at com.servoy.j2db.smart.J2DBClient$23.run(J2DBClient.java:2941)
at java.awt.event.InvocationEvent.dispatch(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)
I use the same connection settings as I do in 5.2.6 something like
URL : jdbc:jtds:sqlserver://sqld/servoy_v4
Driver net.sourceforge.jtds.jdbc.Driver
Regards,
Peter
Installed version 5.2 and everything is working, thanks Peter.
This is fixed in next Servoy 6 beta.
Rob