Hi friend,

To solve the problem do some changes :

1)create a "Statement" object in the while loop
Statement stmt= conn.createStatement();
2)"stmt" object closes in the while loop
stmt.close();


Connection conn;
while(true)
{
conn = DriverManager.getConnection(url+dbName,username,userPassword);
Statement stmt= conn.createStatement();
sqlstmt="SELECT * FROM tablename";
ResultSet rs=stmt.executeQuery(sqlstmt);
while(rs.next())
{
System.out.print("\n"+rs.getString(2));
}
rs.close(); // ResultSet object
stmt.close();
con.close(); //Connectuion object
}


For read more information :

http://www.roseindia.net/jdbc/

Thanks

Hi friend,


Read for more information.

http://www.roseindia.net/servlets/


Thanks.