Android Question B4J server: RuntimeException

[driesvp]

When trying to execute this query

(SELECT tblAppVersies.AppID, tblAppVersies.AppNaam FROM tblAppGeinstalleerd INNER JOIN tblAppVersies ON tblAppGeinstalleerd.AppID = tblAppVersies.AppID WHERE (([tblappversies].[appversie]-[tblappgeinstalleerd].[appversie])>0 AND tblAppGeinstalleerd.DeviceID= ?)

I receive an error:

(RuntimeException) java.lang.RuntimeException: unsupported internal operation: Type

Is this query to complex?

 

[Erel]

Can you post the full error message from the logs (you might need to remove the Try / Catch block)?

Are you using SQLite?

 

[driesvp]

Hello,

I'm using the ucanaccess driver for ms access.

Error occurred on line: 78 (send).
net.ucanaccess.jdbc.UcanaccessSQLException: java.lang.RuntimeException: unsupported internal operation: Type java.lang.RuntimeException: unsupported internal operation: Type
    at net.ucanaccess.jdbc.UcanaccessPreparedStatement.executeQuery(UcanaccessPreparedStatement.java:86)
    at anywheresoftware.b4j.objects.SQL.ExecQuery2(SQL.java:249)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:563)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:221)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:156)
    at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:93)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:82)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:84)
    at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:115)
    at com.sun.javafx.application.PlatformImpl$4$1.run(PlatformImpl.java:182)
    at com.sun.javafx.application.PlatformImpl$4$1.run(PlatformImpl.java:179)
    at java.security.AccessController.doPrivileged(Native Method)
    at com.sun.javafx.application.PlatformImpl$4.run(PlatformImpl.java:179)
    at com.sun.glass.ui.InvokeLaterDispatcher$Future.run(InvokeLaterDispatcher.java:76)
    at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
    at com.sun.glass.ui.win.WinApplication.access$100(WinApplication.java:17)
    at com.sun.glass.ui.win.WinApplication$3$1.run(WinApplication.java:67)
    at java.lang.Thread.run(Thread.java:745)

 

[Erel]

Looks like you are doing something that is not supported by this Jdbc driver.

 

[driesvp]

Ok, has probably something to do with the subtraction I added to the query. I found a work around for this subtraction, problem solved in a way.

Thanks for your help!