Hi,
the tests I was trying to fix are expecting BINARY
(non-BLOB) columns on the database. On MySQL, the appropriate type is BINARY, on
Oracle it would be RAW.
This means, I can fix this using a columnDefinition on
one database. With BINARY, the tests pass on MySQL, with RAW, they pass on
Oracle. But I cant't fix it on both (let alone on all) databases
simultaneously.
I could imagine to specify the column definition in
orm.xml and have ant replace some place-holder with the appropriate type. Ugly
solution, I'd say.
Or, I could introduce a descriptor customizer that does
the adjustment. Also pretty ugly as I'd prefer to keep the WDF using pure
JPA.
Is there an option I am missing? Some custom
type?
-Adrian
PS.
Related bugs:
SAP AG Dietmar-Hopp-Allee 16, 69190 Walldorf,
Germany
Sitz der
Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning
Kagermann (Sprecher/CEO), Léo Apotheker (stellvertretender Sprecher/Deputy CEO),
Werner Brandt, Claus Heinrich, Gerhard Oswald, John Schwarz, Peter
Zencke
Vorsitzender des
Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso
Plattner Registergericht/Commercial Register Mannheim No HRB
350269
Hi,
yes, I have introduced a columnDefinition to fix a
failing test on MySQL. But it obvisously spoiled the tests on Oracle.
Bad idea.
I'll try to come up with something more
portable.
-Adrian
Hi Adrian,
Starting yesterday (Wed. July 14th) I am
getting lots of errors (146 errors 4 failures) when I run test-wdf on
Oracle, yet official build results are clean.
It seems all the errors
are the same - table doesn't exist. It look like:
Internal Exception:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Error Code: 942 Call: SELECT t1.ID, t1.LASTNAME, t1.FIRSTNAME, t1.SALARY,
t1.SAMPLE_ACCOUNT, t1.PROFILE_GUID, t1.DEPARTMENT, t1.COSTCENTER,
t1.CUBICLE_FLOOR, t1.CUBICLE_PLACE, t1.BROKERAGE_ACCOUNT, t1.EMP_START,
t1.EMP_END FROM TMP_EMP_BICYCLE t0, TMP_EMP t1 WHERE ((t0.BICYCLE_ID = ?)
AND (t1.ID = t0.EMPLOYEE_ID)) bind => [7] Query:
ReadAllQuery(name="riders" referenceClass=Employee sql="SELECT t1.ID,
t1.LASTNAME, t1.FIRSTNAME, t1.SALARY, t1.SAMPLE_ACCOUNT, t1.PROFILE_GUID,
t1.DEPARTMENT, t1.COSTCENTER, t1.CUBICLE_FLOOR, t1.CUBICLE_PLACE,
t1.BROKERAGE_ACCOUNT, t1.EMP_START, t1.EMP_END FROM TMP_EMP_BICYCLE t0,
TMP_EMP t1 WHERE ((t0.BICYCLE_ID = ?) AND (t1.ID = t0.EMPLOYEE_ID))")
Local Exception Stack: Exception [EclipseLink-4002] (Eclipse
Persistence Services - 2.2.0.qualifier):
org.eclipse.persistence.exceptions.DatabaseException Internal Exception:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not
exist
or
Exception [EclipseLink-4002] (Eclipse
Persistence Services - 2.2.0.qualifier):
org.eclipse.persistence.exceptions.DatabaseException Internal Exception:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Error Code: 942 Call: INSERT INTO TMP_EMP (ID, LASTNAME, FIRSTNAME, SALARY,
SAMPLE_ACCOUNT, PROFILE_GUID, DEPARTMENT, COSTCENTER, CUBICLE_FLOOR,
CUBICLE_PLACE, BROKERAGE_ACCOUNT, EMP_START, EMP_END) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?) bind => [1234, Mouse, Mighty, null, null, null,
null, null, null, null, null, null, null] Query:
InsertObjectQuery(org.eclipse.persistence.testing.models.wdf.jpa1.employee.Employee@1de6ff8)
javax.persistence.RollbackException: Exception [EclipseLink-4002]
(Eclipse Persistence Services - 2.2.0.qualifier):
org.eclipse.persistence.exceptions.DatabaseException Internal Exception:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not
exist
Any idea what that might
be?
Thanks,
Andrei
eclipselink.jpa.wdf.test\reports\*.*
is attached
On 14/07/2010 7:30 AM, Goerler, Adrian wrote:
Hi,
reviewed by Kevin and checked in
in trunk at # 7814,
-Adrian
Hi Adrian, The patch for this
workaround are fine for me.
Thanks, Kevin
On 13/07/2010
12:51 PM, Goerler, Adrian wrote:
Hi Kevin,
I am proposing a workaround for the failing WDF tests until the
issue 317448 is solved.
The workaround uses a columnDefinition and hence will work on
MySQL only, I am afraid.
Could you please have a look?
Thanks,
Adrian
SAP AG
Dietmar-Hopp-Allee 16, 69190
Walldorf, Germany
Sitz der
Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board:
Henning Kagermann (Sprecher/CEO), Léo Apotheker (stellvertretender
Sprecher/Deputy CEO), Werner Brandt, Claus Heinrich, Gerhard Oswald,
John Schwarz, Peter Zencke
Vorsitzender des
Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso
Plattner
Registergericht/Commercial
Register Mannheim No HRB 350269
_______________________________________________
eclipselink-dev mailing list
eclipselink-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-dev
|