Re: [JBoss-user] Database connections

[David J. <dav...@di...>]

This method is correct.  In jboss 3 versions, you can even hold a
connection over method invocations without breaking pooling, although I do
not particularly recommend it. (also it will not currently work with
wrapped XADataSources) In jboss 2.x versions you must obtain and close
connections within one method and within one transaction.

david jencks

On 2002.07.22 13:26:05 -0400 Dimitri PISSARENKO wrote:
> Hello!
> 
> Although I'm using CMP beans, in some cases (primary key generation) I
> need to execute the SQL queries directly (that is, from within the
> bean).
> 
> I'm using the following code to get the database connection in such
> cases:
> 
> 
> 	    private Connection estabslishDatabaseConnection() throws
> NamingException, SQLException 
> 	    {
> 		Connection connection = null;
> 		InitialContext initialContext = new InitialContext();
> 		DataSource dataSource =
> (DataSource)initialContext.lookup("java:/MySqlDS");
> 		connection = dataSource.getConnection();
> 		return connection;
> 	    }
> 
> 
> If I do it in this way, do I not bypass the connection pooling
> mechanism of JBoss?
> 
> If I do, how should the code be changed to establish a database
> connection properly (that is, by using connection pooled by JBoss) ?
> 
> Thanks
> 
> Dimitri Pissarenko
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JBoss-user mailing list
> JBo...@li...
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
>