Oracle 10g Date, Servoy Datetime

Classic Servoy
1

Hallo,

I have a problem with oracle and datatype datetime.

In oracle I use the datatype ‘date’, in servoy I have a datetime field.

Both datatypes contain both the date and time.

But when I read, for example, the date (orale) ‘2005-10-10 11:10:10’ from the db I get the value ‘2005-10-10 00:00:00’ in servoy.

When I insert a value via servoy in the db only the date is inserted without the time.

First I thought the oracle-jdbc-driver was the problem.

I have, however, tested the problem with Kodo’s jdo implementation using the oracle-jdbc-driver, and there were no problems. This leads me to believe that servoy handles the oracle types incorrectly.

I also have the same problems when the field in Oracle is a timestamp, which is even more confusing.

Tobias Wahmhoff
eFonds24 GmbH

Oracle 10g
Servoy Developer
Version R2 2.1.2-build 315
Java version 1.4.2_01-b06 (Windows XP)

2

that is because we are following the JDBC spec. If the database is saying Types.DATE then we do ResultSet.getDate() and that goes wrong

We now fixed it so that we always are calling getTimeStamp
hopefully all other jdbc drivers are handling that.

3

Hello!

Superb. When will this fix be available? Will it be there in the next
beta build for 2.2?

Thank you,
Michael Wirz

eFonds24 GmbH

4

yes it’s available in 2.2rc1 that you can download through autoupdate.