Grouper Developers Forum

["GW Brown, Information Systems and Computing" <>]

Allen,

It may be that the code is unable to connect to the database - or is very 
slow in doing so. There are a number of settings in 
grouper.hibernate.properties prefixed hibernate.c3p0. which control how the 
connection pool behaves - and links to the relevant documentation.

Are you using v1.3.0? Which database are you using? If you run the default 
HSQLDB database created by Grouper it only allows one connection - you need 
to run it as a server to allow >1 connection.

Gary

--On 22 July 2008 16:11 +0800 Allen Chen 
<>
 wrote:

> Every time I use the Grouper session, the following exception will happen
> time after time :
>
> 2008-07-22 15:39:37,562: SQL Error: 0, SQLState: null
> 2008-07-22 15:39:37,562: An attempt by a client to checkout a Connection
> has timed out.
> 2008-07-22 15:39:37,562: Exception in uniqueResult: (class
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO),
> ByHqlStatic, query: 'from Hib3MemberDAO as m where      m.subjectId
> = :sid    and  m.subjectSourceId = :source and  m.subjectTypeId   =
> :type', cacheable: true, cacheRegion:
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySu
> bject, tx type: nullBind var[0]: 'Param (class java.lang.String):
> 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String):
> 'type'->'application'Bind var[2]: 'Param (class java.lang.String):
> 'source'->'g:isa',
> edu.internet2.middleware.grouper.internal.dao.GrouperDAOException:
> Problem in HibernateSession: HibernateSession: isNew: true, isReadonly:
> true, grouperTransactionType: READONLY_NEW
> at
> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHiber
> nateSession(HibernateSession.java:263)
> at
> edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHql
> Static.java:197)
> at
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySu
> bject(Hib3MemberDAO.java:168)
> at
> edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubj
> ect(MemberFinder.java:183)
> at
> edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(Memb
> erFinder.java:176)
> at
> edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java
> :107)
> at
> edu.grouper.support.GrouperInitServer.onCalled(GrouperInitServer.java:38)
> .........
> at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWork
> er(ThreadPoolExecutor.java:987)
> at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.
> run(ThreadPoolExecutor.java:528)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: org.hibernate.exception.GenericJDBCException: Cannot open
> connection
> at
> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQL
> StateConverter.java:103)
> at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:
> 91)
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.j
> ava:43)
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.j
> ava:29)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.jav
> a:424)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java
> :144)
> at
> org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.
> java:139)
> at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1538)
> at org.hibernate.loader.Loader.doQuery(Loader.java:661)
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader
> .java:224)
> at org.hibernate.loader.Loader.doList(Loader.java:2211)
> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
> at org.hibernate.loader.Loader.list(Loader.java:2090)
> at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
> at
> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:3
> 38)
> at
> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172
> )
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
> at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
> at
> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:
> 811)
> at
> edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlSt
> atic.java:204)
> at
> edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHiber
> nateSession(HibernateSession.java:211)
> ... 59 more
> Caused by: java.sql.SQLException: An attempt by a client to checkout a
> Connection has timed out.
> at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)
> at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
> at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnectio
> n(C3P0PooledConnectionPool.java:262)
> at
> com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSour
> ce.java:94)
> at
> org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0Connect
> ionProvider.java:56)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.jav
> a:421)
> ... 75 more
> Caused by: com.mchange.v2.resourcepool.TimeoutException: internal --
> timeout at awaitAcquire()
> at
> com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourceP
> ool.java:970)
> at
> com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResou
> rcePool.java:208)
> at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnectio
> n(C3P0PooledConnectionPool.java:260)
> ... 78 more
> 2008-07-22 15:39:37,578:
> [cn.edu.scut.grouper.support.mule.GrouperInitServer] Problem in
> HibernateSession: HibernateSession: isNew: true, isReadonly: true,
> grouperTransactionType: READONLY_NEW
>
>
>
> the session used in my code is as follows:
>
>
> GrouperSession session = null;
> try {
> session = GrouperSession.start(SubjectFinder.findById("GrouperSystem",
> "application", InternalSourceAdapter.ID));
>
>
> // using the session to do something
>
> } catch (Exception e) {
> ErrorLog.error(this.getClass(), e.getMessage());
> return "Exception happened:"+e.getMessage();
> }finally{
> GrouperSession.stopQuietly(session);
> }
>
> I search on Google, it's said that there's something wrong with c3po.
> Do the grouper developers notice this bug and fix it already?
>
>
> __________________________________________________
>
> Allen Chen
> 2008-07-22



----------------------
GW Brown, Information Systems and Computing