I am getting a problem in running a sql query through netbeans 7.0 for getting information from specified table. when i a firing select query using statement or PreparedStatement without using where clause , there is no any error ,but when i am trying to get conditional information using where clause exception is generating.
here is code that i am using :
PreparedStatement ps=con.prepareStatement("select * from studentperdetail where classcheck=?");
ps.setString(1,"cmca04");
res=ps.executeQuery();
ResultSetMetaData mdata=res.getMetaData();
int columnnumber=mdata.getColumnCount();
int row=0;
while(res.next())
row++;
res.beforeFirst();
String rows[][]=new String[row][columnnumber];
String column[]={"Name","Father Name","Enrollment Number","Admission NO"};
int rowcount=0;
while(res.next())
{
rows[rowcount][0]=res.getString(1);
rows[rowcount][1]=res.getString(2);
rows[rowcount][2]=res.getString(3);
rows[rowcount][3]=res.getString(4);
rowcount++;
}
javax.swing.table.TableModel dtm=new javax.swing.table.DefaultTableModel(rows,column);
JTable jt=new JTable(dtm);
classrecord.add(new JScrollPane(jt),BorderLayout.WEST);
program.
error is
"
Exception in thread "main" java.sql.SQLException: ORA-00904: "CLASSCHECK": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at teacher.info.manager.pkg1.pkg0.removerecord.<init>(removerecord.java:128)
at teacher.info.manager.pkg1.pkg0.TeacherInfoManager10.main(TeacherInfoManager10.java:27)
Java Result: 1
"
please help me to solve this problem.