Re: Linux + Resin (v3.0) + Oracle New Installation Problem

Mon, 27 Nov 2006 08:35:54 -0800 


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" <[EMAIL PROTECTED]> 
To: <[email protected]>
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:[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

Reply via email to