Hi
I am trying to install ojb support on my machine.
I downloaded ojb 0.9.6 and did run script
ant prepare-testdb
Works nicely with the default database.
But does not work with db2 for me.
Yes, I have changed profile, username, password, database name.
When I run the same script, it generates badly formatted SQL in
target/src/sql/ojbcore-schema.sql
Example:
=========================
drop table OJB_LOCKENTRY;
drop sequence if exists $table.SequenceName;
CREATE TABLE OJB_LOCKENTRY
(
OID_ VARCHAR (250) NOT NULL,
TX_ID VARCHAR (50) NOT NULL,
TIMESTAMP_ NOT NULL,
ISOLATIONLEVEL INT NOT NULL,
LOCKTYPE INT NOT NULL
);
ALTER TABLE OJB_LOCKENTRY
ADD CONSTRAINT OJB_LOCKENTRY_PK
PRIMARY KEY (OID_,TX_ID);
========================
As you see, column TIMESTAMP_ is not complete.
And I don't know what is $table.SequenceName
There are more tables with similar column definitions.
Code for hsqldb is generated correctly.
How to correct it?
Darek
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
