Hi,

I am writing a java service which will be deployed in Jboss server which will establish an oracle database connection.
The following code will obtain a connection from the connection pool in Jboss:

InitialContext ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup(jdbcName);
Connection conn = ds.getConnection();

If the connection is available, the available connection will be returned.
However, if let's say if the database server is down, the following codes will take a very long time to throw an Exception. Is there anyway for me to set a configurable timeout value as I want it to be configurable via the service?

Any help is appreciated.
Thanks