error in prepared statement

[nadeem akhtar]

import java.sql.*;

public class Assignment{

public static void main ( String args[]){

try{

	Class.forName("jdbc.odbc.JdbcOdbcDriver");

String url = "jdbc:odbc:bankDSN";

	Connection con= null;

	 con= DriverManager.getConnection(url,"","");


String sql = "SELECT * FROM Account";

PreparedStatement pStmt= con.prepateStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);



ResultSet rs = pStmt.executeQuery();

	ResultSetMetaData rsmd = rs.getMetaData( );

int numColumns = rsmd.getColumnCount();

	String cName;

for(int i =1; i<numColumns;i++)

{
	cName = rsmd.getColumnName(i);
	System.out.println(cName);
	System.out.println("\t");

}

System.out.println(" ");
int AccountNo,AccountBal;
String ActHolderName,ActType;
while(rs.next( ))
{

	AccountNo = rs.getInt(1);
	ActHolderName= rs.getString(2);
	ActType= rs.getString(3);
	AccountBal= rs.getInt(4);


	System.out.println(AccountNo);
	System.out.println("\t");


	System.out.println(ActHolderName);
	System.out.println("\t");


	System.out.println(ActType);
	System.out.println("\t");


	System.out.println(AccountBal);
	System.out.println("\t");	
	System.out.println(" ");
}

	con.close();
}catch(Exception sqlEx){
System.out.println(sqlEx);
}

}
}

[Rob Camick]

Why did you create a new posting?

You can edit your original question. And while your at it, use the "Code" tags so your code is formatted and readable.

And you still haven't stated what the actual compile/runtime error is.

[Misha Ver]

Please use code tags - http://faq.javaranch.com/java/UseCodeTags , it is hard to read your code. It would be better if you tell the details of the error http://faq.javaranch.com/java/TellTheDetails

By the way you have the misprint in this line

PreparedStatement pStmt= con.prepateStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 

[Jeanne Boyarsky]

Is this the exact code you used? "prepateStatement" has a typo and wouldn't compile.

As pointed out above, you want to TellTheDetails so people can help you with your actual error rather than speculate about it.