db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: database in a jar : conglomerate does not exists
Date Thu, 10 Sep 2020 15:53:56 GMT
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
>>
>
>


Mime
View raw message