SQL-J can freely downloaded from otn.oracle.com It is free.
Ivan Ooi wrote:
> Nice if I can use SQLJ directly inside there :-) cleaner.
> String ls_code ;
> select code
> into :ls_code
> from staff
> where year = 1960
> nice to have and nice to dream off :-(
In theory you can. The default SQL-J setup has worked with Cloudscape
(pre-open source) whenever I've tried really simple tests, using the
setup that converted SQL-J to vanilla JDBC. If it worked with an
embedded connection then it should work within a procedure using the
standard JDBC jdbc:default:connection. I don't see how it would be any
different in Derby.
It would be an interesting experiment to try and writeup, first problem
might be where to get SQL-J.
Also, I've spent some time on looking at supporting procedures written