Hi
i thought the following would be useful. I ran the unit tests for SQLServer
using boith the MS JDBC driver and the
JSQLConnect driver. The results are as follows (N.B> this is a straight out
of teh box run):
MS JDBC Driver
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 187, Failures: 0, Errors: 0, Time elapsed: 92.844 sec
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/D:/apps/db-ojb-1.0.rc1/target/test/ojb/OJB.properties
[junit] Tests run: 150, Failures: 1, Errors: 0, Time elapsed: 40.172 sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/D:/apps/db-ojb-1.0.rc1/target/test/ojb/OJB.properties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3.891 sec
As you can see there was on test failure for the ODMG test suite:
Testcase: testUpdateWithProxy took 4.766 sec
FAILED
Should have found article with name OneToManyUpdateTest
junit.framework.AssertionFailedError: Should have found article with name
OneToManyUpdateTest
at
org.apache.ojb.odmg.OneToManyTest.testUpdateWithProxy(OneToManyTest.java:181
)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
This was something to do with it
org.apache.ojb.odmg.ObjectEnvelopeTable] ERROR: Commit on object level
failed for tx [EMAIL PROTECTED]
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Violation of UNIQUE
KEY constraint 'UQ__SITE__5A7B181B'. Cannot insert duplicate key in object
'SITE'.
[
For JSQLConnect it is another matter -- I get lots of problems, mostly to do
with the JDBC driver not being able to connect
to the server (interestingly, I did not get these errors on v 0.9.9):
junit-no-compile-no-prepare:
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 187, Failures: 3, Errors: 3, Time elapsed: 49.813 sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/D:/apps/db-ojb-1.0.rc1/target/test/ojb/OJB.properties
[junit] Tests run: 150, Failures: 0, Errors: 28, Time elapsed: 10.297
sec
<snip>
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/D:/apps/db-ojb-1.0.rc1/target/test/ojb/OJB.properties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3.032 sec
The errors seem to happen due to rollbacks on underlying connections
failing. It all seems to do with getting autoincrement values
on sequence generators:
Testcase: testMultipleAutoincrement took 0.062 sec
Caused an ERROR
DBComms.transmit exception:[java.net.SocketException: Socket closed]
context:[(2) [Thread[main,5,main], IO:a73bf, Dbc:1429]]]
com.jnetdirect.jsql.x: DBComms.transmit exception:[java.net.SocketException:
Socket closed] context:[(2) [Thread[main,5,main], IO:a73bf, Dbc:1429]]]
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.au.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.prePrepare(Unknown Source)
at
com.jnetdirect.jsql.JSQLConnection.getPreparedStatementHandle(Unknown
Source)
at com.jnetdirect.jsql.ap.executeQuery(Unknown Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(JdbcAcces
sImpl.java:494)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBroker
Impl.java:640)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.store(DelegatingP
ersistenceBroker.java:152)
at
org.apache.ojb.broker.sequence.SequenceManagerTest.testMultipleAutoincrement
(SequenceManagerTest.java:144)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException:
DBComms.transmit exception:[java.net.SocketException: Socket closed]
context:[(2) [Thread[main,5,main], IO:a73bf, Dbc:1429]]]
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(JdbcAcces
sImpl.java:515)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBroker
Impl.java:640)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.store(DelegatingP
ersistenceBroker.java:152)
at
org.apache.ojb.broker.sequence.SequenceManagerTest.testMultipleAutoincrement
(SequenceManagerTest.java:144)
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: com.jnetdirect.jsql.x: DBComms.transmit
exception:[java.net.SocketException: Socket closed] context:[(2)
[Thread[main,5,main], IO:a73bf, Dbc:1429]]]
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.au.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.prePrepare(Unknown Source)
at
com.jnetdirect.jsql.JSQLConnection.getPreparedStatementHandle(Unknown
Source)
at com.jnetdirect.jsql.ap.executeQuery(Unknown Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(JdbcAcces
sImpl.java:494)
... 19 more
Testcase: testForLostKeys took 0.313 sec
FAILED
No generated keys found
junit.framework.AssertionFailedError: No generated keys found
at
org.apache.ojb.broker.sequence.SequenceManagerTest.testForLostKeys(SequenceM
anagerTest.java:483)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
Testcase: testIterator took 0.015 sec
FAILED
org.apache.ojb.broker.PersistenceBrokerSQLException: DBComms.transmit
exception:[java.net.SocketException: Socket closed] context:[(2)
[Thread[main,5,main], IO:a73bf, Dbc:1429]]]
junit.framework.AssertionFailedError:
org.apache.ojb.broker.PersistenceBrokerSQLException: DBComms.transmit
exception:[java.net.SocketException: Socket closed] context:[(2)
[Thread[main,5,main], IO:a73bf, Dbc:1429]]]
at
org.apache.ojb.broker.RsIteratorTest.testIterator(RsIteratorTest.java:59)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
Testcase: testMassOperations took 0 sec
Caused an ERROR
DBComms.transmit exception:[java.net.SocketException: Socket closed]
context:[(2) [Thread[main,5,main], IO:a73bf, Dbc:1429]]]
com.jnetdirect.jsql.x: DBComms.transmit exception:[java.net.SocketException:
Socket closed] context:[(2) [Thread[main,5,main], IO:a73bf, Dbc:1429]]]
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.au.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.prePrepare(Unknown Source)
at
com.jnetdirect.jsql.JSQLConnection.getPreparedStatementHandle(Unknown
Source)
at com.jnetdirect.jsql.ap.executeQuery(Unknown Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(JdbcAcces
sImpl.java:494)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBroker
Impl.java:640)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.store(DelegatingP
ersistenceBroker.java:152)
at
org.apache.ojb.broker.OneToOneTest.testMassOperations(OneToOneTest.java:53)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException:
DBComms.transmit exception:[java.net.SocketException: Socket closed]
context:[(2) [Thread[main,5,main], IO:a73bf, Dbc:1429]]]
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(JdbcAcces
sImpl.java:515)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBroker
Impl.java:640)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.store(DelegatingP
ersistenceBroker.java:152)
at
org.apache.ojb.broker.OneToOneTest.testMassOperations(OneToOneTest.java:53)
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: com.jnetdirect.jsql.x: DBComms.transmit
exception:[java.net.SocketException: Socket closed] context:[(2)
[Thread[main,5,main], IO:a73bf, Dbc:1429]]]
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.au.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.prePrepare(Unknown Source)
at
com.jnetdirect.jsql.JSQLConnection.getPreparedStatementHandle(Unknown
Source)
at com.jnetdirect.jsql.ap.executeQuery(Unknown Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(JdbcAcces
sImpl.java:494)
... 19 more
Testcase: testLookupPB1 took 0 sec
Caused an ERROR
DBComms.transmit exception:[java.net.SocketException: Socket closed]
context:[(2) [Thread[main,5,main], IO:a73bf, Dbc:1429]]]
com.jnetdirect.jsql.x: DBComms.transmit exception:[java.net.SocketException:
Socket closed] context:[(2) [Thread[main,5,main], IO:a73bf, Dbc:1429]]]
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.au.a(Unknown Source)
at com.jnetdirect.jsql.ah.new(Unknown Source)
at com.jnetdirect.jsql.ah.do(Unknown Source)
at com.jnetdirect.jsql.ap.executeQuery(Unknown Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl
.java:259)
at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:175)
at
org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(ReportQueryRs
Iterator.java:86)
at
org.apache.ojb.broker.singlevm.ReportRsIteratorFactoryImpl.createRsIterator(
ReportRsIteratorFactoryImpl.java:96)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
PersistenceBrokerImpl.java:2215)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryIteratorF
romQuery(PersistenceBrokerImpl.java:2263)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryIteratorB
yQuery(PersistenceBrokerImpl.java:2192)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCount(PersistenceBro
kerImpl.java:2163)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getCount(Delegati
ngPersistenceBroker.java:305)
at
org.apache.ojb.broker.metadata.MetadataTest.testLookupPB1(MetadataTest.java:
139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException:
DBComms.transmit exception:[java.net.SocketException: Socket closed]
context:[(2) [Thread[main,5,main], IO:a73bf, Dbc:1429]]]
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl
.java:302)
at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:175)
at
org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(ReportQueryRs
Iterator.java:86)
at
org.apache.ojb.broker.singlevm.ReportRsIteratorFactoryImpl.createRsIterator(
ReportRsIteratorFactoryImpl.java:96)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
PersistenceBrokerImpl.java:2215)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryIteratorF
romQuery(PersistenceBrokerImpl.java:2263)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryIteratorB
yQuery(PersistenceBrokerImpl.java:2192)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCount(PersistenceBro
kerImpl.java:2163)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getCount(Delegati
ngPersistenceBroker.java:305)
at
org.apache.ojb.broker.metadata.MetadataTest.testLookupPB1(MetadataTest.java:
139)
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: com.jnetdirect.jsql.x: DBComms.transmit
exception:[java.net.SocketException: Socket closed] context:[(2)
[Thread[main,5,main], IO:a73bf, Dbc:1429]]]
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.au.a(Unknown Source)
at com.jnetdirect.jsql.ah.new(Unknown Source)
at com.jnetdirect.jsql.ah.do(Unknown Source)
at com.jnetdirect.jsql.ap.executeQuery(Unknown Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl
.java:259)
... 25 more
I hope that helps....
Regards,
Mark Rowell
----------------------------------------------------------------
Mark Rowell
CreditTrade
T: +44 (020) 7400 5078
M: mailto:[EMAIL PROTECTED]
CreditTrade Limited is regulated by the FSA. (c) CreditTrade 2002. All rights
reserved. The information and data contained in this email is provided for the
information purposes of the addressee only and should not be reproduced and/or
distributed to any other person. It is provided without any warranty whatsoever and
unless stated otherwise consists purely of indicative market prices and other
information.
Any opinion or comments expressed or assumption made in association with the data or
information provided in this email is a reflection of CreditTrades judgement at the
time of compiling the data and is subject to change. CreditTrade hereby makes no
representation and accepts no responsibility or liability as to the completeness or
accuracy of this email.
The content of this email is not intended as an offer or solicitation for, or
recommendation of, the purchase or sale of any financial instrument, or as an official
confirmation of any transaction, and should not be construed as investment advice.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
