File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Invalid Column Name Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Invalid Column Name" Watch "Invalid Column Name" New topic
Author

Invalid Column Name

Ignatius Reilly
Greenhorn

Joined: Jun 20, 2013
Posts: 1
Hi,

Am new to JSP, but basically have copied an existing JSP and added by own SQL query and changed columns names etc to match.

However my query extracts the information contained within a few xml nodes and works fine in oracle, however when in the JSP I get an invalid column name.

The JSP is fine when I amend the query within it and remove the the XML parts of it.

Is it possible to have SQL selects such as the below


" substr(M.xml, instr(M.XML, '<Description enabled="1">') + 25, instr(M.xml, '</Description>') - (instr(M.XML, '<Description enabled="1">') + 25)) DEPTNAME, "

Is the below get string incorrect?

<TD align="right"> <%=rs.getString("DEPTNAME")%></TD>

Hope that makes sense, as I said am a rank amatuer when it comes to JSP.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Invalid Column Name
 
Similar Threads
Unable to insert foreign key values..
Query calls terminating without error... just ending-
Pagination using display tag and JSTL.Display problem
Hibernate native sql problem
Displaying the right details of a resource taken from a JSP results page