Hi,
Sorry I don't have a copy of the trace.db file, but I'll try and
reproduce the problem when I am next at the client site and grab the
trace.db file. The only thing I ended up changing was denying the local
system account access to the folder which seemed to rectify the issue.
My theory was that would stop the anti-virus being able to lock the
file. But it is a rather thin theory... It could be any system process,
or all just coincidence. I just thought the anti-virus because it has
just recently been changed over to McAfee and it seems to have really
slowed the system down, so I am assuming it is scanning everything. I
don't have access to the configuration of the anti-virus.
The query is using JaQu.
final OfflineClient oc = new OfflineClient();
return
db.from(oc).where(oc.offlineClientName).is(offlineClientName).selectFirst();
public class OfflineClient {
public Integer offlineClientId;
public String offlineClientName;
public Boolean deleted;
}
Table schema is
<createTable tableName="OfflineClient">
<column name="offlineClientId" type="int" autoIncrement="true">
<constraints primaryKey="true" nullable="false"/>
</column>
<column name="offlineClientName" type="VARCHAR_IGNORECASE(200)">
<constraints nullable="false" unique="true"/>
</column>
<column name="deleted" type="boolean">
<constraints nullable="false"/>
</column>
</createTable>
The query in the trace.db that JaQu generated looked correct from memory.
Cheers,
Ryan
On 26/11/2010 6:37 AM, Thomas Mueller wrote:
Hi,
> I don't have the exact exception sorry, but the database trace log had
> something like jdbcexception.
Could you try to get the .trace.db file and send it to me or post it here?
> Error converting String "some string" in
> Select * from mytable where thing = ?
This error message doesn't sound like an anti-virus problem to me (but
I could be wrong). What is the data type of the column "thing"?
Regards,
Thomas
--
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.
--
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.
