[ISSUES] Commented: (JLCP-209) JLCP does not currently work with Oracle

The following comment has been added to this issue:

     Author: Matthew Schmidt
    Created: Fri, 6 Jun 2003 7:40 AM
       Body:
We'll fix the badly named columns, those are easy and we've done that on several other databases.  The bad CLOB support is something we'll have to talk to Gavin at Hibernate about.  As for using CMP, technically all the DAOs are replaceable, so you could use CMP, but I wouldn't recommend removing the DAOs ;)
---------------------------------------------------------------------
View the issue:

  http://jira.jlcp.org/secure/ViewIssue.jspa?key=JLCP-209


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: JLCP-209
    Summary: JLCP does not currently work with Oracle
       Type: Bug

     Status: Unassigned
   Priority: Major

 Time Spent: Unknown
   Estimate: 1 day

    Project: Javalobby Community Platform
   Versions:
             0.5.1

   Assignee: 
   Reporter: Sam Pullara

    Created: Fri, 6 Jun 2003 2:31 AM
    Updated: Fri, 6 Jun 2003 2:31 AM
Environment: Oracle 9.2

Description:
Hibernate doesn't appear to support CLOBs like they should be so it tries to use VARCHAR2s for all fields -- even though they have a limit of 4000 characters on Oracle. Additionally, some of the column names are not legal on oracle.

Contains a 65535 length field which is then mapped to a varchar2(65535) which is illegal in Oracle. You must use a CLOB type.
src/org/jlcp/core/attribute/provider/hibernate/entity/AttributeValue.hbm.xml

Contains a 10000 length field which is then mapped to a varchar2(10000) which is illegal in Oracle. You must use a CLOB type.
src/org/jlcp/module/cms/provider/hibernate/entity/TextArea.hbm.xml
src/org/jlcp/module/rss/provider/hibernate/model/RssFeed.hbm.xml

Contains a 8000 length field which is then mapped to a varchar2(8000) which is illegal in Oracle. You must use a CLOB type.
src/org/jlcp/module/forum/provider/hibernate/model/Message.hbm.xml
src/org/jlcp/module/poll/provider/hibernate/model/PollResponse.hbm.xml

Temporary workaround, reduce field sizes to 4000.  The correct thing to do is find the Hibernate workarounds for this issue (or use EJB CMP 2.0 instead of this hibernate stuff :))


Can't name a table "file" in Oracle. Renamed file_center.
src/org/jlcp/module/filecenter/provider/hibernate/model/File.hbm.xml

Can't name a column "comment" in Oracle. Renamed comment_field.
src/org/jlcp/module/poll/provider/hibernate/model/PollResponse.hbm.xml

Can't name a column "uid" in Oracle. Renamed user_id.
src/org/jlcp/module/calendar/provider/hibernate/model/CalendarEvent.hbm.xml





---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://jira.jlcp.org/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira