hi, i make the following query:
Select * from Table;
I have a blob, string and date.
in JRDC2 throw me this:
in in the app this:
look in all the forum but I do not find something clear regarding getting simple DATE
also edit this code config.properties:
Select * from Table;
I have a blob, string and date.
in JRDC2 throw me this:
B4X:
(RuntimeException) java.lang.RuntimeException: Cannot serialize object: 2017-09-03in in the app this:
B4X:
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
B4X:
Sub cargar
ProgressDialogHide
Dim cmd As DBCommand
cmd.Initialize
cmd.Name = "select"
reqManager.ExecuteQuery(cmd, 0, "select")
a = cmd.Name
End Sub
B4X:
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,"")
Nextalso edit this code config.properties:
B4X:
JdbcUrl=jdbc:mysql://localhost/dbventaskiana?zeroDateTimeBehavior=convertToNull
Last edited: