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

[SourceForge.net]

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: Closed

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,
***@yahoo.com


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

Comment By: Tim Anderson (tanderson)

Date: 2003-10-29 13:31

Message:
Logged In: YES
user_id=557161

Fix will be available in 0.7.6 RC3

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

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