Re: database in a jar : conglomerate does not exists
Also, look inside the jar file for a directory called docentries/seg0. Does it contain a file called c560.dat? On 9/10/20 8:53 AM, Rick Hillegas wrote: Sorry. Make that query: SELECT s.schemaName, t.tableName, c.conglomerateName FROM sys.sysConglomerates c, sys.sysSchemas s, sys.sysTables t WHERE c.conglomerateNumber = 1376 AND c.tableID = t.tableID AND t.schemaID = s.schemaID ; On 9/10/20 8:22 AM, Rick Hillegas wrote: Hi François, Do you have any information or theories about how your database became corrupted? I have never encountered this situation before. A database in a jar file should be read-only, so the only theory I have is that the jar file itself was corrupted by some process outside Derby. Please run the following query in order to find out what table/index is corrupted: SELECT s.schemaName, t.tableName, c.conglomerateName FROM sys.sysConglomerates c, sys.sysSchemas s, sys.sysTables t WHERE c.conglomerateNumber = 376 AND c.tableID = t.tableID AND t.schemaID = s.schemaID ; Thanks, -Rick On 9/10/20 3:09 AM, RAPPAZ Francois wrote: Hi I have a one table database embedded in a jar file. I tried to access it from ij with java -jar %DERBY_HOME%/lib/derbyrun.jar ij -p ij.properties ij.properties is derby.ui.codeset=utf8 ij.connection.doc=jdbc:derby:jar:(U:/docs/OA/articles/zlib/autconv/autconv.jar)docentries I can see that my table (authors) is in the the database with SHOW TABLES; I can see the columns ij> DESCRIBE authors; COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& -- NAME1 |VARCHAR |NULL|NULL|20 |NULL |40 |NO NAME2 |VARCHAR |NULL|NULL|20 |NULL |40 |NO DATA |VARCHAR |NULL|NULL|50 |NULL |100 |YES AUTHOR_ID |INTEGER |0 |10 |10 |AUTOINCRE&|NULL |NO 4 rows selected But I can't run a select statement: ij> select * from authors; ERROR XSAI2: Le conglomerat (1,376) demande n'existe pas. ij> exit; I have derby 10.8.2.2 Thanks for any help. François
Re: database in a jar : conglomerate does not exists
Sorry. Make that query: SELECT s.schemaName, t.tableName, c.conglomerateName FROM sys.sysConglomerates c, sys.sysSchemas s, sys.sysTables t WHERE c.conglomerateNumber = 1376 AND c.tableID = t.tableID AND t.schemaID = s.schemaID ; On 9/10/20 8:22 AM, Rick Hillegas wrote: Hi François, Do you have any information or theories about how your database became corrupted? I have never encountered this situation before. A database in a jar file should be read-only, so the only theory I have is that the jar file itself was corrupted by some process outside Derby. Please run the following query in order to find out what table/index is corrupted: SELECT s.schemaName, t.tableName, c.conglomerateName FROM sys.sysConglomerates c, sys.sysSchemas s, sys.sysTables t WHERE c.conglomerateNumber = 376 AND c.tableID = t.tableID AND t.schemaID = s.schemaID ; Thanks, -Rick On 9/10/20 3:09 AM, RAPPAZ Francois wrote: Hi I have a one table database embedded in a jar file. I tried to access it from ij with java -jar %DERBY_HOME%/lib/derbyrun.jar ij -p ij.properties ij.properties is derby.ui.codeset=utf8 ij.connection.doc=jdbc:derby:jar:(U:/docs/OA/articles/zlib/autconv/autconv.jar)docentries I can see that my table (authors) is in the the database with SHOW TABLES; I can see the columns ij> DESCRIBE authors; COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& -- NAME1 |VARCHAR |NULL|NULL|20 |NULL |40 |NO NAME2 |VARCHAR |NULL|NULL|20 |NULL |40 |NO DATA |VARCHAR |NULL|NULL|50 |NULL |100 |YES AUTHOR_ID |INTEGER |0 |10 |10 |AUTOINCRE&|NULL |NO 4 rows selected But I can't run a select statement: ij> select * from authors; ERROR XSAI2: Le conglomerat (1,376) demande n'existe pas. ij> exit; I have derby 10.8.2.2 Thanks for any help. François
Re: database in a jar : conglomerate does not exists
Hi François, Do you have any information or theories about how your database became corrupted? I have never encountered this situation before. A database in a jar file should be read-only, so the only theory I have is that the jar file itself was corrupted by some process outside Derby. Please run the following query in order to find out what table/index is corrupted: SELECT s.schemaName, t.tableName, c.conglomerateName FROM sys.sysConglomerates c, sys.sysSchemas s, sys.sysTables t WHERE c.conglomerateNumber = 376 AND c.tableID = t.tableID AND t.schemaID = s.schemaID ; Thanks, -Rick On 9/10/20 3:09 AM, RAPPAZ Francois wrote: Hi I have a one table database embedded in a jar file. I tried to access it from ij with java -jar %DERBY_HOME%/lib/derbyrun.jar ij -p ij.properties ij.properties is derby.ui.codeset=utf8 ij.connection.doc=jdbc:derby:jar:(U:/docs/OA/articles/zlib/autconv/autconv.jar)docentries I can see that my table (authors) is in the the database with SHOW TABLES; I can see the columns ij> DESCRIBE authors; COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& -- NAME1 |VARCHAR |NULL|NULL|20|NULL |40|NO NAME2 |VARCHAR |NULL|NULL|20|NULL |40|NO DATA|VARCHAR |NULL|NULL|50|NULL |100 |YES AUTHOR_ID |INTEGER |0 |10 |10|AUTOINCRE&|NULL |NO 4 rows selected But I can't run a select statement: ij> select * from authors; ERROR XSAI2: Le conglomerat (1,376) demande n'existe pas. ij> exit; I have derby 10.8.2.2 Thanks for any help. François
database in a jar : conglomerate does not exists
Hi I have a one table database embedded in a jar file. I tried to access it from ij with java -jar %DERBY_HOME%/lib/derbyrun.jar ij -p ij.properties ij.properties is derby.ui.codeset=utf8 ij.connection.doc=jdbc:derby:jar:(U:/docs/OA/articles/zlib/autconv/autconv.jar)docentries I can see that my table (authors) is in the the database with SHOW TABLES; I can see the columns ij> DESCRIBE authors; COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& -- NAME1 |VARCHAR |NULL|NULL|20|NULL |40|NO NAME2 |VARCHAR |NULL|NULL|20|NULL |40|NO DATA|VARCHAR |NULL|NULL|50|NULL |100 |YES AUTHOR_ID |INTEGER |0 |10 |10|AUTOINCRE&|NULL |NO 4 rows selected But I can't run a select statement: ij> select * from authors; ERROR XSAI2: Le conglomerat (1,376) demande n'existe pas. ij> exit; I have derby 10.8.2.2 Thanks for any help. François