aspose file tools*
The moose likes JSP and the fly likes Ora Error in JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Ora Error in JSP" Watch "Ora Error in JSP" New topic
Author

Ora Error in JSP

Bob Kimmel
Greenhorn

Joined: Aug 27, 2003
Posts: 26
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

Joined: Aug 07, 2003
Posts: 49
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 ");


Nauman Khan <br />SCJP,MCSE,SCWCD,SCBCD,SCWCD1.4
Bob Kimmel
Greenhorn

Joined: Aug 27, 2003
Posts: 26
Got it thanks!
 
 
subject: Ora Error in JSP