Re: [dba-dev] Creating a table with oracle jdbc

2007-04-25 Thread Frank Schönheit - Sun Microsystems Germ any
Hi Peter, the following error occurs, if I save a table created with the designer: ORA-00906: left parenthesis missing I get the same hint, if I drag a HSQL table structure into an oracle jdbc db. I suppose this is something about the driver returning wrong meta data. OOo asks the

[dba-dev] Creating a table with oracle jdbc

2007-04-24 Thread Peter Eberlein
Hi, the following error occurs, if I save a table created with the designer: ORA-00906: left parenthesis missing I get the same hint, if I drag a HSQL table structure into an oracle jdbc db. The columns are: VARCHAR2 and INTEGER(with primary key). Oracle version is 9, driver is the original