Well I swapped it for this line: <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
But I am using Oracle 10g instead of Oracle 9. Think that makes a difference? Is there a Oracle10Dialect? I don't even know what hibernate is. :) Thanks for you help on this. Aaron > -----Original Message----- > From: nicolas muller [mailto:[EMAIL PROTECTED] > Sent: Monday, November 27, 2006 9:14 AM > To: [email protected] > Subject: Re: Linux + Resin (v3.0) + Oracle New Installation Problem > > Hello, > > Are you sure to have the good dialect for Hibernate in the > config file > (hibernate.cfg.xml) ? By default, it is this for Mysql and > you are working with Oracle. > It's my favorite error (for me :-)) > > Best regards, > > Aaron Freeman a écrit : > > I am trying to install v3.0 of Roller for the first time > with a Linux > > + Resin + Oracle setup. I didn't have any problems with the > > installation, and was able to create a user. However, when > I try to > > login I get an "unexpected exception" and the following stack trace: > > > > [08:47:32.710] [WARNING-UserTransactionImpl] Closing > dangling connections. > > All connections must have a close() in a finally block. > > [08:47:32.715] [WARNING-UserTransactionImpl] > > java.lang.IllegalStateException: unclosed connection: > > UserPoolItem[jdbc/rollerdb,1763] was allocated at [08:47:32.715] at > > com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:112) > > [08:47:32.715] at > > com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:118) > > [08:47:32.715] at > com.caucho.jca.PoolItem.toActive(PoolItem.java:256) > > [08:47:32.715] at > > com.caucho.jca.ConnectionPool.allocateIdle(ConnectionPool.java:736) > > [08:47:32.715] at > > com.caucho.jca.ConnectionPool.allocatePool(ConnectionPool.java:655) > > [08:47:32.715] at > > com.caucho.jca.ConnectionPool.allocate(ConnectionPool.java:620) > > [08:47:32.715] at > > > com.caucho.jca.ConnectionPool.allocateConnection(ConnectionPool.java:5 > > 17) > > [08:47:32.715] at > > com.caucho.sql.DataSourceImpl.getConnection(DataSourceImpl.java:65) > > [08:47:32.715] at > > com.caucho.sql.DBPool.getConnection(DBPool.java:602) > > [08:47:32.715] at > > > org.hibernate.connection.DatasourceConnectionProvider.getConnection(Da > > tasour > > ceConnectionProvider.java:69) > > [08:47:32.715] at > > > org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager. > > java:3 > > 60) > > [08:47:32.715] at > > > org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.j > > ava:12 > > 2) > > [08:47:32.715] at > > org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:125) > > [08:47:32.715] at > > > org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:5 > > 7) > > [08:47:32.715] at > > > org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1309) > > [08:47:32.715] at > > sun.reflect.GeneratedMethodAccessor22.invoke(Unknown > > Source) [08:47:32.715] at > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess > > orImpl > > .java:25) > > [08:47:32.715] at java.lang.reflect.Method.invoke(Method.java:585) > > [08:47:32.715] at > > > org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionW > > rapper > > .invoke(ThreadLocalSessionContext.java:301) > > [08:47:32.715] at $Proxy0.beginTransaction(Unknown Source) > > [08:47:32.715] at > > > org.apache.roller.business.hibernate.HibernatePersistenceStrategy.getS > > ession > > (HibernatePersistenceStrategy.java:83) > > [08:47:32.715] at > > > org.apache.roller.business.hibernate.HibernatePersistenceStrategy.load > > (Hiber > > natePersistenceStrategy.java:153) > > [08:47:32.715] at > > > org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.ge > > tPrope > > rty(HibernatePropertiesManagerImpl.java:79) > > [08:47:32.715] at > > > org.apache.roller.config.RollerRuntimeConfig.getProperty(RollerRuntime > > Config > > .java:67) > > [08:47:32.715] at > > > _jsp._WEB_22dINF._jsps._tiles._tiles_22dsimplepage__jsp._jspService(_t > > iles_2 > > 2dsimplepage__jsp.java:79) > > [08:47:32.715] at com.caucho.jsp.JavaPage.service(JavaPage.java:60) > > [08:47:32.715] at com.caucho.jsp.Page.pageservice(Page.java:570) > > [08:47:32.715] at > > > com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.ja > > va:159 > > ) > > [08:47:32.715] at > > > com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterCh > > ain.ja > > va:115) > > [08:47:32.715] at > > > com.caucho.server.dispatch.ServletInvocation.service(ServletIn > vocation.java: > > 229) > > [08:47:32.715] at > > > com.caucho.server.webapp.RequestDispatcherImpl.include(RequestDispatch > > erImpl > > .java:481) > > [08:47:32.715] at > > > com.caucho.server.webapp.RequestDispatcherImpl.include(RequestDispatch > > erImpl > > .java:346) > > [08:47:32.715] at > > com.caucho.jsp.PageContextImpl.include(PageContextImpl.java:923) > > [08:47:32.715] at > > com.caucho.jsp.PageContextImpl.include(PageContextImpl.java:860) > > [08:47:32.715] at > > > org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:101 > > ) > > [08:47:32.715] at > > org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:137) > > [08:47:32.715] at > > > org.apache.struts.taglib.tiles.InsertTag.doInclude(InsertTag.java:758) > > [08:47:32.715] at > > > org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag(Insert > > Tag.ja > > va:890) > > [08:47:32.715] at > > > org.apache.struts.taglib.tiles.InsertTag.doEndTag(InsertTag.java:460) > > [08:47:32.715] at > > _jsp._WEB_22dINF._jsps._error__jsp._jspService(_error__jsp.java:132) > > [08:47:32.715] at com.caucho.jsp.JavaPage.service(JavaPage.java:60) > > [08:47:32.715] at com.caucho.jsp.Page.pageservice(Page.java:570) > > [08:47:32.715] at > > > com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.ja > > va:159 > > ) > > [08:47:32.715] at > > > com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterCh > > ain.ja > > va:115) > > [08:47:32.715] at > > > com.caucho.server.dispatch.ServletInvocation.service(ServletIn > vocation.java: > > 229) > > [08:47:32.715] at > > > com.caucho.server.webapp.RequestDispatcherImpl.forward(RequestDispatch > > erImpl > > .java:273) > > [08:47:32.715] at > > > com.caucho.server.webapp.RequestDispatcherImpl.error(RequestDispatcher > > Impl.j > > ava:113) > > [08:47:32.715] at > > > com.caucho.server.webapp.ErrorPageManager.sendServletError(Err > orPageManager. > > java:363) > > [08:47:32.715] at > > > com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain. > > java:1 > > 80) > > [08:47:32.715] at > > > com.caucho.server.dispatch.ServletInvocation.service(ServletIn > vocation.java: > > 229) > > [08:47:32.715] at > > > com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:268) > > [08:47:32.715] at > > com.caucho.server.port.TcpConnection.run(TcpConnection.java:389) > > [08:47:32.715] at > > com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492) > > [08:47:32.715] at > com.caucho.util.ThreadPool.run(ThreadPool.java:425) > > [08:47:32.715] at java.lang.Thread.run(Thread.java:595) > > [08:47:32.715] > > [08:47:32.723] [WARNING-Application] > java.lang.IllegalStateException: > > Connection > [EMAIL PROTECTED] > > was not closed. Connections must have a close() in a finally block. > > [08:47:32.723] at > > > com.caucho.jca.UserTransactionImpl.abortTransaction(UserTransactionImp > > l.java > > :466) > > [08:47:32.723] at > > > com.caucho.jca.UserTransactionProxy.abortTransaction(UserTransactionPr > > oxy.ja > > va:174) > > [08:47:32.723] at > > > com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain. > > java:1 > > 98) > > [08:47:32.723] at > > > com.caucho.server.dispatch.ServletInvocation.service(ServletIn > vocation.java: > > 229) > > [08:47:32.723] at > > > com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:268) > > [08:47:32.723] at > > com.caucho.server.port.TcpConnection.run(TcpConnection.java:389) > > [08:47:32.723] at > > com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492) > > [08:47:32.723] at > com.caucho.util.ThreadPool.run(ThreadPool.java:425) > > [08:47:32.723] at java.lang.Thread.run(Thread.java:595) > > > > Any ideas on how to troubleshoot this? > > > > Thanks > > > > Aaron > > > > Aaron Freeman > > www.SendThisFile.com > > (316) 722-8808 > > > > > > >
