Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Ora Error in JSP

 
Bob Kimmel
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a problem that I can't figure out with a SQL statement
which work fine in SQL but when place in my JSP I get:
org.apache.jasper.JasperException: ORA-00911: invalid character
Here it is in SQL:

Here it is in my code:


Any ideas? I had to Capitalize in the JSP or I got invalid
field names.
Thnks,
Bob
 
Nauman Khan
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Your query seems ok but remove semicolon in the last line of 1000,perhaps it works.
But I am not sure try query without semicolon from 1000; such as 1000
java.sql.ResultSet columns = statement.executeQuery(" \n" +"SELECT CCEVS_TECHNOLOGY_REGISTRY.TECHNOLOGY_ID, TECHNOLOGY_TYPES.TECHNOLOGY_NAME, \n" +"CCEVS_PROJECTs_REGISTRY.PROJECT_ID, CCEVS_PROJECTs_REGISTRY.PRODUCT_NAME, \n" +"CCEVS_PROJECTs_REGISTRY.EAL_ID, CCEVS_PROJECTs_REGISTRY.MSR, \n" +"CCEVS_PROJECTs_REGISTRY.PP_ST, CCEVS_PROJECTs_REGISTRY.STATUS, \n" +"CCEVS_PROJECTs_REGISTRY.HRS, CCEVS_PP_ASSIGNED_REGISTRY.PROJECT_ID, \n" +"CCEVS_PP_ASSIGNED_REGISTRY.PP_ID \n" +"FROM (CCEVS_PROJECTs_REGISTRY INNER JOIN (TECHNOLOGY_TYPES \n" +"INNER JOIN CCEVS_TECHNOLOGY_REGISTRY ON TECHNOLOGY_TYPES.TECHNOLOGY_ID \n" +"= CCEVS_TECHNOLOGY_REGISTRY.TECHNOLOGY_ID) on \n" +"CCEVS_PROJECTs_REGISTRY.PROJECT_ID = CCEVS_TECHNOLOGY_REGISTRY.PROJECT_ID) \n" +"INNER JOIN (PP_REGISTRY INNER JOIN CCEVS_PP_ASSIGNED_REGISTRY \n" +"ON PP_REGISTRY.PP_ID = CCEVS_PP_ASSIGNED_REGISTRY.PP_ID) \n" +"ON CCEVS_PROJECTs_REGISTRY.PROJECT_ID = CCEVS_PP_ASSIGNED_REGISTRY.PROJECT_ID \n" +"where CCEVS_PROJECTs_REGISTRY.PROJECT_ID = 1000 ");
 
Bob Kimmel
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Got it thanks!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic