B4J Question sql.AddNonQueryToBatch Error

micro

Well-Known Member
Licensed User
Longtime User
Hi to all
For write table in mysql with csv file i use this code, bat i fail.
B4X:
Dim items() As String
Dim table as List
table.Initialize
table = su.LoadCSV("/mnt/usb/", namef, ";")
Dim sql As SQL = pool.GetConnection
For i = 0 To table.Size -1
    items = table.Get(i)
    sql.AddNonQueryToBatch("INSERT INTO FORMATO VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)", Array As Object(Null, items(1).Trim, items(2).Trim, items(3).Trim, items(4).Trim, items(5).Trim, items(6).Trim, items(7).Trim, items(8).Trim, items(9).Trim, items(10).Trim, items(11).Trim, items(12).Trim)) '<-Error
the last line of code causes this error:
B4X:
Error occurred on line: 2217
java.lang.NullPointerException
    at anywheresoftware.b4j.objects.SQL.AddNonQueryToBatch(SQL.java:224)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at anywheresoftware.b4a.shell.Shell.runVoidMethod(Shell.java:657)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:234)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:159)
    at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:90)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:93)
    at anywheresoftware.b4a.BA$1.run(BA.java:215)
    at com.sun.javafx.application.PlatformImpl.lambda$null$5(Platform
Impl.java:295)
    at java.security.AccessController.doPrivileged(Native Method)
    at com.sun.javafx.application.PlatformImpl.lambda$runLater$6(PlatformImpl.java:294)
    at com.sun.glass.ui.monocle.RunnableProcessor.runLoop(RunnableProcessor.java:92)
    at com.sun.glass.ui.monocle.RunnableProcessor.run(RunnableProcessor.java:51)
    at java.lang.Thread.run(Thread.java:745)

I do not understand where I'm wrong, the INSERT syntax is correct.
Thanks
 

EnriqueGonzalez

Well-Known Member
Licensed User
Longtime User
It seems that you are mixing a non ui with a ui project.

ConnectionPool is part of the jserver library and can only be used with non ui projects.
 
Upvote 0

jmon

Well-Known Member
Licensed User
Longtime User
Upvote 0
Top