You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Aaron Freeman <aa...@sendthisfile.com> on 2006/11/27 15:54:08 UTC
Linux + Resin (v3.0) + Oracle New Installation Problem
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:517)
[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(Datasour
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.java: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:57)
[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(DelegatingMethodAccessorImpl
.java:25)
[08:47:32.715] at java.lang.reflect.Method.invoke(Method.java:585)
[08:47:32.715] at
org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper
.invoke(ThreadLocalSessionContext.java:301)
[08:47:32.715] at $Proxy0.beginTransaction(Unknown Source) [08:47:32.715]
at
org.apache.roller.business.hibernate.HibernatePersistenceStrategy.getSession
(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.getPrope
rty(HibernatePropertiesManagerImpl.java:79)
[08:47:32.715] at
org.apache.roller.config.RollerRuntimeConfig.getProperty(RollerRuntimeConfig
.java:67)
[08:47:32.715] at
_jsp._WEB_22dINF._jsps._tiles._tiles_22dsimplepage__jsp._jspService(_tiles_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.java:159
)
[08:47:32.715] at
com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterChain.ja
va:115)
[08:47:32.715] at
com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:
229)
[08:47:32.715] at
com.caucho.server.webapp.RequestDispatcherImpl.include(RequestDispatcherImpl
.java:481)
[08:47:32.715] at
com.caucho.server.webapp.RequestDispatcherImpl.include(RequestDispatcherImpl
.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(InsertTag.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.java:159
)
[08:47:32.715] at
com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterChain.ja
va:115)
[08:47:32.715] at
com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:
229)
[08:47:32.715] at
com.caucho.server.webapp.RequestDispatcherImpl.forward(RequestDispatcherImpl
.java:273)
[08:47:32.715] at
com.caucho.server.webapp.RequestDispatcherImpl.error(RequestDispatcherImpl.j
ava:113)
[08:47:32.715] at
com.caucho.server.webapp.ErrorPageManager.sendServletError(ErrorPageManager.
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(ServletInvocation.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 UserConnection[com.caucho.sql.ManagedConnectionImpl@49b03] was
not closed. Connections must have a close() in a finally block.
[08:47:32.723] at
com.caucho.jca.UserTransactionImpl.abortTransaction(UserTransactionImpl.java
:466)
[08:47:32.723] at
com.caucho.jca.UserTransactionProxy.abortTransaction(UserTransactionProxy.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(ServletInvocation.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
Re: Linux + Resin (v3.0) + Oracle New Installation Problem
Posted by Anil Gangolli <an...@busybuddha.org>.
Oracle9Dialect is the appropriate setting for Oracle 9 and 10g.
The warning messages have more to do with Resin than Oracle.
The warnings you showed below suggests that either (a) you don't have the
filter "PersistenceSessionFilter" set up properly in the web.xml or (b) that
Resin is complaining about a connection that has not been returned to the
pool after a "FORWARD" dispatch but that may be getting returned to the pool
properly during returning back through the original "REQUEST" dispatch.
Are any other Resin 3.x users seeing this?
----- Original Message -----
From: "nicolas muller" <n....@nouvellemarque.com>
To: <ro...@incubator.apache.org>
Sent: Monday, November 27, 2006 7:31 AM
Subject: Re: Linux + Resin (v3.0) + Oracle New Installation Problem
> 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:n.muller@nouvellemarque.com]
>>> Sent: Monday, November 27, 2006 9:14 AM
>>> To: roller-user@incubator.apache.org
>>> 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
>>>>
>>> UserConnection[com.caucho.sql.ManagedConnectionImpl@49b03]
>>>
>>>> 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
>>>>
>>>>
>>>>
>>>>
>>
>>
>>
>
Re: Linux + Resin (v3.0) + Oracle New Installation Problem
Posted by Anil Gangolli <an...@busybuddha.org>.
Oracle9Dialect is the appropriate setting for Oracle 9 and 10g.
The warning messages have more to do with Resin than Oracle.
The warnings you showed below suggests that either (a) you don't have the
filter "PersistenceSessionFilter" set up properly in the web.xml or (b) that
Resin is complaining about a connection that has not been returned to the
pool after a "FORWARD" dispatch but that may be getting returned to the pool
properly during returning back through the original "REQUEST" dispatch.
Are any other Resin 3.x users seeing this?
----- Original Message -----
From: "nicolas muller" <n....@nouvellemarque.com>
To: <ro...@incubator.apache.org>
Sent: Monday, November 27, 2006 7:31 AM
Subject: Re: Linux + Resin (v3.0) + Oracle New Installation Problem
> 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:n.muller@nouvellemarque.com]
>>> Sent: Monday, November 27, 2006 9:14 AM
>>> To: roller-user@incubator.apache.org
>>> 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
>>>>
>>> UserConnection[com.caucho.sql.ManagedConnectionImpl@49b03]
>>>
>>>> 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
>>>>
>>>>
>>>>
>>>>
>>
>>
>>
>
Re: Linux + Resin (v3.0) + Oracle New Installation Problem
Posted by nicolas muller <n....@nouvellemarque.com>.
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:n.muller@nouvellemarque.com]
>> Sent: Monday, November 27, 2006 9:14 AM
>> To: roller-user@incubator.apache.org
>> 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
>>>
>> UserConnection[com.caucho.sql.ManagedConnectionImpl@49b03]
>>
>>> 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
>>>
>>>
>>>
>>>
>
>
>
RE: Linux + Resin (v3.0) + Oracle New Installation Problem
Posted by Aaron Freeman <aa...@layerz.com>.
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:n.muller@nouvellemarque.com]
> Sent: Monday, November 27, 2006 9:14 AM
> To: roller-user@incubator.apache.org
> 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
> UserConnection[com.caucho.sql.ManagedConnectionImpl@49b03]
> > 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
> >
> >
> >
>
Re: Linux + Resin (v3.0) + Oracle New Installation Problem
Posted by nicolas muller <n....@nouvellemarque.com>.
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:517)
> [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(Datasour
> 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.java: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:57)
> [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(DelegatingMethodAccessorImpl
> .java:25)
> [08:47:32.715] at java.lang.reflect.Method.invoke(Method.java:585)
> [08:47:32.715] at
> org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper
> .invoke(ThreadLocalSessionContext.java:301)
> [08:47:32.715] at $Proxy0.beginTransaction(Unknown Source) [08:47:32.715]
> at
> org.apache.roller.business.hibernate.HibernatePersistenceStrategy.getSession
> (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.getPrope
> rty(HibernatePropertiesManagerImpl.java:79)
> [08:47:32.715] at
> org.apache.roller.config.RollerRuntimeConfig.getProperty(RollerRuntimeConfig
> .java:67)
> [08:47:32.715] at
> _jsp._WEB_22dINF._jsps._tiles._tiles_22dsimplepage__jsp._jspService(_tiles_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.java:159
> )
> [08:47:32.715] at
> com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterChain.ja
> va:115)
> [08:47:32.715] at
> com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:
> 229)
> [08:47:32.715] at
> com.caucho.server.webapp.RequestDispatcherImpl.include(RequestDispatcherImpl
> .java:481)
> [08:47:32.715] at
> com.caucho.server.webapp.RequestDispatcherImpl.include(RequestDispatcherImpl
> .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(InsertTag.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.java:159
> )
> [08:47:32.715] at
> com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterChain.ja
> va:115)
> [08:47:32.715] at
> com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:
> 229)
> [08:47:32.715] at
> com.caucho.server.webapp.RequestDispatcherImpl.forward(RequestDispatcherImpl
> .java:273)
> [08:47:32.715] at
> com.caucho.server.webapp.RequestDispatcherImpl.error(RequestDispatcherImpl.j
> ava:113)
> [08:47:32.715] at
> com.caucho.server.webapp.ErrorPageManager.sendServletError(ErrorPageManager.
> 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(ServletInvocation.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 UserConnection[com.caucho.sql.ManagedConnectionImpl@49b03] was
> not closed. Connections must have a close() in a finally block.
> [08:47:32.723] at
> com.caucho.jca.UserTransactionImpl.abortTransaction(UserTransactionImpl.java
> :466)
> [08:47:32.723] at
> com.caucho.jca.UserTransactionProxy.abortTransaction(UserTransactionProxy.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(ServletInvocation.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
>
>
>