Looks like the database upgrade portion of Roller is throwing an
exception.
The reason: there is no Roller version number in the database.
Since you are not upgrading that exception should not affect Roller.
If you want to get rid of that startup exception, try adding a version
number to your database.
Stop Roller, run the following insert statement in Oracle, restart
Roller.
insert into roller_properties (name,value)
('roller.database.version','200');
What happens when you try to add a user? What error message do you get?
Do you get a stack trace in roller.log or catalina.out?
- Dave
On Dec 8, 2005, at 2:38 PM, mstralka (sent by Nabble.com) wrote:
Hi,
I'm trying to make Roller work with Oracle. Has anyone done this
successfully? I'm having the following problems:
I installed roller 2.0 on:
Windows 2000 SP4
Tomcat 5.0.28
Oracle 9.2 (on remote server)
I copied Oracle's classes12.jar to CATALINA_HOME\common\lib
I created the tables in the schema and database, and the oracle user
has full permissions to it.
If I go to http://localhost:8090/roller/dstest.jsp, it says it was
successful, but when I start Tomcat, I see the following error in
roller.log, and I can't register a new user in the database:
INFO 2005-12-08 14:36:27,460 RollerConfig: - successfully loaded
default properties.
INFO 2005-12-08 14:36:27,460 RollerConfig: - no custom properties
file found in classpath
INFO 2005-12-08 14:36:27,470 RollerConfig: - no custom properties
file specified via jvm option
ERROR 2005-12-08 14:36:28,561 UpgradeDatabase:upgradeDatabase -
Couldn't lookup current database version
java.lang.NumberFormatException: null
at java.lang.Integer.parseInt(Integer.java:436)
at java.lang.Integer.parseInt(Integer.java:518)
at
org.roller.business.utils.UpgradeDatabase.upgradeDatabase(UpgradeDataba
se.java:68)
at
org.roller.presentation.RollerContext.upgradeDatabaseIfNeeded(RollerCon
text.java:304)
at
org.roller.presentation.RollerContext.contextInitialized(RollerContext.
java:177)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.
java:3827)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:
4343)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.j
ava:823)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:
807)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
at
org.apache.catalina.core.StandardHostDeployer.addChild(StandardHostDepl
oyer.java:903)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja
va:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso
rImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:
216)
at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256)
at org.apache.commons.digester.Rule.end(Rule.java:276)
at org.apache.commons.digester.Digester.endElement(Digester.java:1058)
at
org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.j
ava:76)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown
Source)
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Un
known Source)
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDi
spatcher.dispatch(Unknown Source)
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unkn
own Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digester.java:1567)
at
org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeplo
yer.java:488)
at
org.apache.catalina.core.StandardHost.install(StandardHost.java:863)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.jav
a:483)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:
349)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleS
upport.java:119)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
at
org.apache.catalina.core.StandardService.start(StandardService.java:
480)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:
2313)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja
va:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso
rImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)
WARN 2005-12-08 14:36:29,723 Configurator:configure - No
configuration found. Configuring ehcache from ehcache-failsafe.xml
found in the classpath:
file:/C:/tomcat/work/Catalina/localhost/roller/loader/ehcache-
failsafe.xml
INFO 2005-12-08 14:36:30,394 RollerFactory:setRoller - Using Roller
Impl: org.roller.business.hibernate.HibernateRollerImpl
INFO 2005-12-08 14:36:30,875 ThemeManagerImpl: - Loaded 16 themes
from disk.
INFO 2005-12-08 14:36:31,496 IndexManagerImpl: - search enabled: true
INFO 2005-12-08 14:36:31,496 IndexManagerImpl: - index dir:
C:\Documents and Settings\MSTRALK2\roller_data\search-index
INFO 2005-12-08 14:36:31,736 RollerContext:setupPingQueueTask -
Scheduling ping queue task to run at 5 minute intervals.
INFO 2005-12-08 14:36:31,746 RollerContext:setupScheduledTasks -
Setting daily task: org.roller.presentation.TurnoverReferersTask
INFO 2005-12-08 14:36:33,288 LoginServlet:init - secure login
enabled: false
INFO 2005-12-08 14:36:33,288 LoginServlet:init - secure login port:
443
Here is my roller.xml file in CATALINA_HOME\conf\catalina\localhost
factory
org.apache.commons.dbcp.BasicDataSourceFactory
driverClassName
oracle.jdbc.OracleDriver
url
jdbc:oracle:thin:@REMOTE_SERVER:1521:OT35
username USERNAME
password PASSWORD
maxActive 20
maxIdle 3
removeAbandoned true
maxWait 3000
--
Sent from the Roller - User forum at Nabble.com:
http://www.nabble.com/Error-trying-to-use-Oracle-
t704830c12275.html#a1857268
