Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!news.stealth.net!newsgate.cuhk.edu.hk!news.cuhk.edu.hk!news.erg.cuhk.edu.hk!not-for-mail
From: ftp <shyan@cse.cuhk.edu.hk>
Newsgroups: comp.databases.oracle.misc
Subject: Why SQLJ cannot find error?
Date: 10 Oct 2001 09:23:33 GMT
Organization: ERG CUHK
Lines: 27
Message-ID: <9q142l$rid$2@eng-ser1.erg.cuhk.edu.hk>
NNTP-Posting-Host: fraser.cse.cuhk.edu.hk
X-Trace: eng-ser1.erg.cuhk.edu.hk 1002705813 28237 137.189.90.232 (10 Oct 2001 09:23:33 GMT)
X-Complaints-To: abuse@erg.cuhk.edu.hk
NNTP-Posting-Date: 10 Oct 2001 09:23:33 GMT
User-Agent: tin/1.4.1-19991201 ("Polish") (UNIX) (SunOS/5.6 (sun4u))
Xref: easynews comp.databases.oracle.misc:70111
X-Received-Date: Wed, 10 Oct 2001 04:58:53 MST (news.easynews.com)

I have tested the sample program, TestInstallSQLJChecker.sql

My connect.prpoerties is

sqlj.url=jdbc:oracle:oci8:@
sqlj.driver=oracle.jdbc.driver.OracleDriver
sqlj.user=scott
sqlj.password=tiger      

If I run
sqlj TestInstallSQLJChecker.sql
There is no error!

However, if I run
sqlj -user=scott TestInstallSQLJChecker.sql
The SQLJ checker can find the syntax error in my SQL statement.

Oarcle hoempage says that
"Online semantics-checking is enabled as soon as you specify a username
for the translation-time database connection. You can specify the username
either by uncommenting the sqlj.user line in the sqlj.properties file or
by using the -user command-line option"

Why I still need to specify username in command even I have specified it
in connect.properties ?

--