LAMW: jMsSqlJDBCConnection can not connect
lazarus / 43-Android

----------------------------------------------------------------------
af0815 · 2021-03-02 20:14

Based on the Demo AppMSSQLJDBCConnectionDemo i want to connect to a
MS-SQLServer.
If i come to the open command, the App is instantly closed without a
message on my testdevice.

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i procedure
TAndroidModule1.jButton3Click(Sender: TObject);begin 
//jAsyncTask1.Execute; 
jMsSqlJDBCConnection1.ServerIP:='192.168.1.xx'; 
jMsSqlJDBCConnection1.UserName:='Looser'; 
jMsSqlJDBCConnection1.Password:='secret'; 
jMsSqlJDBCConnection1.DatabaseName:='testdb';  jEditText1.Text:='1'; 
if jMsSqlJDBCConnection1.Open() then  begin     
jEditText1.Text:='2';      jMsSqlJDBCConnection1.Close();  end  else 
jEditText1.Text:='Sorry... fail to connect...';end; 
With Logcat i found a part of the log with info

QuoteI/System.out(20504): [socket][0] connection
/192.168.1.yy1433;LocalPort=36324(0)
I/System.out(20504): [CDS]connect[/192.168.1.xx:1433] tm:90
D/Posix   (20504): [Posix_connect Debug]Process
org.lamw.applamwproject1 :1433
I/System.out(20504): [socket][/192.168.1.yy:36324] connected
I/System.out(20504): [CDS]rx timeout:0
D/dalvikvm(20504): GC_CONCURRENT freed 784K (6058), 25% free
3135K/4132K, paused 2ms+3ms, total 46ms
D/dalvikvm(20504): WAIT_FOR_CONCURRENT_GC blocked 39ms
I/dalvikvm(20504): Could not find method
org.ietf.jgss.GSSManager.getInstance, referenced from method
net.sourceforge.jtds.jdbc.TdsCore.createGssToken
W/dalvikvm(20504): VFY: unable to resolve static method 3303:
Lorg/ietf/jgss/GSSManager;.getInstance ()Lorg/ietf/jgss/GSSManager;
D/dalvikvm(20504): VFY: replacing opcode 0x71 at 0x0000
I/dalvikvm(20504): Could not find method
org.ietf.jgss.GSSContext.initSecContext, referenced from method
net.sourceforge.jtds.jdbc.TdsCore.sendGssToken
W/dalvikvm(20504): VFY: unable to resolve interface method 3297:
Lorg/ietf/jgss/GSSContext;.initSecContext ([BII)[B
D/dalvikvm(20504): VFY: replacing opcode 0x72 at 0x0008
W/dalvikvm(20504): VFY: unable to resolve exception class 559
(Lorg/ietf/jgss/GSSException;)
W/dalvikvm(20504): VFY: unable to find exception handler at addr 0x4a
W/dalvikvm(20504): VFY:  rejected
Lnet/sourceforge/jtds/jdbc/TdsCore;.sendGssToken ()V
W/dalvikvm(20504): VFY:  rejecting opcode 0x0d at 0x004a
W/dalvikvm(20504): VFY:  rejected
Lnet/sourceforge/jtds/jdbc/TdsCore;.sendGssToken ()V
W/dalvikvm(20504): Verifier rejected class
Lnet/sourceforge/jtds/jdbc/TdsCore;
W/dalvikvm(20504): JNI WARNING: JNI function GetObjectClass called
with exception pending
W/dalvikvm(20504):              in
Lorg/lamw/applamwproject1/Controls;.pOnClick:(JI)V (GetObjectClass)
W/dalvikvm(20504): Pending exception is:
I/dalvikvm(20504): java.lang.VerifyError:
net/sourceforge/jtds/jdbc/TdsCore
I/dalvikvm(20504):    at net.sourceforge.jtds.jdbc.JtdsConnection.<ini
t>(JtdsConnection.java:359)
I/dalvikvm(20504):    at
net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
I/dalvikvm(20504):    at
java.sql.DriverManager.getConnection(DriverManager.java:175)
I/dalvikvm(20504):    at
java.sql.DriverManager.getConnection(DriverManager.java:140)
I/dalvikvm(20504):    at org.lamw.applamwproject1.jMsSqlJDBCConnection
.createConnection(jMsSqlJDBCConnection.java:73)
I/dalvikvm(20504):    at org.lamw.applamwproject1.jMsSqlJDBCConnection
.Open(jMsSqlJDBCConnection.java:82)
I/dalvikvm(20504):    at
org.lamw.applamwproject1.Controls.pOnClick(Native Method)
I/dalvikvm(20504):    at
org.lamw.applamwproject1.jButton$1.onClick(jButton.java:80)
I/dalvikvm(20504):    at
android.view.View.performClick(View.java:4222)
I/dalvikvm(20504):    at
android.view.View$PerformClick.run(View.java:17622)
I/dalvikvm(20504):    at
android.os.Handler.handleCallback(Handler.java:800)
I/dalvikvm(20504):    at
android.os.Handler.dispatchMessage(Handler.java:100)
I/dalvikvm(20504):    at android.os.Looper.loop(Looper.java:194)
I/dalvikvm(20504):    at
android.app.ActivityThread.main(ActivityThread.java:5434)
I/dalvikvm(20504):    at java.lang.reflect.Method.invokeNative(Native
Method)
I/dalvikvm(20504):    at
java.lang.reflect.Method.invoke(Method.java:525)
I/dalvikvm(20504):    at com.android.internal.os.ZygoteInit$MethodAndA
rgsCaller.run(ZygoteInit.java:834)
I/dalvikvm(20504):    at
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:601)
I/dalvikvm(20504):    at dalvik.system.NativeStart.main(Native Method)
I/dalvikvm(20504): "main" prio=5 tid=1 NATIVE
I/dalvikvm(20504):   | group="main" sCount=0 dsCount=0 obj=0x40e9eaa8
self=0x40e8d0d8
I/dalvikvm(20504):   | sysTid=20504 nice=0 sched=0/0 cgrp=apps
handle=1074899084
I/dalvikvm(20504):   | state=R schedstat=( 574480404 114610847 1509 )
utm=41 stm=16 core=2
D/dalvikvm(20504): dump native stack for : main
D/dalvikvm(20504): unwind backtrace
D/dalvikvm(20504): get native symbol
D/dalvikvm(20504): format backtrace line
I/dalvikvm(20504):   #00  pc 000012a0  /system/lib/libcorkscrew.so
(unwind_backtrace_thread+27)
I/dalvikvm(20504):   #01  pc 00061da2  /system/lib/libdvm.so
(dvmDumpNativeStack(DebugOutputTarget const*, int)+53)
I/dalvikvm(20504):   #02  pc 00055558  /system/lib/libdvm.so
(dvmDumpThreadEx(DebugOutputTarget const*, Thread*, bool)+355)
I/dalvikvm(20504):   #03  pc 00055606  /system/lib/libdvm.so
(dvmDumpThread(Thread*, bool)+25)
I/dalvikvm(20504):   #04  pc 0003950a  /system/lib/libdvm.so
I/dalvikvm(20504):   #05  pc 0004186c  /system/lib/libdvm.so
D/dalvikvm(20504): get native done
I/dalvikvm(20504):   at
org.lamw.applamwproject1.Controls.pOnClick(Native Method)
I/dalvikvm(20504):   at
org.lamw.applamwproject1.jButton$1.onClick(jButton.java:80)
I/dalvikvm(20504):   at android.view.View.performClick(View.java:4222)
I/dalvikvm(20504):   at
android.view.View$PerformClick.run(View.java:17622)
I/dalvikvm(20504):   at
android.os.Handler.handleCallback(Handler.java:800)
I/dalvikvm(20504):   at
android.os.Handler.dispatchMessage(Handler.java:100)
I/dalvikvm(20504):   at android.os.Looper.loop(Looper.java:194)
I/dalvikvm(20504):   at
android.app.ActivityThread.main(ActivityThread.java:5434)
I/dalvikvm(20504):   at java.lang.reflect.Method.invokeNative(Native
Method)
I/dalvikvm(20504):   at
java.lang.reflect.Method.invoke(Method.java:525)
I/dalvikvm(20504):   at com.android.internal.os.ZygoteInit$MethodAndAr
gsCaller.run(ZygoteInit.java:834)
I/dalvikvm(20504):   at
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:601)
I/dalvikvm(20504):   at dalvik.system.NativeStart.main(Native Method)
I/dalvikvm(20504):
E/dalvikvm(20504): VM aborting
F/libc    (20504): Fatal signal 11 (SIGSEGV) at 0xdeadd00d (code=1),
thread 20504 (applamwproject1)
D/AEE/AED (  131): $===AEE===AEE===AEE===$
D/AEE/AED (  131): p 0 poll events 1 revents 0
D/AEE/AED (  131): not know revents:0
D/AEE/AED (  131): p 1 poll events 1 revents 0
D/AEE/AED (  131): not know revents:0
D/AEE/AED (  131): p 2 poll events 1 revents 1
D/AEE/AED (  131): aed_main_fork_worker: generator 0x3c168, worker
0xbe8d39e8, recv_fd 15
D/AEE/AED (  131): p 3 poll events 1 revents 0
D/AEE/AED (  131): not know revents:0
D/AEE/AED (  131): p 4 poll events 1 revents 0
D/AEE/AED (  131): not know revents:0
I/DEBUG   (20661): handle_request(15)
I/DEBUG   (20661): check process 20504 name:applamwproject1
I/DEBUG   (20661): BOOM: pid=20504 uid=10066 gid=10066 tid=20504
I/DEBUG   (20661): [OnPurpose Redunant in preset_info] pid: 20504,
tid: 20504, name: applamwproject1  >>> org.lamw.applamwproject1 <<<
I/SurfaceTextureClient(  646): [STC::queueBuffer] (this:0x5e3678b8)
fps:1.00, dur:1001.97, max:1001.97, min:1001.97
I/BufferQueue(  137): [StatusBar](this:0x424103a8,api:1) [queue]
fps:1.00, dur:1002.05, max:1002.05, min:1002.05
I/DEBUG   (20661): *** *** *** *** *** *** *** *** *** *** *** *** ***
*** *** ***
I/DEBUG   (20661): Build fingerprint:
'TCT/ALCATEL_ONE_TOUCH_7041D/YARISXL:4.2.2/JDQ39/vASF-0:user/release-
keys'
I/DEBUG   (20661): pid: 20504, tid: 20504, name: applamwproject1  >>>
org.lamw.applamwproject1 <<<
I/DEBUG   (20661): signal 11 (SIGSEGV), code 1 (SEGV_MAPERR), fault
addr deadd00d
I/BufferQueue(  137): [StatusBar](this:0x424103a8,api:1) [release]
fps:1.00, dur:1001.78, max:1001.78, min:1001.78
I/SurfaceTextureClient(  137): [STC::queueBuffer] (this:0x416ff9e0)
fps:3.45, dur:1160.06, max:369.92, min:157.99
I/BufferQueue(  137): [FramebufferSurface](this:0x41841008,api:1)
[release] fps:3.45, dur:1160.05, max:369.99, min:157.92
I/BufferQueue(  137): [FramebufferSurface](this:0x41841008,api:1)
[queue] fps:3.45, dur:1160.03, max:370.04, min:157.85
I/SurfaceFlinger(  137): [SurfaceFlinger]
fps:3.448151,dur:1160.04,max:370.11,min:157.80
I/DEBUG   (20661):     r0 00000000  r1 00000000  r2 deadd00d  r3
00000000
I/DEBUG   (20661):     r4 40a0d850  r5 0000020c  r6 1d200232  r7
00000001
I/DEBUG   (20661):     r8 bea13414  r9 56deed94  sl 40e8d0e8  fp
bea13254
I/DEBUG   (20661):     ip 00004000  sp bea12f28  lr 4014a77c  pc
409967f8  cpsr 60000030
I/DEBUG   (20661):
I/DEBUG   (20661): backtrace:
I/DEBUG   (20661):     #00  pc 000467f8  /system/lib/libdvm.so
(dvmAbort+75)
I/DEBUG   (20661):     #01  pc 0004186d  /system/lib/libdvm.so
I/DEBUG   (20661):     #02  pc 00040f54  /data/app-
lib/org.lamw.applamwproject1-2/libcontrols.so
I/DEBUG   (20661):
I/DEBUG   (20661): stack:
I/DEBUG   (20661):          bea12ee8  00000001 
I/DEBUG   (20661):          bea12eec  4018cd8c 
I/DEBUG   (20661):          bea12ef0  4018cd8c 
I/DEBUG   (20661):          bea12ef4  40189178  /system/lib/libc.so
I/DEBUG   (20661):          bea12ef8  4018cd8c 
I/DEBUG   (20661):          bea12efc  4014a77c  /system/lib/libc.so
(__sflush_locked+60)
I/DEBUG   (20661):          bea12f00  401891cc  /system/lib/libc.so
I/DEBUG   (20661):          bea12f04  ffffffff 
I/DEBUG   (20661):          bea12f08  00000000 
I/DEBUG   (20661):          bea12f0c  4014c3c0  /system/lib/libc.so
(_fwalk+64)
I/DEBUG   (20661):          bea12f10  40a0d850  /system/lib/libdvm.so
I/DEBUG   (20661):          bea12f14  0000020c 
I/DEBUG   (20661):          bea12f18  1d200232 
I/DEBUG   (20661):          bea12f1c  00000001 
I/DEBUG   (20661):          bea12f20  df0027ad 
I/DEBUG   (20661):          bea12f24  00000000 
I/DEBUG   (20661):     #00  bea12f28  58ce5d22 
/system/framework/framework.odex
I/DEBUG   (20661):          bea12f2c  6c756e28 
I/DEBUG   (20661):          bea12f30  0000296c 
I/DEBUG   (20661):          bea12f34  00000000 
I/DEBUG   (20661):          bea12f38  00000000 
I/DEBUG   (20661):          bea12f3c  00000000 
I/DEBUG   (20661):          bea12f40  00000000 
I/DEBUG   (20661):          bea12f44  00000000 
I/DEBUG   (20661):          bea12f48  00000000 
I/DEBUG   (20661):          bea12f4c  00000000 
I/DEBUG   (20661):          bea12f50  00000000 
I/DEBUG   (20661):          bea12f54  00000000 
I/DEBUG   (20661):          bea12f58  00000000 
I/DEBUG   (20661):          bea12f5c  00000000 
I/DEBUG   (20661):          bea12f60  00000000 
I/DEBUG   (20661):          bea12f64  00000000 
I/DEBUG   (20661):          ........  ........
I/DEBUG   (20661):     #01  bea13140  6d90001d 
I/DEBUG   (20661):          bea13144  40e8d0d8 
I/DEBUG   (20661):          bea13148  bea1318c  [stack]
I/DEBUG   (20661):          bea1314c  40e76228 
I/DEBUG   (20661):          bea13150  40a02db0  /system/lib/libdvm.so
I/DEBUG   (20661):          bea13154  00000000 
I/DEBUG   (20661):          bea13158  409ec401  /system/lib/libdvm.so
I/DEBUG   (20661):          bea1315c  4098a88d  /system/lib/libdvm.so
I/DEBUG   (20661):          bea13160  00000000 
I/DEBUG   (20661):          bea13164  5d62ad10  /data/app-
lib/org.lamw.applamwproject1-2/libcontrols.so
I/DEBUG   (20661):          bea13168  5d62ad10  /data/app-
lib/org.lamw.applamwproject1-2/libcontrols.so
I/DEBUG   (20661):          bea1316c  00000000 
I/DEBUG   (20661):          bea13170  56deeda0 
I/DEBUG   (20661):          bea13174  5d5d7f58  /data/app-
lib/org.lamw.applamwproject1-2/libcontrols.so
I/DEBUG   (20661):     #02  bea13178  40a0d850  /system/lib/libdvm.so
I/DEBUG   (20661):          bea1317c  4018c210 
I/DEBUG   (20661):          bea13180  00000000 
I/DEBUG   (20661):          bea13184  5d6758a0 
I/DEBUG   (20661):          bea13188  00000000 
I/DEBUG   (20661):          bea1318c  5d6758a0 
I/DEBUG   (20661):          bea13190  00000000 
I/DEBUG   (20661):          bea13194  00000000 
I/DEBUG   (20661):          bea13198  00000000 
I/DEBUG   (20661):          bea1319c  00000000 
I/DEBUG   (20661):          bea131a0  00000000 
I/DEBUG   (20661):          bea131a4  00000000 
I/DEBUG   (20661):          bea131a8  00000000 
I/DEBUG   (20661):          bea131ac  00000000 
I/DEBUG   (20661):          bea131b0  00000000 
Anyy hint ?

