Android Question JRDC2 error

[marcick]

I'm trying to move my code from JRDC to JRDC2 but now I get an error on the server when I use ExecuteQuery2 from the client.
The line in JRDC2 that generate the error is this

Dim data() As Byte = ser.ConvertObjectToBytes(res)

And the error is:

java.lang.RuntimeException: java.lang.RuntimeException: Cannot serialize object: 2015-12-0412:07:08.0

Any hint ?

 

[b4auser1]

Check this:

Due to the usage of B4XSerializator with other platforms, the two types should be declared in the main module:

Sub Process_Globals
   Dim reqManager As DBRequestManager
   Type DBResult (Tag As Object, Columns As Map, Rows As List)
   Type DBCommand (Name As String, Parameters() As Object)
End Sub

 

[marcick]

Thank you but, yes, it is.
The error appears also in the original JRDC2 source code

 

[Erel]

Seems like it is failing with a date data type. What are the columns types?

 

[marcick]

that error I suppose is related to a column Timestamp or DateTime (I have both types in the MySQL db)

 

[Erel]

You need to convert it to string in the query. For example: http://stackoverflow.com/questions/2392413/convert-datetime-value-into-string-in-mysql

 

[marcick]

Uhmm... Not clear exactly what to do and where...

 

[Erel]

Can you post the query that you are running (from the config file)?

 

[marcick]

sql.RDC_Sync = SELECT * FROM `records` WHERE (( `Pwd` = ? OR `Pwd` = ?) AND `Index` > ? AND `Device` NOT LIKE ?)

 

[Erel]

You need to replace * with the column names and explicitly convert the datetime columns to a string:

sql.RDC_Sync = SELECT col1, col2, DATE_FORMAT(col3,'%d %m %Y'), col4, DATE_FORMAT(col5,'%d %m %Y') FROM `records` ...

 

[marcick]

something is changing but have other errors and need to understand better tomorrow.
I have a bigint(20) column also. Could it create problems in serializator ?

 

[Erel]

You need to post the error messages...

 

[marcick]

Solved. The problem was that using "DATE_FORMAT(sdate,'%d %m %Y')" the column name that is returned to the client is not "sdate" but "DATE_FORMAT(col3,'%d %m %Y')" ....

So I have modified the query using "AS"

DATE_FORMAT("sdate",'%d %m %Y') AS "sdate"

Everything seems to works fine now.
This foum is better than a school.
Thanks again !