Thomas,
Sorry for the delay. Here are the two files you've asked for. I hope
this "bug" can be found. It's the only thing that keeps me from
switching from Derby to H2.
Wim
FILE 1:
___________________________________
07-08 15:10:59 database: opening C:\db\mc\mydb (build 155)
07-08 15:10:59 fileLock: load {method=file,
id=130e65767d3978a588c9419afe4b5a5764bed40c13e}
07-08 15:10:59 fileLock: load {method=file,
id=130e65767d3978a588c9419afe4b5a5764bed40c13e}
07-08 15:10:59 fileLock: save
{id=13109df60c80b30d41327012a25c304e429879c57e5, method=file}
07-08 15:11:01 fileLock: load {method=file,
id=130e65767d3978a588c9419afe4b5a5764bed40c13e}
07-08 15:11:01 fileLock: load {method=file,
id=130e65767d3978a588c9419afe4b5a5764bed40c13e}
07-08 15:11:02 database: opening C:\db\mc\mydb (build 155)
07-08 15:11:02 fileLock: load {method=file,
id=130e65767d3978a588c9419afe4b5a5764bed40c13e}
07-08 15:11:02 fileLock: load {method=file,
id=130e65767d3978a588c9419afe4b5a5764bed40c13e}
07-08 15:11:02 fileLock: save
{id=13109df6ab652a570a6ca1aa4edc2dd1008f5a57135, method=file}
07-08 15:11:04 fileLock: load {method=file,
id=130e65767d3978a588c9419afe4b5a5764bed40c13e}
07-08 15:11:04 fileLock: load {method=file,
id=130e65767d3978a588c9419afe4b5a5764bed40c13e}
07-08 15:13:39 jdbc[25]:
/*SQL t:1310130819239*/SET TRACE_LEVEL_FILE 3;
07-08 15:13:39 command: slow query: 1.310.130.819.248 ms
07-08 15:13:39 jdbc[25]:
/*SQL */COMMIT;
07-08 15:13:39 jdbc[25]:
/*SQL l:15*/SET LOCK_MODE ? {1: 3};
07-08 15:13:39 jdbc[25]:
/*SQL #:1*/CALL READONLY();
07-08 15:13:39 jdbc[25]:
/*SQL */COMMIT;
07-08 15:13:39 jdbc[25]:
/*SQL l:15*/SET LOCK_MODE ? {1: 3};
07-08 15:13:39 jdbc[25]:
/*SQL */COMMIT;
07-08 15:13:39 jdbc[25]:
/*SQL l:15*/SET LOCK_MODE ? {1: 3};
07-08 15:13:43 lock: 25 shared read lock requesting for mydbusers
07-08 15:13:43 jdbc[25]:
/*SQL #:1*/select (originalpicture) as l from mydbusers where
userid=25874;
07-08 15:13:43 lock: 1 shared read lock requesting for LOB_MAP
07-08 15:13:43 lock: 1 shared read lock requesting for LOB_DATA
07-08 15:13:43 lock: 1 shared read lock requesting for LOB_MAP
07-08 15:13:43 lock: 1 shared read lock requesting for LOB_DATA
07-08 15:13:43 lock: 1 shared read lock requesting for LOB_MAP
07-08 15:13:43 lock: 1 shared read lock requesting for LOB_DATA
07-08 15:13:43 lock: 1 shared read lock requesting for LOB_MAP
07-08 15:13:43 lock: 1 shared read lock requesting for LOB_DATA
07-08 15:13:43 lock: 1 shared read lock requesting for LOB_MAP
07-08 15:13:43 lock: 1 shared read lock requesting for LOB_DATA
07-08 15:13:43 jdbc[25]:
/*SQL #:1*/CALL DATABASE();
07-08 15:13:43 jdbc[25]:
/*SQL */COMMIT;
07-08 15:13:43 jdbc[25]:
/*SQL l:15*/SET LOCK_MODE ? {1: 3};
FILE 2:
_________________________
07-08 15:13:39 jdbc:
/**/Connection conn179 = DriverManager.getConnection("jdbc:h2:tcp://
127.0.0.1/c:/db/mc/mydb;CIPHER=XTEA;trace_level_file=3",
"ADMINISTRATOR", "");
07-08 15:13:39 jdbc:
/**/conn179.setTransactionIsolation(2);
07-08 15:13:39 jdbc:
/**/conn179.commit();
07-08 15:13:39 jdbc: SESSION_PREPARE_READ_PARAMS 0
07-08 15:13:39 jdbc: COMMAND_EXECUTE_UPDATE 0
07-08 15:13:39 jdbc: SESSION_PREPARE_READ_PARAMS 1
07-08 15:13:39 jdbc: COMMAND_EXECUTE_UPDATE 1
07-08 15:13:39 jdbc:
/**/conn179.isReadOnly();
07-08 15:13:39 jdbc: SESSION_PREPARE_READ_PARAMS 2
07-08 15:13:39 jdbc: COMMAND_EXECUTE_QUERY 2
07-08 15:13:39 jdbc: RESULT_CLOSE 3
07-08 15:13:39 jdbc:
/**/conn179.setAutoCommit(true);
07-08 15:13:39 jdbc: SESSION_SET_AUTOCOMMIT 1
07-08 15:13:39 jdbc:
/**/conn179.setTransactionIsolation(2);
07-08 15:13:39 jdbc:
/**/conn179.commit();
07-08 15:13:39 jdbc: COMMAND_EXECUTE_UPDATE 0
07-08 15:13:39 jdbc: COMMAND_EXECUTE_UPDATE 1
07-08 15:13:39 jdbc:
/**/conn179.setReadOnly(false);
07-08 15:13:39 jdbc:
/**/conn179.isClosed();
07-08 15:13:39 jdbc:
/**/conn179.setAutoCommit(true);
07-08 15:13:39 jdbc: SESSION_SET_AUTOCOMMIT 1
07-08 15:13:39 jdbc:
/**/conn179.setTransactionIsolation(2);
07-08 15:13:39 jdbc:
/**/conn179.commit();
07-08 15:13:39 jdbc: COMMAND_EXECUTE_UPDATE 0
07-08 15:13:39 jdbc: COMMAND_EXECUTE_UPDATE 1
07-08 15:13:39 jdbc:
/**/conn179.setReadOnly(false);
07-08 15:13:43 jdbc:
/**/conn179.isClosed();
07-08 15:13:43 jdbc:
/**/conn179.getAutoCommit();
07-08 15:13:43 jdbc:
/**/DatabaseMetaData dbMeta2933 = conn179.getMetaData();
07-08 15:13:43 jdbc:
/**/dbMeta2933.supportsGetGeneratedKeys();
07-08 15:13:43 jdbc:
/**/Statement stat2852 = conn179.createStatement();
07-08 15:13:43 jdbc:
/**/stat2852.setMaxRows(1);
07-08 15:13:43 jdbc:
/**/stat2852.execute("select (originalpicture) as l from mydbusers
where userid=25874", 1);
07-08 15:13:43 jdbc: SESSION_PREPARE_READ_PARAMS 4
07-08 15:13:43 jdbc: COMMAND_EXECUTE_QUERY 4
07-08 15:13:43 jdbc: RESULT_CLOSE 5
07-08 15:13:43 jdbc: COMMAND_CLOSE 4
07-08 15:13:43 jdbc:
/**/stat2852.getUpdateCount();
07-08 15:13:43 jdbc:
/**/ResultSet rs3008 = stat2852.getResultSet();
07-08 15:13:43 jdbc:
/**/ResultSetMetaData rsMeta23991 = rs3008.getMetaData();
07-08 15:13:43 jdbc:
/**/conn179.getCatalog();
07-08 15:13:43 jdbc: SESSION_PREPARE_READ_PARAMS 6
07-08 15:13:43 jdbc: COMMAND_EXECUTE_QUERY 6
07-08 15:13:43 jdbc: RESULT_CLOSE 7
07-08 15:13:43 jdbc: COMMAND_CLOSE 6
07-08 15:13:43 jdbc:
/**/rsMeta23991.getColumnCount();
07-08 15:13:43 jdbc:
/**/rsMeta23991.getColumnLabel(1);
07-08 15:13:43 jdbc:
/**/rsMeta23991.isCaseSensitive(1);
07-08 15:13:43 jdbc:
/**/rsMeta23991.getColumnType(1);
07-08 15:13:43 jdbc:
/**/rsMeta23991.getColumnTypeName(1);
07-08 15:13:43 jdbc:
/**/rs3008.next();
07-08 15:13:43 jdbc:
/**/ResultSetMetaData rsMeta23992 = rs3008.getMetaData();
07-08 15:13:43 jdbc:
/**/conn179.getCatalog();
07-08 15:13:43 jdbc:
/**/rs3008.getObject(1);
07-08 15:13:43 jdbc:
/**/rs3008.next();
07-08 15:13:43 jdbc:
/**/blob24.getBinaryStream();
07-08 15:13:43 jdbc: exception
org.h2.jdbc.JdbcSQLException: Datei nicht gefunden: "C:\Windows\Temp
\h2.temp.ca4c9ff6786cdf2a.14.temp.db"
File not found: "C:\Windows\Temp\h2.temp.ca4c9ff6786cdf2a.
14.temp.db" [90124-155]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.SessionRemote.openFile(SessionRemote.java:608)
at org.h2.value.ValueLobDb.getInputStream(ValueLobDb.java:273)
at org.h2.jdbc.JdbcBlob.getBinaryStream(JdbcBlob.java:154)
at coldfusion.sql.QueryTable.resolveObject(QueryTable.java:486)
at coldfusion.sql.QueryTable.populate(QueryTable.java:418)
at coldfusion.sql.Executive.getRowSet(Executive.java:581)
at coldfusion.sql.Executive.executeQuery(Executive.java:1383)
at coldfusion.sql.Executive.executeQuery(Executive.java:1127)
at coldfusion.sql.Executive.executeQuery(Executive.java:1058)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
at cftest2ecfm1683294928.runPage(C:\ColdFusion9\wwwroot\test.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:
381)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:
48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:
40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:
28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:
22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:200)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:
89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:
42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:
46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:
286)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:
543)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
at jrunx.scheduler.ThreadPool
$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at jrunx.scheduler.ThreadPool
$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.ThreadPool
$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
07-08 15:13:43 jdbc:
/**/stat2852.setMaxRows(0);
07-08 15:13:43 jdbc:
/**/stat2852.close();
07-08 15:13:43 jdbc:
/**/conn179.setAutoCommit(true);
07-08 15:13:43 jdbc: SESSION_SET_AUTOCOMMIT 1
07-08 15:13:43 jdbc:
/**/conn179.setTransactionIsolation(2);
07-08 15:13:43 jdbc:
/**/conn179.commit();
07-08 15:13:43 jdbc: COMMAND_EXECUTE_UPDATE 0
07-08 15:13:43 jdbc: COMMAND_EXECUTE_UPDATE 1
07-08 15:13:43 jdbc:
/**/conn179.setReadOnly(false);
On Jul 2, 2:42 pm, Thomas Mueller <[email protected]>
wrote:
> Hi,
>
> Probably ColdFusion uses an unusual combination of JDBC method calls.
> Could you append ;TRACE_LEVEL_FILE=3 to the database URL and then send
> me all the *.trace.db files? There should be at least onefileon the
> client, and one where the H2 server runs. Or maybe be easier, use an
> embedded URL (in that case you will only get one .trace.dbfile):
> jdbc:h2:c:/db/mydbdir/mydb;CIPHER=XTEA;trace_level_file=3
>
> 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.
