[openjms-developer] [ openjms-Bugs-826378 ] openjms-0.7.6-rc2 - oracle table script

[SourceForge.net <no...@so...>]

Bugs item #826378, was opened at 2003-10-19 14:41
Message generated for change (Tracker Item Submitted) made by Item Submitter
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: None
Priority: 5
Submitted By: hagar (bigmom)
Assigned to: Jim Alateras (jalateras)
Summary: openjms-0.7.6-rc2 - 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,
hag...@ya...


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

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