sharing my ways to solve oracle+roller problems
-----------------------------------------------
Key: ROL-1757
URL: https://issues.apache.org/roller/browse/ROL-1757
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(RollerRuntimeConfig.java:223)
at
org.apache.roller.config.RollerRuntimeConfig.isSiteWideWeblog(RollerRuntimeConfig.java:236)
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.
