struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vic Cekvenich <>
Subject Re: ibatis and jndi pooling
Date Tue, 27 Jul 2004 19:31:36 GMT
josh wrote:
> I am trying to figure out how to use sqlmaps and struts.  Before sqlMaps
> I would create a connection to the database using a plugin.  In my
> init() I did something like this
> this.ds = (DataSource) context.lookup("java:comp/env/" + lookupString);
> This gave me a datasource object that I could use for my app, and I
> could close the connection in the destroy() method of the plugin to be
> sure that my connections would get closed up if tomcat were to be
> restarted.
> Now that I use sqlMaps I still use a plugin, but there is no equivalent
> close function to use in the destroy() method of the plugin. 

It's becuase SQL maps does it for you!

You should try it just making connections in SQL maps for now.
Then, if you want move to having container making a DataSourcePool and 
SQLMaps just using that pool.

  This means
> that if I remove my app from the server or restart it the old DB
> connection gets orphaned but doesn't die.  And meanwhile my app gets a
> new connection to the DB.  How do other people deal with this?  Am I
> doing this completely wrong?  I can't find anything in the sqlMaps
> documentation about this.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message