Android Question B4J server: RuntimeException

D

driesvp

Member
Licensed User
Longtime User
When trying to execute this query
B4X: 
(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:
B4X: 
(RuntimeException) java.lang.RuntimeException: unsupported internal operation: Type

Is this query to complex?
 
Sort by date Sort by votes
D

driesvp

Member
Licensed User
Longtime User
Hello,

I'm using the ucanaccess driver for ms access.

B4X: 
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)
 
Upvote 0
D

driesvp

Member
Licensed User
Longtime User
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!
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question Prefs App change: java.lang.RuntimeException: Unable to create service xxx.starter:
Replies
5
Views
636
Erel
A
  • Question
Android Question java.lang.RuntimeException: android.app.MissingForegroundServiceTypeException: Starting FGS without a type
Replies
6
Views
1K
Erel
N
  • Question
Android Question java.lang.RuntimeException: java.net.SocketException: Socket closed
Replies
1
Views
641
Erel
  • Solved
Other Google Play Console: java.lang.RuntimeException
Replies
2
Views
850
Sergio Haurat
Y
  • Question
Android Question Error java.lang.RuntimeException: Stub!
Replies
1
Views
4K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…