Thanks.I thought max connection is used for different dataContext connections.
>
> Kimden: Andrus Adamchik <andru..bjectstyle.org>
> Tarih: 2006/03/14 Tue PM 05:04:39 GMT+02:00
> Kime: cayenne-use..bjectstyle.org
> Konu: Re: Request timed out SQLException
>
> Try increasing "max connections" setting for the DataNode in the
> Modeler. The default is "1", and from the error message I see that
> you left it unchanged. Try setting it to 2 or higher.
>
> Andrus
>
>
> On Mar 14, 2006, at 4:57 PM, <emre.yilma..r.net>
> <emre.yilma..r.net> wrote:
>
> > Hi,
> >
> > I get an exception of java.sql.SQLException.I check the MsSql 7.0
> > polling
> > interval which is 10 seconds. But when I use the
> > context.commitChanges() in a
> > TimerTask rarely I get this exception. Is there any way to handle this
> > exception with cayenne or any advice you have?
> >
> > Exception :
> >
> > java.sql.SQLException: Can't obtain connection. Request timed out.
> > Total used
> > connections: 1
> > at org.objectstyle.cayenne.conn.PoolManager.uncheckPooledConnection
> > (PoolManager.java:466)
> > at org.objectstyle.cayenne.conn.PoolManager.getConnection
> > (PoolManager.java:392)
> > at org.objectstyle.cayenne.conn.PoolManager.getConnection
> > (PoolManager.java:385)
> > at org.objectstyle.cayenne.access.DataNode
> > $TransactionDataSource.getConnection
> > (DataNode.java:589)
> > at org.objectstyle.cayenne.access.DataNode.performQueries
> > (DataNode.java:301)
> > at org.objectstyle.cayenne.access.DataDomainCommitAction.commit
> > (DataDomainCommitAction.java:180)
> > at org.objectstyle.cayenne.access.DataDomain.onSync
> > (DataDomain.java:750)
> > at org.objectstyle.cayenne.access.DataContext.doCommitChanges
> > (DataContext.java:
> > 1115)
> > at org.objectstyle.cayenne.access.DataContext.commitChanges
> > (DataContext.java:
> > 1081)
> > at tr.com.htr.hgys.db.AccessPersonelLogs.insertAccessLogs
> > (AccessPersonelLogs.
> > java:27)
> > at tr.com.htr.hgys.core.AccesLogRecorder.validPersonelEntrance
> > (AccesLogRecorder.java:37)
> > at tr.com.htr.hgys.core.AccesLogRecorder.validCardEntrance
> > (AccesLogRecorder.
> > java:24)
> > at tr.com.htr.hgys.core.access.MagneticDoorAccess
> > $DoorCloseReminder.run
> > (MagneticDoorAccess.java:128)
> > at java.util.TimerThread.mainLoop(Unknown Source)
> > at java.util.TimerThread.run(Unknown Source)
> > Exception in thread "Timer-6"
> > org.objectstyle.cayenne.CayenneRuntimeException:
> > [v.1.2M11 February 13 2006] Commit Exception
> > at org.objectstyle.cayenne.access.DataContext.doCommitChanges
> > (DataContext.java:
> > 1125)
> > at org.objectstyle.cayenne.access.DataContext.commitChanges
> > (DataContext.java:
> > 1081)
> > at tr.com.htr.hgys.db.AccessPersonelLogs.insertAccessLogs
> > (AccessPersonelLogs.
> > java:27)
> > at tr.com.htr.hgys.core.AccesLogRecorder.validPersonelEntrance
> > (AccesLogRecorder.java:37)
> > at tr.com.htr.hgys.core.AccesLogRecorder.validCardEntrance
> > (AccesLogRecorder.
> > java:24)
> > at tr.com.htr.hgys.core.access.MagneticDoorAccess
> > $DoorCloseReminder.run
> > (MagneticDoorAccess.java:128)
> > at java.util.TimerThread.mainLoop(Unknown Source)
> > at java.util.TimerThread.run(Unknown Source)
> >
> > My code:
> >
> > class Reminder extends TimerTask {
> > public void run() {
> > AccessPersonelLogs newAccessLogs = (AccessPersonelLogs)
> > context.createAndRegisterNewObject(AccessPersonelLogs.class);
> >
> > newAccessLogs.setTime(ts);
> > newAccessLogs.setDeviceRel(device);
> > newAccessLogs.setPersonelRel(personel);
> > newAccessLogs.setLogTypeRel(type);
> > newAccessLogs.setExcuseResonRel(reason);
> >
> > context.commitChanges();
> > }
> > }
> >
> > Thanks..
> >
> >
>
>
>
This archive was generated by hypermail 2.0.0 : Tue Mar 14 2006 - 10:56:30 EST