General question about SQLJ.

[Claude Moore]

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]

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]

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]

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.

[Martin Vajsar]

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]

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

[Tim Moores]

SQLJ was an idea that had some traction in the late 90s. It passed :-)

[Claude Moore]

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

[Rob Spoor]

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.