I haven't seen that error before, so this is somewhat baffling.
Here's something else to check, make sure you are using the Hibernate 3.1.2 jars and not some other version. - Dave On 12/5/06, bmil <[EMAIL PROTECTED]> wrote:
It is more a hibernate session problem (or parameters in my hibernaate.cfg.xml ) as a database connection problem. I can connect to roller db with java.sql. and the same db connection paramteres. Roller server is not started so I can't logon to MY SQL from the Roller server or run http://localhost:8080/roller/roller-ui/tools/dstest.jsp Boris - Please double check your database connection parameters (connection URL, username password - Make sure you've got the MySQL JDBC driver in tomcat/common/lib - Verify that you can login to MySQL from the Roller server - Once you've got the database setup right, you should be able to run http://localhost:8080/roller/roller-ui/tools/dstest.jsp without error. EBUG 2006-12-04 23:11:08,513 UpgradeDatabase:upgradeDatabase - Database version = 300 DEBUG 2006-12-04 23:11:08,523 UpgradeDatabase:upgradeDatabase - Desired version = 300 INFO 2006-12-04 23:11:08,523 UpgradeDatabase:upgradeDatabase - Database is current, no upgrade needed DEBUG 2006-12-04 23:11:08,523 RollerConfig:getProperty - Fetching property [persistence.roller.classname=org.apache.roller.business.hibernate.HibernateRollerImpl] DEBUG 2006-12-04 23:11:08,634 HibernateRollerImpl:instantiate - Instantiating HibernateRollerImpl DEBUG 2006-12-04 23:11:08,664 HibernatePersistenceStrategy:<init> - Initializing Hibernate SessionFactory INFO 2006-12-04 23:11:12,058 RollerFactory:setRoller - Using Roller Impl: org.apache.roller.business.hibernate.HibernateRollerImpl DEBUG 2006-12-04 23:11:12,058 HibernatePropertiesManagerImpl:<init> - Instantiating Hibernate Properties Manager DEBUG 2006-12-04 23:11:12,058 HibernatePersistenceStrategy:getSession - Opening Hibernate Session FATAL 2006-12-04 23:11:12,429 HibernatePropertiesManagerImpl:init - Failed to initialize runtime configuration properties.Please check that the database has been upgraded! java.lang.UnsupportedOperationException at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:116) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:554) Dave Johnson-8 wrote: > > Looks like a database connection problem. > > - Please double check your database connection parameters > (connection URL, username password > > - Make sure you've got the MySQL JDBC driver in tomcat/common/lib > > - Verify that you can login to MySQL from the Roller server > > - Once you've got the database setup right, you should be able to run > http://localhost:8080/roller/roller-ui/tools/dstest.jsp > without error. > > - Dave > > > > On 12/3/06, boris Milikic <[EMAIL PROTECTED]> wrote: >> Hi >> >> I have downloadedRoller 3.1 and when I run it in Tomcat 5.5 I get this >> error. I have recreated a database, checked hibernate.cfg.xml, >> roller.xml, >> but without help. >> >> Boris >> >> roller.log >> >> DEBUG 2006-12-03 12:39:25,799 RollerConfig:<clinit> - >> schemeenforcement.https.urls=/j_security_check,/roller-ui/login-redirect.jsp >> ,/roller-ui/login.do,/roller-ui/user.do,/roller-ui/yourProfile.do,/roller-ui/admin/user.do,/roller-ui/authoring/userdata >> DEBUG 2006-12-03 12:39:25,799 RollerConfig:<clinit> - >> webservices.atomprotocol.enabled=false >> DEBUG 2006-12-03 12:39:25,799 RollerConfig:<clinit> - >> debug.memory.enabled=false >> DEBUG 2006-12-03 12:39:25,799 RollerConfig:<clinit> - >> referrers.asyncProcessing.enabled=false >> DEBUG 2006-12-03 12:39:26,119 UpgradeDatabase:upgradeDatabase - Database >> version = 300 >> DEBUG 2006-12-03 12:39:26,119 UpgradeDatabase:upgradeDatabase - Desired >> version = 300 >> INFO 2006-12-03 12:39:26,119 UpgradeDatabase:upgradeDatabase - Database >> is >> current, no upgrade needed >> DEBUG 2006-12-03 12:39:26,119 RollerConfig:getProperty - Fetching >> property [ >> persistence.roller.classname=org.apache.roller.business.hibernate.HibernateRollerImpl >> ] >> DEBUG 2006-12-03 12:39:26,169 HibernateRollerImpl:instantiate - >> Instantiating HibernateRollerImpl >> DEBUG 2006-12-03 12:39:26,169 HibernatePersistenceStrategy:<init> - >> Initializing Hibernate SessionFactory >> INFO 2006-12-03 12:39:28,673 RollerFactory:setRoller - Using Roller >> Impl: >> org.apache.roller.business.hibernate.HibernateRollerImpl >> DEBUG 2006-12-03 12:39:28,673 HibernatePropertiesManagerImpl:<init> - >> Instantiating Hibernate Properties Manager >> DEBUG 2006-12-03 12:39:28,673 HibernatePersistenceStrategy:getSession - >> Opening Hibernate Session >> FATAL 2006-12-03 12:39:28,813 HibernatePropertiesManagerImpl:init - >> Failed >> to initialize runtime configuration properties.Please check that the >> database has been upgraded! >> java.lang.UnsupportedOperationException >> at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection( >> PoolingDataSource.java:116) >> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection( >> BasicDataSource.java:554) >> at org.hibernate.connection.DatasourceConnectionProvider.getConnection( >> DatasourceConnectionProvider.java:66) >> at org.hibernate.jdbc.ConnectionManager.openConnection( >> ConnectionManager.java:360) >> at org.hibernate.jdbc.ConnectionManager.getConnection( >> ConnectionManager.java:122) >> at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:125) >> at >> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57) >> at >> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1309) >> 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:585) >> at >> org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke >> (ThreadLocalSessionContext.java:301) >> at $Proxy0.beginTransaction(Unknown Source) >> at >> org.apache.roller.business.hibernate.HibernatePersistenceStrategy.getSession >> (HibernatePersistenceStrategy.java:83) >> at >> org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.getProperties >> (HibernatePropertiesManagerImpl.java:98) >> at >> org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.init >> (HibernatePropertiesManagerImpl.java:147) >> at org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl >> .<init>(HibernatePropertiesManagerImpl.java:70) >> at >> org.apache.roller.business.hibernate.HibernateRollerImpl.getPropertiesManager >> (HibernateRollerImpl.java:182) >> at org.apache.roller.ui.core.RollerContext.setupRollerProperties( >> RollerContext.java:237) >> at org.apache.roller.ui.core.RollerContext.contextInitialized( >> RollerContext.java:173) >> at org.apache.catalina.core.StandardContext.listenerStart( >> StandardContext.java:3763) >> at org.apache.catalina.core.StandardContext.start(StandardContext.java >> :4211) >> at org.apache.catalina.core.ContainerBase.addChildInternal( >> ContainerBase.java:759) >> at >> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) >> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) >> at >> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java >> :608) >> at >> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java >> :535) >> at >> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) >> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122) >> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java >> :310) >> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent( >> LifecycleSupport.java:119) >> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021) >> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) >> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) >> at >> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) >> at >> org.apache.catalina.core.StandardService.start(StandardService.java:450) >> at >> org.apache.catalina.core.StandardServer.start(StandardServer.java:709) >> at org.apache.catalina.startup.Catalina.start(Catalina.java:551) >> 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:585) >> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294) >> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432) >> FATAL 2006-12-03 12:39:28,813 RollerContext:contextInitialized - >> RollerContext initialization failed >> java.lang.RuntimeException: java.lang.UnsupportedOperationException >> at >> org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.init >> (HibernatePropertiesManagerImpl.java:163) >> at org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl >> .<init>(HibernatePropertiesManagerImpl.java:70) >> at >> org.apache.roller.business.hibernate.HibernateRollerImpl.getPropertiesManager >> (HibernateRollerImpl.java:182) >> at org.apache.roller.ui.core.RollerContext.setupRollerProperties( >> RollerContext.java:237) >> at org.apache.roller.ui.core.RollerContext.contextInitialized( >> RollerContext.java:173) >> at org.apache.catalina.core.StandardContext.listenerStart( >> StandardContext.java:3763) >> at org.apache.catalina.core.StandardContext.start(StandardContext.java >> :4211) >> at org.apache.catalina.core.ContainerBase.addChildInternal( >> ContainerBase.java:759) >> at >> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) >> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) >> at >> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java >> :608) >> at >> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java >> :535) >> at >> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) >> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122) >> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java >> :310) >> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent( >> LifecycleSupport.java:119) >> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021) >> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) >> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) >> at >> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) >> at >> org.apache.catalina.core.StandardService.start(StandardService.java:450) >> at >> org.apache.catalina.core.StandardServer.start(StandardServer.java:709) >> at org.apache.catalina.startup.Catalina.start(Catalina.java:551) >> 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:585) >> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294) >> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432) >> Caused by: java.lang.UnsupportedOperationException >> >> >> roller.xml >> >> <Context path="/roller" debug="0"> >> <Resource name="jdbc/rollerdb" auth="Container" >> type="javax.sql.DataSource" >> driverClassName="com.mysql.jdbc.Driver" >> url="jdbc:mysql://linux:3306/roller?useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8" >> username="scott" >> password="tiger" >> maxActive="20" >> maxIdle="3" >> removeAbandoned="true" >> maxWait="3000" /> >> <!-- If you want e-mail features, un-comment the section below --> >> <Resource name="mail/Session" auth="Container" type="javax.mail.Session" >> mail.smtp.host="mail.siol.net" /> >> </Context> >> >> >> >> >> >> hibernate.cfg.xml >> >> <?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> >> <!-- By default Roller uses a JNDI DataSource --> >> <property name="connection.datasource >> ">java:comp/env/jdbc/rollerdb</property> >> <property name="show_sql">false</property> >> >> <!-- use thread local Session context --> >> <property name="hibernate.current_session_context_class >> ">thread</property> >> <!-- session properties --> >> <property name="hibernate.current_session_context_class"> >> org.hibernate.context.ThreadLocalSessionContext</property> >> <!-- select SQL dialect, MySQL 3.X or 4.X by default --> >> <property name="dialect">org.hibernate.dialect.MySQLDialect >> </property> >> <property name="hibernate.connection.driver_class"> >> com.mysql.jdbc.Driver</property> >> <property name="hibernate.connection.url"> >> jdbc:mysql://linux:3306/roller</property> >> <property name="hibernate.connection.username">scott</property> >> <property name="hibernate.connection.password">tiger</property> >> >> >> <!-- Hibernate L2 Caching --> >> <property name="hibernate.cache.provider_class"> >> org.hibernate.cache.EhCacheProvider</property> >> <property name="hibernate.generate_statistics">true</property> >> <property name="hibernate.cache.use_structured_entries >> ">true</property> >> >> >> <!-- Map Roller pojo classes --> >> <mapping resource="org/apache/roller/pojos/BookmarkData.hbm.xml" >> /> >> <mapping resource="org/apache/roller/pojos/CommentData.hbm.xml" >> /> >> <mapping >> resource="org/apache/roller/pojos/EntryAttributeData.hbm.xml" /> >> <mapping resource="org/apache/roller/pojos/FolderAssoc.hbm.xml" >> /> >> <mapping resource="org/apache/roller/pojos/FolderData.hbm.xml" /> >> <mapping >> resource="org/apache/roller/pojos/WeblogTemplate.hbm.xml" >> /> >> <mapping >> resource="org/apache/roller/pojos/PingCategoryRestrictionData.hbm.xml" /> >> <mapping resource="org/apache/roller/pojos/AutoPingData.hbm.xml" >> /> >> <mapping >> resource="org/apache/roller/pojos/PingQueueEntryData.hbm.xml" /> >> <mapping >> resource="org/apache/roller/pojos/PingTargetData.hbm.xml" >> /> >> <mapping resource="org/apache/roller/pojos/RefererData.hbm.xml" >> /> >> <mapping resource="org/apache/roller/pojos/RoleData.hbm.xml" /> >> <mapping >> resource="org/apache/roller/pojos/RollerConfigData.hbm.xml" >> /> >> <mapping resource="org/apache/roller/pojos/UserData.hbm.xml" /> >> <mapping >> resource="org/apache/roller/pojos/WeblogCategoryData.hbm.xml" /> >> <mapping >> resource="org/apache/roller/pojos/WeblogCategoryAssoc.hbm.xml" /> >> <mapping >> resource="org/apache/roller/pojos/WeblogEntryData.hbm.xml" >> /> >> <mapping resource="org/apache/roller/pojos/WebsiteData.hbm.xml" >> /> >> <mapping >> resource="org/apache/roller/pojos/RollerPropertyData.hbm.xml" /> >> <mapping >> resource="org/apache/roller/pojos/PermissionsData.hbm.xml" >> /> >> <mapping >> resource="org/apache/roller/pojos/PlanetConfigData.hbm.xml" >> /> >> <mapping >> resource="org/apache/roller/pojos/PlanetGroupData.hbm.xml" >> /> >> <mapping >> resource="org/apache/roller/pojos/PlanetEntryData.hbm.xml" >> /> >> <mapping >> resource="org/apache/roller/pojos/PlanetSubscriptionData.hbm.xml" /> >> <mapping >> resource="org/apache/roller/pojos/PlanetGroupSubscriptionAssoc.hbm.xml" >> /> >> >> </session-factory> >> </hibernate-configuration> >> >> > > http://www.nabble.com/file/4472/hibernate.cfg.xml hibernate.cfg.xml http://www.nabble.com/file/4473/roller.xml roller.xml -- View this message in context: http://www.nabble.com/FATAL-2006-12-03-12%3A39%3A28%2C813-HibernatePropertiesManagerImpl%3Ainit---Failed-to-initialize-runtime-configuration-properties.Please-check-that-the-database-has-been-upgraded%21-tf2747881s12275.html#a7710941 Sent from the Roller - User mailing list archive at Nabble.com.
