[ openjms-Bugs-826378 ] errors in oracle table script

Bugs item #826378, was opened at 2003-10-20 00:41
Message generated for change (Comment added) made by tanderson
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=826378&group_id=54559

Category: persistence
Group: None
Status: Open
>Resolution: Fixed
Priority: 5
Submitted By: hagar (bigmom)
Assigned to: Jim Alateras (jalateras)
>Summary: errors in oracle table script

Initial Comment:
Hi, 
I try to use the 
openjms-0.7.6-rc2 /config/db/create_oracle.sql script
and I find some error in it:

1.system_data table - id field need to be NUMBER type 
and not int.

2.tx_messages table - messageId field - there is a 
spelling error - found varhar, need to be varchar
(missing 'c' char)

3.It will be better if all the varchar fields will be varchar2.

Thank you,

Hagar,
hagar_klarman-/[email protected]


----------------------------------------------------------------------

>Comment By: Tim Anderson (tanderson)
Date: 2003-10-23 23:43

Message:
Logged In: YES 
user_id=557161

1. Done - int works in oracle 9i. What version are you using?
2. true. Tables are actually not used at the moment. Will 
remove for now.
3. Done.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=826378&group_id=54559


-------------------------------------------------------
This SF.net email is sponsored by: The SF.net Donation Program.
Do you like what SourceForge.net is doing for the Open
Source Community?  Make a contribution, and help us add new
features and functionality. Click here: http://sourceforge.net/donate/