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

Reply via email to