On Monday 14 May 2007 10:04:33 Daniel Noll wrote:
> I'll see if I can get access to the derby.log file.
Okay, now I have derby.log and the same error occurs twice. Once on
checkpoint, but it also happens earlier when trying to do a real query
(figures.)
Here's the lines which precede the error:
2007-05-11 04:34:05.612 GMT Thread[sG,5,main] (XID = 114873), (SESSIONID = 0),
(DATABASE = directory:D:\Path\To\Stores\EvidenceDatabase), (DRDAID = null),
Cleanup action starting
2007-05-11 04:34:05.612 GMT Thread[sG,5,main] (XID = 114873), (SESSIONID = 0),
(DATABASE = directory:D:\Path\To\Stores\EvidenceDatabase), (DRDAID = null),
Failed Statement is: SELECT CAST ('' AS VARCHAR(128)) AS TABLE_CAT,
SCHEMANAME AS TABLE_SCHEM, TABLENAME AS TABLE_NAME, (CAST (RTRIM(TABLE_TYPE)
AS VARCHAR(12))) AS TABLE_TYPE, CAST ('' AS VARCHAR(128)) AS REMARKS FROM
SYS.SYSTABLES, SYS.SYSSCHEMAS, (VALUES ('T','TABLE'), ('S','SYSTEM TABLE'),
('V', 'VIEW')) T(TTABBREV,TABLE_TYPE) WHERE (TTABBREV=TABLETYPE AND
(SYS.SYSTABLES.SCHEMAID = SYS.SYSSCHEMAS.SCHEMAID) AND ((1=1) OR ? IS NOT
NULL) AND (SYS.SYSSCHEMAS.SCHEMANAME LIKE ?) AND (TABLENAME LIKE ?)) AND
TABLETYPE IN ('T') ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME
Daniel
--
Daniel Noll
Nuix Pty Ltd
Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Ph: +61 2 9280 0699
Web: http://nuix.com/ Fax: +61 2 9212 6902
