You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by William Cai <ca...@acm.org> on 2007/05/09 07:53:51 UTC
DB2 support
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
Posted by Craig L Russell <Cr...@Sun.COM>.
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 <mi...@gmail.com> 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:50000/TEST" />
>> <property name="openjpa.ConnectionUserName"
>> value="db2user" />
>> <property name="openjpa.ConnectionPassword"
>> value="db2password"
>> />
>> . . .
>> </properties>
>> . . .
>>
>> Regards,
>> Michael DIck
>>
>> On 5/9/07, William Cai <ca...@acm.org> 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:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!
Re: DB2 support
Posted by Marc Prud'hommeaux <mp...@apache.org>.
> 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 <mi...@gmail.com> 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:50000/TEST" />
>> <property name="openjpa.ConnectionUserName"
>> value="db2user" />
>> <property name="openjpa.ConnectionPassword"
>> value="db2password"
>> />
>> . . .
>> </properties>
>> . . .
>>
>> Regards,
>> Michael DIck
>>
>> On 5/9/07, William Cai <ca...@acm.org> 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
Posted by Michael Dick <mi...@gmail.com>.
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 <mi...@gmail.com> 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:50000/TEST" />
> <property name="openjpa.ConnectionUserName" value="db2user" />
> <property name="openjpa.ConnectionPassword" value="db2password"
> />
> . . .
> </properties>
> . . .
>
> Regards,
> Michael DIck
>
> On 5/9/07, William Cai <ca...@acm.org> 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
Posted by Michael Dick <mi...@gmail.com>.
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:50000/TEST" />
<property name="openjpa.ConnectionUserName" value="db2user" />
<property name="openjpa.ConnectionPassword" value="db2password" />
. . .
</properties>
. . .
Regards,
Michael DIck
On 5/9/07, William Cai <ca...@acm.org> 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
>