Android Question RDCJ2 Get date MSQL

[luisro]

hi, i make the following query:

Select * from Table;

I have a blob, string and date.

in JRDC2 throw me this:

(RuntimeException) java.lang.RuntimeException: Cannot serialize object: 2017-09-03

in in the app this:

ResponseError. Reason: java.lang.RuntimeException: Cannot serialize object: 2017-09-03, Response: <html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
<title>Error 500 </title>
</head>
<body>
<h2>HTTP ERROR: 500</h2>
<p>Problem accessing /rdc. Reason:
<pre>    java.lang.RuntimeException: Cannot serialize object: 2017-09-03</pre></p>
<hr /><a href="http://eclipse.org/jetty">Powered by Jetty:// 9.3.z-SNAPSHOT</a><hr/>
</body>
</html>
Error: <html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
<title>Error 500 </title>
</head>
<body>
<h2>HTTP ERROR: 500</h2>
<p>Problem accessing /rdc. Reason:
<pre>    java.lang.RuntimeException: Cannot serialize object: 2017-09-03</pre></p>
<hr /><a href="http://eclipse.org/jetty">Powered by Jetty:// 9.3.z-SNAPSHOT</a><hr/>
</body>
</html>

look in all the forum but I do not find something clear regarding getting simple DATE

Sub cargar
ProgressDialogHide
Dim cmd As DBCommand
cmd.Initialize
cmd.Name = "select"
reqManager.ExecuteQuery(cmd, 0, "select")
a = cmd.Name
End Sub

Case "select"
            Dim result As DBResult = reqManager.HandleJob(job)
            For Each records() As Object In result.Rows
                Dim a8 As String
                a8 = records(result.Columns.get("fecha"))
                DateTime.DateFormat = "dd-MM-yyyy"
                Label13.Text = DateTime.Date(a8)
                clv1.Add(p,p.Height,"")
            Next

also edit this code config.properties:

JdbcUrl=jdbc:mysql://localhost/dbventaskiana?zeroDateTimeBehavior=convertToNull

 

[azzam223]

the problem is in date column you must change it type To date instead of datetime

 

[luisro]

Hi, sorry but I did not understand where I have to change the type? do you tell me in the database to change from Date to DateTime?

 

[azzam223]

i mean change the type of date column in database To date only not datetime

 

[luisro]

solved.

in config.properties, instead of:

sql.select=Select * from Table;

Use:

sql.select= SELECT `dat1`,`dat2`, DATE_FORMAT((date),'%d %m %Y') as 'date' FROM `Table`;

formatting the query directly to the date.

thanks for your help.

 

[azzam223]

Your welcome