B4J Question sql.AddNonQueryToBatch Error

[micro]

Hi to all
For write table in mysql with csv file i use this code, bat i fail.

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:

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]

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.

 

[keirS]

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.

Not so. Erel has advised to use ConnectionPool in UI projects on several occasions.

 

[Erel]

jSQL v1.51 is attached. It should fix this issue.

 

[micro]

jSQL v1.51 is attached. It should fix this issue.

Thanks Erel, now works well.

 

[jmon]

It should fix this issue.

Thanks a lot! I was pulling my hairs trying to understand where I left a null object!

 

[inakigarm]

Thanks a lot! I was pulling my hairs trying to understand where I left a null object!

Me too ! (Tried this command yesterday in a new app)