Hi,
A company where I have an application deployed recently changed from
Norton to McAfee virus scanner, and since then they have been getting a
strange error with H2. Disabling the anti-virus (well kind of) seemed to
fix the error.
I don't have the exact exception sorry, but the database trace log had
something like jdbcexception. Error converting String "some string" in
Select * from mytable where thing = ?. It was a simple query that is
called hundreds of times (for the past year!) and then intermittently
started failing. Everything else seemed to be fine, just this query was
having intermittent issues.
I was just wondering if anyone else has come across anything like this?.
I did notice that McAfee was locking files in the folder that is must
have been scanning (I'm assuming it was McAfee anyway, because the
application wasn't running and nothing else had the files open. I
couldn't delete the files because the OS was claiming they were in use,
but after a minute they were not longer in use. The virus scanner was
using 100% CPU at the time). So I am wondering if it was locking the
file or doing something strange that H2 didn't like.
I reinstalled the Application, rebuilt the database, tested on another
system (which it was fine), etc. So the only thing I could end up
putting it down to was the virus scanner. I ended up changing file
permissions on the application folder to not allow the local system
account and as far as I know it has been fine since then.
I just wanted to post to see of any other weird experiences out there?
Cheers,
Ryan
--
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.
