wood burning stoves 2.0*
The moose likes JDBC and the fly likes General question about SQLJ. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "General question about SQLJ." Watch "General question about SQLJ." New topic
Author

General question about SQLJ.

Claude Moore
Ranch Hand

Joined: Jun 24, 2005
Posts: 448
    
    1

Good morning,

since I'll have to deal with a lot of SQL operations in my Java code, I'm searching a suitable way to get my life easier.... I thought about SQLJ but I'm not sure if this technology really took off or if I should considerate it obsolete....

Can you advice me ?
Thanks!
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

I hadn't heard of it so went to check it out, from the sqlj.org website there is a link to oracles page, this page is no longer up
Claude Moore
Ranch Hand

Joined: Jun 24, 2005
Posts: 448
    
    1

Wendy Gibbons wrote:I hadn't heard of it so went to check it out, from the sqlj.org website there is a link to oracles page, this page is no longer up

A really ugly symptom.. I'd better avoid it ?
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19672
    
  18

I'd say so. The first sentence from its wiki page:
SQLJ is an outdated working title for efforts to combine Java and SQL.

I'd simply stick with good ol' JDBC.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

There are a few mentions of SQLJ over the net, most of them seem to suggest the days of SQLJ have already passed. There is certainly not widespread support for SQLJ these days and you could have difficulties find someone in a forum to help you if you run into problems.

I personally like the SQLJ idea. I didn't explore it yet, since I didn't want yet another tool to learn when I switched to Java a few years ago. If I started a new project nowadays, I'd probably try to see if it integrates to my IDE (or any IDE) and build process and might give it a try. Having SQL statically checked against a schema seems a big boon to me.

Some people suggest using an ORM framework (such as Hibernate), therefore avoiding the need for SQL (and by extension SQLJ) in the code.
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

when i first started i did pro*c, i am guessing it was trying to get the same concept.
Tim Moores
Rancher

Joined: Sep 21, 2011
Posts: 2408
SQLJ was an idea that had some traction in the late 90s. It passed :-)
Claude Moore
Ranch Hand

Joined: Jun 24, 2005
Posts: 448
    
    1

Thanks you a lot. Having read your message, I think i won't use SQLJ....
Regards !
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19672
    
  18

Martin Vajsar wrote:I personally like the SQLJ idea. I didn't explore it yet, since I didn't want yet another tool to learn when I switched to Java a few years ago. If I started a new project nowadays, I'd probably try to see if it integrates to my IDE (or any IDE) and build process and might give it a try. Having SQL statically checked against a schema seems a big boon to me.

To be fair, the idea of embedding SQL in code is not that bad. C# has LINQ that can more or less do the same.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: General question about SQLJ.