I'm working on my problems posted above. So far, I found the following
answers:
3. binary data is fetched at the point of time I try to access it because
my idea for use case 4b) works
4b) workaround to check whether a file has been deleted:
if (rs.first()) { //at most one element because of unique id!
Blob data = rs.getBlob("data");
try{
byteData = data.getBytes(0, (int) data.length());
}catch(Exception e) {
if(e instanceof JdbcSQLException) {
if(e.getMessage().contains("[90124-")){//Error Code for FileNotFound
System.err.println("Chuck Norris killed a file on id: " + index);
//do some update work
}
}
}
}
However, I rate this a workaround and not a solution. Suggestions to get a
more failure proof method are welcome.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/drBCttCShRgJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
