jdbc connectivity

[kaleeswaran]

hi!
i am started to connect jdbc driver with my java program..
i am using proper systax in my java program for connecting jdbc driver but i face the problem like this:
[Microsoft][ODBC Driver Manager] Invalid cursor stat..
this my java code:
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection"jdbc:odbc:sample","kal eeswaran","kalees");
Statement stat = conn.createStatement();
ResultSet res = stat.executeQuery("Select * from customers");
ResultSetMetaData d=res.getMetaData();
int co=d.getColumnCount();
while(res.next());
{
for(int i=1;i<=co;i++)
{
System.out.println(res.getObject(i)+" ");
System.out.println();
}
conn.close();
}
i hope i am getting immediate reply,
thank you,

[dmjpro]

do one thing .....

insert System.out.println(message) before and after the line .....
ResultSetMetaData d=res.getMetaData();

then tell me what prints and what not.......

and do one more thing ... check out the table whether it contains data or not.

best of luck
kind regards.

[kaleeswaran]

Thank you for replay me!..
i found my mistake...
i was put a semicolon in my while statement that's the problem..
thank you,

[dmjpro]

that means exausted resultset causes this error.