You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@roller.apache.org by Dave Johnson <da...@rollerweblogger.org> on 2005/12/09 15:46:17 UTC
Re: Error trying to use Oracle
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
Re: inviteMember.notificationContent= | Formatting, e.g. Line Feed
or HTML
Posted by Anil Gangolli <an...@busybuddha.org>.
The value of inviteMember.notificationContent is treated under the rules
of java.util.Properties and of java.text.MessageFormat.
I believe \r (CR) and \n (LF) will work here.
Currently the message is always sent as MIME type "text/plain;
charset=utf-8", so it would require a bit of customization to use HTML.
You'd probably want to add a configuration (roller.properties) property
for the MIME type of the e-mail, and then in InviteMemberAction apply
MailUtil.sendMessage() with the configured type rather than
sendTextMessage() which forces the type. This might be a reasonable
request for a minor improvement, or taken back into the source base as a
contribution.
That said, text is generally safer to use here for transparency to be
more easily distinguished from phishing or spam both by automated and
human assessment.
--a.
Greg Hamer wrote:
>In ApplicationResources.properties for inviteMember.notificationContent= is
>any sort of formatting possible/supported?
>
>E.g. line feeds, or maybe even HTML?
>
>Thanks,
>
>g
>
>
>
>
inviteMember.notificationContent= | Formatting, e.g. Line Feed or HTML
Posted by Greg Hamer <ro...@gmail.com>.
In ApplicationResources.properties for inviteMember.notificationContent= is
any sort of formatting possible/supported?
E.g. line feeds, or maybe even HTML?
Thanks,
g
Re: Error trying to use Oracle
Posted by Mark Stralka <ms...@gmail.com>.
I finally got Oracle working! It was a stupid mis-configuration in
hibernate.cfg.xml.
Originally, hibernate.cfg.xml had the following line:
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
Because I was using Oracle, I changed it to:
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
The default hibernate.cfg.xml file had several commented-out lines about
Oracle configuration. I activated these lines:
<property name="hibernate.connection.driver_class">
oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost
:1521:DEV9OT01</property>
<property name="hibernate.connection.username">USERNAME</property>
<property name="hibernate.connection.password">PASSWORD</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect
</property>
I should not have done this! I just commented them out again and now Roller
is working fine with oracle.
Thanks for all your help everyone. I'm going to post my Oracle experience
on the website.
Thanks
Mark
On 12/10/05, Mark Stralka <ms...@gmail.com> wrote:
>
> Is there anything I can do to get around this? I want to use Roller at my
> company but they'll only use an Oracle db. Thanks!
>
> On 12/10/05, Max Rudman < mrudman@steelbrick.com> wrote:
> >
> >
> > On Dec 9, 2005, at 12:03 PM, Allen Gilliland wrote:
> >
> > > 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?
> >
> > I've noticed this before. For some odd reason, Oracle (or the driver)
> > seems to return null even when the column value is blank. Ie: ''
> > returns null.
> >
> > Max
> >
> >
> >
> >
> >
> >
> > >
> > > 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
> > >>
> >
> >
>
Re: Error trying to use Oracle
Posted by Mark Stralka <ms...@gmail.com>.
Is there anything I can do to get around this? I want to use Roller at my
company but they'll only use an Oracle db. Thanks!
On 12/10/05, Max Rudman <mr...@steelbrick.com> wrote:
>
>
> On Dec 9, 2005, at 12:03 PM, Allen Gilliland wrote:
>
> > 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?
>
> I've noticed this before. For some odd reason, Oracle (or the driver)
> seems to return null even when the column value is blank. Ie: ''
> returns null.
>
> Max
>
>
>
>
>
>
> >
> > 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
> >>
>
>
Re: Error trying to use Oracle
Posted by Max Rudman <mr...@steelbrick.com>.
On Dec 9, 2005, at 12:03 PM, Allen Gilliland wrote:
> 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?
I've noticed this before. For some odd reason, Oracle (or the driver)
seems to return null even when the column value is blank. Ie: ''
returns null.
Max
>
> 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
>>
Re: Error trying to use Oracle
Posted by Max Rudman <mr...@steelbrick.com>.
On Dec 9, 2005, at 12:03 PM, Allen Gilliland wrote:
> 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?
I've noticed this before. For some odd reason, Oracle (or the driver)
seems to return null even when the column value is blank. Ie: ''
returns null.
Max
>
> 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
>>
Re: Error trying to use Oracle
Posted by Mark Stralka <ms...@gmail.com>.
Strange. I'm using Oracle 9.2 and I have the oracle 10 jar file in
CATALINA_HOME/common/lib. I'm not experienced with Hibernate - does
anything look wrong here:
Has anyone else used Roller with Oracle? Could it be a UTF-8 issue? I
didn't do anything special to create the schema with UTF-8, maybe that's the
problem?
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="show_sql">false</property>
<property name="connection.datasource
">java:comp/env/jdbc/rollerdb</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.OracleDriver
</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost
:1521:DEV9OT01</property>
<property name="hibernate.connection.username">USER</property>
<property name="hibernate.connection.password">PASSWORD</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect
</property>
<mapping resource="org/roller/business/HitCountData.hbm.xml" />
<mapping resource="org/roller/pojos/BookmarkData.hbm.xml" />
<mapping resource="org/roller/pojos/CommentData.hbm.xml" />
<mapping resource="org/roller/pojos/EntryAttributeData.hbm.xml" />
<mapping resource="org/roller/pojos/FolderAssoc.hbm.xml" />
<mapping resource="org/roller/pojos/FolderData.hbm.xml" />
<mapping resource="org/roller/pojos/WeblogTemplate.hbm.xml" />
<mapping
resource="org/roller/pojos/PingCategoryRestrictionData.hbm.xml" />
<mapping resource="org/roller/pojos/AutoPingData.hbm.xml" />
<mapping resource="org/roller/pojos/PingQueueEntryData.hbm.xml" />
<mapping resource="org/roller/pojos/PingTargetData.hbm.xml" />
<mapping resource="org/roller/pojos/RefererData.hbm.xml" />
<mapping resource="org/roller/pojos/RoleData.hbm.xml" />
<mapping resource="org/roller/pojos/RollerConfigData.hbm.xml" />
<mapping resource="org/roller/pojos/UserData.hbm.xml" />
<mapping resource="org/roller/pojos/UserCookieData.hbm.xml" />
<mapping resource="org/roller/pojos/WeblogCategoryData.hbm.xml" />
<mapping resource="org/roller/pojos/WeblogCategoryAssoc.hbm.xml" />
<mapping resource="org/roller/pojos/WeblogEntryData.hbm.xml" />
<mapping resource="org/roller/pojos/WebsiteData.hbm.xml" />
<mapping resource="org/roller/pojos/RollerPropertyData.hbm.xml" />
<mapping resource="org/roller/pojos/PermissionsData.hbm.xml" />
<mapping resource="org/roller/pojos/PlanetConfigData.hbm.xml" />
<mapping resource="org/roller/pojos/PlanetGroupData.hbm.xml" />
<mapping resource="org/roller/pojos/PlanetEntryData.hbm.xml" />
<mapping resource="org/roller/pojos/PlanetSubscriptionData.hbm.xml"
/>
<mapping
resource="org/roller/pojos/PlanetGroupSubscriptionAssoc.hbm.xml" />
</session-factory>
</hibernate-configuration>
Re: Error trying to use Oracle
Posted by Dave Johnson <da...@rollerweblogger.org>.
Seeing an unsupported operation in PropertiesManager.getProperties() is
unusual, that's a dead-simple query. Perhaps you still have a Hibernate
dialect or JDBC driver issue?
- Dave
On Dec 9, 2005, at 12:56 PM, Mark Stralka wrote:
> FATAL 2005-12-09 12:04:51,352 PropertiesManagerImpl:init - Failed to
> initialize runtime configuration properties.Please check that the
> database
> has been upgraded!
> java.lang.UnsupportedOperationException
> at org.apache.commons.dbcp.PoolingDataSource.getConnection(
...
...
...
> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
> at
> org.roller.business.hibernate.HibernatePropertiesManagerImpl.getPropert
> ies(
> HibernatePropertiesManagerImpl.java:71)
Re: Error trying to use Oracle
Posted by Mark Stralka <ms...@gmail.com>.
Hi Dave and Allen,
Thank you for the response I've made a little progress but am having
different errors now.
-I tried to run your query but the name 'roller.database.version' already
existed in the table:
insert into roller_properties (name,value) ('roller.database.version
','200');
-Instead of using classes12.jar from Oracle 9, I put ojdbc14-10g.jar from
Oracle 10g into CATALINA_HOME/common/lib. That let me get past the
"UpgradeDatabase" error. Someone suggested this for a different web app I'm
trying too.
-I also modified WEB-INF/hibernate.cfg.xml to use Oracle dialect instead of
Mysql. The relevent part looks like this:
<property name="show_sql">false</property>
<property name="connection.datasource
">java:comp/env/jdbc/rollerdb</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="hibernate.connection.driver_class">
oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@SERVER
:1521:OT35</property>
<property name="hibernate.connection.username">USERNAME</property>
<property name="hibernate.connection.password">PASSWORD</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect
</property>
Now no errors appear in the CATALINA log but I see a fatal one in
roller.log(width JDBC debug=99 in
roller.xml):
INFO 2005-12-09 12:04:47,968 RollerConfig:<clinit> - successfully loaded
default properties.
INFO 2005-12-09 12:04:47,968 RollerConfig:<clinit> - no custom properties
file found in classpath
INFO 2005-12-09 12:04:47,968 RollerConfig:<clinit> - no custom properties
file specified via jvm option
INFO 2005-12-09 12:04:48,719 UpgradeDatabase:upgradeDatabase - Database is
current, no upgrade needed
INFO 2005-12-09 12:04:48,769 Environment:<clinit> - Hibernate 3.0.5
INFO 2005-12-09 12:04:48,769 Environment:<clinit> -
hibernate.propertiesnot found
INFO 2005-12-09 12:04:48,769 Environment:<clinit> - using CGLIB reflection
optimizer
INFO 2005-12-09 12:04:48,779 Environment:<clinit> - using JDK 1.4
java.sql.Timestamp handling
INFO 2005-12-09 12:04:48,859 Configuration:configure - configuring from
resource: /hibernate.cfg.xml
INFO 2005-12-09 12:04:48,859 Configuration:getConfigurationInputStream -
Configuration resource: /hibernate.cfg.xml
DEBUG 2005-12-09 12:04:48,909 DTDEntityResolver:resolveEntity - trying to
locate http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd in
classpath under org/hibernate/
DEBUG 2005-12-09 12:04:48,919 DTDEntityResolver:resolveEntity - found
http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd in
classpath
DEBUG 2005-12-09 12:04:48,969 Configuration:addProperties - show_sql=false
DEBUG 2005-12-09 12:04:48,969 Configuration:addProperties -
connection.datasource=java:comp/env/jdbc/rollerdb
DEBUG 2005-12-09 12:04:48,969 Configuration:addProperties - dialect=
org.hibernate.dialect.Oracle9Dialect
DEBUG 2005-12-09 12:04:48,969 Configuration:addProperties -
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
DEBUG 2005-12-09 12:04:48,969 Configuration:addProperties -
hibernate.connection.url=jdbc:oracle:thin:@jomhp1d2.na.jnj.com:1521:OT35
DEBUG 2005-12-09 12:04:48,969 Configuration:addProperties -
hibernate.connection.username=USERNAME
DEBUG 2005-12-09 12:04:48,979 Configuration:addProperties -
hibernate.connection.password=PASSWORD
DEBUG 2005-12-09 12:04:48,979 Configuration:addProperties -
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
DEBUG 2005-12-09 12:04:48,979 Configuration:parseMappingElement - null<-
org.dom4j.tree.DefaultAttribute@b31b77 [Attribute: name resource value
"org/roller/business/HitCountData.hbm.xml"]
INFO 2005-12-09 12:04:48,979 Configuration:addResource - Mapping resource:
org/roller/business/HitCountData.hbm.xml
DEBUG 2005-12-09 12:04:48,979 DTDEntityResolver:resolveEntity - trying to
locate http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in
classpath under org/hibernate/
TRIMMED FOR LENGTH
DEBUG 2005-12-09 12:04:51,272 SessionFactoryObjectFactory:<clinit> -
initializing class SessionFactoryObjectFactory
DEBUG 2005-12-09 12:04:51,272 SessionFactoryObjectFactory:addInstance -
registered: 8a920f0808107b6b0108107b70480000 (unnamed)
INFO 2005-12-09 12:04:51,272 SessionFactoryObjectFactory:addInstance - Not
binding factory to JNDI, no JNDI name configured
DEBUG 2005-12-09 12:04:51,272 SessionFactoryImpl:<init> - instantiated
session factory
INFO 2005-12-09 12:04:51,272 SessionFactoryImpl:checkNamedQueries -
Checking 0 named queries
INFO 2005-12-09 12:04:51,282 RollerFactory:setRoller - Using Roller Impl:
org.roller.business.hibernate.HibernateRollerImpl
DEBUG 2005-12-09 12:04:51,322 SessionImpl:<init> - opened session at
timestamp: 4645469762691072
DEBUG 2005-12-09 12:04:51,342 AbstractBatcher:logOpenPreparedStatement -
about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG 2005-12-09 12:04:51,342 ConnectionManager:openConnection - opening
JDBC connection
DEBUG 2005-12-09 12:04:51,342 JDBCContext:afterNontransactionalQuery - after
autocommit
DEBUG 2005-12-09 12:04:51,342 SessionImpl:afterTransactionCompletion - after
transaction completion
FATAL 2005-12-09 12:04:51,352 PropertiesManagerImpl:init - Failed to
initialize runtime configuration properties.Please check that the database
has been upgraded!
java.lang.UnsupportedOperationException
at org.apache.commons.dbcp.PoolingDataSource.getConnection(
PoolingDataSource.java:116)
at org.apache.commons.dbcp.BasicDataSource.getConnection(
BasicDataSource.java:554)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(
DatasourceConnectionProvider.java:56)
at org.hibernate.jdbc.ConnectionManager.openConnection(
ConnectionManager.java:298)
at org.hibernate.jdbc.ConnectionManager.getConnection(
ConnectionManager.java:110)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(
AbstractBatcher.java:88)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
at org.hibernate.loader.Loader.doQuery(Loader.java:390)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(
Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java
:111)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
at
org.roller.business.hibernate.HibernatePropertiesManagerImpl.getProperties(
HibernatePropertiesManagerImpl.java:71)
at org.roller.business.PropertiesManagerImpl.init(
PropertiesManagerImpl.java:57)
at org.roller.business.PropertiesManagerImpl.<init>(
PropertiesManagerImpl.java:49)
at org.roller.business.hibernate.HibernatePropertiesManagerImpl.<init>(
HibernatePropertiesManagerImpl.java:39)
at
org.roller.business.hibernate.HibernateRollerImpl.getPropertiesManager(
HibernateRollerImpl.java:197)
at org.roller.presentation.RollerContext.setupRollerProperties(
RollerContext.java:217)
at org.roller.presentation.RollerContext.contextInitialized(
RollerContext.java:182)
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)
FATAL 2005-12-09 12:04:51,352 RollerContext:contextInitialized -
RollerContext initialization failed
java.lang.RuntimeException: java.lang.UnsupportedOperationException
at org.roller.business.PropertiesManagerImpl.init(
PropertiesManagerImpl.java:75)
at org.roller.business.PropertiesManagerImpl.<init>(
PropertiesManagerImpl.java:49)
at org.roller.business.hibernate.HibernatePropertiesManagerImpl.<init>(
HibernatePropertiesManagerImpl.java:39)
at
org.roller.business.hibernate.HibernateRollerImpl.getPropertiesManager(
HibernateRollerImpl.java:197)
at org.roller.presentation.RollerContext.setupRollerProperties(
RollerContext.java:217)
at org.roller.presentation.RollerContext.contextInitialized(
RollerContext.java:182)
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)
Caused by: java.lang.UnsupportedOperationException
at org.apache.commons.dbcp.PoolingDataSource.getConnection(
PoolingDataSource.java:116)
at org.apache.commons.dbcp.BasicDataSource.getConnection(
BasicDataSource.java:554)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(
DatasourceConnectionProvider.java:56)
at org.hibernate.jdbc.ConnectionManager.openConnection(
ConnectionManager.java:298)
at org.hibernate.jdbc.ConnectionManager.getConnection(
ConnectionManager.java:110)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(
AbstractBatcher.java:88)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
at org.hibernate.loader.Loader.doQuery(Loader.java:390)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(
Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java
:111)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
at
org.roller.business.hibernate.HibernatePropertiesManagerImpl.getProperties(
HibernatePropertiesManagerImpl.java:71)
at org.roller.business.PropertiesManagerImpl.init(
PropertiesManagerImpl.java:57)
... 49 more
INFO 2005-12-09 12:04:52,774 LoginServlet:init - secure login enabled:
false
INFO 2005-12-09 12:04:52,784 LoginServlet:init - secure login port: 443
Re: Error trying to use Oracle
Posted by Allen Gilliland <Al...@Sun.COM>.
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
>
Re: Error trying to use Oracle
Posted by Allen Gilliland <Al...@Sun.COM>.
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
>