Databases
StackOverflow2013
Postsdbo
POSQLException: Invalid Column Name...?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQLException: Invalid Column Name...?
    text
    copied!<p>I have a JSP file which I am deploying within a Java Project with the help of Eclipse, Maven, and Tomcat. I've got a few other JSP files almost identical to this one, though they run different operations. Anyway, when I go to the page, I've given this:</p> <pre><code>org.apache.jasper.JasperException: An exception occurred processing JSP page /entertime2.jsp at line 106 103: rsBug = psBug.executeQuery(); 104: 105: while(rsBug.next()) { 106: Bug b = new Bug(rsBug); 107: out.println("&lt;option value='" + b.get(Bug.BUG_ID) + "'&gt;" + b.get(Bug.TITLE) + "&lt;/option&gt;"); 108: } 109: rsBug.close(); root cause javax.servlet.ServletException: java.sql.SQLException: Invalid column name ixPersonOpenedBy. </code></pre> <p>Bug is a custom class that can take in a result set -- <code>rsBug</code> -- and performs the following operations:</p> <pre><code>setValue(Bug.BUG_ID,rs.getString(Bug.BUG_ID)); setValue(Bug.PERSON_OPENED_BY,rs.getString(Bug.PERSON_OPENED_BY)); setValue(Bug.PERSON_ASSIGNED_TO,rs.getString(Bug.PERSON_ASSIGNED_TO)); setValue(Bug.TITLE, rs.getString(Bug.TITLE)); setValue(Bug.PROJECT_ID,rs.getString(Bug.PROJECT_ID)); </code></pre> <p>Where BUG_ID, PERSON_OPENED_BY, PERSON_ASSIGNED_TO, TITLE, and PROJECT_ID are all string members of the Bug class that correspond to the column names within the Bug table stored in the database. Now, there is a <code>ixPersonOpenedBy</code> column in the table, but it's never given me any problems before. I'm not sure if it has anything to do with the SQL statement I try to execute or not, but I've used the EXACT same statement before in one of my other JSP's and it hasn't given me any trouble. In addition, this error wasn't popping up in earlier deployments of the project. I had a typo in an unrelated variable, and once it was fixed, this guy popped up outta nowhere.</p> <p>Anyway, can anyone see why this error would be given when I know the column "should" be valid? If you need to see more of the JSP, the Bug Class, or the Bug Table within the database, just let me know; any help is appreciated.</p> <p>EDIT: Here are the two SQL statements I'm using, but I'm not sure if either are causing the problem.</p> <pre><code>SELECT p.ixPerson, p.sFullName FROM Person p, jwTeamMembers t WHERE p.ixPerson = t.ixPerson ORDER BY p.sFullName ASC SELECT b.ixBug, b.sTitle FROM Bug b, Person per, Project p, Area a, jwTime t, jwTeamMembers m, jwTeam jt, Status s, jwDivision d WHERE per.ixPerson = t.ixPerson AND t.ixBug = b.ixBug AND b.ixProject = p.ixProject AND b.ixArea = a.ixArea AND per.ixPerson = m.ixPerson AND m.ixTeam = jt.ixTeam AND b.ixStatus = s.ixStatus AND a.ixDivision *= d.ixDivision AND (per.ixPerson = ?) GROUP BY b.ixBug, b.sTitle ORDER BY b.ixBug DESC </code></pre> <p>The parameter in the second statement is filled with:</p> <pre><code>psBug.setInt(1, Integer.valueOf(personId).intValue()); </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload