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(UpgradeDatabase.java:68) at org.roller.presentation.RollerContext.upgradeDatabaseIfNeeded(RollerContext.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.java: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(StandardHostDeployer.java:903) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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.java:76) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown 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(StandardHostDeployer.java:488) at org.apache.catalina.core.StandardHost.install(StandardHost.java:863) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java: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(LifecycleSupport.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.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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
