Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: General questions
A copy of this was sent to Siavash <solati_at_nortelnetworks.com>
(if that email address didn't require changing)
On Mon, 05 Apr 1999 14:32:39 -0400, you wrote:
>Hi all,
>
>Does JSQL uses JDBC to connect to Oracle Database Server? According
>to 8i oracle documentation Pl/SQL does not uses JDBC but JSQL does.
>
SQLJ is a 'precompiler' language that compiles into JDBC calls.
x.sqlj -> gets run thru preprocessor outputs -> x.java -> which gets run thru javac -> *.class -> which gets run through java.
PL/SQL is the navtive stored procedure language that mixes an ada like language with SQL constructs. For example, in plsql I can easiy:
for x in ( select * from emp )
loop
dbms_output.put_line( x.ename ); end loop;
it does not use jdbc (predates jdbc by a couple of years at least)...
SQLJ can be used to build a standalone java program or a java stored procedure.
PLSQL can be used to build a standalong plsql program or a plsql stored procedure.
They are very similar in nature (both use VMs to execute in). They are just different languages.
>has anybody have any thoughts on this?
>
>
>thanks in advance for your help and suggestions
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities