You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by Craig L Russell <Cr...@Sun.COM> on 2010/02/23 03:19:59 UTC

OpenJPA MySQL testing

Hi,

I'm trying to run the standard OpenJPA tests with MySQL and getting  
some unexpected results. I recently checked out the 1.2.2 tag and am  
using a local mysql server.

When I run the tests in tags/1.2.2/openjpa-persistence-jdbc using

mvn test -Ptest-mysql -Dopenjpa.mysql.url=jdbc:mysql://localhost:9306/ 
test -Dopenjpa.mysql.username=root -Dopenjpa.mysql.password=

The output indicates I'm running with an old jdbc driver.

29  TestConv  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class  
"org.apache.openjpa.jdbc.sql.MySQLDictionary" (MySQL 5.1.41-ndb-7.1.2- 
beta-debug ,MySQL-AB JDBC Driver mysql-connector-java-5.1.5  
( Revision: ${svn.Revision} )).

I've removed this driver from my machine and it's still finding and  
loading this driver.

My pom.xml has this [1]

I've verified that if I change the version number to something that  
doesn't exist, 5.1.150, I get the expected [2]

I've updated the pom [3]

Anyone figure out where the MySQL-AB driver is coming from?

Thanks,

Craig


[1]         <!-- Profile for testing with MySQL DB -->
         <profile>
             <id>test-mysql</id>
             <activation><property><name>test-mysql</name></property></ 
activation>
             <dependencies>
                 <dependency>
                     <groupId>mysql</groupId>
                     <artifactId>driver</artifactId>
                     <version>5.1.15</version>
                 </dependency>
             </dependencies>
             <properties>
                 <connection.driver.name>com.mysql.jdbc.Driver</ 
connection.driver.name>
                 <connection.url>${openjpa.mysql.url}</connection.url>
                 <connection.username>${openjpa.mysql.username}</ 
connection.username>
                 <connection.password>${openjpa.mysql.password}</ 
connection.password>
             </properties>
         </profile>

[2]
Downloading: http://repo1.maven.org/maven2/mysql/driver/5.1.150/driver-5.1.150.jar
[INFO] Unable to find resource 'mysql:driver:jar:5.1.150' in  
repository central (http://repo1.maven.org/maven2)
[INFO]  
------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO]  
------------------------------------------------------------------------
[INFO] Failed to resolve artifact.

Missing:
----------
1) mysql:driver:jar:5.1.150

   Try downloading the file manually from the project website.

[3] clr% svn diff
Index: openjpa-slice/pom.xml
===================================================================
--- openjpa-slice/pom.xml	(revision 915135)
+++ openjpa-slice/pom.xml	(working copy)
@@ -104,8 +104,8 @@
  			<dependencies>
  				<dependency>
  					<groupId>mysql</groupId>
-					<artifactId>mysql-connector-java</artifactId>
-					<version>5.1.5</version>
+					<artifactId>driver</artifactId>
+					<version>5.1.15</version>
  				</dependency>
  			</dependencies>
  			<properties>
Index: openjpa-persistence-jdbc/pom.xml
===================================================================
--- openjpa-persistence-jdbc/pom.xml	(revision 915135)
+++ openjpa-persistence-jdbc/pom.xml	(working copy)
@@ -98,8 +98,8 @@
              <dependencies>
                  <dependency>
                      <groupId>mysql</groupId>
-                    <artifactId>mysql-connector-java</artifactId>
-                    <version>5.1.6</version>
+                    <artifactId>driver</artifactId>
+                    <version>5.1.15</version>
                  </dependency>
              </dependencies>
              <properties>

Craig L Russell
Architect, Sun Java Enterprise System http://db.apache.org/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!