🚀 go-pugleaf

"John Moore (TeamB)" <jbm@microps.com> wrote:
>Oh, and as an additional note..
>
>If the driver supports it.. there is a DataSource property "user".. 
>Consult any JDBC 2.0 book on Datasource properties..
>
>John..
>
>-- 
>=============================================
>TeamB are volunteer helpers.  Please DO NOT REPLY VIA EMAIL!
>Post all questions and replies to this newsgroup ONLY
>For papers on DataExpress, Applets, JSP, and Web Development go to:
>http://www.microps.com/mps/paperFAQ.html
>====================================================

I have determined that the issue is the nested querys,
ex:

Select USERNAME
FROM USER_TABLE
WHERE USERNAME = (SELECT SYS_CONTEXT('USERENV','CURRENT_USER' FROM DUAL)

Using JBuilders SQL Builder, I am simply typing in the query that I wish to use in the SQL Tab and then trying to test it by clicking the TEST Tab, at which point the following "ALERT" pops up:

"Error parsing SQL: [line 4, col44] Invalid start of expression, found near SELECT. You must enter valid SQL in order to proceed."

Is this alert being returned from the server, or is this before it even leaves JBuilder?


I know that my SQL is valid:
SELECT PS_PROJECT_INFO.PROJECT_ID, PS_PROJECT_INFO.PROJECT_NAME,
PS_PROJECT_INFO.PROJECT_DESC
FROM PS_PROJECT_INFO
WHERE PS_PROJECT_INFO.PROJECT_ID = (SELECT ORADBA.PS_PROJECT_EMPLOYEES.PROJECT_ID 
                                           FROM ORADBA.PS_PROJECT_EMPLOYEES
                                           WHERE ORADBA.PS_PROJECT_EMPLOYEES.EMPLOYEE_ID = 8)


I just wanted to give more specifics to help me in my search for a solution.  How does JBuilder determine if its valid SQL, does it use the JDBC driver?  I didn't find anything relevant in the Oracle forums, so I figured I would give the exact error message that came up.

I am using JBuilder 2006 Enterprise 12.0.203.0
           JDBC Driver Classes12.jar 
           Oracle 8.1.7
           SDK 1.5

thanks for any info,
N