Re: DB2 support

2007-05-09 Thread Michael Dick

Hi William,

I have been running OpenJPA against DB2 v9 with no major issues, and I
believe others on the forums have been doing so as well. Admittedly this
isn't a certification, but it's at least anecdotal evidence that DB2 v9 will
work.

For KODO I'd have to refer you to BEA's support statement, but I'd be
surprised if they did not support DB2 as well.

I'm not sure what you mean by cases to run OpenJPA/KODO on DB2. If you're
looking for instructions on how to run the OpenJPA unit tests against DB2 I
can help you with that. If you'd prefer to try running your own application
against DB2 all you need to do is add the appropriate connection properties
to persistence.xml :

Something like this should work.
. . .
   properties
. . .
property name=openjpa.ConnectionDriverName  value=
com.ibm.db2.jcc.DB2Driver /
property name=openjpa.ConnectionURL
value=jdbc:db2://localhost:5/TEST /
property name=openjpa.ConnectionUserName value=db2user /
property name=openjpa.ConnectionPassword value=db2password /
. . .
/properties
. . .

Regards,
Michael DIck

On 5/9/07, William Cai [EMAIL PROTECTED] wrote:


Hi list,
AFAIK,
the latest DB2 version is DB2 enterprise server edition V9.1. But but
current OpenJDK only supports DB2 UDB v8.1. Do we have any plans to
certify DB2 UDB V8.2 and DB2 v9 recently? Or more realistically -- are
there any cases to run OpenJPA/KODO on DB2 UDB v8.2 or DB2 v9?

Any input is greatly appreciated.

Thanks,
William




Database Name

Database Version

JDBC Driver Name

JDBC Driver Version

Apache Derby

10.1.2.1

Apache Derby Embedded JDBC Driver

10.1.2.1

Borland Interbase

7.1.0.202

Interclient

4.5.1

Borland JDataStore

6.0

Borland JDataStore

6.0

DB2

8.1

IBM DB2 JDBC Universal Driver

1.0.581



Re: DB2 support

2007-05-09 Thread Michael Dick

OK, now that I found the relevant section in the documentation I understand
what William is asking for.

What level of testing do we need to do before we can add a new version of
DB2 to the list of supported databases? Is just running our unit test bucket
sufficient to add a new database to the list or do we need a more formal
process?


On 5/9/07, Michael Dick [EMAIL PROTECTED] wrote:


Hi William,

I have been running OpenJPA against DB2 v9 with no major issues, and I
believe others on the forums have been doing so as well. Admittedly this
isn't a certification, but it's at least anecdotal evidence that DB2 v9 will
work.

For KODO I'd have to refer you to BEA's support statement, but I'd be
surprised if they did not support DB2 as well.

I'm not sure what you mean by cases to run OpenJPA/KODO on DB2. If
you're looking for instructions on how to run the OpenJPA unit tests against
DB2 I can help you with that. If you'd prefer to try running your own
application against DB2 all you need to do is add the appropriate connection
properties to persistence.xml :

Something like this should work.
. . .
properties
 . . .
 property name=openjpa.ConnectionDriverName  value=
com.ibm.db2.jcc.DB2Driver  /
 property name=openjpa.ConnectionURL
value=jdbc:db2://localhost:5/TEST /
 property name=openjpa.ConnectionUserName value=db2user /
 property name=openjpa.ConnectionPassword value=db2password
/
 . . .
 /properties
. . .

Regards,
Michael DIck

On 5/9/07, William Cai [EMAIL PROTECTED] wrote:

 Hi list,
 AFAIK,
 the latest DB2 version is DB2 enterprise server edition V9.1. But but
 current OpenJDK only supports DB2 UDB v8.1. Do we have any plans to
 certify DB2 UDB V8.2 and DB2 v9 recently? Or more realistically -- are
 there any cases to run OpenJPA/KODO on DB2 UDB v8.2 or DB2 v9?

 Any input is greatly appreciated.

 Thanks,
 William




 Database Name

 Database Version

 JDBC Driver Name

 JDBC Driver Version

 Apache Derby

 10.1.2.1

 Apache Derby Embedded JDBC Driver

 10.1.2.1

 Borland Interbase

  7.1.0.202

 Interclient

 4.5.1

 Borland JDataStore

 6.0

 Borland JDataStore

 6.0

 DB2

 8.1

 IBM DB2 JDBC Universal Driver

 1.0.581





Re: DB2 support

2007-05-09 Thread Marc Prud'hommeaux



What level of testing do we need to do before we can add a new  
version of
DB2 to the list of supported databases? Is just running our unit  
test bucket
sufficient to add a new database to the list or do we need a more  
formal

process?


That's a very good question, and one that I don't think has been  
discussed in the context of OpenJPA yet.


One thing we can do is say that a DB is certified if it passes all  
of the existing unit tests against that DB. A better solution might  
be to say that a DB is certified if the JPA TCK passes 100% against  
that database, but that would make the certification process a bit  
more cumbersome, since obtaining the TCK requires an NDA to be signed.


Also, we should determine how this should impact the release cycle.  
Should be disallow a release until each and every supported DB  
version has passed everything 100%?


Thoughts?



On May 9, 2007, at 6:09 AM, Michael Dick wrote:

OK, now that I found the relevant section in the documentation I  
understand

what William is asking for.

What level of testing do we need to do before we can add a new  
version of
DB2 to the list of supported databases? Is just running our unit  
test bucket
sufficient to add a new database to the list or do we need a more  
formal

