ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Meindert" <meind...@pastelebusiness.com>
Subject RE: how to close connection iin iBATIS
Date Tue, 22 Jan 2008 16:03:26 GMT
Ok to reply to myself then.


I've 'fixed' it by using the shutdown property on my IBATIS Derby JDBC

I call the dangerous servlet below from my other application to kill IBATIS
database connection (for ever, the application has to be restarted)


  public String killMe() {

        try {

            DriverManager.getConnection("jdbc:derby:;shutdown=true", "",

        } catch (SQLException ex) {



         return null;



I tried to just shutdown the one database but that doesn't seem to work
(database not found error)




From: anika agarwal [mailto:scarlet_ani@yahoo.co.in] 
Sent: Tuesday, January 22, 2008 1:22 PM
To: user-java@ibatis.apache.org
Subject: Re: how to close connection iin iBATIS


Forcing the iBATIS to close the connection doesnt work.we have tried this at
our end.


----- Original Message ----
From: Meindert <meindert@pastelebusiness.com>
To: user-java@ibatis.apache.org
Sent: Tuesday, 22 January, 2008 3:51:22 PM
Subject: RE: how to close connection iin iBATIS

Hi Anika,


I'm having the same issue, am using Derby with IBATIS on my application.
Derby only one process to access it.

So I'll have to force IBATIS to close all connections before I can access it
from a other process.

My other process would be the database setup application that updates the


Is there a way to force/shut down the transaction manager via code?


Kind Regards

 Meindert Hoving



From: anika agarwal [mailto:scarlet_ani@yahoo.co..in] 
Sent: Tuesday, December 18, 2007 11:06 AM
To: user-java@ibatis.apache.org
Subject: how to close connection iin iBATIS



hi ,

we are using iBATIS for our application.Alhough iBATIS closes its connection
on its own ,still  we have certain open connection from our application
which is causing issues while running the application. We have configured
transaction manager in sqlMapConfig.xml like :


<transactionManager type="JDBC">

<dataSource type="SIMPLE">

<property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver" />

<property name="JDBC.ConnectionURL" value="ipaddress" />

<property name="JDBC.Username" value="username" />

<property name="JDBC.Password" value="pwd" />

<property name="JDBC.DefaultAutoCommit" value="true" />

<property name="Pool.MaximumActiveConnections" value="10" />

<property name="Pool.MaximumIdleConnections" value="5" />

<property name="Pool.MaximumCheckoutTime" value="120000" />

<property name="Pool.TimeToWait" value="500" />





Can any one suggest how to overcome this issue and how to close the
connection in iBATIS explicitly.






Get the freedom to save as many mails as you wish. Click here to know how.




Get the freedom to save as many mails as you wish. Click here to know how.



Meet people who discuss and share your passions. Join
them now..

View raw message