SQLJ or JDBC?

[BigM]

Simple question....I am an experienced Oracle developer but am wanting to move into Java/Oracle development for obvious reasons....

Where do you people recommend I start....SQLJ or JDBC?

TIA

Martin

 

[sem]

SQLJ is something like Pro*C - you can easy embed static PL/SQL into Java code. JDBC is like ODBC. It's fully dynamic and you manage your results with java code, not PL/SQL.

 

[stoleru]

I'm using JDBC and I'm very pleased with it. With JDBC2 you can even implement strong security schemas, the old REF_CURSOR bug (in JDBC1) being fixed. All you have is to build stored functions and procedures in application owner schema, to define a GUI in Java (Swing or AWT) and (granting execute rights to users) calling your PL/SQL code from GUI. It's a simplistic way to port your application to GUI in Java. Off course, there's Java beans, EJB ... etc

Good luck in your actions.
Eduard Stoleru
e_stoleru@yahoo.com

 

[nontrad]

According to the class I am taking now, Most people use both. One has checking during compile and the other has access to the C libraries.