🚀 go-pugleaf

N wrote:
> "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
> 
> 

Ok, that's the relevent information we needed.  classes12.jar is very 
old, and was intended for JDK 1.3 and earlier.  You need a more recent 
JDBC driver jar.

According to the Oracle FAQ, you can use the ojdbc14.jar file from 
Oracle 10 with Oracle 8.1.7.

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm

-- 

Regards,

Lori Olson [TeamB]

------------

Save yourself, and everyone else, some time and search the
newsgroups and the FAQ-O-Matic before posting your next
question.

Google Advanced Newsgroup Search
     http://www.google.ca/advanced_group_search
Other Newsgroup Searches:
     http://www.borland.com/newsgroups/ngsearch.html
Joi Ellis's FAQ-O-Matic:
     http://www.visi.com/~gyles19/fom-serve/cache/1.html