Click here to Skip to main content
15,905,877 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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 :
Java
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.
Posted
Comments
[no name] 18-May-14 8:45am    
http://www.techonthenet.com/oracle/errors/ora00904.php
sr45687845 18-May-14 8:56am    
thanks for replay , i navigate your provide url , here it is mentioned that this error come when column name is missed some spelling or refereed column name is not available but in my program i have rechecked it and i have neither missed spelling nor use wrong column name however i am still getting the same problem.
[no name] 18-May-14 9:19am    
Well I sure don't know what to tell you. That is what the error means and I have no idea what is in your database.
baliram bhande 19-May-14 3:05am    
check the data base column name means classcheck is present or not

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900