On Fri, 2005-12-09 at 06:46, Dave Johnson wrote:
> 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.
the strange part here is that the call to "if(rs.next())" seems to be true, but
it seems that "rs.getString(1)" is returning null, so something must be wacky
with the oracle driver?
we can add a null check inside that if statement so that it doesn't try and
parse the string if the value is null, but that shouldn't be happening anyways.
>
> 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');
this is a good work around, but we can't expect users to do this, so we still
need to fix this.
-- Allen
>
> 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
>
