sorry again, the problem has been resolved now..
according to hibernate user faq, platform specific issues, http://www.hibernate.org/120.html Tomcat throws java.lang.UnsupportedOperationException when fetching a JDBC connection In Tomcat (maybe other situations) if you are using the built-in DBCP to as a JNDI datasource, be sure that you do not specify hibernate.connection.username or hibernate.connection.password in either hibernate.cfg.xml or hibernate.properties. DBCP does not implement the version of Datasource.getConnection() that takes a username and password. so I removed any association to the hibernate.connection.username and hibernate.connection.password from both the hibernate.properties and hibernate.cfg.xml and.. roller works! sorry to waste your time, thank you, - eric Eric Pramono wrote: > > sorry, > > a slight copy-n'-paste mistake.. > > the hibernate.properties file should read as follows > > hibernate.connection.username=scott > hibernate.connection.password=tiger > hibernate.connection.url=jdbc:mysql://localhost/roller > hibernate.connection.driver_class=com.mysql.jdbc.Driver > hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect > > please help me, > thank you, > > - eric > > > Eric Pramono wrote: >> >> dear all, >> >> it's been 3 days of trying, reading, searching, downloading.. and now i >> really need some help >> >> i had followed all the instructions as best as i could, here's my >> configuration: >> >> jakarta-tomcat-5.5.9: >> - copied mysql-connector-java-3.0.17-ga-bin.jar to >> {catalina.home}/common/lib >> - verified that naming-factory-dbcp.jar existed in >> {catalina.home}/common/lib >> - created roller.xml in the {catalina.home}/conf/Catalina/localhost, with >> the following contents >> >> <Context path="/roller" docBase="${catalina.home}/webapps/roller" >> debug="0"> >> <Resource name="jdbc/rollerdb" auth="Container" >> type="javax.sql.DataSource" >> driverClassName="com.mysql.jdbc.Driver" >> url="jdbc:mysql://localhost:3306/roller?autoReconnect=true" >> username="scott" >> password="tiger" >> maxActive="20" >> maxIdle="3" >> removeAbandoned="true" >> maxWait="3000" /> >> </Context> >> >> - verified that roller.log has been created by Tomcat in the >> {catalina.home}/logs >> - copied the roller folder into {catalina.home}/webapps >> - no changes are made to the web.xml, it still has the following JNDI >> resource definition: >> >> <resource-ref> >> <res-ref-name>jdbc/rollerdb</res-ref-name> >> <res-type>javax.sql.DataSource</res-type> >> <res-auth>Container</res-auth> >> </resource-ref> >> >> - downloaded the required-jars-roller-3.0-incubating.tar from >> roller.dev.java.net >> - copied all the jars from that tar into roller/WEB-INF/lib >> - modified the roller.properties, to include the following entries: >> >> uploads.dir=D:/rollerdata/uploads >> search.index.dir=D:/rollerdata/search-index >> >> - both directories have been created in the filesystem >> - modified the hibernate.cfg.xml to include the following: >> >> <property >> name="connection.datasource">java:comp/env/jdbc/rollerdb</property> >> <property name="show_sql">false</property> >> <property >> name="hibernate.current_session_context_class">thread</property> >> <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://localhost:3306/roller?user=scott&password=tiger</property> >> <property name="hibernate.connection.username">scott</property> >> <property name="hibernate.connection.password">tiger</property> >> <property >> name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> >> >> - modified the hibernate.properties to: >> >> hibernate.connection.username=scott >> hibernate.connection.password=tiger >> hibernate.connection.url=jdbc:mysql:/roller >> hibernate.connection.driver_class=com.mysql.jdbc.Driver >> hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect >> >> mysql4.1 >> - followed exactly what the installation guide says >> >> when i tried to run the application, here's what i got: >> >> Mar 12, 2007 10:35:39 PM org.apache.catalina.core.StandardContext start >> SEVERE: Error filterStart >> Mar 12, 2007 10:35:39 PM org.apache.catalina.core.StandardContext start >> SEVERE: Context [/roller] startup failed due to previous errors >> Mar 12, 2007 10:35:39 PM org.apache.catalina.loader.WebappClassLoader >> loadClass >> INFO: Illegal access: this web application instance has been stopped >> already. C >> ould not load >> org.apache.roller.business.hibernate.HibernateWeblogManagerImpl. >> The eventual following stack trace is caused by an error thrown for >> debugging pu >> rposes as well as to attempt to terminate the thread which caused the >> illegal ac >> cess, and has no functional impact. >> >> and this is what the roller.log says: >> >> INFO 2007-03-12 22:35:22,609 RollerConfig:<clinit> - successfully loaded >> default properties. >> ... >> INFO 2007-03-12 22:35:23,953 UpgradeDatabase:upgradeDatabase - Database >> is current, no upgrade needed >> INFO 2007-03-12 22:35:25,187 Environment:<clinit> - Hibernate 3.1.2 >> INFO 2007-03-12 22:35:25,328 Environment:<clinit> - loaded properties >> from resource hibernate.properties: {hibernate.connection.username=scott, >> hibernate.connection.password=****, >> hibernate.cglib.use_reflection_optimizer=true, >> hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, >> hibernate.connection.url=jdbc:mysql:/roller, >> hibernate.connection.driver_class=com.mysql.jdbc.Driver} >> ... >> INFO 2007-03-12 22:35:26,781 Configuration:configure - configuring from >> resource: /hibernate.cfg.xml >> INFO 2007-03-12 22:35:26,796 Configuration:getConfigurationInputStream - >> Configuration resource: /hibernate.cfg.xml >> INFO 2007-03-12 22:35:27,515 Configuration:addResource - Reading >> mappings from resource: org/apache/roller/pojos/BookmarkData.hbm.xml >> INFO 2007-03-12 22:35:29,562 >> HbmBinder:bindRootPersistentClassCommonValues - Mapping class: >> org.apache.roller.pojos.BookmarkData -> bookmark >> ... >> INFO 2007-03-12 22:35:31,484 Configuration:addResource - Reading >> mappings from resource: >> org/apache/roller/pojos/PlanetGroupSubscriptionAssoc.hbm.xml >> INFO 2007-03-12 22:35:31,500 >> HbmBinder:bindRootPersistentClassCommonValues - Mapping class: >> org.apache.roller.pojos.PlanetGroupSubscriptionAssoc -> >> rag_group_subscription >> INFO 2007-03-12 22:35:31,500 Configuration:doConfigure - Configured >> SessionFactory: null >> INFO 2007-03-12 22:35:31,500 HbmBinder:bindCollectionSecondPass - >> Mapping collection: org.apache.roller.pojos.FolderData.bookmarks -> >> bookmark >> ... >> INFO 2007-03-12 22:35:31,515 HbmBinder:bindCollectionSecondPass - >> Mapping collection: >> org.apache.roller.pojos.PlanetSubscriptionData.entries -> rag_entry >> INFO 2007-03-12 22:35:31,562 NamingHelper:getInitialContext - JNDI >> InitialContext properties:{} >> INFO 2007-03-12 22:35:31,578 DatasourceConnectionProvider:configure - >> Using datasource: java:comp/env/jdbc/rollerdb >> INFO 2007-03-12 22:35:32,015 Dialect:<init> - Using dialect: >> org.hibernate.dialect.MySQLDialect >> INFO 2007-03-12 22:35:32,078 >> TransactionFactoryFactory:buildTransactionFactory - Using default >> transaction strategy (direct JDBC transactions) >> INFO 2007-03-12 22:35:32,125 >> TransactionManagerLookupFactory:getTransactionManagerLookup - No >> TransactionManagerLookup configured (in JTA environment, use of >> read-write or transactional second-level cache is not recommended) >> INFO 2007-03-12 22:35:32,140 SettingsFactory:buildSettings - Automatic >> flush during beforeCompletion(): disabled >> ... >> INFO 2007-03-12 22:35:32,562 SettingsFactory:buildSettings - Default >> entity-mode: pojo >> INFO 2007-03-12 22:35:33,218 SessionFactoryImpl:<init> - building >> session factory >> WARN 2007-03-12 22:35:33,734 EhCacheProvider:buildCache - Could not find >> configuration [org.apache.roller.pojos.BookmarkData]; using defaults. >> ... >> WARN 2007-03-12 22:35:36,765 EhCacheProvider:buildCache - Could not find >> configuration [org.apache.roller.pojos.FolderAssoc]; using defaults. >> INFO 2007-03-12 22:35:37,812 SessionFactoryObjectFactory:addInstance - >> Not binding factory to JNDI, no JNDI name configured >> INFO 2007-03-12 22:35:37,828 RollerFactory:setRoller - Using Roller >> Impl: org.apache.roller.business.hibernate.HibernateRollerImpl >> FATAL 2007-03-12 22:35:38,828 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:3669) >> ... >> FATAL 2007-03-12 22:35:38,828 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:3669) >> ... >> Caused by: 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) >> ... 28 more >> ERROR 2007-03-12 22:35:39,156 StandardContext:filterStart - Exception >> starting filter securityFilter >> java.lang.IllegalStateException: No WebApplicationContext found: no >> ContextLoaderListener registered? >> at >> org.springframework.web.context.support.WebApplicationContextUtils.getRequiredWebApplicationContext(WebApplicationContextUtils.java:84) >> at >> org.acegisecurity.util.FilterToBeanProxy.getContext(FilterToBeanProxy.java:169) >> at >> org.acegisecurity.util.FilterToBeanProxy.doInit(FilterToBeanProxy.java:111) >> at >> org.acegisecurity.util.FilterToBeanProxy.init(FilterToBeanProxy.java:181) >> at >> org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:225) >> ... >> INFO 2007-03-12 22:35:39,156 IPBanFilter:init - INIT IPBanFilter >> INFO 2007-03-12 22:35:39,203 CompressionFilter:init - Compressed Output >> ENABLED >> INFO 2007-03-12 22:35:39,500 RequestMappingFilter:init - Request mapping >> filter initialized, 1 mappers configured. >> INFO 2007-03-12 22:35:39,531 ReferrerQueueManagerImpl:<init> - >> Initializing Referrer Queue Manager >> INFO 2007-03-12 22:35:39,546 ReferrerQueueManagerImpl:<init> - >> Asynchronous referrer processing = false >> INFO 2007-03-12 22:35:39,546 CacheManager:<clinit> - Cache Manager >> Initialized. >> INFO 2007-03-12 22:35:39,546 CacheManager:<clinit> - Cache Factory = >> org.apache.roller.util.cache.ExpiringLRUCacheFactoryImpl >> INFO 2007-03-12 22:35:39,546 FuturePostingsInvalidationJob:input - >> Peeking 3 minutes into the future each pass >> INFO 2007-03-12 22:35:39,578 ContinuousWorkerThread:run - future >> invalidations thread Started. >> ERROR 2007-03-12 22:35:39,578 WorkerThread:run - Error executing job. >> Worker = future invalidations thread, Job = >> org.apache.roller.util.cache.FuturePostingsInvalidationJob >> java.lang.ThreadDeath >> at >> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1221) >> at >> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1181) >> at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) >> at >> org.apache.roller.business.hibernate.HibernateRollerImpl.getWeblogManager(HibernateRollerImpl.java:152) >> at >> org.apache.roller.util.cache.FuturePostingsInvalidationJob.execute(FuturePostingsInvalidationJob.java:74) >> at >> org.apache.roller.business.runnable.WorkerThread.run(WorkerThread.java:73) >> at >> org.apache.roller.business.runnable.ContinuousWorkerThread.run(ContinuousWorkerThread.java:83) >> INFO 2007-03-12 22:35:39,578 ContinuousWorkerThread:run - future >> invalidations thread INTERRUPT: sleep interrupted >> >> i appreciate any help/guidance from you all, >> thank you, >> >> - eric >> > > -- View this message in context: http://www.nabble.com/roller-3.0-installation-problem%2C-please-help-tf3390293s12275.html#a9437203 Sent from the Roller - User mailing list archive at Nabble.com.
