Brill, I am not sure I understand what you are proposing.
We are using hibernate to generate the schema for first time install. Unfortunately hibernate AFAIK does not generate upgrade scripts (I am not sure how it could). As far as I can see, the problem with XPR-146 is not because of Oracle but because xplanner somehow is storing a 7 character code in a 1 character code field. So far we haven't been able to replicate this. However the workaround allows to save the story but the offending code will not be properly retrieved until the stored value is one of the pre-defined 1 character enumeration value.
BTW talking about maven what do you think of moving straight to maven 2.0?
Jacques
PS: FYI I am thinking of ditching hibernate generation completely for new install because of discrepancies introduced between a brand new hibernate generated schema and a schema of a old install that has been upgraded multiple times. Instead I want to go to what I put in http://jira.codehaus.org/browse/XPR-152
----- Original Message ----
From: Brill Pappin <johnpappin@...>
To: xplanner-devel@...
Sent: Saturday, December 03, 2005 4:27:59 PM
Subject: Re: [Xplanner-devel] Developer list
XPlanner uses Hibernate, so why not let hibernate to the schema export?
It should be able to do Oracle as well ae anything else (the silly 30 char limit in Oracle aside).
This hsould be simpler after version 0.7 is releaseed and we can move to Maven (if people are still interested) because you can generate/update the database directly for the dialect you want.
In the mean time, there is a Hibernate Ant task that will allow you to output the DDL for whatever dialect you from Hibernate.
- Brill Pappin
On 11/28/05, Sun, Guili <Guili.Sun@...> wrote:
Zoly,
Changing the column size to CHAR(11) will fix the problem temporarily,
however, the direction is to have one character storage for disposition
and status columns on story.
Take a look at http://jira.codehaus.org/browse/XPR-146 issue and its
comments. If you want to submit a patch, please attach it to the issue
as well.
Thanks,
Guili
-----Original Message-----
From: xplanner-devel-admin@...
[mailto:xplanner-devel-admin@...] On Behalf Of Zoltan
Farkas
Sent: Monday, November 28, 2005 11:31 AM
To: xplanner-devel@...
Subject: RE: [Xplanner-devel] Developer list
I have updated the column size to CHAR(11), fixed the problem.
I have updated also my Oracle Migration Scripts.
Does anybody work on the Oracle Migrations ? I could contribute those
scripts if needed. (they would be usefull for existing oracle users)
--zoly
-----Original Message-----
From: xplanner-devel-admin@...
[mailto:xplanner-devel-admin@... ] On Behalf Of Sun,
Guili
Sent: Monday, November 28, 2005 12:21 PM
To: xplanner-devel@...
Subject: RE: [Xplanner-devel] Developer list
Zoly,
I did a test on xplanner 0.7b3 version on MySQL 4.0 in the following
order:
1. Created an iteration
2. Created a story
3. Created a task
4. Enter time entry for this task
5. Being prompted to start the iteration
6. Clicked ok and the time was entered.
I think with 0.7b3, this is fixed.
Thanks,
Guili
-----Original Message-----
From: xplanner-devel-admin@...
[mailto:xplanner-devel-admin@...] On Behalf Of Zoltan
Farkas
Sent: Monday, November 28, 2005 9:50 AM
To: xplanner-devel@...
Subject: RE: [Xplanner-devel] Developer list
I am using version 0.7 b2.
I was trying to add in hours, and xplanner asked me if I want to start
the task, after saying yes it gave me the error.
I have migrated my oracle database from release 0.6.2 to 0.7 b2, after
converting the MYSQL conversion scripts to oracle sql.
--zoly
-----Original Message-----
From: xplanner-devel-admin@...
[mailto:xplanner-devel-admin@...] On Behalf Of Sun,
Guili
Sent: Monday, November 28, 2005 10:35 AM
To: xplanner-devel@...
Subject: RE: [Xplanner-devel] Developer list
Zoly,
Which version of xplanner and what database are you using? This bug has
been reported (http://jira.codehaus.org/browse/XPR-146). What were the
steps that you followed to reveal this problem?
Thanks,
Guili
-----Original Message-----
From: xplanner-devel-admin@...
[mailto:xplanner-devel-admin@... ] On Behalf Of Zoltan
Farkas
Sent: Monday, November 28, 2005 9:12 AM
To: xplanner-devel@...
Subject: RE: [Xplanner-devel] Developer list
Found some issues with some CHAR(1) columns like Disposition, the column
contains values like 'p', 'd', however Xplanner tryes to update the
columns with 'p-lanned' instead, giving a inserted value to large error
?
What is the problem, any fix available?
--zoly
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log
files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=ick
_______________________________________________
Xplanner-devel mailing list
Xplanner-devel@...
https://lists.sourceforge.net/lists/listinfo/xplanner-devel
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log
files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=ick
_______________________________________________
Xplanner-devel mailing list
Xplanner-devel@...
https://lists.sourceforge.net/lists/listinfo/xplanner-devel
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log
files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=ick
_______________________________________________
Xplanner-devel mailing list
Xplanner-devel@...
https://lists.sourceforge.net/lists/listinfo/xplanner-devel
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log
files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=ick
_______________________________________________
Xplanner-devel mailing list
Xplanner-devel@...
https://lists.sourceforge.net/lists/listinfo/xplanner-devel
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log
files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=ick
_______________________________________________
Xplanner-devel mailing list
Xplanner-devel@...
https://lists.sourceforge.net/lists/listinfo/xplanner-devel
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&opclick
_______________________________________________
Xplanner-devel mailing list
Xplanner-devel@...
https://lists.sourceforge.net/lists/listinfo/xplanner-devel
|