Re: Can I do that in SQLJ?

ftp wrote:
>
> In JDBC, I can prepare a query by
> PreparedStatement pstmt = conn.prepareStatement(sqlString);
> The sqlString can be created by the program in runtime.
>
> Can I do the similar thing in SQLJ?
>

Although I am really no SQLJ expert I want to point you to the technet SQLJ documentation.

This mentions that the Oracle driver implements a statement cache (default size: 5 statements), which does an implicit prepare for you. You can increase or disable this cache by command line options for "sqlj".

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Karlsdorfer Str. 31 | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!