wood burning stoves 2.0*
The moose likes JDBC and the fly likes diff btw SQLJ and E/SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "diff btw SQLJ and E/SQL" Watch "diff btw SQLJ and E/SQL" New topic
Author

diff btw SQLJ and E/SQL

deep venu
Ranch Hand

Joined: Jun 09, 2001
Posts: 56
could nebody tell me the pros and cons between using SQLJ or E/SQL programs..
basically the need to extract from data from multiple tables at regular intervals and then used the data to make XML type file format to be put on to queue...am welcome ny suggestions beside using one of the above mentioned ones...
Nigel Browne
Ranch Hand

Joined: May 15, 2001
Posts: 673
SQLJ is a layer that sits onto of jdbc. It allows you embed SQL in java code. It requires a translator and runtime, but once set up it allow you to perform queries, writing fewer lines of code than when using JDBC calls to the database.
[ February 13, 2002: Message edited by: Nigel Browne ]
deep venu
Ranch Hand

Joined: Jun 09, 2001
Posts: 56
thanx nigel..
since i haven't worked on either on sqlj oe e/sql like ProC would it possible to say which one scores more than the other?
Nigel Browne
Ranch Hand

Joined: May 15, 2001
Posts: 673
I only have experience of SQLJ on oracle. I found the basics very easy to learn and the advanced features were great once I had understood the concepts. One feature I really like is the named iterator.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: diff btw SQLJ and E/SQL