You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by Kazuaki SUZUKI <ca...@gmail.com> on 2011/03/16 11:58:08 UTC

Some OpenJPA tests does not pass on Oracle DB

Hi,

I tried to test OpenJPA on Oracle DB 10g.
I typed "mvn test -Ptest-oracle
-Dopenjpa.oracle.url=jdbc:oracle:thin:@xxx:1521:xxx
-Dopenjpa.oracle.username=xxx -Dopenjpa.oracle.password=xxx".
Some OpenJPA 2.0.2 tests does not pass on Oracle DB 10g.

Because of Optimistic locking errors, tests does not pass on Oracle DB 10g.
The Tests are
testDate(org.apache.openjpa.persistence.kernel.TestProxies2)
testStringSet(org.apache.openjpa.persistence.kernel.TestProxies2)
testStringMap(org.apache.openjpa.persistence.kernel.TestProxies2)
testProxySet(org.apache.openjpa.persistence.kernel.TestProxies2)
testProxyMap(org.apache.openjpa.persistence.kernel.TestProxies2)
testReplace(org.apache.openjpa.persistence.kernel.TestProxies2)
testComparators(org.apache.openjpa.persistence.kernel.TestProxies2)
testChangeListOrder(org.apache.openjpa.persistence.kernel.TestProxies2)
testSQLDate(org.apache.openjpa.persistence.kernel.TestProxies2)
testTimestamp(org.apache.openjpa.persistence.kernel.TestProxies2)
testPersistAndFind(org.apache.openjpa.persistence.annotations.TestEmbeddableSuperclass)
testPersistAndFind(org.apache.openjpa.persistence.jdbc.annotations.TestEmbeddableSuperclass)

Because of ORA-21700, tests does not pass on Oracle DB 10g too.
The Tests are
testCrudXmlColumn(org.apache.openjpa.jdbc.oracle.TestOracleXmlColumn)
testExistingColumn(org.apache.openjpa.jdbc.oracle.TestOracleXmlColumn)

thank you

--
View this message in context: http://openjpa.208410.n2.nabble.com/Some-OpenJPA-tests-does-not-pass-on-Oracle-DB-tp6176034p6176034.html
Sent from the OpenJPA Developers mailing list archive at Nabble.com.

Re: Some OpenJPA tests does not pass on Oracle DB

Posted by Kazuaki SUZUKI <ca...@gmail.com>.
Hi mike,

Thank you.
That's very helpful of you.
The tests in TestProxies2 passed with Oracle JDBC driver version 10.2.0.5.0.

Now I'm trying all tests.

best regards,

-Kazu

--
View this message in context: http://openjpa.208410.n2.nabble.com/Some-OpenJPA-tests-does-not-pass-on-Oracle-DB-tp6176034p6196003.html
Sent from the OpenJPA Developers mailing list archive at Nabble.com.

Re: Some OpenJPA tests does not pass on Oracle DB

Posted by Michael Dick <mi...@gmail.com>.
Hi Kazu,

I think you'll find that the tests (at least TestProxies2) pass with JDBC
driver version 10.2.0.5.0. Can you download the latest version?

-mike

On Thu, Mar 17, 2011 at 3:01 AM, Kazuaki SUZUKI <ca...@gmail.com>wrote:

> Hi Michael,
>
> Thank you for your quick response.
> The JDBC driver version is 10.2.0.2.0.
>
> -Kazu
>
>
> --
> View this message in context:
> http://openjpa.208410.n2.nabble.com/Some-OpenJPA-tests-does-not-pass-on-Oracle-DB-tp6176034p6180032.html
> Sent from the OpenJPA Developers mailing list archive at Nabble.com.
>

Re: Some OpenJPA tests does not pass on Oracle DB

Posted by Kazuaki SUZUKI <ca...@gmail.com>.
Hi Michael,

Thank you for your quick response.
The JDBC driver version is 10.2.0.2.0.

-Kazu


--
View this message in context: http://openjpa.208410.n2.nabble.com/Some-OpenJPA-tests-does-not-pass-on-Oracle-DB-tp6176034p6180032.html
Sent from the OpenJPA Developers mailing list archive at Nabble.com.

Re: Some OpenJPA tests does not pass on Oracle DB

Posted by Michael Dick <mi...@gmail.com>.
Hi Kazuaki,

I just ran the TestProxies2 on Oracle 10g XE and the tests passed for me. I
am using version 11.2.0.1.0 of the JDBC driver.

I have seen some trouble with TestSequence.testMultiThreadedNaitveSequences
with Oracle on trunk but otherwise I think the base tests are passing.

Which version of the JDBC driver are you using?

-mike

On Wed, Mar 16, 2011 at 5:58 AM, Kazuaki SUZUKI <ca...@gmail.com>wrote:

> Hi,
>
> I tried to test OpenJPA on Oracle DB 10g.
> I typed "mvn test -Ptest-oracle
> -Dopenjpa.oracle.url=jdbc:oracle:thin:@xxx:1521:xxx
> -Dopenjpa.oracle.username=xxx -Dopenjpa.oracle.password=xxx".
> Some OpenJPA 2.0.2 tests does not pass on Oracle DB 10g.
>
> Because of Optimistic locking errors, tests does not pass on Oracle DB 10g.
> The Tests are
> testDate(org.apache.openjpa.persistence.kernel.TestProxies2)
> testStringSet(org.apache.openjpa.persistence.kernel.TestProxies2)
> testStringMap(org.apache.openjpa.persistence.kernel.TestProxies2)
> testProxySet(org.apache.openjpa.persistence.kernel.TestProxies2)
> testProxyMap(org.apache.openjpa.persistence.kernel.TestProxies2)
> testReplace(org.apache.openjpa.persistence.kernel.TestProxies2)
> testComparators(org.apache.openjpa.persistence.kernel.TestProxies2)
> testChangeListOrder(org.apache.openjpa.persistence.kernel.TestProxies2)
> testSQLDate(org.apache.openjpa.persistence.kernel.TestProxies2)
> testTimestamp(org.apache.openjpa.persistence.kernel.TestProxies2)
>
> testPersistAndFind(org.apache.openjpa.persistence.annotations.TestEmbeddableSuperclass)
>
> testPersistAndFind(org.apache.openjpa.persistence.jdbc.annotations.TestEmbeddableSuperclass)
>
> Because of ORA-21700, tests does not pass on Oracle DB 10g too.
> The Tests are
> testCrudXmlColumn(org.apache.openjpa.jdbc.oracle.TestOracleXmlColumn)
> testExistingColumn(org.apache.openjpa.jdbc.oracle.TestOracleXmlColumn)
>
> thank you
>
> --
> View this message in context:
> http://openjpa.208410.n2.nabble.com/Some-OpenJPA-tests-does-not-pass-on-Oracle-DB-tp6176034p6176034.html
> Sent from the OpenJPA Developers mailing list archive at Nabble.com.
>