Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-201
Here is an overview of the issue:
---------------------------------------------------------------------
Key: CAY-201
Summary: Modeler generate db schema doesn't properly handle post-Oracle 8 TIMESTAMP fields
Type: Bug
Status: Assigned
Priority: Major
Project: Cayenne
Components:
CayenneModeler GUI
Versions:
1.1
Assignee: Andrus Adamchik
Reporter: Mike Kienenberger
Created: Mon, 4 Oct 2004 12:57 PM
Updated: Mon, 4 Oct 2004 12:57 PM
Environment: Version: 1.1RC1 (October 3 2004)
Description:
I just downloaded Version: 1.1RC1 (October 3 2004) to verify that this bug exists in the latest version.
In Oracle 8 and before, a java timestamp always mapped to DATE. Starting with Oracle 9, a TIMESTAMP field was created. Unfortunately, the modeler still generates all TIMESTAMP model types into Oracle DATE fields rather than Oracle TIMESTAMP fields.
I'm not certain the best way this should be handled. Maybe provide a pre-9 Oracle adaptor that models the current types, but update the current adaptor to default to the new types? Might be backward compatibility issues, but at some point new versions of Oracle need to be supported as the default.
Another possibility might be a checkbox preference in the modeler, but that seems ugly as well.
I'm going to make a quick fix as I need to recreate my entire database schema in a new database, and I don't want to do it by hand :)
-Mike
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://objectstyle.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
This archive was generated by hypermail 2.0.0 : Mon Oct 04 2004 - 12:58:51 EDT