process?


On 5/9/07, Michael Dick [EMAIL PROTECTED] wrote:


Hi William,

I have been running OpenJPA against DB2 v9 with no major issues,  
and I
believe others on the forums have been doing so as well.  
Admittedly this
isn't a certification, but it's at least anecdotal evidence that  
DB2 v9 will

work.

For KODO I'd have to refer you to BEA's support statement, but I'd be
surprised if they did not support DB2 as well.

I'm not sure what you mean by cases to run OpenJPA/KODO on DB2. If
you're looking for instructions on how to run the OpenJPA unit  
tests against

DB2 I can help you with that. If you'd prefer to try running your own
application against DB2 all you need to do is add the appropriate  
connection

properties to persistence.xml :

Something like this should work.
. . .
properties
 . . .
 property name=openjpa.ConnectionDriverName  value=
com.ibm.db2.jcc.DB2Driver  /
 property name=openjpa.ConnectionURL
value=jdbc:db2://localhost:5/TEST /
 property name=openjpa.ConnectionUserName  
value=db2user /
 property name=openjpa.ConnectionPassword  
value=db2password

/
 . . .
 /properties
. . .

Regards,
Michael DIck

On 5/9/07, William Cai [EMAIL PROTECTED] wrote:

 Hi list,
 AFAIK,
 the latest DB2 version is DB2 enterprise server edition V9.1.  
But but

 current OpenJDK only supports DB2 UDB v8.1. Do we have any plans to
 certify DB2 UDB V8.2 and DB2 v9 recently? Or more realistically  
-- are

 there any cases to run OpenJPA/KODO on DB2 UDB v8.2 or DB2 v9?

 Any input is greatly appreciated.

 Thanks,
 William




 Database Name

 Database Version

 JDBC Driver Name

 JDBC Driver Version

 Apache Derby

 10.1.2.1

 Apache Derby Embedded JDBC Driver

 10.1.2.1

 Borland Interbase

  7.1.0.202

 Interclient

 4.5.1

 Borland JDataStore

 6.0

 Borland JDataStore

 6.0

 DB2

 8.1

 IBM DB2 JDBC Universal Driver

 1.0.581







Re: DB2 support

2007-05-09 Thread Craig L Russell


On May 9, 2007, at 6:09 AM, Michael Dick wrote:

OK, now that I found the relevant section in the documentation I  
understand

what William is asking for.

What level of testing do we need to do before we can add a new  
version of
DB2 to the list of supported databases? Is just running our unit  
test bucket
sufficient to add a new database to the list or do we need a more  
formal

process?


Well, since we're an open source project, the only formal process is  
what we as a community decide to do. My personal opinion is that if  
someone runs tests that pass on a database, that's sufficient to say  
that we support it.


Of course, support in an open source project is a matter of  
interpretation. If someone has a problem, we basically tell them that  
they should file a JIRA, provide a reproducible test case, and  
provide a patch licensed to Apache that fixes the issue. One of the  
committers will review the patch and check it in if they like it.


Now, support for a product based on OpenJPA is a completely different  
matter, and the Apache OpenJPA project doesn't really have an opinion.


Craig



On 5/9/07, Michael Dick [EMAIL PROTECTED] wrote:


Hi William,

I have been running OpenJPA against DB2 v9 with no major issues,  
and I
believe others on the forums have been doing so as well.  
Admittedly this
isn't a certification, but it's at least anecdotal evidence that  
DB2 v9 will

work.

For KODO I'd have to refer you to BEA's support statement, but I'd be
surprised if they did not support DB2 as well.

I'm not sure what you mean by cases to run OpenJPA/KODO on DB2. If
you're looking for instructions on how to run the OpenJPA unit  
tests against

DB2 I can help you with that. If you'd prefer to try running your own
application against DB2 all you need to do is add the appropriate  
connection

properties to persistence.xml :

Something like this should work.
. . .
properties
 . . .
 property name=openjpa.ConnectionDriverName  value=
com.ibm.db2.jcc.DB2Driver  /
 property name=openjpa.ConnectionURL
value=jdbc:db2://localhost:5/TEST /
 property name=openjpa.ConnectionUserName  
value=db2user /
 property name=openjpa.ConnectionPassword  
value=db2password

/
 . . .
 /properties
. . .

Regards,
Michael DIck

On 5/9/07, William Cai [EMAIL PROTECTED] wrote:

 Hi list,
 AFAIK,
 the latest DB2 version is DB2 enterprise server edition V9.1.  
But but

 current OpenJDK only supports DB2 UDB v8.1. Do we have any plans to
 certify DB2 UDB V8.2 and DB2 v9 recently? Or more realistically  
-- are

 there any cases to run OpenJPA/KODO on DB2 UDB v8.2 or DB2 v9?

 Any input is greatly appreciated.

 Thanks,
 William




 Database Name

 Database Version

 JDBC Driver Name

 JDBC Driver Version

 Apache Derby

 10.1.2.1

 Apache Derby Embedded JDBC Driver

 10.1.2.1

 Borland Interbase

  7.1.0.202

 Interclient

 4.5.1

 Borland JDataStore

 6.0

 Borland JDataStore

 6.0

 DB2

 8.1

 IBM DB2 JDBC Universal Driver

 1.0.581





Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:[EMAIL PROTECTED]
P.S. A good JDO? O, Gasp!



smime.p7s
Description: S/MIME cryptographic signature