Hi Rick Thanks for helping !
The query return 11 rows SCHEMANAME |TABLENAME |CONGLOMERATENAME -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- APP |AUTHORS |08264012-0124-bfb9-c84d-ffffa7816d66 NULLID |AUTHORS |08264012-0124-bfb9-c84d-ffffa7816d66 SQLJ |AUTHORS |08264012-0124-bfb9-c84d-ffffa7816d66 SYS |AUTHORS |08264012-0124-bfb9-c84d-ffffa7816d66 SYSCAT |AUTHORS |08264012-0124-bfb9-c84d-ffffa7816d66 SYSCS_DIAG |AUTHORS |08264012-0124-bfb9-c84d-ffffa7816d66 SYSCS_UTIL |AUTHORS |08264012-0124-bfb9-c84d-ffffa7816d66 SYSFUN |AUTHORS |08264012-0124-bfb9-c84d-ffffa7816d66 SYSIBM |AUTHORS |08264012-0124-bfb9-c84d-ffffa7816d66 SYSPROC |AUTHORS |08264012-0124-bfb9-c84d-ffffa7816d66 SYSSTAT |AUTHORS |08264012-0124-bfb9-c84d-ffffa7816d66 11 rows selected ij> There is no C560.dat file in docentries/Seg0 directory in the jar file. (there is a d560.dat and a c460.dat). The thing that has changed (possibly since a long time ago) is the java version himself since it is update automatically on my pc . But the code I'm using have been made years ago and it went well for a long time without any change from my side. I did rebuild the table in the database on my disc once in a year, either by deleting + adding new rows, or by dropping the table and creating a new then adding the row. The database in the docentries folder is ok, I can run a select again the table. Then I build the jar (with an ant task that didn't change for years.) François -----Original Message----- From: Rick Hillegas <rick.hille...@gmail.com> Sent: 11 September 2020 00:49 To: Derby Discussion <derby-user@db.apache.org>; RAPPAZ Francois <francois.rap...@unifr.ch> Subject: 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/a >>> utconv.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 >>> >> >> > >