----------------------------------------------------------------------
jmpessoa · 2021-03-03 00:29

The core error is here:

QuoteW/dalvikvm(20504): Pending exception is:
I/dalvikvm(20504): java.lang.VerifyError:
net/sourceforge/jtds/jdbc/TdsCore
I/dalvikvm(20504):    at net.sourceforge.jtds.jdbc.JtdsConnection.<ini
t>(JtdsConnection.java:359)
I/dalvikvm(20504):    at
net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
I/dalvikvm(20504):    at
java.sql.DriverManager.getConnection(DriverManager.java:175)
I/dalvikvm(20504):    at
java.sql.DriverManager.getConnection(DriverManager.java:140)

I/dalvikvm(20504):    at org.lamw.applamwproject1.jMsSqlJDBCConnection
.createConnection(jMsSqlJDBCConnection.java:73)

I/dalvikvm(20504):    at org.lamw.applamwproject1.jMsSqlJDBCConnection
.Open(jMsSqlJDBCConnection.java:82)

I will verify LAMW template "jMsSqlJDBCConnection.java" lines 73 and
82

----------------------------------------------------------------------
af0815 · 2021-03-07 18:32

I have done more tests, with a newer device  connect, select and
delete ist working.

So i think the connection have to be Android 6 or better.

Newer Device: Samsung S5 duos SM-G900FD Android 6.0.1
Older : Alcatel One Touch 7041D Android 4.2.2