Basic Java question regarding objects initialization 1

[thelordoftherings]

Hello,

When I am writing this code:

Connection connection;

try
{

connection = DriverManager.getConnection...
}
catch( SQLException e )
{
e.printStackTrace();
}
finally
{
try
{
connection.close();
}
catch( SQLException e )
{
e.printStackTrace();
}
}


I receive a complitation error on this line: connection.close(): "Connection may have not have been initialized". But of course it may not have been initialized, this is why the try...catch are for. So why am I receiving this error?

Roy

 

[sedj]

Because is the call to DriverManager.getConnection() fails - then "connection" object will not have been initialized - which would cause an error in the finally block.

Do :

Connection connection = null;

You should also say :

if (connection != null) connection.close();

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[thelordoftherings]

10X sedj