You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by Kevin Sutter <kw...@gmail.com> on 2009/05/13 23:36:53 UTC
Database support
Hi,
I'm trolling... I'm looking for ideas on how we can better integrate with
the various database vendors. Many of us committers have our own "favorite"
databases due to our employers' needs. But, what about the MySQL, or
Postgres, or SQL Server, or pick your favorite databases? I know we have
had some interest from these database vendors on our users and dev forums,
but I'm looking for ways to get these vendors more involved. When they
produce a new version of their database, it would be great to announce
OpenJPA support. And, if they have new features to take advantage of, that
would be even better.
Everybody's development and tests teams are limited. I understand that.
But, I'm looking for ideas on how we can work together to accomplish this
task. I'm going to cross post on both users and dev forums to see if there
any lurkers that might have some ideas.
Just to provide a real world example... I was just pinged about MS SQL
Server 2008 support. Our OpenJPA manual only documents SQL Server 2005
support. I don't have experience with SQL Server. So, it made me think how
we could improve this aspect of our OpenJPA database support.
Any thoughts?
Kevin
Re: Database support
Posted by Kevin Sutter <kw...@gmail.com>.
Ravi,
Volunteers for each database could be an alternative. Maybe volunteering
for database support would be a new requirement for committers? :-) Like
in your case, you seem to have a vested interest in Oracle. And, I tend
towards DB2 and Derby. But, what do we do about other mainstream databases
that don't have committers on our project? I wonder if soliciting on some
of these other sites would help?
Maybe a wiki page outlining the current database support along with the
OpenJPA Point of Contact would be a good first step?
Still soliciting ideas...
Thanks,
Kevin
On Wed, May 13, 2009 at 4:44 PM, Ravi Palacherla <ravi.palacherla@oracle.com
> wrote:
> Hi Kevin,
>
> What about volunteers for every database ?
>
> I can volunteer for oracle database.
> Currently I am trying to make all the trunk testcases successful against
> oracleDB.
>
> So, if every database has volunteers to make sure all openJPA testcases run
> against a particular DB then I guess it would help.
>
> What do you think ?
>
> Thanks,
> Ravi.
>
> -----Original Message-----
> From: Kevin Sutter [mailto:kwsutter@gmail.com]
> Sent: Wednesday, May 13, 2009 3:37 PM
> To: dev@openjpa.apache.org; users@openjpa.apache.org
> Subject: Database support
>
> Hi,
> I'm trolling... I'm looking for ideas on how we can better integrate with
> the various database vendors. Many of us committers have our own
> "favorite"
> databases due to our employers' needs. But, what about the MySQL, or
> Postgres, or SQL Server, or pick your favorite databases? I know we have
> had some interest from these database vendors on our users and dev forums,
> but I'm looking for ways to get these vendors more involved. When they
> produce a new version of their database, it would be great to announce
> OpenJPA support. And, if they have new features to take advantage of, that
> would be even better.
>
> Everybody's development and tests teams are limited. I understand that.
> But, I'm looking for ideas on how we can work together to accomplish this
> task. I'm going to cross post on both users and dev forums to see if there
> any lurkers that might have some ideas.
>
> Just to provide a real world example... I was just pinged about MS SQL
> Server 2008 support. Our OpenJPA manual only documents SQL Server 2005
> support. I don't have experience with SQL Server. So, it made me think
> how
> we could improve this aspect of our OpenJPA database support.
>
> Any thoughts?
>
> Kevin
>
Re: Database support
Posted by Kevin Sutter <kw...@gmail.com>.
Ravi,
Volunteers for each database could be an alternative. Maybe volunteering
for database support would be a new requirement for committers? :-) Like
in your case, you seem to have a vested interest in Oracle. And, I tend
towards DB2 and Derby. But, what do we do about other mainstream databases
that don't have committers on our project? I wonder if soliciting on some
of these other sites would help?
Maybe a wiki page outlining the current database support along with the
OpenJPA Point of Contact would be a good first step?
Still soliciting ideas...
Thanks,
Kevin
On Wed, May 13, 2009 at 4:44 PM, Ravi Palacherla <ravi.palacherla@oracle.com
> wrote:
> Hi Kevin,
>
> What about volunteers for every database ?
>
> I can volunteer for oracle database.
> Currently I am trying to make all the trunk testcases successful against
> oracleDB.
>
> So, if every database has volunteers to make sure all openJPA testcases run
> against a particular DB then I guess it would help.
>
> What do you think ?
>
> Thanks,
> Ravi.
>
> -----Original Message-----
> From: Kevin Sutter [mailto:kwsutter@gmail.com]
> Sent: Wednesday, May 13, 2009 3:37 PM
> To: dev@openjpa.apache.org; users@openjpa.apache.org
> Subject: Database support
>
> Hi,
> I'm trolling... I'm looking for ideas on how we can better integrate with
> the various database vendors. Many of us committers have our own
> "favorite"
> databases due to our employers' needs. But, what about the MySQL, or
> Postgres, or SQL Server, or pick your favorite databases? I know we have
> had some interest from these database vendors on our users and dev forums,
> but I'm looking for ways to get these vendors more involved. When they
> produce a new version of their database, it would be great to announce
> OpenJPA support. And, if they have new features to take advantage of, that
> would be even better.
>
> Everybody's development and tests teams are limited. I understand that.
> But, I'm looking for ideas on how we can work together to accomplish this
> task. I'm going to cross post on both users and dev forums to see if there
> any lurkers that might have some ideas.
>
> Just to provide a real world example... I was just pinged about MS SQL
> Server 2008 support. Our OpenJPA manual only documents SQL Server 2005
> support. I don't have experience with SQL Server. So, it made me think
> how
> we could improve this aspect of our OpenJPA database support.
>
> Any thoughts?
>
> Kevin
>
RE: Database support
Posted by Ravi Palacherla <ra...@oracle.com>.
Hi Kevin,
What about volunteers for every database ?
I can volunteer for oracle database.
Currently I am trying to make all the trunk testcases successful against oracleDB.
So, if every database has volunteers to make sure all openJPA testcases run against a particular DB then I guess it would help.
What do you think ?
Thanks,
Ravi.
-----Original Message-----
From: Kevin Sutter [mailto:kwsutter@gmail.com]
Sent: Wednesday, May 13, 2009 3:37 PM
To: dev@openjpa.apache.org; users@openjpa.apache.org
Subject: Database support
Hi,
I'm trolling... I'm looking for ideas on how we can better integrate with
the various database vendors. Many of us committers have our own "favorite"
databases due to our employers' needs. But, what about the MySQL, or
Postgres, or SQL Server, or pick your favorite databases? I know we have
had some interest from these database vendors on our users and dev forums,
but I'm looking for ways to get these vendors more involved. When they
produce a new version of their database, it would be great to announce
OpenJPA support. And, if they have new features to take advantage of, that
would be even better.
Everybody's development and tests teams are limited. I understand that.
But, I'm looking for ideas on how we can work together to accomplish this
task. I'm going to cross post on both users and dev forums to see if there
any lurkers that might have some ideas.
Just to provide a real world example... I was just pinged about MS SQL
Server 2008 support. Our OpenJPA manual only documents SQL Server 2005
support. I don't have experience with SQL Server. So, it made me think how
we could improve this aspect of our OpenJPA database support.
Any thoughts?
Kevin
RE: Database support
Posted by Ravi Palacherla <ra...@oracle.com>.
Hi Kevin,
What about volunteers for every database ?
I can volunteer for oracle database.
Currently I am trying to make all the trunk testcases successful against oracleDB.
So, if every database has volunteers to make sure all openJPA testcases run against a particular DB then I guess it would help.
What do you think ?
Thanks,
Ravi.
-----Original Message-----
From: Kevin Sutter [mailto:kwsutter@gmail.com]
Sent: Wednesday, May 13, 2009 3:37 PM
To: dev@openjpa.apache.org; users@openjpa.apache.org
Subject: Database support
Hi,
I'm trolling... I'm looking for ideas on how we can better integrate with
the various database vendors. Many of us committers have our own "favorite"
databases due to our employers' needs. But, what about the MySQL, or
Postgres, or SQL Server, or pick your favorite databases? I know we have
had some interest from these database vendors on our users and dev forums,
but I'm looking for ways to get these vendors more involved. When they
produce a new version of their database, it would be great to announce
OpenJPA support. And, if they have new features to take advantage of, that
would be even better.
Everybody's development and tests teams are limited. I understand that.
But, I'm looking for ideas on how we can work together to accomplish this
task. I'm going to cross post on both users and dev forums to see if there
any lurkers that might have some ideas.
Just to provide a real world example... I was just pinged about MS SQL
Server 2008 support. Our OpenJPA manual only documents SQL Server 2005
support. I don't have experience with SQL Server. So, it made me think how
we could improve this aspect of our OpenJPA database support.
Any thoughts?
Kevin
Re: OpenJPA for Content Servers
Posted by Michael Dick <mi...@gmail.com>.
Hi Sriram,
It largely depends on how you communicate with docbase. JPA (typically)
interacts with JDBC, if there's a JDBC interface to the docbase you're using
then it will be fairly straightforward to use a JPA provider to do the
interactions.
If there isn't a JDBC driver for docbase then it's more difficult. OpenJPA
supports different back ends, but you'd have to write a fair bit of code to
talk to docbase's interface.
hope this helps,
-mike
On Thu, May 14, 2009 at 5:26 PM, shriram <sh...@yahoo.com> wrote:
> Kevin,
>
> Actually this is how it works
>
> client ======>docbase(Content Server) ===> database.
> (DFC-libraries)
>
> DFC==>Documentum Foundation Classes.
>
> If we are using a docbase from Documentum , is it possible for the client
> to connect with docbase using JPA.
>
> like
>
> client ===>JPA===>docbase==>database
>
> docbase just stores meta data, whereas the actual data is still stored in
> database.
>
> Thanks
> sriram
>
>
>
>
>
>
> ________________________________
> From: Kevin Sutter <kw...@gmail.com>
> To: users@openjpa.apache.org
> Sent: Thursday, May 14, 2009 4:53:38 PM
> Subject: Re: OpenJPA for Content Servers
>
> Sure. Most Content Servers still require some type of database to
> persistently store the "content", right? So, the implementation of a
> Content Server could easily use Entities to define their data model and use
> generic JPA constructs to persist the data. Independent from any
> particular
> database implementation (ie. not dependent on specific JDBC or SQL
> dialects). Sounds like a good fit, from my personal perspective. :-)
>
> Kevin
>
> On Thu, May 14, 2009 at 12:14 PM, shriram <sh...@yahoo.com> wrote:
>
> > Hi,
> >
> > I work for a Documentum Based product development company. Is there any
> way
> > OpenJPA applied for Content Servers.
> >
> > Thanks
> > sriram
> >
> >
> >
> >
>
>
>
>
>
Re: OpenJPA for Content Servers
Posted by shriram <sh...@yahoo.com>.
Kevin,
Actually this is how it works
client ======>docbase(Content Server) ===> database.
(DFC-libraries)
DFC==>Documentum Foundation Classes.
If we are using a docbase from Documentum , is it possible for the client to connect with docbase using JPA.
like
client ===>JPA===>docbase==>database
docbase just stores meta data, whereas the actual data is still stored in database.
Thanks
sriram
________________________________
From: Kevin Sutter <kw...@gmail.com>
To: users@openjpa.apache.org
Sent: Thursday, May 14, 2009 4:53:38 PM
Subject: Re: OpenJPA for Content Servers
Sure. Most Content Servers still require some type of database to
persistently store the "content", right? So, the implementation of a
Content Server could easily use Entities to define their data model and use
generic JPA constructs to persist the data. Independent from any particular
database implementation (ie. not dependent on specific JDBC or SQL
dialects). Sounds like a good fit, from my personal perspective. :-)
Kevin
On Thu, May 14, 2009 at 12:14 PM, shriram <sh...@yahoo.com> wrote:
> Hi,
>
> I work for a Documentum Based product development company. Is there any way
> OpenJPA applied for Content Servers.
>
> Thanks
> sriram
>
>
>
>
Re: OpenJPA for Content Servers
Posted by Kevin Sutter <kw...@gmail.com>.
Sure. Most Content Servers still require some type of database to
persistently store the "content", right? So, the implementation of a
Content Server could easily use Entities to define their data model and use
generic JPA constructs to persist the data. Independent from any particular
database implementation (ie. not dependent on specific JDBC or SQL
dialects). Sounds like a good fit, from my personal perspective. :-)
Kevin
On Thu, May 14, 2009 at 12:14 PM, shriram <sh...@yahoo.com> wrote:
> Hi,
>
> I work for a Documentum Based product development company. Is there any way
> OpenJPA applied for Content Servers.
>
> Thanks
> sriram
>
>
>
>
OpenJPA for Content Servers
Posted by shriram <sh...@yahoo.com>.
Hi,
I work for a Documentum Based product development company. Is there any way OpenJPA applied for Content Servers.
Thanks
sriram
Re: Database support
Posted by Kevin Sutter <kw...@gmail.com>.
Okay, so I'm looking at our stated database support [1]. From this chart, I
would divide up the databases into the following categories. The "Not
Currently Covered" category is where I would focus my phishing efforts
first. Any discussion?
Covered Interest by members of OpenJPA Community
=======================================
o Derby
o DB2
o Informix
o Oracle
o MS SQL Server ???
o Sybase ???
Not Currently Covered Interest by members of OpenJPA Community
=================================================
o MySQL
o PostgreSQL
o H2
o HSQLDB (Hypersonic)
o Firebird ???
Are these still required?
=================
o Borland Interbase
o Borland JDataStore
o Empress
o Intersystems Cache
o MS Access
o MS Visual FoxPro
o Pointbase
Thanks,
Kevin
[1]
http://openjpa.apache.org/builds/latest/docs/manual/manual.html#dbsupport
On Thu, May 14, 2009 at 10:01 AM, David Beer <da...@googlemail.com>wrote:
> Hi Kevin
>
> Some database vendors usually have some sort of universal contact which
> might be the best way of going about it. Posting a one of message to
> support forums might well be an idea that could work.
>
> David
>
> On Thu, 14 May 2009 08:46:03 -0500 Kevin Sutter
> <kw...@gmail.com> wrote:
>
> > Hi David,
> >
> > On Wed, May 13, 2009 at 5:10 PM, David Beer
> > <da...@googlemail.com>wrote:
> >
> > > Hi Kevin
> > >
> > > I currently use OpenJPA with the H2 database for my embeded
> > > programs, and will be considering MySQL for larger scale programs.
> > > I think that the more database vendors or suppliers we can get
> > > links with the better for both sides. I am happily using H2 with
> > > OpenJPA but there were some features I had to ask about and how to
> > > work with OenJPA.
> > >
> > > So my point is that we need a way of getting committers or users
> > > from both sides to help so we need a way of maybe certifying a
> > > database version.
> >
> >
> > It sounds like we're on the same page. The tricky part is signing up
> > this help and support from these database vendors and users groups.
> > Maybe I should just post to these vendor's user forums and ask for
> > some support. Just go phishing... :-)
> >
> > Kevin
> >
> >
> > >
> > >
> > > Jut my thoughts.
> > >
> > > David
> > >
> > > On Wed, 13 May 2009 16:36:53 -0500 Kevin Sutter
> > > <kw...@gmail.com> wrote:
> > >
> > > > Hi,
> > > > I'm trolling... I'm looking for ideas on how we can better
> > > > integrate with the various database vendors. Many of us
> > > > committers have our own "favorite" databases due to our
> > > > employers' needs. But, what about the MySQL, or Postgres, or SQL
> > > > Server, or pick your favorite databases? I know we have had some
> > > > interest from these database vendors on our users and dev forums,
> > > > but I'm looking for ways to get these vendors more involved.
> > > > When they produce a new version of their database, it would be
> > > > great to announce OpenJPA support. And, if they have new
> > > > features to take advantage of, that would be even better.
> > > >
> > > > Everybody's development and tests teams are limited. I understand
> > > > that. But, I'm looking for ideas on how we can work together to
> > > > accomplish this task. I'm going to cross post on both users and
> > > > dev forums to see if there any lurkers that might have some ideas.
> > > >
> > > > Just to provide a real world example... I was just pinged about
> > > > MS SQL Server 2008 support. Our OpenJPA manual only documents SQL
> > > > Server 2005 support. I don't have experience with SQL Server.
> > > > So, it made me think how we could improve this aspect of our
> > > > OpenJPA database support.
> > > >
> > > > Any thoughts?
> > > >
> > > > Kevin
> > >
> > >
>
>
Re: Database support
Posted by David Beer <da...@googlemail.com>.
Hi Kevin
Some database vendors usually have some sort of universal contact which
might be the best way of going about it. Posting a one of message to
support forums might well be an idea that could work.
David
On Thu, 14 May 2009 08:46:03 -0500 Kevin Sutter
<kw...@gmail.com> wrote:
> Hi David,
>
> On Wed, May 13, 2009 at 5:10 PM, David Beer
> <da...@googlemail.com>wrote:
>
> > Hi Kevin
> >
> > I currently use OpenJPA with the H2 database for my embeded
> > programs, and will be considering MySQL for larger scale programs.
> > I think that the more database vendors or suppliers we can get
> > links with the better for both sides. I am happily using H2 with
> > OpenJPA but there were some features I had to ask about and how to
> > work with OenJPA.
> >
> > So my point is that we need a way of getting committers or users
> > from both sides to help so we need a way of maybe certifying a
> > database version.
>
>
> It sounds like we're on the same page. The tricky part is signing up
> this help and support from these database vendors and users groups.
> Maybe I should just post to these vendor's user forums and ask for
> some support. Just go phishing... :-)
>
> Kevin
>
>
> >
> >
> > Jut my thoughts.
> >
> > David
> >
> > On Wed, 13 May 2009 16:36:53 -0500 Kevin Sutter
> > <kw...@gmail.com> wrote:
> >
> > > Hi,
> > > I'm trolling... I'm looking for ideas on how we can better
> > > integrate with the various database vendors. Many of us
> > > committers have our own "favorite" databases due to our
> > > employers' needs. But, what about the MySQL, or Postgres, or SQL
> > > Server, or pick your favorite databases? I know we have had some
> > > interest from these database vendors on our users and dev forums,
> > > but I'm looking for ways to get these vendors more involved.
> > > When they produce a new version of their database, it would be
> > > great to announce OpenJPA support. And, if they have new
> > > features to take advantage of, that would be even better.
> > >
> > > Everybody's development and tests teams are limited. I understand
> > > that. But, I'm looking for ideas on how we can work together to
> > > accomplish this task. I'm going to cross post on both users and
> > > dev forums to see if there any lurkers that might have some ideas.
> > >
> > > Just to provide a real world example... I was just pinged about
> > > MS SQL Server 2008 support. Our OpenJPA manual only documents SQL
> > > Server 2005 support. I don't have experience with SQL Server.
> > > So, it made me think how we could improve this aspect of our
> > > OpenJPA database support.
> > >
> > > Any thoughts?
> > >
> > > Kevin
> >
> >
Re: Database support
Posted by Kevin Sutter <kw...@gmail.com>.
Hi David,
On Wed, May 13, 2009 at 5:10 PM, David Beer <da...@googlemail.com>wrote:
> Hi Kevin
>
> I currently use OpenJPA with the H2 database for my embeded programs,
> and will be considering MySQL for larger scale programs. I think that
> the more database vendors or suppliers we can get links with the
> better for both sides. I am happily using H2 with OpenJPA but there
> were some features I had to ask about and how to work with OenJPA.
>
> So my point is that we need a way of getting committers or users from
> both sides to help so we need a way of maybe certifying a database
> version.
It sounds like we're on the same page. The tricky part is signing up this
help and support from these database vendors and users groups. Maybe I
should just post to these vendor's user forums and ask for some support.
Just go phishing... :-)
Kevin
>
>
> Jut my thoughts.
>
> David
>
> On Wed, 13 May 2009 16:36:53 -0500 Kevin Sutter
> <kw...@gmail.com> wrote:
>
> > Hi,
> > I'm trolling... I'm looking for ideas on how we can better integrate
> > with the various database vendors. Many of us committers have our
> > own "favorite" databases due to our employers' needs. But, what
> > about the MySQL, or Postgres, or SQL Server, or pick your favorite
> > databases? I know we have had some interest from these database
> > vendors on our users and dev forums, but I'm looking for ways to get
> > these vendors more involved. When they produce a new version of
> > their database, it would be great to announce OpenJPA support. And,
> > if they have new features to take advantage of, that would be even
> > better.
> >
> > Everybody's development and tests teams are limited. I understand
> > that. But, I'm looking for ideas on how we can work together to
> > accomplish this task. I'm going to cross post on both users and dev
> > forums to see if there any lurkers that might have some ideas.
> >
> > Just to provide a real world example... I was just pinged about MS
> > SQL Server 2008 support. Our OpenJPA manual only documents SQL
> > Server 2005 support. I don't have experience with SQL Server. So,
> > it made me think how we could improve this aspect of our OpenJPA
> > database support.
> >
> > Any thoughts?
> >
> > Kevin
>
>
Re: Database support
Posted by Kevin Sutter <kw...@gmail.com>.
Hi David,
On Wed, May 13, 2009 at 5:10 PM, David Beer <da...@googlemail.com>wrote:
> Hi Kevin
>
> I currently use OpenJPA with the H2 database for my embeded programs,
> and will be considering MySQL for larger scale programs. I think that
> the more database vendors or suppliers we can get links with the
> better for both sides. I am happily using H2 with OpenJPA but there
> were some features I had to ask about and how to work with OenJPA.
>
> So my point is that we need a way of getting committers or users from
> both sides to help so we need a way of maybe certifying a database
> version.
It sounds like we're on the same page. The tricky part is signing up this
help and support from these database vendors and users groups. Maybe I
should just post to these vendor's user forums and ask for some support.
Just go phishing... :-)
Kevin
>
>
> Jut my thoughts.
>
> David
>
> On Wed, 13 May 2009 16:36:53 -0500 Kevin Sutter
> <kw...@gmail.com> wrote:
>
> > Hi,
> > I'm trolling... I'm looking for ideas on how we can better integrate
> > with the various database vendors. Many of us committers have our
> > own "favorite" databases due to our employers' needs. But, what
> > about the MySQL, or Postgres, or SQL Server, or pick your favorite
> > databases? I know we have had some interest from these database
> > vendors on our users and dev forums, but I'm looking for ways to get
> > these vendors more involved. When they produce a new version of
> > their database, it would be great to announce OpenJPA support. And,
> > if they have new features to take advantage of, that would be even
> > better.
> >
> > Everybody's development and tests teams are limited. I understand
> > that. But, I'm looking for ideas on how we can work together to
> > accomplish this task. I'm going to cross post on both users and dev
> > forums to see if there any lurkers that might have some ideas.
> >
> > Just to provide a real world example... I was just pinged about MS
> > SQL Server 2008 support. Our OpenJPA manual only documents SQL
> > Server 2005 support. I don't have experience with SQL Server. So,
> > it made me think how we could improve this aspect of our OpenJPA
> > database support.
> >
> > Any thoughts?
> >
> > Kevin
>
>
Re: Database support
Posted by David Beer <da...@googlemail.com>.
Hi Kevin
I currently use OpenJPA with the H2 database for my embeded programs,
and will be considering MySQL for larger scale programs. I think that
the more database vendors or suppliers we can get links with the
better for both sides. I am happily using H2 with OpenJPA but there
were some features I had to ask about and how to work with OenJPA.
So my point is that we need a way of getting committers or users from
both sides to help so we need a way of maybe certifying a database
version.
Jut my thoughts.
David
On Wed, 13 May 2009 16:36:53 -0500 Kevin Sutter
<kw...@gmail.com> wrote:
> Hi,
> I'm trolling... I'm looking for ideas on how we can better integrate
> with the various database vendors. Many of us committers have our
> own "favorite" databases due to our employers' needs. But, what
> about the MySQL, or Postgres, or SQL Server, or pick your favorite
> databases? I know we have had some interest from these database
> vendors on our users and dev forums, but I'm looking for ways to get
> these vendors more involved. When they produce a new version of
> their database, it would be great to announce OpenJPA support. And,
> if they have new features to take advantage of, that would be even
> better.
>
> Everybody's development and tests teams are limited. I understand
> that. But, I'm looking for ideas on how we can work together to
> accomplish this task. I'm going to cross post on both users and dev
> forums to see if there any lurkers that might have some ideas.
>
> Just to provide a real world example... I was just pinged about MS
> SQL Server 2008 support. Our OpenJPA manual only documents SQL
> Server 2005 support. I don't have experience with SQL Server. So,
> it made me think how we could improve this aspect of our OpenJPA
> database support.
>
> Any thoughts?
>
> Kevin