#10 Incorrect sql script for Oracle

[Guillaume Compagnon]

The sql script file provided with ejb-utils is not convenient
for Oracle DB.

In the provided script, the Char type is used and in
Oracle, CHAR is the fixed length string.
and that a reason why PreparedStatement could not
work because , for Oracle, 'NAME' is not the same
that 'NAME '

For using Oracle, the table must be created with
VARCHAR2 type. and in most of case, String type (java)
corresponds to a VARCHAR2 type.
the exception is when all your String have always the
same length (same length that defined in Oracle CHAR
type)

ejbutils4Oracle.sql:

CREATE TABLE HIGH_KEY
(
NAME VARCHAR2(25) NOT NULL,
VALUE VARCHAR2(28) NOT NULL
);

CREATE UNIQUE INDEX PK_HIGH_KEY ON
HIGH_KEY(NAME);