Using 3.5 on WinXP with ASA 10.
Quite often during development, after Servoy runs into a bug in my code (such as ‘cannot convert null to object’) the next time I show a form I get a ‘Cannot load form data’ error and under details it says ‘Login Failed’ and I have to restart Servoy to get things right again. Closing and opening the solution doesn’t fix it, and nor does logging out and back in.
Any way to avoid this Login Failed error? Thanks.
Please file a support case with an sample of your bad code…since it seems to enter an illegal state
I have more information on this. I hope you don’t mind if I continue the discussion here rather than submit a support case - I think others could benefit from the discussion.
The problem is happening when I do something illegal that causes an error in Sybase. For example, I had a stored datetime calc that was calculating wrong and it caused this error to appear in the servoy_log:
2008-08-20 14:33:54,578 ERROR [AWT-EventQueue-0] com.servoy.j2db.util.Debug - Throwable
java.sql.SQLException: JZ0SU: A Date or Timestamp parameter was set with a year of 195118, but the server can only support year values between 1753 and 9999. If you’re trying to send data to date or timestamp columns or parameters on Adaptive Server Anywhere, you may wish to send your data as Strings, and let the server convert them.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
at com.sybase.jdbc3.tds.TdsParam.a(Unknown Source)
at com.sybase.jdbc3.tds.TdsParam.prepareForSend(Unknown Source)
at com.sybase.jdbc3.jdbc.ParamManager.checkParams(Unknown Source)
at com.sybase.jdbc3.tds.Tds.language(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.sendQuery(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.sendQuery(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeUpdate(Unknown Source)
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 com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
at $Proxy1.executeUpdate(Unknown Source)
at
Once this happens, I get a ‘Cannot load form data’ and ‘Login Failed’ and I have to restart Servoy. How can I get it to handle this kind of error without having to restart?
I wonder are you using a transaction during this error?
what kind of connection validation are you using?
Can you file a support case with small sample solution demonstrating this perhaps?
No transaction involved.
I am using Exception Validation.
I submitted sample solution with case 155887