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<-
[EMAIL PROTECTED] [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
