Questions tagged [sqlj]

SQLJ is an outdated ISO standard for embedding SQL instructions in Java programs.

Instead of JDBC, SQLJ is not an API but an extension to the Java language. So SQLJ programs must be preprocessed (by a SQLJ translator) before being compiled.

36 questions
0
votes
2 answers

SQLj in Eclipse

I want to connect SQLj with Eclipse. I have done this steps: http://mojo.codehaus.org/sqlj-maven-plugin/usage.html But when I want to compile SQLj files I receive an message null…
user3025978
  • 477
  • 2
  • 8
  • 27
0
votes
1 answer

How to select data from data base using sqlj in message broker v8?

Can any one tell me how to to select table from data base using sqlj in java compute node in message broker v8 i have tried every thing in the help content but nothing seems to be working pls help me as i am new to message broker
0
votes
1 answer

Get the number of affected rows in SQLJ update statement

I am executing an update statement through SQLJ: #sql [connCtx] { UPDATE MYTABLE SET MYCOLUMN = null WHERE MYCOLUMN IS NOT NULL }; Is there a way to retrieve the number of affected rows?
Jack
  • 2,937
  • 5
  • 34
  • 44
0
votes
0 answers

Recursive query in SQLJ

I would like some help in SQLJ (yes...). I'm googling how to reproduce a recursive SQL query in this inline-java SQL. References are also welcome, because it has being really hard to find also... My SQL query: WITH attachedemails(id, subject,…
Pedro Dusso
  • 2,100
  • 9
  • 34
  • 64
0
votes
1 answer

Cursors in Database compared to JDBC cursors and SQLJ cursors

Could someone briefly compare and contrast the use of cursors in SQL procedures with their use in JDBC SQLJ
smallB
  • 16,662
  • 33
  • 107
  • 151
-1
votes
3 answers

Difference between sql, pl/sql and sqlj

I want to know how do the 3 compare with one another? which one to use when? which can be used as a replacement of other?
user325894
  • 183
  • 1
  • 7
1 2
3