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
6
votes
2 answers

Is there any Java 8 supported release of SqlJ?

Actually I am getting an error: Exception in thread "main" java.lang.NoClassDefFoundError:sun/io/CharToByteConverter This is because in Java 8, the CharToByteConverter class has been removed as it was deprecated. Now I want to know of any…
Murtuza K
  • 165
  • 2
  • 10
5
votes
1 answer

Why did SQLJ die?

Does anyone know why that was canned a long time ago? Seemed like it wasn't such a bad idea. My very naive guess is that ORM tools didn't need SQLJ and also plugged the gap. Anyway, still curious.
Alexander Mills
  • 90,741
  • 139
  • 482
  • 817
3
votes
1 answer

SQLJ in Netbeans

I just read, that Netbeans does not support SQLJ and can´t believe this. Is there really no way to run SQLJ code in Netbeans?
user896692
  • 2,351
  • 7
  • 36
  • 57
3
votes
1 answer

SQLJ IN-statement support

Is it possible to use the SQL IN statement using SQLJ? I have tried to use the IN statement in combination with a List or String[] to represent a collection of variables, but SQLJ says it can't parse the object. Parameter object type is…
NielsInc
  • 426
  • 7
  • 23
2
votes
1 answer

Make implicit rule for 2 file types

I have in my makefile currently this implicit rule: .java.class: $(JAVAC) -classpath . $< What I need to achieve is not only to use this rule on .java files but also on .sqlj files. I need something like this: (.java.sqlj).class: $(SQLJC)…
jteichert
  • 527
  • 1
  • 4
  • 20
1
vote
1 answer

CLOB value too large to insert into DB2 table

I have a java.sql.Clob object which I populate from an Oracle query and then I have to insert this field at DB2 table (also a Clob column). So, at my sqlj class I created a java.sql.Clob type and set the value with the result from Oracle select…
Rodrigo Camargo
  • 180
  • 1
  • 6
1
vote
1 answer

How to use SQLJ with Eclipse?

There is not a plugin for SQLJ. So which files i have to import to project? How can i make the compiler understand SQLJ commands? I am currently using JDBC.
previous_developer
  • 10,579
  • 6
  • 41
  • 66
1
vote
1 answer

Auto-generating SQLJ source code

Has anyone out here tried auto-generating sqlj source code , from oracle pl/sql packages or procedures ?
Abhay Chaware
  • 333
  • 4
  • 14
1
vote
1 answer

How to insert and update multiple rows at the same time in JS?

I have a table which contains say X rows and 10 columns. User has an option to edit any of the rows and columns and also he can add new rows and add details to it. He has a single button 'Save' and check box upon every row. He can select the rows…
Sadique
  • 11
  • 1
  • 3
1
vote
0 answers

Translate function binding issue

I am using SQLJ as the data set is quite large for the application. I am trying to incorporate a query into my SQLJ file, but at the time of binding it gives me an error. Please help me with an alternative to the same. I cannot drop the translate…
Abhi
  • 386
  • 2
  • 5
  • 21
1
vote
0 answers

Debugging SQLJ files

I am working in IBM RAD IDE and I have a problem while debugging SQLJ files. While debugging, when I come to methods that are in .sqlj files, debugger automatically opens .java files (which are harder to read) instead of .sqlj files. I have enabled…
kerk
  • 11
  • 2
1
vote
0 answers

Java - Existence value of SQLJ

My company using very old java version 1.4.2, and still using .SQLJ, use it in a way like setters and getters, and also data manipulations (add, delete, edit). I know SQLJ is outdated. http://blog.jooq.org/2014/01/03/why-did-sqlj-die/ But for now, I…
hades
  • 4,294
  • 9
  • 46
  • 71
1
vote
2 answers

using a sequence in sqlj?

I'm new to sqlj and try to insert data with an id generated by a sequence. This is my current code: String pattern = ...; #sql {INSERT INTO my_table (id, pattern) VALUES (my_seq.nextVal(), :(pattern))}; but I keep getting and ORA-02287 Error. Do I…
EasterBunnyBugSmasher
  • 1,507
  • 2
  • 15
  • 34
1
vote
2 answers

Constructing an SQL Query in DB2 for SQLJ

I have a table called Lives: create table Lives( animal varchar(10) not null, year int not null, zoo varchar(10), primary key(animal,year) ); With the given data: ANIMAL YEAR ZOO ---------- ----------- ---------- joe …
Valerie94
  • 303
  • 2
  • 9
1
vote
1 answer

Migrate .SQLJ to maven project in netbeans

I am currently migrating a project which using sqlj to do all the query. It is using JDeveloper to to develop the project. Currently I need to create a new maven project using netbeans and I need to reuse those sqlj in this migrationg. But netbeans…
Mr Kids
  • 11
  • 5
1
2 3