nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to stop Active Objects to automatically convert TIME field to TIMESTAMP?

smhf97

Hi everyone,

I defined a simple AO entity called TimePeriod that has two java.sql.Time fields, one for start of the period and one for the end.

When I create a TimePeriod and save it in java, it gets converted into TIMESTAMP in the database. The problem is that when I want to get a Time field of this timeperiod in java, a cast error raises: java.sql.Timestamp cannot be cast to java.sql.Time (I'm guessing this is because java thinks it should be Time but it's actually a Timestamp).

I tried to manually (with SQL) alter the column type and change it to TIME, but after that AO keeps raising this error: can't find type 92 (precision=6) in field END_TIME.

Is there anyway to fix this without having to change the field type in the entity definition?

Thanks!

Accepted answers

All comments

Nic Brough -Adaptavist-

You should never be looking at the database, so you shouldn't be caring that active objects is doing this. The databases expect to use Timestamps and trying to change that is not something you should be worrying about, let alone breaking it by changing the database.

A timestamp is not a duration as you're trying to store anyway, you're using the wrong type of field.

smhf97

Hi @Nic Brough -Adaptavist- Thank you for your answer,

I did not intend to directly manipulate or even look at the database, but the error got me there. I can't use the field getter function (like getEndTime, which returns a java.sql.Time) because upon using it, the cast error occur.

So then I went to see where is Timestamp coming from and I saw the column type was TIMSTAMP but I defined a Time field (which corresponds to TIME type in SQL).

I'm using two java.sql.Time fields to create a duration (as AO does not directly support the Duration type).

Why does even this change of Time type happen? It changes the type and then when I want to retrieve the value, it raise a cast error! (cause java expects sql.Time but it returns sql.Timestamp)

Thanks!

Nic Brough -Adaptavist-

Ok, that's good (not looking at the database).

The change here happens because AO does not have code for storing times or dates. It just stores a date-time. Those need dates on them, so if you are writing code to use just the time part of the data, your code will need to cope with the date part. (Note that for date only fields, Jira makes an assumption that the time will be 00:00:00 - you could do that for dates too, assume epoch time, or just completely ignore the date part of it)

But I don't think it makes a lot of sense to use two time fields to represent a duration - it's duplication and, actually, the data part of the timestamp that AO is forcing makes sense. Consider the case where you've got say start: 11:11 and end: 22:22 - whilst the obvious information in there is 11 hours and 11 minutes, it also says 25 hours and 11 minutes, and 49 hours and 11 minutes and so-on.

I'd store a duration as a simple number - you'd have to assume a unit, minutes, seconds, milliseconds, hours, etc, but you'd have one field and a consistent way to use it (possibly not even needing any casts - you can add numbers straight to a "start date" if it's a date-time field and get an end date-time without any casting if you're using the right unit for it)

smhf97

Thank you for your precious time!

Assume that I have only one Time field. Are there any ways to use Time type for my AO field?

Because in 'fieldtype-h2.xml' file I can see the java.sql.Time is a know and valid type for AO fields.

Thanks!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

app

active-objects

time