I have a problem with the auto-create-table feature of
Orion 1.0 and IBM DB2 7.1 Personal Edition on a Suse-Linux-Box.
Auto-deploying ic-ejb...
Auto-creating table: create table Event (id BIGINT not null primary key,
ort VARCHAR(255) null, titel VARCHAR(255) null)
Warning: Error creating table: [IBM][CLI Driver][DB2/LINUX] SQL0104N An
unexpected token "," was found following "rt VARCHAR(255) null".
Expected tokens may include: "<references_spec>". SQLSTATE=42601
It seem to be the "null" suffixes on the columns "ort" and "titel" which
make the problem. I investigated with the DB2 Command Center. Leaving out
the keyword null in both cases lets me create the table without problem.
Is this correct sql syntax? I only know "not null", not "null"...
Anyway...
what can I do? And... Has anybody a db2.xml for
orion/config/database-schemas/ ?
Thanks for input,
--
Benjamin Lorenz {http://,mail@}benjamin-lorenz.com
60323 Frankfurt Voice: +49 179 597 6163 Fax: +49 89 1488 201577
