Eclipse Community Forums: Eclipse Scout » AbstractDateTimeField with Milliseconds

Home » Eclipse Projects » Eclipse Scout » AbstractDateTimeField with Milliseconds

AbstractDateTimeField with Milliseconds [message #1851521]

Thu, 07 April 2022 07:14

Eclipse User

Hi,

we are using a DateTime Field within a form which has its corresponding column in a DB table. We could not figure out, how we can use also milliseconds. If we put current date into this formfield, the milliseconds are still there, but using the SQL.insert the milliseconds will be cut off. Looking at the plain text of the insert statement the value of field looks like

to_date('07.04.2022 12:52:43','dd.mm.yyyy hh24:mi:ss')

There are no milliseconds. Can somebody give a hint how milliseconds can reach the DB table?

Thanks

Re: AbstractDateTimeField with Milliseconds [message #1851522 is a reply to message #1851521]

Thu, 07 April 2022 07:24

Eclipse User

Thank you for your post.

What version of scout are you using?
What database type is it? postgres, oracle, db2?

With that info I can quickly help you

Re: AbstractDateTimeField with Milliseconds [message #1851523 is a reply to message #1851522]

Thu, 07 April 2022 07:31

Eclipse User

I am using Scout 2021.1202-1200 and MariaDB 10.3

Re: AbstractDateTimeField with Milliseconds [message #1851525 is a reply to message #1851523]

Thu, 07 April 2022 08:02

Eclipse User

Thanks. One last question, is it the ISqlService and SQL class you are using for database access?
Which implementation for ISqlService for mario db?

Re: AbstractDateTimeField with Milliseconds [message #1851529 is a reply to message #1851525]

Thu, 07 April 2022 10:35

Eclipse User

We are using
<dependency>
<groupId>org.eclipse.scout.rt</groupId>
<artifactId>org.eclipse.scout.rt.server.jdbc</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.22</version>
</dependency>

Re: AbstractDateTimeField with Milliseconds [message #1851548 is a reply to message #1851529]

Fri, 08 April 2022 03:53

Eclipse User

Thanks.
Date/Time parsing is in DateField.js
The format used is in the (DateTimeField)getConfiguredFormat() method that you (could) overwrite.

But the main caveat may be here:
MySql (same witrh oracle and postgres) use baseic JDBC specification which in turn uses the standard java.sql.Timestamp class to transfer datetime values between the database and the java code.
The java.sql.Timestamp class only uses precision up to second. It contains a seperate field for nanos but this field is not so far supported by database implementors.

So if you really need milliseconds in the field then either use a proprietary sql java class for MySql (does that exist?) or switch to the database type for java.lang.Long and store the Date.getTime() UTC millisecond value.

Does this help further?

Re: AbstractDateTimeField with Milliseconds [message #1851560 is a reply to message #1851548]

Fri, 08 April 2022 09:12

Eclipse User

thanks Ivan. Thank you for the clarification. at least it creates clarity!!!

Previous Topic:	Get data for form from database
Next Topic:	How can I execute a scout service using a URL

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Sep 16 00:07:10 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter