Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

General question about SQLJ.

 
Claude Moore
Ranch Hand
Posts: 814
7
IBM DB2 Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 814
7
IBM DB2 Java Netbeans IDE
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 20605
60
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
when i first started i did pro*c, i am guessing it was trying to get the same concept.
 
Tim Moores
Bartender
Posts: 2891
46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SQLJ was an idea that had some traction in the late 90s. It passed :-)
 
Claude Moore
Ranch Hand
Posts: 814
7
IBM DB2 Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks you a lot. Having read your message, I think i won't use SQLJ....
Regards !
 
Rob Spoor
Sheriff
Pie
Posts: 20605
60
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic