[ 
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

        

Reply via email to