You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by Brian McCallister <mc...@forthillcompany.com> on 2004/06/20 21:28:25 UTC
Postponing 1.0 until Weds, Jun 23
As right now the status of OJB on java 1.2 and 1.3 is unknown, there
are some problems with postgres, and no report on the results with
Oracle or MySQL I am not going to release 1.0 tonight.
As soon as these are cleared up we can push a release.
-Brian
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Thomas Dudziak <to...@first.fhg.de>.
Martin Kalén wrote:
> Armin Waibel wrote:
>
>> I have some question relating to OJB269, OJB270 and OJB271:
>>
>> ---------------
>> OJB269:
>> "Incorrect JDBC type mappings in Torque schema for JUnit test table
>> BLOB_TEST cause BlobTest to fail when using Oracle"
>> ----------------
>> If I apply your patch the BlobTest fails with sapDB/maxDB. With
>> current version the test pass. The problem seems to be the datatype
>> used by Torque to create the blob column
>
>
> Yes, Torque is creating invalid DDL for e.g. HSQLDB.
>
> Since the test is called _Blob_Test I think it makes most sence to
> apply OJB269.
>
>
> But since we are having some issues with Torque, I vote for adding
> this to the stoplist of "known failures" and dealing with it after the
> 1.0 relase.
+1
IMO we should not deal with Torque bugs right now, also because I will
investigate whether commons-sql could replace Torque once the 1.0 is
out. Its easier to use/integrate, and I have commit rights there, so
changes would be easier.
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Martin Kalén <ma...@curalia.se>.
Armin Waibel wrote:
> I have some question relating to OJB269, OJB270 and OJB271:
>
> ---------------
> OJB269:
> "Incorrect JDBC type mappings in Torque schema for JUnit test table
> BLOB_TEST cause BlobTest to fail when using Oracle"
> ----------------
> If I apply your patch the BlobTest fails with sapDB/maxDB. With current
> version the test pass. The problem seems to be the datatype used by
> Torque to create the blob column
Yes, Torque is creating invalid DDL for e.g. HSQLDB.
Since the test is called _Blob_Test I think it makes most sence to apply OJB269.
But since we are having some issues with Torque, I vote for adding this to the stoplist of
"known failures" and dealing with it after the 1.0 relase.
Adding this test to known failures and applying OJB269 is not making the regression test
suite less complete IMO, since the BlobTest was previously testing other datatypes and not
LOB:s.
> --------------
> OJB270:
> "OJB DB-profile and build system support for ConnectionPool validation
> query"
> --------------
> I agree in pass the @validationQuery@ attribute, but why should we pass
> @TEST_ON_BORROW@ and @TEST_ON_RETURN@ too? By default AFAIK
> @TEST_ON_BORROW@ is true and why do we need to test on return?
Why not have them there? Makes no difference by default, but it is possible to tweak
platform profiles for validation query and testing when neccesary.
But I'm not beeing stubborn here - ditch'em if you feel like and do the 1.0 already! ;-)
(Main thing is to have testOnBorrow="true" and validationQuery="SELECT 1 FROM DUAL" for
Oracle9i platform to make it work out of the box.)
> --------------
> OJB271:
> " JdbcTypesHelper handling of LONGVARBINARY not compatible with Oracle9i"
> --------------
> All tests pass against sapDB after change. I don't know anything about
> the JDBC spec, so please excuse my question. Is this patch only needed
> for LONGVARBINARY columns? What about VARBINARY/BINARY?
It's all a mess with the JDBC datatypes since each RDBMS will usually translate the DDL
into it's own favourite proprieraty types anyway...
We should probably add more testcases for this after 1.0, but if it's not regression and
not introducing any new failures it's at least as good as RC7 (and better for Oracle9i!).
Regards,
Martin
--
Martin Kalén
Curalia AB Web: http://www.curalia.se
Orrspelsvägen 2B Mail: info@curalia.se
SE-182 79 Stocksund Tel: +46-8-410 064 40
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Armin Waibel <ar...@apache.org>.
Hi,
>
> With OJB268 (already in CVS), OJB269, OJB270 and OJB271 applied all
> JUnit tests pass
> on Oracle9i.
This are good news!
I have some question relating to OJB269, OJB270 and OJB271:
---------------
OJB269:
"Incorrect JDBC type mappings in Torque schema for JUnit test table
BLOB_TEST cause BlobTest to fail when using Oracle"
----------------
If I apply your patch the BlobTest fails with sapDB/maxDB. With current
version the test pass. The problem seems to be the datatype used by
Torque to create the blob column
[torque-sql-exec] Our new url -> jdbc:sapdb://localhost/OJB
[torque-sql-exec] Executing file:
E:\dev\ojb-head\db-ojb\target\test\sql\ojbtest-schema.sql
[torque-sql-exec] Failed to execute: CREATE TABLE BLOB_TEST ( ID INTEGER
NOT NULL, BLOB_VALUE_ LONG BYTE, CLOB_VALUE_ LONG UNICODE )
[torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException:
[-3002] (at 87): Invalid datatype
Seems Torque doesn't handle BOLB/CLOB type for sapDB in right way. Does
the BlobTest pass against MySQL and PostgreSQL out of the box?
--------------
OJB270:
"OJB DB-profile and build system support for ConnectionPool validation
query"
--------------
I agree in pass the @validationQuery@ attribute, but why should we pass
@TEST_ON_BORROW@ and @TEST_ON_RETURN@ too? By default AFAIK
@TEST_ON_BORROW@ is true and why do we need to test on return?
--------------
OJB271:
" JdbcTypesHelper handling of LONGVARBINARY not compatible with Oracle9i"
--------------
All tests pass against sapDB after change. I don't know anything about
the JDBC spec, so please excuse my question. Is this patch only needed
for LONGVARBINARY columns? What about VARBINARY/BINARY?
regards,
Armin
Martin Kalén wrote:
> Martin Kalén wrote:
>
>>> With these issues out of the way, these are the results running
>>> ant junit
>>> against db-ojb HEAD from CVS as of June 21 2004 12:30 UTC
>>> with Sun JDK 1.4.2_04 on Windows XP SP 1, Oracle9i Personal rel
>>> 9.2.0.1.0
>>> (with OJB.skip.issues=true in build.properties):
>>> [junit] Running org.apache.ojb.odmg.AllTests
>>> [junit] Tests run: 196, Failures: 0, Errors: 1
>
>
> The ODMG test failure was due to Oracle thin driver truncating the
> LONGVARBINARY column
> used as OID_ for OJB_NRM-table, causing the conversion class trying to
> read the data
> as a gzip InputStream to spit exceptions about incompatible format
> (which I can
> understand when the gzipped output stream written was byte[403], but
> read back as
> byte[255]).
>
> After applying OJB271 locally, patching JdbcTypesHelper to stream data
> from LONGVARBINARY,
> this test pass.
>
>
> With OJB268 (already in CVS), OJB269, OJB270 and OJB271 applied all
> JUnit tests pass
> on Oracle9i.
> "
> [junit] Running org.apache.ojb.broker.AllTests
> [junit] Tests run: 402, Failures: 0, Errors: 0, Time elapsed: 92,672
> sec
> [junit] Running org.apache.ojb.odmg.AllTests
> [junit] [BOOT] INFO: Loading OJB's properties from file [snip]
> [junit] [BOOT] INFO: No value for key 'InterceptorClass'
> [junit] Tests run: 196, Failures: 0, Errors: 0, Time elapsed: 21,813
> sec
> [junit] Running org.apache.ojb.soda.AllTests
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3,469 sec
> [junit] Running org.apache.ojb.otm.AllTests
> [junit] Tests run: 79, Failures: 0, Errors: 0, Time elapsed: 17,218 sec
> "
>
> Neat. :-)
>
> /Martin
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Thomas Dudziak <to...@first.fhg.de>.
Thomas Dudziak wrote:
> How's status ?
>
> I've checked the tutorials (except JDO which I'll check today), and so
> far they work with the updated ojb-blank project, which itself works
> nicely too (checked against Hsqldb and MySQL) and now include XDoclet
> and Torque targets. I'll check the tutorial docs in more detail in the
> next couple of days, but since that is doc, it shouldn't hinder release,
> right ?
JDO tutorial also works with ojb-blank.
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Martin Kalén <ma...@curalia.se>.
Thomas Dudziak wrote:
> How's status ?
Two things;
1)
Patches for OJB269, OJB270 and OJB271 need to be applied for all JUnit tests to pass
under Oracle9i.
(Applying OJB269 introduces DDL failure for HSQLDB probably beacuse of Torque error(?) but
the BlobTest is disabled for HSQL som there is no new regression test failure. Previously
the BLOB test was in fact not testing BLOB handling because of invalid DDL...)
2)
The HOWTO for using LOB's with Oracle should be updated (always been a really promising
introduction and then "..." where it gets down to real code). Also the 3 different Oracle
platform impls with their respective capabilities regarding LOB lengths should be properly
documented.
If the patch for OJB272 is applied the docs update can wait since messages in exceptions
thrown will be a bit more to the point and less confusing.
Regards,
Martin
--
Martin Kalén
Curalia AB Web: http://www.curalia.se
Orrspelsvägen 2B Mail: info@curalia.se
SE-182 79 Stocksund Tel: +46-8-410 064 40
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by "Robert S. Sfeir" <ro...@codepuccino.com>.
Last I checked tests still had probs with postgresql and mysql. It seems
it's tests only. Unfortunately I am crammed in corporate meetings this
week, and can't get to the postgresql 'probing'.
Also there is an issue which was posted by a user today on the user list
regarding oracle and optimistic locking, we should make sure that's fixed
before we release.
Real sorry I can't dig more right now... that time of the month :-)
R
On 6/23/04 7:02 AM, "Thomas Dudziak" <to...@first.fhg.de> wrote:
> How's status ?
>
> I've checked the tutorials (except JDO which I'll check today), and so
> far they work with the updated ojb-blank project, which itself works
> nicely too (checked against Hsqldb and MySQL) and now include XDoclet
> and Torque targets. I'll check the tutorial docs in more detail in the
> next couple of days, but since that is doc, it shouldn't hinder release,
> right ?
>
> So, can we release 1.0 today, or are there problems left that need to
> tackled before release (e.g. Oracle/PostgreSQL problems) ?
>
> Tom
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Thomas Dudziak <to...@first.fhg.de>.
How's status ?
I've checked the tutorials (except JDO which I'll check today), and so
far they work with the updated ojb-blank project, which itself works
nicely too (checked against Hsqldb and MySQL) and now include XDoclet
and Torque targets. I'll check the tutorial docs in more detail in the
next couple of days, but since that is doc, it shouldn't hinder release,
right ?
So, can we release 1.0 today, or are there problems left that need to
tackled before release (e.g. Oracle/PostgreSQL problems) ?
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Martin Kalén <ma...@curalia.se>.
Martin Kalén wrote:
>> With these issues out of the way, these are the results running
>> ant junit
>> against db-ojb HEAD from CVS as of June 21 2004 12:30 UTC
>> with Sun JDK 1.4.2_04 on Windows XP SP 1, Oracle9i Personal rel 9.2.0.1.0
>> (with OJB.skip.issues=true in build.properties):
>> [junit] Running org.apache.ojb.odmg.AllTests
>> [junit] Tests run: 196, Failures: 0, Errors: 1
The ODMG test failure was due to Oracle thin driver truncating the LONGVARBINARY column
used as OID_ for OJB_NRM-table, causing the conversion class trying to read the data
as a gzip InputStream to spit exceptions about incompatible format (which I can
understand when the gzipped output stream written was byte[403], but read back as
byte[255]).
After applying OJB271 locally, patching JdbcTypesHelper to stream data from LONGVARBINARY,
this test pass.
With OJB268 (already in CVS), OJB269, OJB270 and OJB271 applied all JUnit tests pass
on Oracle9i.
"
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 402, Failures: 0, Errors: 0, Time elapsed: 92,672 sec
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: Loading OJB's properties from file [snip]
[junit] [BOOT] INFO: No value for key 'InterceptorClass'
[junit] Tests run: 196, Failures: 0, Errors: 0, Time elapsed: 21,813 sec
[junit] Running org.apache.ojb.soda.AllTests
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3,469 sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 79, Failures: 0, Errors: 0, Time elapsed: 17,218 sec
"
Neat. :-)
/Martin
--
Martin Kalén
Curalia AB Web: http://www.curalia.se
Orrspelsvägen 2B Mail: info@curalia.se
SE-182 79 Stocksund Tel: +46-8-410 064 40
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Martin Kalén <ma...@curalia.se>.
Martin Kalén wrote:
> With these issues out of the way, these are the results running
> ant junit
> against db-ojb HEAD from CVS as of June 21 2004 12:30 UTC
> with Sun JDK 1.4.2_04 on Windows XP SP 1, Oracle9i Personal rel 9.2.0.1.0
> (with OJB.skip.issues=true in build.properties):
> "
> [junit] Running org.apache.ojb.broker.AllTests
> [junit] Tests run: 402, Failures: 0, Errors: 3, Time elapsed:
> 116,328 sec
Failures:
1) BlobTest.testReadNullBlob
Incorrect field mappings for Torque: Oracle confused when getting
data from [BC]LOB with null-data.
Already resolved by Armins commit for issue OJB-268
http://nagoya.apache.org/scarab/issues/id/OJB268
2) BlobTest.testBlobInsertion
The test case uses long [BC]LOB values and I had P6Spy activated,
causing native Oracle LOB handling to fail (it must have direct
access to the OracleConnection, OraclePreparedStatement etc).
There have been reports on the list about using Oracle LOBs in a managed
environment (eg WebLogic) - these issues are probably related.
I will open up a separate issue and adding a patch with better info
in the exceptions thrown when native Oracle LOB handling can't be used.
However; the BlobTest.testBlobInsertion can be considered OK as it
passes with the properties that OJB ship with.
3) OptimisticLockingTest.testTimestampLock
See my mail re "Nanosecond precision makes optimistic locking unusable with Oracle"
> [junit] Running org.apache.ojb.odmg.AllTests
> [junit] Tests run: 196, Failures: 0, Errors: 1
Haven't looked yet - on it... ;-)
Regards,
Martin
--
Martin Kalén
Curalia AB Web: http://www.curalia.se
Orrspelsvägen 2B Mail: info@curalia.se
SE-182 79 Stocksund Tel: +46-8-410 064 40
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Brian McCallister <mc...@forthillcompany.com>.
Much appreciated!
-Brian
On Jun 21, 2004, at 7:45 AM, Martin Kalén wrote:
> Brian McCallister wrote:
>
>> As right now the status of OJB on java 1.2 and 1.3 is unknown, there
>> are some problems with postgres, and no report on the results with
>> Oracle or MySQL I am not going to release 1.0 tonight.
>
> With Oracle, there was an old issue with the testcases and the SQL DDL-
> statements generated by Torque. I filed an issue in Scarab with a
> diff-attachment that Armin applied to solve this. (See issue OJB-268)
>
> Oracle also needs a validation query check when borrowing brokers for
> the testcases, otherwise the server may (will...) close connections
> that
> are later re-used for preparing statements in the JDBC client.
>
> There is yet no support for adding a validation query in
> build.properties,
> so I had to do this manually for the default PB-pool in
> src/test/org/apache/ojb/repository_database.xml:
> <connection-pool
> maxActive="21"
> testOnBorrow="true"
> validationQuery="SELECT 1 FROM DUAL"/>
>
> Adding a new property to build.properties and a new
> @pattern@-replacement
> in Ant should solve this - I will file a diff in Scarab if I add this
> myself.
>
>
> With these issues out of the way, these are the results running
> ant junit
> against db-ojb HEAD from CVS as of June 21 2004 12:30 UTC
> with Sun JDK 1.4.2_04 on Windows XP SP 1, Oracle9i Personal rel
> 9.2.0.1.0
> (with OJB.skip.issues=true in build.properties):
> "
> [junit] Running org.apache.ojb.broker.AllTests
> [junit] Tests run: 402, Failures: 0, Errors: 3, Time elapsed:
> 116,328 sec
>
> [junit] TEST org.apache.ojb.broker.AllTests FAILED
> [junit] Running org.apache.ojb.odmg.AllTests
> [junit] [BOOT] INFO: Loading OJB's properties from (snip)
> [junit] [BOOT] INFO: No value for key 'InterceptorClass'
> [junit] Tests run: 196, Failures: 0, Errors: 1, Time elapsed:
> 25,219 sec
>
> [junit] TEST org.apache.ojb.odmg.AllTests FAILED
> [junit] Running org.apache.ojb.soda.AllTests
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3,64
> sec
>
> [junit] Running org.apache.ojb.otm.AllTests
> [junit] Tests run: 79, Failures: 0, Errors: 0, Time elapsed:
> 15,703 sec
> "
>
> I am analysing the logs at the moment and will get back with details...
>
> --
> Martin Kalén
> Curalia AB Web: http://www.curalia.se
> Orrspelsvägen 2B Mail: info@curalia.se
> SE-182 79 Stocksund Tel: +46-8-410 064 40
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Martin Kalén <ma...@curalia.se>.
Brian McCallister wrote:
> As right now the status of OJB on java 1.2 and 1.3 is unknown, there are
> some problems with postgres, and no report on the results with Oracle or
> MySQL I am not going to release 1.0 tonight.
With Oracle, there was an old issue with the testcases and the SQL DDL-
statements generated by Torque. I filed an issue in Scarab with a
diff-attachment that Armin applied to solve this. (See issue OJB-268)
Oracle also needs a validation query check when borrowing brokers for
the testcases, otherwise the server may (will...) close connections that
are later re-used for preparing statements in the JDBC client.
There is yet no support for adding a validation query in build.properties,
so I had to do this manually for the default PB-pool in
src/test/org/apache/ojb/repository_database.xml:
<connection-pool
maxActive="21"
testOnBorrow="true"
validationQuery="SELECT 1 FROM DUAL"/>
Adding a new property to build.properties and a new @pattern@-replacement
in Ant should solve this - I will file a diff in Scarab if I add this myself.
With these issues out of the way, these are the results running
ant junit
against db-ojb HEAD from CVS as of June 21 2004 12:30 UTC
with Sun JDK 1.4.2_04 on Windows XP SP 1, Oracle9i Personal rel 9.2.0.1.0
(with OJB.skip.issues=true in build.properties):
"
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 402, Failures: 0, Errors: 3, Time elapsed: 116,328 sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: Loading OJB's properties from (snip)
[junit] [BOOT] INFO: No value for key 'InterceptorClass'
[junit] Tests run: 196, Failures: 0, Errors: 1, Time elapsed: 25,219 sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3,64 sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 79, Failures: 0, Errors: 0, Time elapsed: 15,703 sec
"
I am analysing the logs at the moment and will get back with details...
--
Martin Kalén
Curalia AB Web: http://www.curalia.se
Orrspelsvägen 2B Mail: info@curalia.se
SE-182 79 Stocksund Tel: +46-8-410 064 40
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Brian McCallister <mc...@forthillcompany.com>.
Much appreciated!
-Brian
On Jun 21, 2004, at 5:39 AM, Ilkka Priha wrote:
> Hi
>
> Many MySQL failures are due to missing support for subqueries in 4.0.x
> versions. With 4.1.2a all tests pass, but some locking errors occur.
>
> I've added foreign key indeces to ojbtest-schema.sql to make it
> compatible with MySQL's InnoDB engine to enable transactions.
>
> Windows XP, JDK 1.4.2_03, MySQL 4.1.2-alpha, Connector/J 3.0.14
>
> [junit] Running org.apache.ojb.broker.AllTests
> [junit] Tests run: 402, Failures: 0, Errors: 17, Time elapsed: 117.274
> sec
>
> [junit] TEST org.apache.ojb.broker.AllTests FAILED
> [junit] Running org.apache.ojb.odmg.AllTests
> [junit] [BOOT] INFO: Loading OJB's properties from file
> file:/E:/Cc/Apache/d
> -ojb/target/test/ojb/OJB.properties
> [junit] [BOOT] INFO: No value for key 'InterceptorClass'
> [junit] Tests run: 196, Failures: 0, Errors: 4, Time elapsed: 24.653
> sec
>
> [junit] TEST org.apache.ojb.odmg.AllTests FAILED
> [junit] Running org.apache.ojb.soda.AllTests
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 1.914 sec
>
> [junit] Running org.apache.ojb.otm.AllTests
> [junit] Tests run: 79, Failures: 0, Errors: 0, Time elapsed: 14.745 sec
>
>
> PB Error (repeated 17 times only in this test case):
>
> Testcase: testRuntimeMetadataChanges took 1.509 sec
> Caused an ERROR
> java.sql.SQLException: null, message from server: "Deadlock found
> when trying to get lock; Try restarting transaction"
> org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: null, message from server: "Deadlock found
> when trying to get lock; Try restarting transaction"
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdateSQL(JdbcA
> ccessImpl.java:438)
> at
> org.apache.ojb.broker.core.MtoNBroker.deleteMtoNImplementor(MtoNBroker.
> java:155)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkMtoN(Persi
> stenceBrokerImpl.java:854)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(Persi
> stenceBrokerImpl.java:803)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceB
> rokerImpl.java:1682)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBroke
> rImpl.java:1575)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBroke
> rImpl.java:707)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkMtoN(Persi
> stenceBrokerImpl.java:880)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(Persi
> stenceBrokerImpl.java:803)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceB
> rokerImpl.java:1682)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBroke
> rImpl.java:1575)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBroke
> rImpl.java:707)
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegating
> PersistenceBroker.java:174)
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegating
> PersistenceBroker.java:174)
> at
> org.apache.ojb.broker.metadata.MetadataMultithreadedTest$ThreadedUsingB
> roker.runTestCase(MetadataMultithreadedTest.java:273)
> at
> org.apache.ojb.junit.JUnitExtensions$MultiThreadedTestCase$TestCaseRunn
> able.run(JUnitExtensions.java:186)
> at java.lang.Thread.run(Thread.java:534)
> Caused by: java.sql.SQLException: null, message from server:
> "Deadlock found when trying to get lock; Try restarting transaction"
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
> at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:
> 1741)
> at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:
> 1588)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdateSQL(JdbcA
> ccessImpl.java:417)
> ... 16 more
>
> ODMG error (repeated 4 times only in this test case):
>
> Testcase: testLockingOfObject took 1.68 sec
> Caused an ERROR
> Can not lock
> org.apache.ojb.odmg.LockingMultithreadedTest$LockObject@11c0d60 for
> WRITE
> org.odmg.LockNotGrantedException: Can not lock
> org.apache.ojb.odmg.LockingMultithreadedTest$LockObject@11c0d60 for
> WRITE
> at org.apache.ojb.odmg.TransactionImpl.lock(TransactionImpl.java:249)
> at
> org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(Lo
> ckingMultithreadedTest.java:148)
> ...
>
> -- Ilkka
>
>
> Thomas Dudziak wrote:
>
>> Brian McCallister wrote:
>>> As right now the status of OJB on java 1.2 and 1.3 is unknown, there
>>> are some problems with postgres, and no report on the results with
>>> Oracle or MySQL I am not going to release 1.0 tonight.
>> Results for MySQL (WindowsXP, JDK 1.4.2_02, MySQL 4.0.12 with
>> Connector/J 3.0.14 stable)
>> [junit] Running org.apache.ojb.broker.AllTests
>> [junit] Tests run: 402, Failures: 6, Errors: 5, Time elapsed: 60,984
>> sec
>> [junit] TEST org.apache.ojb.broker.AllTests FAILED
>> [junit] Running org.apache.ojb.odmg.AllTests
>> [junit] Tests run: 196, Failures: 2, Errors: 0, Time elapsed: 14,063
>> sec
>> [junit] TEST org.apache.ojb.odmg.AllTests FAILED
>> [junit] Running org.apache.ojb.soda.AllTests
>> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 2,578 sec
>> [junit] Running org.apache.ojb.otm.AllTests
>> [junit] Tests run: 79, Failures: 1, Errors: 0, Time elapsed: 14,187
>> sec
>> [junit] TEST org.apache.ojb.otm.AllTests FAILED
>> PB Errors:
>> Testcase: testSubQuery2 took 0,078 sec
>> Caused an ERROR
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at line
>> 1"
>> org.apache.ojb.broker.PersistenceBrokerException:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at line
>> 1"
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:240) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:252) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(
>> PersistenceBrokerImpl.java:1238) at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy
>> Query(DelegatingPersistenceBroker.java:332) at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy
>> Query(DelegatingPersistenceBroker.java:332) at
>> org.apache.ojb.broker.QueryTest.testSubQuery2(QueryTest.java:172)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) Caused by:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at line
>> 1"
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcce
>> ssImpl.java:318) at
>> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryOb
>> ject.java:74) at
>> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:
>> 183)
>> at
>> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIt
>> eratorFactoryImpl.java:58) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuer
>> y(PersistenceBrokerImpl.java:1824) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(
>> PersistenceBrokerImpl.java:1354) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:110) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:232) ... 21 more
>> Caused by: java.sql.SQLException: Syntax error or access violation,
>> message from server: "You have an error in your SQL syntax. Check
>> the manual that corresponds to your MySQL server version for the
>> right syntax to use near 'SELECT DISTINCT B0.Kategorie_Nr FROM
>> Artikel B0)' at line 1"
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
>> at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
>> 1555)
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcce
>> ssImpl.java:283) ... 28 more
>> Testcase: testSubQuery1 took 0,016 sec
>> Caused an ERROR
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE
>> B0.Artikelname"
>> org.apache.ojb.broker.PersistenceBrokerException:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE
>> B0.Artikelname"
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:240) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:252) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(
>> PersistenceBrokerImpl.java:1238) at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy
>> Query(DelegatingPersistenceBroker.java:332) at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy
>> Query(DelegatingPersistenceBroker.java:332) at
>> org.apache.ojb.broker.QueryTest.testSubQuery1(QueryTest.java:199)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) Caused by:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE
>> B0.Artikelname"
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcce
>> ssImpl.java:318) at
>> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryOb
>> ject.java:74) at
>> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:
>> 183)
>> at
>> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIt
>> eratorFactoryImpl.java:58) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuer
>> y(PersistenceBrokerImpl.java:1836) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(
>> PersistenceBrokerImpl.java:1354) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:110) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:232) ... 21 more
>> Caused by: java.sql.SQLException: Syntax error or access violation,
>> message from server: "You have an error in your SQL syntax. Check
>> the manual that corresponds to your MySQL server version for the
>> right syntax to use near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0
>> WHERE B0.Artikelname"
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
>> at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
>> 1555)
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcce
>> ssImpl.java:283) ... 28 more
>> Testcase: testSubQuery3 took 0 sec
>> Caused an ERROR
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE
>> B0.Kategori"
>> org.apache.ojb.broker.PersistenceBrokerException:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE
>> B0.Kategori"
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:240) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:252) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(
>> PersistenceBrokerImpl.java:1238) at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy
>> Query(DelegatingPersistenceBroker.java:332) at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy
>> Query(DelegatingPersistenceBroker.java:332) at
>> org.apache.ojb.broker.QueryTest.testSubQuery3(QueryTest.java:227)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) Caused by:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE
>> B0.Kategori"
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcce
>> ssImpl.java:318) at
>> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryOb
>> ject.java:74) at
>> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:
>> 183)
>> at
>> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIt
>> eratorFactoryImpl.java:58) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuer
>> y(PersistenceBrokerImpl.java:1824) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(
>> PersistenceBrokerImpl.java:1354) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:110) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:232) ... 21 more
>> Caused by: java.sql.SQLException: Syntax error or access violation,
>> message from server: "You have an error in your SQL syntax. Check
>> the manual that corresponds to your MySQL server version for the
>> right syntax to use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel
>> B0 WHERE B0.Kategori"
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
>> at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
>> 1555)
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcce
>> ssImpl.java:283) ... 28 more
>> Testcase: testSubQuery4 took 0,016 sec
>> Caused an ERROR
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE
>> B0.Kategori"
>> org.apache.ojb.broker.PersistenceBrokerException:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE
>> B0.Kategori"
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:240) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:252) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(
>> PersistenceBrokerImpl.java:1238) at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy
>> Query(DelegatingPersistenceBroker.java:332) at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy
>> Query(DelegatingPersistenceBroker.java:332) at
>> org.apache.ojb.broker.QueryTest.testSubQuery4(QueryTest.java:252)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) Caused by:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE
>> B0.Kategori"
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcce
>> ssImpl.java:318) at
>> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryOb
>> ject.java:74) at
>> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:
>> 183)
>> at
>> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIt
>> eratorFactoryImpl.java:58) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuer
>> y(PersistenceBrokerImpl.java:1824) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(
>> PersistenceBrokerImpl.java:1354) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:110) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:232) ... 21 more
>> Caused by: java.sql.SQLException: Syntax error or access violation,
>> message from server: "You have an error in your SQL syntax. Check
>> the manual that corresponds to your MySQL server version for the
>> right syntax to use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel
>> B0 WHERE B0.Kategori"
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
>> at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
>> 1555)
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcce
>> ssImpl.java:283) ... 28 more
>> Testcase: testDeleteWithRemovalAwareCollection took 0,031 sec
>> FAILED
>> expected:<1> but was:<2>
>> junit.framework.AssertionFailedError: expected:<1> but was:<2>
>> at
>> org.apache.ojb.broker.OneToManyTest.testDeleteWithRemovalAwareCollecti
>> on(OneToManyTest.java:65) at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) Testcase: testUserRollbackClearCache took 0,063 sec
>> FAILED
>> expected:<60> but was:<70>
>> junit.framework.AssertionFailedError: expected:<60> but was:<70>
>> at
>> org.apache.ojb.broker.PBRollbackTest.testUserRollbackClearCache(PBRoll
>> backTest.java:160) at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) Testcase: testUserRollback took 0,078 sec
>> FAILED
>> expected:<80> but was:<90>
>> junit.framework.AssertionFailedError: expected:<80> but was:<90>
>> at
>> org.apache.ojb.broker.PBRollbackTest.testUserRollback(PBRollbackTest.j
>> ava:200) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>> Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) Testcase: testRollbackCausedByNotExistingObject took
>> 0,047 sec
>> FAILED
>> Object count does not match after rollback expected:<100> but
>> was:<110>
>> junit.framework.AssertionFailedError: Object count does not match
>> after rollback expected:<100> but was:<110>
>> at
>> org.apache.ojb.broker.PBRollbackTest.testRollbackCausedByNotExistingOb
>> ject(PBRollbackTest.java:252) at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) Testcase: testRollbackCausedBySQLException took 0,031
>> sec
>> FAILED
>> Test should throw a exception in place
>> junit.framework.AssertionFailedError: Test should throw a exception
>> in place
>> at
>> org.apache.ojb.broker.PBRollbackTest.testRollbackCausedBySQLException(
>> PBRollbackTest.java:289) at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) Testcase: testMultipleInsertAndRollback took 9,125
>> sec
>> FAILED
>> expected:<2000> but was:<4000>
>> junit.framework.AssertionFailedError: expected:<2000> but was:<4000>
>> at
>> org.apache.ojb.broker.sequence.SMMultiThreadedTest.checkGeneratedObjec
>> ts(SMMultiThreadedTest.java:80) at
>> org.apache.ojb.broker.sequence.SMMultiThreadedTest.testMultipleInsertA
>> ndRollback(SMMultiThreadedTest.java:55) at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) at
>> org.apache.ojb.junit.JUnitExtensions$MultiThreadedTestCase.run(JUnitEx
>> tensions.java:107) Testcase: testSubQueryExists took 0 sec
>> Caused an ERROR
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0 INNER
>> JOIN P"
>> org.apache.ojb.broker.PersistenceBrokerException:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0 INNER
>> JOIN P"
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:240) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:252) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(
>> PersistenceBrokerImpl.java:1238) at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy
>> Query(DelegatingPersistenceBroker.java:332) at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy
>> Query(DelegatingPersistenceBroker.java:332) at
>> org.apache.ojb.broker.PathTest.testSubQueryExists(PathTest.java:612)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) Caused by:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message
>> from server: "You have an error in your SQL syntax. Check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0 INNER
>> JOIN P"
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcce
>> ssImpl.java:318) at
>> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryOb
>> ject.java:74) at
>> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:
>> 183)
>> at
>> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIt
>> eratorFactoryImpl.java:58) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuer
>> y(PersistenceBrokerImpl.java:1824) at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(
>> PersistenceBrokerImpl.java:1354) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:110) at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q
>> ueryReferenceBroker.java:232) ... 21 more
>> Caused by: java.sql.SQLException: Syntax error or access violation,
>> message from server: "You have an error in your SQL syntax. Check
>> the manual that corresponds to your MySQL server version for the
>> right syntax to use near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM
>> P_A_TABLE B0 INNER JOIN P"
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
>> at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
>> 1555)
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcce
>> ssImpl.java:283) ... 28 more
>> ODMG Errors:
>> Testcase: testTransactionFlush took 0,032 sec
>> FAILED
>> We should not find objects from aborted tx
>> junit.framework.AssertionFailedError: We should not find objects from
>> aborted tx
>> at
>> org.apache.ojb.odmg.ODMGRollbackTest.testTransactionFlush(ODMGRollback
>> Test.java:91) at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) Testcase: testStoreDeleteThreePersons_1 took 0,015
>> sec
>> FAILED
>> children's names are equal expected:<[Child_Two_1087769433125,
>> Child_One_1087769433125]> but was:<[Child_One_1087769433125,
>> Child_Two_1087769433125]>
>> junit.framework.AssertionFailedError: children's names are equal
>> expected:<[Child_Two_1087769433125, Child_One_1087769433125]> but
>> was:<[Child_One_1087769433125, Child_Two_1087769433125]>
>> at
>> org.apache.ojb.odmg.PersonWithArrayTest.testStoreDeleteThreePersons_1(
>> PersonWithArrayTest.java:100) at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) OTM Errors:
>> Testcase: testOtmCache took 0,078 sec
>> FAILED
>> should be equal expected:<1> but was:<2>
>> junit.framework.ComparisonFailure: should be equal expected:<1> but
>> was:<2>
>> at
>> org.apache.ojb.otm.OtmExamples.testOtmCache(OtmExamples.java:353)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>> ava:39) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>> orImpl.java:25) Tom
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-dev-help@db.apache.org
>> .
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Ilkka Priha <im...@surfeu.fi>.
All transactional tests fail with MySQL 4.1.2a/MyISAM engine, as expected
without transaction support, and others pass without errors.
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 402, Failures: 6, Errors: 0, Time elapsed: 76.86 sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: Loading OJB's properties from file file:/E:/Cc/Apache/d
-ojb/target/test/ojb/OJB.properties
[junit] [BOOT] INFO: No value for key 'InterceptorClass'
[junit] Tests run: 196, Failures: 2, Errors: 0, Time elapsed: 17.268 sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 1.916 sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 79, Failures: 1, Errors: 0, Time elapsed: 12.795 sec
PB Failures:
Testcase: testDeleteWithRemovalAwareCollection took 0.031 sec
FAILED
expected:<1> but was:<2>
junit.framework.AssertionFailedError: expected:<1> but was:<2>
Testcase: testUserRollbackClearCache took 0.093 sec
FAILED
expected:<60> but was:<70>
junit.framework.AssertionFailedError: expected:<60> but was:<70>
Testcase: testUserRollback took 0.094 sec
FAILED
expected:<80> but was:<90>
junit.framework.AssertionFailedError: expected:<80> but was:<90>
Testcase: testRollbackCausedByNotExistingObject took 0.062 sec
FAILED
Object count does not match after rollback expected:<100> but was:<110>
junit.framework.AssertionFailedError: Object count does not match after rollback
expected:<100> but was:<110>
Testcase: testRollbackCausedBySQLException took 0.047 sec
FAILED
Test should throw a exception in place
junit.framework.AssertionFailedError: Test should throw a exception in place
Testcase: testMultipleInsertAndRollback took 11.423 sec
FAILED
expected:<2000> but was:<4000>
junit.framework.AssertionFailedError: expected:<2000> but was:<4000>
ODMG Failures:
Testcase: testTransactionFlush took 0.031 sec
FAILED
We should not find objects from aborted tx
junit.framework.AssertionFailedError: We should not find objects from aborted tx
Testcase: testStoreDeleteThreePersons_1 took 0.031 sec
FAILED
children's names are equal expected:<[Child_Two_1087823392231,
Child_One_1087823392231]> but was:<[Child_One_1087823392231,
Child_Two_1087823392231]>
junit.framework.AssertionFailedError: children's names are equal
expected:<[Child_Two_1087823392231, Child_One_1087823392231]> but
was:<[Child_One_1087823392231, Child_Two_1087823392231]>
OTM Failures:
Testcase: testOtmCache took 0.094 sec
FAILED
should be equal expected:<1> but was:<2>
junit.framework.ComparisonFailure: should be equal expected:<1> but was:<2>
-- Ilkka
Ilkka Priha wrote:
> Hi
>
> Many MySQL failures are due to missing support for subqueries in 4.0.x
> versions. With 4.1.2a all tests pass, but some locking errors occur.
>
> I've added foreign key indeces to ojbtest-schema.sql to make it
> compatible with MySQL's InnoDB engine to enable transactions.
>
> Windows XP, JDK 1.4.2_03, MySQL 4.1.2-alpha, Connector/J 3.0.14
>
> [junit] Running org.apache.ojb.broker.AllTests
> [junit] Tests run: 402, Failures: 0, Errors: 17, Time elapsed: 117.274 sec
>
> [junit] TEST org.apache.ojb.broker.AllTests FAILED
> [junit] Running org.apache.ojb.odmg.AllTests
> [junit] [BOOT] INFO: Loading OJB's properties from file
> file:/E:/Cc/Apache/d
> -ojb/target/test/ojb/OJB.properties
> [junit] [BOOT] INFO: No value for key 'InterceptorClass'
> [junit] Tests run: 196, Failures: 0, Errors: 4, Time elapsed: 24.653 sec
>
> [junit] TEST org.apache.ojb.odmg.AllTests FAILED
> [junit] Running org.apache.ojb.soda.AllTests
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 1.914 sec
>
> [junit] Running org.apache.ojb.otm.AllTests
> [junit] Tests run: 79, Failures: 0, Errors: 0, Time elapsed: 14.745 sec
>
>
> PB Error (repeated 17 times only in this test case):
>
> Testcase: testRuntimeMetadataChanges took 1.509 sec
> Caused an ERROR
> java.sql.SQLException: null, message from server: "Deadlock found when
> trying to get lock; Try restarting transaction"
> org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: null, message from server: "Deadlock found when
> trying to get lock; Try restarting transaction"
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdateSQL(JdbcAccessImpl.java:438)
>
> at
> org.apache.ojb.broker.core.MtoNBroker.deleteMtoNImplementor(MtoNBroker.java:155)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkMtoN(PersistenceBrokerImpl.java:854)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(PersistenceBrokerImpl.java:803)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:1682)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1575)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:707)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkMtoN(PersistenceBrokerImpl.java:880)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(PersistenceBrokerImpl.java:803)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:1682)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1575)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:707)
>
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:174)
>
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:174)
>
> at
> org.apache.ojb.broker.metadata.MetadataMultithreadedTest$ThreadedUsingBroker.runTestCase(MetadataMultithreadedTest.java:273)
>
> at
> org.apache.ojb.junit.JUnitExtensions$MultiThreadedTestCase$TestCaseRunnable.run(JUnitExtensions.java:186)
>
> at java.lang.Thread.run(Thread.java:534)
> Caused by: java.sql.SQLException: null, message from server: "Deadlock
> found when trying to get lock; Try restarting transaction"
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
> at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1741)
> at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1588)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdateSQL(JdbcAccessImpl.java:417)
>
> ... 16 more
>
> ODMG error (repeated 4 times only in this test case):
>
> Testcase: testLockingOfObject took 1.68 sec
> Caused an ERROR
> Can not lock
> org.apache.ojb.odmg.LockingMultithreadedTest$LockObject@11c0d60 for WRITE
> org.odmg.LockNotGrantedException: Can not lock
> org.apache.ojb.odmg.LockingMultithreadedTest$LockObject@11c0d60 for WRITE
> at org.apache.ojb.odmg.TransactionImpl.lock(TransactionImpl.java:249)
> at
> org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(LockingMultithreadedTest.java:148)
>
> ...
>
> -- Ilkka
>
>
> Thomas Dudziak wrote:
>
>> Brian McCallister wrote:
>>
>>> As right now the status of OJB on java 1.2 and 1.3 is unknown, there
>>> are some problems with postgres, and no report on the results with
>>> Oracle or MySQL I am not going to release 1.0 tonight.
>>
>>
>>
>> Results for MySQL (WindowsXP, JDK 1.4.2_02, MySQL 4.0.12 with
>> Connector/J 3.0.14 stable)
>>
>> [junit] Running org.apache.ojb.broker.AllTests
>> [junit] Tests run: 402, Failures: 6, Errors: 5, Time elapsed: 60,984 sec
>>
>> [junit] TEST org.apache.ojb.broker.AllTests FAILED
>> [junit] Running org.apache.ojb.odmg.AllTests
>> [junit] Tests run: 196, Failures: 2, Errors: 0, Time elapsed: 14,063 sec
>>
>> [junit] TEST org.apache.ojb.odmg.AllTests FAILED
>> [junit] Running org.apache.ojb.soda.AllTests
>> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 2,578 sec
>>
>> [junit] Running org.apache.ojb.otm.AllTests
>> [junit] Tests run: 79, Failures: 1, Errors: 0, Time elapsed: 14,187 sec
>>
>> [junit] TEST org.apache.ojb.otm.AllTests FAILED
>>
>>
>>
>> PB Errors:
>>
>>
>>
>> Testcase: testSubQuery2 took 0,078 sec
>> Caused an ERROR
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at line 1"
>> org.apache.ojb.broker.PersistenceBrokerException:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at line 1"
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
>>
>> at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>>
>> at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>>
>> at org.apache.ojb.broker.QueryTest.testSubQuery2(QueryTest.java:172)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>> Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at line 1"
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
>>
>> at
>> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
>>
>> at
>> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
>> at
>> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1824)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
>>
>> ... 21 more
>> Caused by: java.sql.SQLException: Syntax error or access violation,
>> message from server: "You have an error in your SQL syntax. Check the
>> manual that corresponds to your MySQL server version for the right
>> syntax to use near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)'
>> at line 1"
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
>> at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
>>
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
>>
>> ... 28 more
>>
>>
>> Testcase: testSubQuery1 took 0,016 sec
>> Caused an ERROR
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE B0.Artikelname"
>> org.apache.ojb.broker.PersistenceBrokerException:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE B0.Artikelname"
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
>>
>> at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>>
>> at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>>
>> at org.apache.ojb.broker.QueryTest.testSubQuery1(QueryTest.java:199)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>> Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE B0.Artikelname"
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
>>
>> at
>> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
>>
>> at
>> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
>> at
>> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1836)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
>>
>> ... 21 more
>> Caused by: java.sql.SQLException: Syntax error or access violation,
>> message from server: "You have an error in your SQL syntax. Check the
>> manual that corresponds to your MySQL server version for the right
>> syntax to use near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE
>> B0.Artikelname"
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
>> at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
>>
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
>>
>> ... 28 more
>>
>>
>> Testcase: testSubQuery3 took 0 sec
>> Caused an ERROR
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
>> org.apache.ojb.broker.PersistenceBrokerException:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
>>
>> at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>>
>> at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>>
>> at org.apache.ojb.broker.QueryTest.testSubQuery3(QueryTest.java:227)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>> Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
>>
>> at
>> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
>>
>> at
>> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
>> at
>> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1824)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
>>
>> ... 21 more
>> Caused by: java.sql.SQLException: Syntax error or access violation,
>> message from server: "You have an error in your SQL syntax. Check the
>> manual that corresponds to your MySQL server version for the right
>> syntax to use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0
>> WHERE B0.Kategori"
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
>> at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
>>
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
>>
>> ... 28 more
>>
>>
>> Testcase: testSubQuery4 took 0,016 sec
>> Caused an ERROR
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
>> org.apache.ojb.broker.PersistenceBrokerException:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
>>
>> at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>>
>> at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>>
>> at org.apache.ojb.broker.QueryTest.testSubQuery4(QueryTest.java:252)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>> Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
>>
>> at
>> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
>>
>> at
>> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
>> at
>> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1824)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
>>
>> ... 21 more
>> Caused by: java.sql.SQLException: Syntax error or access violation,
>> message from server: "You have an error in your SQL syntax. Check the
>> manual that corresponds to your MySQL server version for the right
>> syntax to use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0
>> WHERE B0.Kategori"
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
>> at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
>>
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
>>
>> ... 28 more
>>
>>
>> Testcase: testDeleteWithRemovalAwareCollection took 0,031 sec
>> FAILED
>> expected:<1> but was:<2>
>> junit.framework.AssertionFailedError: expected:<1> but was:<2>
>> at
>> org.apache.ojb.broker.OneToManyTest.testDeleteWithRemovalAwareCollection(OneToManyTest.java:65)
>>
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>>
>>
>> Testcase: testUserRollbackClearCache took 0,063 sec
>> FAILED
>> expected:<60> but was:<70>
>> junit.framework.AssertionFailedError: expected:<60> but was:<70>
>> at
>> org.apache.ojb.broker.PBRollbackTest.testUserRollbackClearCache(PBRollbackTest.java:160)
>>
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>>
>> Testcase: testUserRollback took 0,078 sec
>> FAILED
>> expected:<80> but was:<90>
>> junit.framework.AssertionFailedError: expected:<80> but was:<90>
>> at
>> org.apache.ojb.broker.PBRollbackTest.testUserRollback(PBRollbackTest.java:200)
>>
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>>
>>
>> Testcase: testRollbackCausedByNotExistingObject took 0,047 sec
>> FAILED
>> Object count does not match after rollback expected:<100> but was:<110>
>> junit.framework.AssertionFailedError: Object count does not match
>> after rollback expected:<100> but was:<110>
>> at
>> org.apache.ojb.broker.PBRollbackTest.testRollbackCausedByNotExistingObject(PBRollbackTest.java:252)
>>
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>>
>>
>> Testcase: testRollbackCausedBySQLException took 0,031 sec
>> FAILED
>> Test should throw a exception in place
>> junit.framework.AssertionFailedError: Test should throw a exception in
>> place
>> at
>> org.apache.ojb.broker.PBRollbackTest.testRollbackCausedBySQLException(PBRollbackTest.java:289)
>>
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>>
>>
>> Testcase: testMultipleInsertAndRollback took 9,125 sec
>> FAILED
>> expected:<2000> but was:<4000>
>> junit.framework.AssertionFailedError: expected:<2000> but was:<4000>
>> at
>> org.apache.ojb.broker.sequence.SMMultiThreadedTest.checkGeneratedObjects(SMMultiThreadedTest.java:80)
>>
>> at
>> org.apache.ojb.broker.sequence.SMMultiThreadedTest.testMultipleInsertAndRollback(SMMultiThreadedTest.java:55)
>>
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>> at
>> org.apache.ojb.junit.JUnitExtensions$MultiThreadedTestCase.run(JUnitExtensions.java:107)
>>
>>
>>
>> Testcase: testSubQueryExists took 0 sec
>> Caused an ERROR
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0 INNER JOIN P"
>> org.apache.ojb.broker.PersistenceBrokerException:
>> org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0 INNER JOIN P"
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
>>
>> at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>>
>> at
>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>>
>> at
>> org.apache.ojb.broker.PathTest.testSubQueryExists(PathTest.java:612)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>> Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
>> java.sql.SQLException: Syntax error or access violation, message from
>> server: "You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0 INNER JOIN P"
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
>>
>> at
>> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
>>
>> at
>> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
>> at
>> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1824)
>>
>> at
>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
>>
>> at
>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
>>
>> ... 21 more
>> Caused by: java.sql.SQLException: Syntax error or access violation,
>> message from server: "You have an error in your SQL syntax. Check the
>> manual that corresponds to your MySQL server version for the right
>> syntax to use near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0
>> INNER JOIN P"
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
>> at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
>>
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
>>
>> ... 28 more
>>
>>
>> ODMG Errors:
>>
>> Testcase: testTransactionFlush took 0,032 sec
>> FAILED
>> We should not find objects from aborted tx
>> junit.framework.AssertionFailedError: We should not find objects from
>> aborted tx
>> at
>> org.apache.ojb.odmg.ODMGRollbackTest.testTransactionFlush(ODMGRollbackTest.java:91)
>>
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>>
>>
>> Testcase: testStoreDeleteThreePersons_1 took 0,015 sec
>> FAILED
>> children's names are equal expected:<[Child_Two_1087769433125,
>> Child_One_1087769433125]> but was:<[Child_One_1087769433125,
>> Child_Two_1087769433125]>
>> junit.framework.AssertionFailedError: children's names are equal
>> expected:<[Child_Two_1087769433125, Child_One_1087769433125]> but
>> was:<[Child_One_1087769433125, Child_Two_1087769433125]>
>> at
>> org.apache.ojb.odmg.PersonWithArrayTest.testStoreDeleteThreePersons_1(PersonWithArrayTest.java:100)
>>
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>>
>>
>> OTM Errors:
>>
>> Testcase: testOtmCache took 0,078 sec
>> FAILED
>> should be equal expected:<1> but was:<2>
>> junit.framework.ComparisonFailure: should be equal expected:<1> but
>> was:<2>
>> at org.apache.ojb.otm.OtmExamples.testOtmCache(OtmExamples.java:353)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>>
>>
>>
>> Tom
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-dev-help@db.apache.org
>>
>> .
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
>
> .
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Ilkka Priha <im...@surfeu.fi>.
Hi
Many MySQL failures are due to missing support for subqueries in 4.0.x versions.
With 4.1.2a all tests pass, but some locking errors occur.
I've added foreign key indeces to ojbtest-schema.sql to make it compatible with
MySQL's InnoDB engine to enable transactions.
Windows XP, JDK 1.4.2_03, MySQL 4.1.2-alpha, Connector/J 3.0.14
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 402, Failures: 0, Errors: 17, Time elapsed: 117.274 sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: Loading OJB's properties from file file:/E:/Cc/Apache/d
-ojb/target/test/ojb/OJB.properties
[junit] [BOOT] INFO: No value for key 'InterceptorClass'
[junit] Tests run: 196, Failures: 0, Errors: 4, Time elapsed: 24.653 sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 1.914 sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 79, Failures: 0, Errors: 0, Time elapsed: 14.745 sec
PB Error (repeated 17 times only in this test case):
Testcase: testRuntimeMetadataChanges took 1.509 sec
Caused an ERROR
java.sql.SQLException: null, message from server: "Deadlock found when trying
to get lock; Try restarting transaction"
org.apache.ojb.broker.PersistenceBrokerSQLException: java.sql.SQLException:
null, message from server: "Deadlock found when trying to get lock; Try
restarting transaction"
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdateSQL(JdbcAccessImpl.java:438)
at org.apache.ojb.broker.core.MtoNBroker.deleteMtoNImplementor(MtoNBroker.java:155)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkMtoN(PersistenceBrokerImpl.java:854)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(PersistenceBrokerImpl.java:803)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:1682)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1575)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:707)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkMtoN(PersistenceBrokerImpl.java:880)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(PersistenceBrokerImpl.java:803)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:1682)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1575)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:707)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:174)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:174)
at
org.apache.ojb.broker.metadata.MetadataMultithreadedTest$ThreadedUsingBroker.runTestCase(MetadataMultithreadedTest.java:273)
at
org.apache.ojb.junit.JUnitExtensions$MultiThreadedTestCase$TestCaseRunnable.run(JUnitExtensions.java:186)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: null, message from server: "Deadlock found
when trying to get lock; Try restarting transaction"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1741)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1588)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdateSQL(JdbcAccessImpl.java:417)
... 16 more
ODMG error (repeated 4 times only in this test case):
Testcase: testLockingOfObject took 1.68 sec
Caused an ERROR
Can not lock org.apache.ojb.odmg.LockingMultithreadedTest$LockObject@11c0d60 for
WRITE
org.odmg.LockNotGrantedException: Can not lock
org.apache.ojb.odmg.LockingMultithreadedTest$LockObject@11c0d60 for WRITE
at org.apache.ojb.odmg.TransactionImpl.lock(TransactionImpl.java:249)
at
org.apache.ojb.odmg.LockingMultithreadedTest$LockHandle.updateObject(LockingMultithreadedTest.java:148)
...
-- Ilkka
Thomas Dudziak wrote:
> Brian McCallister wrote:
>
>> As right now the status of OJB on java 1.2 and 1.3 is unknown, there
>> are some problems with postgres, and no report on the results with
>> Oracle or MySQL I am not going to release 1.0 tonight.
>
>
> Results for MySQL (WindowsXP, JDK 1.4.2_02, MySQL 4.0.12 with
> Connector/J 3.0.14 stable)
>
> [junit] Running org.apache.ojb.broker.AllTests
> [junit] Tests run: 402, Failures: 6, Errors: 5, Time elapsed: 60,984 sec
>
> [junit] TEST org.apache.ojb.broker.AllTests FAILED
> [junit] Running org.apache.ojb.odmg.AllTests
> [junit] Tests run: 196, Failures: 2, Errors: 0, Time elapsed: 14,063 sec
>
> [junit] TEST org.apache.ojb.odmg.AllTests FAILED
> [junit] Running org.apache.ojb.soda.AllTests
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 2,578 sec
>
> [junit] Running org.apache.ojb.otm.AllTests
> [junit] Tests run: 79, Failures: 1, Errors: 0, Time elapsed: 14,187 sec
>
> [junit] TEST org.apache.ojb.otm.AllTests FAILED
>
>
>
> PB Errors:
>
>
>
> Testcase: testSubQuery2 took 0,078 sec
> Caused an ERROR
> org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at line 1"
> org.apache.ojb.broker.PersistenceBrokerException:
> org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at line 1"
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
>
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>
> at org.apache.ojb.broker.QueryTest.testSubQuery2(QueryTest.java:172)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at line 1"
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
>
> at
> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
>
> at
> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
> at
> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1824)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
>
> ... 21 more
> Caused by: java.sql.SQLException: Syntax error or access violation,
> message from server: "You have an error in your SQL syntax. Check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at
> line 1"
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
>
> ... 28 more
>
>
> Testcase: testSubQuery1 took 0,016 sec
> Caused an ERROR
> org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE B0.Artikelname"
> org.apache.ojb.broker.PersistenceBrokerException:
> org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE B0.Artikelname"
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
>
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>
> at org.apache.ojb.broker.QueryTest.testSubQuery1(QueryTest.java:199)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE B0.Artikelname"
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
>
> at
> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
>
> at
> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
> at
> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1836)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
>
> ... 21 more
> Caused by: java.sql.SQLException: Syntax error or access violation,
> message from server: "You have an error in your SQL syntax. Check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE
> B0.Artikelname"
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
>
> ... 28 more
>
>
> Testcase: testSubQuery3 took 0 sec
> Caused an ERROR
> org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
> org.apache.ojb.broker.PersistenceBrokerException:
> org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
>
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>
> at org.apache.ojb.broker.QueryTest.testSubQuery3(QueryTest.java:227)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
>
> at
> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
>
> at
> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
> at
> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1824)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
>
> ... 21 more
> Caused by: java.sql.SQLException: Syntax error or access violation,
> message from server: "You have an error in your SQL syntax. Check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE
> B0.Kategori"
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
>
> ... 28 more
>
>
> Testcase: testSubQuery4 took 0,016 sec
> Caused an ERROR
> org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
> org.apache.ojb.broker.PersistenceBrokerException:
> org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
>
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>
> at org.apache.ojb.broker.QueryTest.testSubQuery4(QueryTest.java:252)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
>
> at
> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
>
> at
> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
> at
> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1824)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
>
> ... 21 more
> Caused by: java.sql.SQLException: Syntax error or access violation,
> message from server: "You have an error in your SQL syntax. Check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE
> B0.Kategori"
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
>
> ... 28 more
>
>
> Testcase: testDeleteWithRemovalAwareCollection took 0,031 sec
> FAILED
> expected:<1> but was:<2>
> junit.framework.AssertionFailedError: expected:<1> but was:<2>
> at
> org.apache.ojb.broker.OneToManyTest.testDeleteWithRemovalAwareCollection(OneToManyTest.java:65)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>
>
> Testcase: testUserRollbackClearCache took 0,063 sec
> FAILED
> expected:<60> but was:<70>
> junit.framework.AssertionFailedError: expected:<60> but was:<70>
> at
> org.apache.ojb.broker.PBRollbackTest.testUserRollbackClearCache(PBRollbackTest.java:160)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>
> Testcase: testUserRollback took 0,078 sec
> FAILED
> expected:<80> but was:<90>
> junit.framework.AssertionFailedError: expected:<80> but was:<90>
> at
> org.apache.ojb.broker.PBRollbackTest.testUserRollback(PBRollbackTest.java:200)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>
>
> Testcase: testRollbackCausedByNotExistingObject took 0,047 sec
> FAILED
> Object count does not match after rollback expected:<100> but was:<110>
> junit.framework.AssertionFailedError: Object count does not match after
> rollback expected:<100> but was:<110>
> at
> org.apache.ojb.broker.PBRollbackTest.testRollbackCausedByNotExistingObject(PBRollbackTest.java:252)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>
>
> Testcase: testRollbackCausedBySQLException took 0,031 sec
> FAILED
> Test should throw a exception in place
> junit.framework.AssertionFailedError: Test should throw a exception in
> place
> at
> org.apache.ojb.broker.PBRollbackTest.testRollbackCausedBySQLException(PBRollbackTest.java:289)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>
>
> Testcase: testMultipleInsertAndRollback took 9,125 sec
> FAILED
> expected:<2000> but was:<4000>
> junit.framework.AssertionFailedError: expected:<2000> but was:<4000>
> at
> org.apache.ojb.broker.sequence.SMMultiThreadedTest.checkGeneratedObjects(SMMultiThreadedTest.java:80)
>
> at
> org.apache.ojb.broker.sequence.SMMultiThreadedTest.testMultipleInsertAndRollback(SMMultiThreadedTest.java:55)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> at
> org.apache.ojb.junit.JUnitExtensions$MultiThreadedTestCase.run(JUnitExtensions.java:107)
>
>
>
> Testcase: testSubQueryExists took 0 sec
> Caused an ERROR
> org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0 INNER JOIN P"
> org.apache.ojb.broker.PersistenceBrokerException:
> org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0 INNER JOIN P"
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
>
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
>
> at org.apache.ojb.broker.PathTest.testSubQueryExists(PathTest.java:612)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
> java.sql.SQLException: Syntax error or access violation, message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0 INNER JOIN P"
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
>
> at
> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
>
> at
> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
> at
> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1824)
>
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
>
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
>
> ... 21 more
> Caused by: java.sql.SQLException: Syntax error or access violation,
> message from server: "You have an error in your SQL syntax. Check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0
> INNER JOIN P"
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
>
> ... 28 more
>
>
> ODMG Errors:
>
> Testcase: testTransactionFlush took 0,032 sec
> FAILED
> We should not find objects from aborted tx
> junit.framework.AssertionFailedError: We should not find objects from
> aborted tx
> at
> org.apache.ojb.odmg.ODMGRollbackTest.testTransactionFlush(ODMGRollbackTest.java:91)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>
>
> Testcase: testStoreDeleteThreePersons_1 took 0,015 sec
> FAILED
> children's names are equal expected:<[Child_Two_1087769433125,
> Child_One_1087769433125]> but was:<[Child_One_1087769433125,
> Child_Two_1087769433125]>
> junit.framework.AssertionFailedError: children's names are equal
> expected:<[Child_Two_1087769433125, Child_One_1087769433125]> but
> was:<[Child_One_1087769433125, Child_Two_1087769433125]>
> at
> org.apache.ojb.odmg.PersonWithArrayTest.testStoreDeleteThreePersons_1(PersonWithArrayTest.java:100)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>
>
> OTM Errors:
>
> Testcase: testOtmCache took 0,078 sec
> FAILED
> should be equal expected:<1> but was:<2>
> junit.framework.ComparisonFailure: should be equal expected:<1> but was:<2>
> at org.apache.ojb.otm.OtmExamples.testOtmCache(OtmExamples.java:353)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>
>
>
> Tom
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
>
> .
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Postponing 1.0 until Weds, Jun 23
Posted by Thomas Dudziak <to...@first.fhg.de>.
Brian McCallister wrote:
> As right now the status of OJB on java 1.2 and 1.3 is unknown, there are
> some problems with postgres, and no report on the results with Oracle or
> MySQL I am not going to release 1.0 tonight.
Results for MySQL (WindowsXP, JDK 1.4.2_02, MySQL 4.0.12 with
Connector/J 3.0.14 stable)
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 402, Failures: 6, Errors: 5, Time elapsed: 60,984 sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] Tests run: 196, Failures: 2, Errors: 0, Time elapsed: 14,063 sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 2,578 sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 79, Failures: 1, Errors: 0, Time elapsed: 14,187 sec
[junit] TEST org.apache.ojb.otm.AllTests FAILED
PB Errors:
Testcase: testSubQuery2 took 0,078 sec
Caused an ERROR
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at line 1"
org.apache.ojb.broker.PersistenceBrokerException:
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at line 1"
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
at org.apache.ojb.broker.QueryTest.testSubQuery2(QueryTest.java:172)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at line 1"
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1824)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
... 21 more
Caused by: java.sql.SQLException: Syntax error or access violation,
message from server: "You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'SELECT DISTINCT B0.Kategorie_Nr FROM Artikel B0)' at
line 1"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
... 28 more
Testcase: testSubQuery1 took 0,016 sec
Caused an ERROR
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE B0.Artikelname"
org.apache.ojb.broker.PersistenceBrokerException:
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE B0.Artikelname"
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
at org.apache.ojb.broker.QueryTest.testSubQuery1(QueryTest.java:199)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE B0.Artikelname"
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1836)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
... 21 more
Caused by: java.sql.SQLException: Syntax error or access violation,
message from server: "You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'SELECT avg(B0.Einzelpreis) FROM Artikel B0 WHERE
B0.Artikelname"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
... 28 more
Testcase: testSubQuery3 took 0 sec
Caused an ERROR
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
org.apache.ojb.broker.PersistenceBrokerException:
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
at org.apache.ojb.broker.QueryTest.testSubQuery3(QueryTest.java:227)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1824)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
... 21 more
Caused by: java.sql.SQLException: Syntax error or access violation,
message from server: "You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE
B0.Kategori"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
... 28 more
Testcase: testSubQuery4 took 0,016 sec
Caused an ERROR
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
org.apache.ojb.broker.PersistenceBrokerException:
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
at org.apache.ojb.broker.QueryTest.testSubQuery4(QueryTest.java:252)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE B0.Kategori"
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1824)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
... 21 more
Caused by: java.sql.SQLException: Syntax error or access violation,
message from server: "You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'SELECT count(B0.Kategorie_Nr) FROM Artikel B0 WHERE
B0.Kategori"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
... 28 more
Testcase: testDeleteWithRemovalAwareCollection took 0,031 sec
FAILED
expected:<1> but was:<2>
junit.framework.AssertionFailedError: expected:<1> but was:<2>
at
org.apache.ojb.broker.OneToManyTest.testDeleteWithRemovalAwareCollection(OneToManyTest.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testUserRollbackClearCache took 0,063 sec
FAILED
expected:<60> but was:<70>
junit.framework.AssertionFailedError: expected:<60> but was:<70>
at
org.apache.ojb.broker.PBRollbackTest.testUserRollbackClearCache(PBRollbackTest.java:160)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testUserRollback took 0,078 sec
FAILED
expected:<80> but was:<90>
junit.framework.AssertionFailedError: expected:<80> but was:<90>
at
org.apache.ojb.broker.PBRollbackTest.testUserRollback(PBRollbackTest.java:200)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testRollbackCausedByNotExistingObject took 0,047 sec
FAILED
Object count does not match after rollback expected:<100> but was:<110>
junit.framework.AssertionFailedError: Object count does not match after
rollback expected:<100> but was:<110>
at
org.apache.ojb.broker.PBRollbackTest.testRollbackCausedByNotExistingObject(PBRollbackTest.java:252)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testRollbackCausedBySQLException took 0,031 sec
FAILED
Test should throw a exception in place
junit.framework.AssertionFailedError: Test should throw a exception in place
at
org.apache.ojb.broker.PBRollbackTest.testRollbackCausedBySQLException(PBRollbackTest.java:289)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testMultipleInsertAndRollback took 9,125 sec
FAILED
expected:<2000> but was:<4000>
junit.framework.AssertionFailedError: expected:<2000> but was:<4000>
at
org.apache.ojb.broker.sequence.SMMultiThreadedTest.checkGeneratedObjects(SMMultiThreadedTest.java:80)
at
org.apache.ojb.broker.sequence.SMMultiThreadedTest.testMultipleInsertAndRollback(SMMultiThreadedTest.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
org.apache.ojb.junit.JUnitExtensions$MultiThreadedTestCase.run(JUnitExtensions.java:107)
Testcase: testSubQueryExists took 0 sec
Caused an ERROR
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0 INNER JOIN P"
org.apache.ojb.broker.PersistenceBrokerException:
org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0 INNER JOIN P"
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:240)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:252)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1238)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:332)
at org.apache.ojb.broker.PathTest.testSubQueryExists(PathTest.java:612)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0 INNER JOIN P"
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1824)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1354)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:110)
at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:232)
... 21 more
Caused by: java.sql.SQLException: Syntax error or access violation,
message from server: "You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'EXISTS (SELECT B0.A_ATTRIB,B0.ID FROM P_A_TABLE B0
INNER JOIN P"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:283)
... 28 more
ODMG Errors:
Testcase: testTransactionFlush took 0,032 sec
FAILED
We should not find objects from aborted tx
junit.framework.AssertionFailedError: We should not find objects from
aborted tx
at
org.apache.ojb.odmg.ODMGRollbackTest.testTransactionFlush(ODMGRollbackTest.java:91)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testStoreDeleteThreePersons_1 took 0,015 sec
FAILED
children's names are equal expected:<[Child_Two_1087769433125,
Child_One_1087769433125]> but was:<[Child_One_1087769433125,
Child_Two_1087769433125]>
junit.framework.AssertionFailedError: children's names are equal
expected:<[Child_Two_1087769433125, Child_One_1087769433125]> but
was:<[Child_One_1087769433125, Child_Two_1087769433125]>
at
org.apache.ojb.odmg.PersonWithArrayTest.testStoreDeleteThreePersons_1(PersonWithArrayTest.java:100)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
OTM Errors:
Testcase: testOtmCache took 0,078 sec
FAILED
should be equal expected:<1> but was:<2>
junit.framework.ComparisonFailure: should be equal expected:<1> but was:<2>
at org.apache.ojb.otm.OtmExamples.testOtmCache(OtmExamples.java:353)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org