Errormessage: invalid cursor state in the Pizza Mario app

2
Hi there, I'm completely new to Mendix, so forgive me if my questions are a little bit simple. I just installed Mendix because I have to get familliar with it. After installing I (down)loaded the Pizza Mario example application. Nou when I try to run it it throws an error: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty Now, I understand it has something to do with upgrading the datamodel, but I have no clue where to start to resolve this. Can I solve this manually? If so, how? I installed Mendix on Windows 7 x 64. I also had to install JDK, which I did. Can anyone help and put me in the right direction. TIA Oh, and BTW I have seen this message on this forum, but no solution to it. At least not for me.
asked
3 answers
5

No question is too simple, we attempt to make the modeler moron proof so if you run into any issues, feel free to ask away :)

That being said, you should obviously not be getting this error message. It looks as if you set your environment up correctly (.NET, JDK etc).

What type of database have you configured in the modeler? (it's under projects, settings somewhere if I'm not mistaken)

In case you're using HSQLDB (built-in), this sometimes happens when changing the domain model. You can easily fix it by deleting your database (it's under <deploymentdirectory>/deployment/data/database/

answered
4

Hi Michel and Achiel,

you both suggested deleting the development database in (Pizza Mario\deployment\data\database). This solved my problem.

Everything is running fine now.

Thanks for the help.

answered
2

Hi Achiel,

thanks for the reply. So I am a moron now? ;) Mosts starts are difficult ;)

First I want to mention when I installed the modeler and tried to run it, it threw the message I described above (at the end I will insert all the text of the error). The only thing I changed was the path to Jave in the settings. Now as for your question, I have checked in [Project settings] tab [Databases]. The type used is "Build-in database". Configuration "Development".

Thanks for the help.

Complete error message:

Blockquote

Blockquote> runtime.start() should not throw anything other than AdminException! at lr.execute(SourceFile:62) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:84) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:550) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:662) Caused by: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty at w.b(SourceFile:912) at w.b(SourceFile:830) at w.b(SourceFile:233) at w.a(SourceFile:74) at fo.b(SourceFile:179) at fo.a(SourceFile:153) at iX.b(SourceFile:129) at com.mendix.core.MxRuntime.G(SourceFile:450) at com.mendix.core.MxRuntime.a(SourceFile:221) at lr.execute(SourceFile:54) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:84) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:550) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:662) Caused by: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCResultSet.getCurrent(Unknown Source) at org.hsqldb.jdbc.JDBCResultSet.getColumnInType(Unknown Source) at org.hsqldb.jdbc.JDBCResultSet.getLong(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.getLong(DelegatingResultSet.java:228) at org.apache.commons.dbcp.DelegatingResultSet.getLong(DelegatingResultSet.java:228) at w.b(SourceFile:908) at w.b(SourceFile:830) at w.b(SourceFile:233) at w.a(SourceFile:74) at fo.b(SourceFile:179) at fo.a(SourceFile:153) at iX.b(SourceFile:129) at com.mendix.core.MxRuntime.G(SourceFile:450) at com.mendix.core.MxRuntime.a(SourceFile:221) at lr.execute(SourceFile:54) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:84) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:550) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:662) Caused by: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCResultSet.getCurrent(Unknown Source) at org.hsqldb.jdbc.JDBCResultSet.getColumnInType(Unknown Source) at org.hsqldb.jdbc.JDBCResultSet.getLong(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.getLong(DelegatingResultSet.java:228) at org.apache.commons.dbcp.DelegatingResultSet.getLong(DelegatingResultSet.java:228) at w.b(SourceFile:908) at w.b(SourceFile:830) at w.b(SourceFile:233) at w.a(SourceFile:74) at fo.b(SourceFile:179) at fo.a(SourceFile:153) at iX.b(SourceFile:129) at com.mendix.core.MxRuntime.G(SourceFile:450) at com.mendix.core.MxRuntime.a(SourceFile:221) at lr.execute(SourceFile:54) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:84) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:550) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:662) Blockquote

Blockquote

answered