roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "weilei shen (JIRA)" <>
Subject [jira] Commented: (ROL-1757) sharing my ways to solve oracle+roller problems
Date Mon, 03 Nov 2008 05:14:19 GMT


weilei shen commented on ROL-1757:


VALUE VARCHAR2(4000) default ' ' not null 

(there has a blank space between ' '  )

> sharing my ways to solve oracle+roller problems
> -----------------------------------------------
>                 Key: ROL-1757
>                 URL:
>             Project: Roller
>          Issue Type: Bug
>         Environment: oracle9i/oracle10,tomcat5.5,windows 2000/vista home basic
>            Reporter: weilei shen
>            Assignee: Roller Unassigned
> i met two errors when i use oracle database,now i found the way to solve it.(it's all
ok when i use mssql2000)
> 1.error:Problem to register the user and receive the following message :"I'm sorry, but
the administrator of this site has turned off new user registrations."
> oracle9i: be sure you have set correct access rights to roller_data 
>                  then,Use Oracle JDBC 10g Drivers instead of the 9.x ones
> oracle10: it's caused by createdb.sql, some types are wrong.
>                   In createdb.sql, some type set to be clob type ,in fact, they are varchar

>                   i advise you to create table follow the  files like *.hbm.xml under
" org\apache\roller\pojos"
> 2.error:can't access to the userblog
> roller.log:
> DEBUG 2008-10-30 16:09:45,453 RollerRuntimeConfig:getProperty - fetched property [site.frontpage.weblog.handle=null]
> ERROR 2008-10-30 16:09:45,453 ApplicationDispatcher:invoke - Servlet.service() for servlet
PageServlet threw exception
> java.lang.NullPointerException
> 	at org.apache.roller.config.RollerRuntimeConfig.isFrontPageWeblog(
> 	at org.apache.roller.config.RollerRuntimeConfig.isSiteWideWeblog(
> it's caused by [site.frontpage.weblog.handle=null].In table roller_properties , site.frontpage.weblog.handle
is null.
> BUT if we set the handle in it, the frontpage will be the userblog. I perfer to set a
blank space in it.
> you can rebuild the roller_properties .(the column VALUE shoule be varchar,so it's the
createdb.sql error again.  -_-!)
> my sql:
> create table roller_properties (
>     name     varchar(255) not null primary key,
>    VALUE  VARCHAR2(4000) default ' ' not null 
> );
> my english is poor,i don't know whether you can understand what i say...
> hopes these can help you.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message