I can SELECT from my tables using the schema name, but I can't insert.
I have an Apache Derby database and I'm trying to incorporate Sequoia into our
product. However, when I try to do an insert with the following syntax:
insert into SCHEMA_NAME.TABLE_NAME values (1, 'test');
I get the following error from Sequoia:
Error during command execution (Unknown table 'schema_name.table_name'
in this INSERT statement: 'insert into SCHEMA_NAME.TABLE_NAME values (1,
'test')')
If I query with the command:
select * from SCHEMA_NAME.TABLE_NAME;
it works fine.
I have gone in as admin and done a schema dump, which results in the following
output:
SCHEMA_NAME.TABLE_NAME
SCHEMA_NAME.TABLE_NAME2
I asked about this problem before, and it was suggested that it might be a
problem with case sensitivity. My tables and schema are defined using all
uppercase, which is what I supply in my query. However, the error reports a
lowercase schema and table name. Maybe Sequoia is converting the case when
doing an insert? Using the standard JDBC driver I don't have this problem. In
fact, I can use any case I want there. Between the schema dump and the select
working, I don't know why this would fail.
Any ideas? I'm running Sequoia 2.10.10. I noticed there was a fix for
something like this in 2.5 against Postgres. Did the fix not apply to Derby?
Jonathan Stockho
Software Developer
Swisslog Healthcare Solutions
10825 E. 47th Avenue
Denver, CO 80239
Phone: 303-373-7814
FAX: 303-373-7872
e-mail: [EMAIL PROTECTED]
Internet: www.swisslog.com
------------------------------------------------------------------------------------
About Swisslog
Swisslog designs solutions in logistics automation that greatly reduce the
manual flow of materials and associated information within healthcare
facilities.
This message may contain legally privileged or confidential information and is
therefore addressed to the named persons only. The recipient should inform the
sender and delete this message, if he/she is not named as addressee.
The sender disclaims any and all liability for the integrity and punctuality of
this message. The sender has activated an automatic virus scanning, but does
not guarantee the virus free transmission of this message.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
