Hi,
h2.lobInDatabase=false will not be supported in future versions of H2. If
you need this feature, could you store the files in the filesystem yourself?
Regards,
Thomas
On Wednesday, May 30, 2012, SME wrote:
> 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]<javascript:_e({}, 'cvml',
> '[email protected]');>
> .
> To unsubscribe from this group, send email to
> [email protected] <javascript:_e({}, 'cvml',
> 'h2-database%[email protected]');>.
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
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.
