Re: DB2 support

[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.


process?

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

Craig

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.

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

Hi William,


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

DB2 I can help you with that. If you'd prefer to try running your own

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" />

/>
         . . .
     </properties>
. . .

Regards,
Michael DIck

On 5/9/07, William Cai <[EMAIL PROTECTED]> wrote:
>
> Hi list,
> AFAIK,

> current OpenJDK only supports DB2 UDB v8.1. Do we have any plans to

> 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
>

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 you're looking for instructions on how to run the OpenJPA unit tests against application against DB2 all you need to do is add the appropriate connection <property name="openjpa.ConnectionUserName" value="db2user" /> <property name="openjpa.ConnectionPassword" value="db2password" > the latest DB2 version is DB2 enterprise server edition V9.1. But but > certify DB2 UDB V8.2 and DB2 v9 recently? Or more realistically -- are

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