Hi Michelle,
Hi Michael,
Version 0.8.5.2 of c3p0 is not available on ibiblio.org. Version
0.8.4.5 is available. Is it possible to use the earlier version? (It
looks like I get some additional errors on the TCK using the earlier
version.)
I can not recommend using version 0.8.5.2. I got lots of errors
(something like 300).
If not, can you provide a URL for downloading the later version?
There is a new prerelease 6 available for download. This produces
reasonable amount of errors/failures. I got the same amount of errors
without connection pooling:
Datastore identity:
Tests run: 350, Failures: 13, Errors: 88 (Time: 625 seconds)
Application identity:
Tests run: 350, Failures: 12, Errors: 84 (Time: 768 seconds)
The download URL is:
http://prdownloads.sourceforge.net/c3p0/c3p0-0.9.0-pre6.bin.zip?use_mirror=switch
Attached you find a patch for the project.xml, containing that version
together with the doanload URL. "jdori.properties" are set to use c3p0
connection pooling with this patch.
Regards,
Michael
Thanks,
Michelle
Michael Watzek wrote:
Hi,
In order to run you need to download the following jars and store them
in your local maven repository:
1) jpox-dbcp-1.1.0-beta-3.jar to jpox/jars
2) jpox-c3p0-1.1.0-beta-3.jar to jpox/jars
3) commons-dbcp-1.2.1.jar to commons-dbcp/jars
4) c3p0-0.8.5.2.jar to c3p0/jars
5) commons-pool-1.2.jar to commons-pool/jars
6) commons-collections-3.1.jar to commons-collections/jars
Regards,
Michael
--
-------------------------------------------------------------------
Michael Watzek [EMAIL PROTECTED] Engineering GmbH
mailto:[EMAIL PROTECTED] Buelowstr. 66
Tel.: ++49/30/235 520 36 10783 Berlin - Germany
Fax.: ++49/30/217 520 12 http://www.spree.de/
-------------------------------------------------------------------
Index: test/conf/jdori.properties
===================================================================
--- test/conf/jdori.properties (revision 190563)
+++ test/conf/jdori.properties (working copy)
@@ -21,3 +21,5 @@
org.jpox.autoCreateColumns=false
org.jpox.rdbms.CheckExistTablesOrViews=false
org.jpox.autoStartMechanism=None
+#org.jpox.connectionPoolingType=DBCP
+org.jpox.connectionPoolingType=C3P0
Index: project.properties
===================================================================
--- project.properties (revision 190563)
+++ project.properties (working copy)
@@ -26,9 +26,10 @@
iut.enhancer.main = ${jdo.enhancer.main}
iut.enhancer.options = -v -d "${iut.enhanced.dir}"
iut.enhancer.args = ${jdo.tck.jdometadata.files}
-iut.enhancer.sourcepath =
${jdo.tck.testclasses.dir}${path.separator}${jdo.jdoapi.jarfile}${path.separator}${junit.jarfile}${path.separator}${log4j.jarfile}
-iut.enhancer.classpath =
${jpox.enhancer.jarfile}${path.separator}${jpox.jdori.jarfile}${path.separator}${jdo.jdoapi.jarfile}${path.separator}${log4j.jarfile}${path.separator}${bcel.jarfile}
-iut.enhancer.sysproperties =
-Dlog4j.configuration=file:${basedir}/test/conf/logging.properties
+iut.enhancer.sysproperties =
+jdo.enhancer.sourcepath =
${jdo.tck.testclasses.dir}${path.separator}${jdo.jdoapi.jarfile}${path.separator}${junit.jarfile}${path.separator}${log4j.jarfile}
+jdo.enhancer.classpath =
${jpox.enhancer.jarfile}${path.separator}${jpox.jdori.jarfile}${path.separator}${jdo.jdoapi.jarfile}${path.separator}${log4j.jarfile}${path.separator}${bcel.jarfile}
+jdo.enhancer.sysproperties =
-Dlog4j.configuration=file:${basedir}/test/conf/logging.properties
# JUnit settings
# Start new JVM for junit tests
@@ -62,6 +63,13 @@
core20.jarfile = ${pom.getDependencyPath('apache-jdo:jdo2-core')}
enhancer20.jarfile = ${pom.getDependencyPath('apache-jdo:jdo2-enhancer')}
xmlparser =
+# connection pooling dependencies
+jpox.dbcp.jarfile = ${pom.getDependencyPath('jpox:jpox-dbcp')}
+jpox.c3p0.jarfile = ${pom.getDependencyPath('jpox:jpox-c3p0')}
+c3p0.jarfile = ${pom.getDependencyPath('c3p0')}
+dbcp.jarfile = ${pom.getDependencyPath('commons-dbcp')}
+pool.jarfile = ${pom.getDependencyPath('commons-pool')}
+collections.jarfile = ${pom.getDependencyPath('commons-collections')}
# JDORI enhancer
jdo.enhanced.dir = ${maven.build.dir}/enhanced/jdori
@@ -305,6 +313,7 @@
org/apache/jdo/tck/pc/fieldtypes/MapStringKeyCollections.jdo \
org/apache/jdo/tck/pc/fieldtypes/MapStringValueCollections.jdo \
org/apache/jdo/tck/pc/fieldtypes/SetCollections.jdo \
+ org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo \
org/apache/jdo/tck/pc/fieldtypes/TreeMapStringKeyCollections.jdo \
org/apache/jdo/tck/pc/fieldtypes/TreeMapStringValueCollections.jdo \
org/apache/jdo/tck/pc/fieldtypes/TreeSetCollections.jdo \
Index: maven.xml
===================================================================
--- maven.xml (revision 190563)
+++ maven.xml (working copy)
@@ -100,7 +100,7 @@
<!-- maven -Dtest=api.jdohelper.GetObjectId runtck.single -->
<goal name="runtck.jdorisingle" prereqs="java:compile, jdorienhance,
copyprops">
<echo>Run TCK test org.apache.jdo.tck.${test} on the RI with
configuration ${jdo.tck.configuration}</echo>
- <java fork="yes" dir="${jdo.tck.testdir}"
+ <java fork="yes" dir="${jdo.tck.testdir}"
classname="org.apache.jdo.tck.${test}">
<classpath refid="jdori.class.path"/>
<sysproperty key="ResultPrinterClass"
value="${jdo.tck.resultprinterclass}"/>
@@ -418,6 +418,13 @@
<pathelement location="${derby.jarfile}" />
<pathelement location="${core20.jarfile}" />
<pathelement location="${enhancer20.jarfile}" />
+ <!-- Jar files for connection pooling -->
+ <pathelement location="${jpox.dbcp.jarfile}" />
+ <pathelement location="${jpox.c3p0.jarfile}" />
+ <pathelement location="${c3p0.jarfile}"/>
+ <pathelement location="${dbcp.jarfile}"/>
+ <pathelement location="${pool.jarfile}"/>
+ <pathelement location="${collections.jarfile}"/>
</path>
<!-- ==== -->
Index: project.xml
===================================================================
--- project.xml (revision 190563)
+++ project.xml (working copy)
@@ -104,6 +104,40 @@
<artifactId>jdo2-core</artifactId>
<version>SNAPSHOT</version>
</dependency>
+ <!-- dependencies for connection pooling -->
+ <dependency>
+ <groupId>jpox</groupId>
+ <artifactId>jpox-c3p0</artifactId>
+ <version>SNAPSHOT</version>
+ <url>http://www.jpox.org/docs/download.html</url>
+ </dependency>
+ <dependency>
+ <groupId>jpox</groupId>
+ <artifactId>jpox-dbcp</artifactId>
+ <version>SNAPSHOT</version>
+ <url>http://www.jpox.org/docs/download.html</url>
+ </dependency>
+ <dependency>
+ <groupId>c3p0</groupId>
+ <artifactId>c3p0</artifactId>
+ <version>0.9.0-pre6</version>
+
<url>http://prdownloads.sourceforge.net/c3p0/c3p0-0.9.0-pre6.bin.zip?use_mirror=easynews</url>
+ </dependency>
+ <dependency>
+ <groupId>commons-dbcp</groupId>
+ <artifactId>commons-dbcp</artifactId>
+ <version>1.2.1</version>
+ </dependency>
+ <dependency>
+ <groupId>commons-pool</groupId>
+ <artifactId>commons-pool</artifactId>
+ <version>1.2</version>
+ </dependency>
+ <dependency>
+ <groupId>commons-collections</groupId>
+ <artifactId>commons-collections</artifactId>
+ <version>3.1</version>
+ </dependency>
</dependencies>
<!-- =================== -->
<!-- Build Specification -->
