You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by "Rahul Jain (JIRA)" <no...@atlassian.com> on 2007/04/17 17:25:55 UTC

[Roller-JIRA] Commented: (ROL-453) Currently Roller does not support the Oracle RDBMS

    [ http://opensource.atlassian.com/projects/roller/browse/ROL-453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_13685 ] 

Rahul Jain commented on ROL-453:
--------------------------------

Hi Padraic,

Would you mind attaching the files with this issue from the left menu for the patch you are talking of to work with oracle? That might be of some help with the below mentioned issue.

I am using Roller 3.0, Oracle 10g, Jboss. The problem is while loading Roller in JBoss a NumberFormatException occurs which is probably because of reading the database version using getString from a CLOB datatype.

But even if we ignore this exception, I am not being able to create even the first Global admin user, because the users.registration.enabled field in ROLLER_PROPERTIES has CLOB as value datatype and hibernate is not being able to read the CLOB datatype as String in RollerPropertyData.java. This results in a page displaying User Registration is disabled even with the first Global Admin user.

Please let me know if you are aware of any work around for the same.

> Currently Roller does not support the Oracle RDBMS
> --------------------------------------------------
>
>                 Key: ROL-453
>                 URL: http://opensource.atlassian.com/projects/roller/browse/ROL-453
>             Project: Roller
>          Issue Type: New Feature
>          Components: Database Access & Data Model
>         Environment: Oracle 9i
>            Reporter: Padraic Hannon
>            Assignee: Roller Unassigned
>
> A few minor changes need to be made to roller in order to support Oracle as its datastore. 
> The following files need to be updated to support oracle:
> metadata/database/hibernate/hibernate.properties
> src/org/roller/business/hibernate/HibernateRefererManagerImpl.java
> src/org/roller/pojos/CommentData.java
> src/org/roller/pojos/PageData.java
> src/org/roller/pojos/UserData.java
> src/org/roller/pojos/WeblogEntryData.java
> In addition a clob to string mapping class for hibernate is needed:
> src/org/roller/business/hibernate/HibernateOracleClobType.java

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/roller/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira