good question. For the moment I have never used Oracle 10g and Hibernate. So I don't know if it is good.
http://forums.hibernate.org/viewtopic.php?p=2295650&sid=9e91fae3feffa76359de9910a879528e Best regards, Aaron Freeman a écrit : > 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 >>> >>> >>> >>> > > >
