Tom,
sorry for asking you again, but once more I am stuck with my MaxDB work.
Here is the code I have written so far:
public final class MaxDBPlatform extends DatabasePlatform {
private static final long serialVersionUID = 1L;
@Override
protected final Hashtable buildFieldTypes() {
final Hashtable<Class, FieldTypeDefinition> fieldTypeMapping =
new Hashtable<Class, FieldTypeDefinition>();
fieldTypeMapping.put(Boolean.class, new
FieldTypeDefinition("BOOLEAN", false));
fieldTypeMapping.put(Integer.class, new
FieldTypeDefinition("INTEGER", false));
fieldTypeMapping.put(Long.class, new
FieldTypeDefinition("FIXED", 20));
fieldTypeMapping.put(Float.class, new
FieldTypeDefinition("FLOAT", false));
fieldTypeMapping.put(Double.class, new
FieldTypeDefinition("DOUBLE PRECISION", false));
fieldTypeMapping.put(Short.class, new
FieldTypeDefinition("BOOLEAN", false));
fieldTypeMapping.put(Byte.class, new
FieldTypeDefinition("BINARY", 3));
fieldTypeMapping.put(BigInteger.class, new
FieldTypeDefinition("DOUBLE PRECISION", false));
fieldTypeMapping.put(BigDecimal.class, new
FieldTypeDefinition("DOUBLE PRECISION",false));
fieldTypeMapping.put(Number.class, new
FieldTypeDefinition("DOUBLE PRECISION",false));
fieldTypeMapping.put(String.class, new
FieldTypeDefinition("VARCHAR"));
fieldTypeMapping.put(Character.class, new
FieldTypeDefinition("CHAR UNICODE"));
fieldTypeMapping.put(Byte[].class, new FieldTypeDefinition("LONG
BYTE", false));
fieldTypeMapping.put(Character[].class, new
FieldTypeDefinition("LONG VARCHAR UNICODE", false));
fieldTypeMapping.put(byte[].class, new FieldTypeDefinition("LONG
BYTE", false));
fieldTypeMapping.put(char[].class, new FieldTypeDefinition("LONG
VARCHAR UNICODE", false));
fieldTypeMapping.put(Blob.class, new FieldTypeDefinition("LONG
BYTE", false));
fieldTypeMapping.put(Clob.class, new FieldTypeDefinition("LONG
VARCHAR UNICODE", false));
fieldTypeMapping.put(Date.class, new FieldTypeDefinition("DATE",
false));
fieldTypeMapping.put(Time.class, new FieldTypeDefinition("TIME",
false));
fieldTypeMapping.put(Timestamp.class, new
FieldTypeDefinition("TIMESTAMP", false));
return fieldTypeMapping;
}
}
Not much, actually. When I run the test, it tells me that MaxDBPlatform
does not support Native Sequence (since MaxDB supports native sequences,
I am actually writing this MaxDBPlatform!). So I looked at
OraclePlatform (as you told me) and copied anything that sounds like
"sequence" into my code:
public final ValueReadQuery buildSelectQueryForNativeSequence(final
String sequenceName, final Integer size) {
return new ValueReadQuery("SELECT " +
this.getQualifiedSequenceName(sequenceName) + ".NEXTVAL FROM DUAL");
}
protected final String getQualifiedSequenceName(final String
sequenceName) {
return this.getTableQualifier().length() == 0 ? sequenceName :
this.getTableQualifier() + "." + sequenceName;
}
public final boolean supportsNativeSequenceNumbers() {
return true;
}
When I run the test with those lines added (which in fact are valid for
MaxDB as its manual tells me), then in fact the test is hanging! "top"
(= process table) tells me that my machine is idle completely (so
neither Java nor MaxDB is doing anything, also the disc stands still
totally). The testresults.txt file is zero bytes large, and no stack
traces or something like that are on the screen. The .jdbc files are
created correctly (and I assume that they got applied correctly since in
former faults I always got lots of complaints of the driver in
testresults.txt). "ant test" just writes the output seen below and then
suspends for ever. Seems the tests suite is not well done -- it neither
prints SUCCESS, nor prints FAILURE, nor prints what it is waiting for...
it just makes my laptop sleep (not work, actually, but really sleep). I
don't have any clue what to check for to see what went wrong, since
there is no kind of log or other output written.
What shall I do?
Buildfile: build.xml
init:
[echo] Building component TopLink Essentials Testing
test:
[junit] Running
oracle.toplink.essentials.testing.tests.FullRegressionTestSuite
[junit] [TopLink Finer]: 2006.10.07
05:26:36.204--Thread(Thread[main,5,main])--javaSECMPInitializer -
initializaing
jar:file:/home/markus/workspace/glassfish/entity-persistence-tests/lib/toplink-essentials-tests.jar!/META-INF/persistence.xml.
[junit] [TopLink Finer]: 2006.10.07
05:26:36.847--Thread(Thread[main,5,main])--javaSECMPInitializer -
created temporary ClassLoader:
oracle.toplink.essentials.internal.ejb.cmp3.JavaSECMPInitializer$TempEntityLoad.
[junit] [TopLink Finer]: 2006.10.07
05:26:36.848--Thread(Thread[main,5,main])--javaSECMPInitializer -
override load class for collection members: true.
[junit] [TopLink Finer]: 2006.10.07
05:26:36.973--Thread(Thread[main,5,main])--javaSECMPInitializer -
predeploying default.
[junit] [TopLink Config]: 2006.10.07
05:26:50.203--ServerSession(9936523)--Thread(Thread[main,5,main])--The
primary key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.NonFueledVehicle]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.213--ServerSession(9936523)--Thread(Thread[main,5,main])--The
foreign key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.NonFueledVehicle]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.224--ServerSession(9936523)--Thread(Thread[main,5,main])--The
primary key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Car] is
being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.226--ServerSession(9936523)--Thread(Thread[main,5,main])--The
foreign key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Car] is
being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.232--ServerSession(9936523)--Thread(Thread[main,5,main])--The
primary key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.SportsCar]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.233--ServerSession(9936523)--Thread(Thread[main,5,main])--The
foreign key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.SportsCar]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.238--ServerSession(9936523)--Thread(Thread[main,5,main])--The
primary key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Bicycle]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.240--ServerSession(9936523)--Thread(Thread[main,5,main])--The
foreign key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Bicycle]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.310--ServerSession(9936523)--Thread(Thread[main,5,main])--The
discriminator column name for the root inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Person] is
being defaulted to: DTYPE.
[junit] [TopLink Config]: 2006.10.07
05:26:50.313--ServerSession(9936523)--Thread(Thread[main,5,main])--The
primary key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Engineer]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.314--ServerSession(9936523)--Thread(Thread[main,5,main])--The
foreign key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Engineer]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.320--ServerSession(9936523)--Thread(Thread[main,5,main])--The
primary key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.ImaginaryCar]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.321--ServerSession(9936523)--Thread(Thread[main,5,main])--The
foreign key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.ImaginaryCar]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.325--ServerSession(9936523)--Thread(Thread[main,5,main])--The
primary key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Lawyer] is
being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.326--ServerSession(9936523)--Thread(Thread[main,5,main])--The
foreign key column name for the inheritance class [class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Lawyer] is
being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.366--ServerSession(9936523)--Thread(Thread[main,5,main])--The
primary key column name for the mapping element [public
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Car
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Person.getCar()]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.369--ServerSession(9936523)--Thread(Thread[main,5,main])--The
primary key column name for the mapping element [public
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Engineer
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Person.getBestFriend()]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:50.376--ServerSession(9936523)--Thread(Thread[main,5,main])--The
target entity (reference) class for the one to one mapping element
[public
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Person
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Bus.getBusDriver()]
is being defaulted to: class
oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Person.
[junit] [TopLink Finer]: 2006.10.07
05:26:50.381--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.TireInfo].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.386--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Car].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.387--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.SportsCar].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.389--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Boat].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.390--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Bus].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.392--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Bicycle].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.393--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Person].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.395--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Engineer].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.396--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.PerformanceTireInfo].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.398--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.NonFueledVehicle].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.399--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Company].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.401--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Vehicle].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.403--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.Lawyer].
[junit] [TopLink Finer]: 2006.10.07
05:26:50.404--ServerSession(9936523)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.inheritance.ImaginaryCar].
[junit] [TopLink Finer]:
Thread(Thread[main,5,main])--javaSECMPInitializer - registering
transformer for ignore.
[junit] [TopLink Finer]:
Thread(Thread[main,5,main])--javaSECMPInitializer - initializaing
jar:file:/home/markus/workspace/glassfish/entity-persistence-tests/lib/toplink-essentials-ddl-generation-tests.jar!/META-INF/persistence.xml.
[junit] [TopLink Finer]:
Thread(Thread[main,5,main])--javaSECMPInitializer - created temporary
ClassLoader:
oracle.toplink.essentials.internal.ejb.cmp3.JavaSECMPInitializer$TempEntityLoad.
[junit] [TopLink Finer]:
Thread(Thread[main,5,main])--javaSECMPInitializer - override load class
for collection members: true.
[junit] [TopLink Finer]:
Thread(Thread[main,5,main])--javaSECMPInitializer - predeploying
ddlGeneration.
[junit] [TopLink Warning]: 2006.10.07
05:26:52.236--ServerSession(11228395)--Thread(Thread[main,5,main])--Ignoring
the named/named-native query
[oracle.toplink.essentials.internal.ejb.cmp3.metadata.MetadataDescriptor_at_8a54]
on entity class [findAnyMergeSQLBeerConsumer] as a query with that name
already exists.
[junit] [TopLink Warning]: 2006.10.07
05:26:52.238--ServerSession(11228395)--Thread(Thread[main,5,main])--Ignoring
the named/named-native query
[oracle.toplink.essentials.internal.ejb.cmp3.metadata.MetadataDescriptor_at_8a54]
on entity class [findAllMergeSQLCertifications] as a query with that
name already exists.
[junit] [TopLink Config]: 2006.10.07
05:26:52.245--ServerSession(11228395)--Thread(Thread[main,5,main])--The
table name for entity [class
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Alpine]
is being defaulted to: MERGEALPINE.
[junit] [TopLink Config]: 2006.10.07
05:26:52.258--ServerSession(11228395)--Thread(Thread[main,5,main])--The
column name for element [private java.sql.Timestamp
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Beer.version]
is being defaulted to: VERSION.
[junit] [TopLink Config]: 2006.10.07
05:26:52.263--ServerSession(11228395)--Thread(Thread[main,5,main])--The
column name for element [public java.lang.String
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.EmbeddedSerialNumber.getBreweryCode()]
is being defaulted to: BREWERYCODE.
[junit] [TopLink Config]: 2006.10.07
05:26:52.265--ServerSession(11228395)--Thread(Thread[main,5,main])--The
column name for element [private double
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Beer.alcoholContent]
is being defaulted to: ALCOHOLCONTENT.
[junit] [TopLink Config]: 2006.10.07
05:26:52.269--ServerSession(11228395)--Thread(Thread[main,5,main])--The
column name for element [private
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Alpine$Classification
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Alpine.classification]
is being defaulted to: CLASSIFICATION.
[junit] [TopLink Config]: 2006.10.07
05:26:52.275--ServerSession(11228395)--Thread(Thread[main,5,main])--The
column name for element [private java.sql.Timestamp
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Beer.version]
is being defaulted to: VERSION.
[junit] [TopLink Config]: 2006.10.07
05:26:52.277--ServerSession(11228395)--Thread(Thread[main,5,main])--The
column name for element [private double
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Beer.alcoholContent]
is being defaulted to: ALCOHOLCONTENT.
[junit] [TopLink Config]: 2006.10.07
05:26:52.279--ServerSession(11228395)--Thread(Thread[main,5,main])--The
column name for element [private
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Canadian$Flavor
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Canadian.flavor]
is being defaulted to: FLAVOR.
[junit] [TopLink Config]: 2006.10.07
05:26:52.543--ServerSession(11228395)--Thread(Thread[main,5,main])--The
column name for element [public java.lang.Integer
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.BeerConsumer.getId()]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:52.604--ServerSession(11228395)--Thread(Thread[main,5,main])--The
column name for element [public java.lang.String
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.BeerConsumer.getName()]
is being defaulted to: NAME.
[junit] [TopLink Config]: 2006.10.07
05:26:52.821--ServerSession(11228395)--Thread(Thread[main,5,main])--The
column name for element [public java.lang.String
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Certification.getDescription()]
is being defaulted to: DESCRIPTION.
[junit] [TopLink Config]: 2006.10.07
05:26:52.826--ServerSession(11228395)--Thread(Thread[main,5,main])--The
column name for element [public java.lang.Integer
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Certification.getId()]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:52.829--ServerSession(11228395)--Thread(Thread[main,5,main])--The
primary key column name for the mapping element [public
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.BeerConsumer
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.TelephoneNumber.getBeerConsumer()]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:52.830--ServerSession(11228395)--Thread(Thread[main,5,main])--The
primary key column name for the mapping element [private
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.BeerConsumer
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Beer.beerConsumer]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:52.832--ServerSession(11228395)--Thread(Thread[main,5,main])--The
primary key column name for the mapping element [private
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.BeerConsumer
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Beer.beerConsumer]
is being defaulted to: ID.
[junit] [TopLink Config]: 2006.10.07
05:26:52.833--ServerSession(11228395)--Thread(Thread[main,5,main])--The
map key attribute name for the mapping element [public java.util.Map
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.BeerConsumer.getCanadianBeersToConsume()]
is being defaulted to: id.
[junit] [TopLink Config]: 2006.10.07
05:26:52.835--ServerSession(11228395)--Thread(Thread[main,5,main])--The
primary key column name for the mapping element [public
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.BeerConsumer
oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Certification.getBeerConsumer()]
is being defaulted to: ID.
[junit] [TopLink Finer]: 2006.10.07
05:26:52.837--ServerSession(11228395)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Canadian].
[junit] [TopLink Finer]: 2006.10.07
05:26:52.837--ServerSession(11228395)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.BeerConsumer].
[junit] [TopLink Finer]: 2006.10.07
05:26:52.838--ServerSession(11228395)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Alpine].
[junit] [TopLink Finer]: 2006.10.07
05:26:52.839--ServerSession(11228395)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.TelephoneNumber].
[junit] [TopLink Finer]: 2006.10.07
05:26:52.840--ServerSession(11228395)--Thread(Thread[main,5,main])--Weaver
processing class
[oracle.toplink.essentials.testing.models.cmp3.xml.merge.inherited.Certification].
[junit] [TopLink Finer]:
Thread(Thread[main,5,main])--javaSECMPInitializer - registering
transformer for ddlGeneration.
[junit] [TopLink Finer]:
Thread(Thread[main,5,main])--javaSECMPInitializer - initializaing
jar:file:/home/markus/workspace/glassfish/entity-persistence-tests/lib/toplink-essentials-validation-tests.jar!/META-INF/persistence.xml.
[junit] [TopLink Finer]:
Thread(Thread[main,5,main])--javaSECMPInitializer - created temporary
ClassLoader:
oracle.toplink.essentials.internal.ejb.cmp3.JavaSECMPInitializer$TempEntityLoad.
[junit] [TopLink Finer]:
Thread(Thread[main,5,main])--javaSECMPInitializer - override load class
for collection members: true.
[junit] [TopLink Finer]:
Thread(Thread[main,5,main])--javaSECMPInitializer - predeploying broken-PU.
Markus
Tom Ware wrote:
> Hi Markus,
>
> I think we have a clear idea of the requirements now.
>
> If I were going to enable a feature that allowed delimiters to be
> appended to the end of DDL statements, I would take a look at the
> following:
>
> 1. SchemaManager and its createSQLFiles member variable
> 2. DatabasePlatform and its getStoredProcedureTerminationToken() method
> 3. The implementation of createOnDatabase() and buildCreationWriter()
> in DatabaseObjectDefinition and its subclasses.
>
> -Tom