RE: JDBC Knowledge of Journaling

["Fred Kulack" <kulack@xxxxxxxxxx>]

On 01/29/2002 at 03:02:05 AM, java400-l-admin@midrange.com wrote:
You can call getTransactionIsolation() on your Connection object.  That
will tell you the maximum level that the database supports.
--- end of excerpt ---

Connection.getTransactionIsolation() tells you only the _current_
isolation level, not the max that the database supports and it is
unrelated to a particular file/table's enabling of journaling.

I'd probably create a stored procedure that took the schema and table
name as parameters, and use proprietary Os/400 mechanisms to see
if the file was journaled and output true or false.

On a non-AS/400 system, the stored procedure would probably just
output true.
I don't know right off hand which API to use in the stored procedure
and the as400bks site seems unavailable to me right now.
There's probably a DB File API that does some things similar
to DSPFD (Display File Description). But, worst case, you could
use DSPFD with the output to an outfile and look at it.

(I wouldn't do it too frequently... I.e. once per file would
be good, and remember the results).
DSPFD outputs a line like this:
File is currently journaled . . . . . . . . :            Yes


In every single ethnic, religious or racial group, there are a
very few truly evil people. For each of those people there
are many, many, many good people.
Assuming anything (evilness or capability for evil) about the
particular group is bigotry and idiocy. Don't do it.  -- Me

Fred A. Kulack  -  IBM eServer iSeries - Java DB2 access, Jdbc, JTA, etc...
IBM in Rochester, MN  (Phone: 507.253.5982   T/L 553-5982)
mailto:kulack@us.ibm.com   Personal: mailto:kulack@magnaspeed.net
AOL Instant Messenger: Home:FKulack  Work:FKulackWrk