How to free the Connection object being used in sql execution

Hi All,

I've a problem regarding to java connection object. I've created a connection object and then tried to call a server program that has taken a long time due to the long working specified in server program. So, do we have any mechanism to cancel the job being handled at server program so that i can free the connection resource held be server program for other purposes.

Thx. in advance.

[417 byte] By [Ahmad_22a] at [2007-11-26 22:55:06]

«« Using Properties File.Please help.
»» call stateless EJB3

# 1

just call close() on the connectionif you're using a connection pool, you'll have to read the associated docs on how to free the connection back to the pool

SoulTech2012a at 2007-7-10 12:19:25 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

Hi, I've used conn.close() using another thread (say thread2) so that i can release the connection object that is held by thread1. but this is also not working.Here what i m doing is: retrieving the connection from connection pool and then call close() on that connection.

Ahmad_22a at 2007-7-10 12:19:25 >

# 3

okay that is badwhen you use a pool you don't close connectionsyou need to return the connection to the pool to be recycled

SoulTech2012a at 2007-7-10 12:19:25 >

Database Connectivity

Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

How to free the Connection object being used in sql execution

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified