Обсуждение: JPA and Postgresql

My question is - what is the MINIMAL configuration for using the  JPA  features
together with postgresql ?

---

Jetzt 30 Gratis-Emoticons für Windows Live Messenger downloaden! Windows Live Messenger

Robert Wimmer wrote:
> My question is - what is the MINIMAL configuration for using the  JPA
> features
> together with postgresql ?


minimal in what way?    smallest possible memory footprint?     easiest
to deploy on some specific platform?

>
>
> minimal in what way? smallest possible memory footprint? easiest
> to deploy on some specific platform?
>


easiest to deploy on eclipse (3.3) with minimal resources in that sense
- if possible no Hibernate
- if possible no Application Server

regards sepp

---

Jetzt 30 Gratis-Emoticons für Windows Live Messenger downloaden! Windows Live Messenger

Robert Wimmer wrote:
> easiest to deploy on eclipse (3.3) with minimal resources in that sense
> - if possible no Hibernate
> - if possible no Application Server

You don't install Postgres on eclipse, you install and configure it on
your host operating system, enabling it to accept network ('host')
connections from the client.  the details of installing and configuring
vary with different operating system distributions.

You'd then use the postgres jdbc provider, installable on your eclipse
jdk environment, same as you'd install any other jar.

The rest are JPA questions, and would better be served by a Java/JPA
list, I suspect.

> > - if possible no Hibernate
> > - if possible no Application Server
>
> You don't install Postgres on eclipse,

i never wanted to reinstall my postgres

My question was - what is the MINIMAL configuration for using the  JPA  features
together with postgresql ?

>
> The rest are JPA questions, and would better be served by a Java/JPA
> list, I suspect.
>

if there would exist a postgresql jdbc4 driver that supports the features
you need for the JPA extensions, i wouldnt have asked here.

so i try to reword my question.

what is the minimal configuration (workaround)  for  using  the new JPA  features  (extensions)  in eclipse (3.3) together with an existing and running 8.0 PostgreSQL instance (database) on WindowsXP (on saturdays in europe when its raining). 

please forgive me my awfull english - its not my mothertongue.

regards Sepp

---

Jetzt 30 Gratis-Emoticons für Windows Live Messenger downloaden! Windows Live Messenger

Robert Wimmer wrote:

> if there would exist a postgresql jdbc4 driver that supports the features
> you need for the JPA extensions, i wouldnt have asked here.

Well, what are the features that JPA needs that the current driver
doesn't provide? Assume that we know nothing about JPA.

-O

>
> Robert Wimmer wrote:
>
> > if there would exist a postgresql jdbc4 driver that supports the features
> > you need for the JPA extensions, i wouldnt have asked here.
>
> Well, what are the features that JPA needs that the current driver
> doesn't provide? Assume that we know nothing about JPA.
>
 
qoute from jdbc.postgresql.org

"JDK 1.6 - JDBC4. Support for JDBC4 methods is limited. The driver builds, but the majority of new methods are stubbed out"

what i want to do is to use the new java annotations for "OR-Mapping".  so i dont have to do all these mappings by hand and via SQL Strings. the following is an example that runs with derby on eclipse. trying similar things with the new jdbc driver  didnt work.

** snippet

@Entity
@Table(name = "PRODUCTLINE", schema = "CLASSICCARS", uniqueConstraints = {})
public class Productline implements java.io.Serializable {

**


regards sepp

---

Jetzt 30 Gratis-Emoticons für Windows Live Messenger downloaden! Windows Live Messenger

Robert Wimmer wrote:

> what i want to do is to use the new java annotations for "OR-Mapping".
> so i dont have to do all these mappings by hand and via SQL Strings. the
> following is an example that runs with derby on eclipse. trying similar
> things with the new jdbc driver  didnt work.

Ok, so once again .. what are the features that the JDBC driver needs to
implement to get this working? "didn't work" is not very informative.

-O

Robert Wimmer wrote:

.hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } >
> Robert Wimmer wrote:
>
> > if there would exist a postgresql jdbc4 driver that supports the features
> > you need for the JPA extensions, i wouldnt have asked here.
>
> Well, what are the features that JPA needs that the current driver
> doesn't provide? Assume that we know nothing about JPA.
>
 
qoute from jdbc.postgresql.org

"JDK 1.6 - JDBC4. Support for JDBC4 methods is limited. The driver builds, but the majority of new methods are stubbed out"

what i want to do is to use the new java annotations for "OR-Mapping".  so i dont have to do all these mappings by hand and via SQL Strings. the following is an example that runs with derby on eclipse. trying similar things with the new jdbc driver  didnt work.

** snippet

@Entity
@Table(name = "PRODUCTLINE", schema = "CLASSICCARS", uniqueConstraints = {})
public class Productline implements java.io.Serializable {

**

Well, this is simply defining a table, schema, and unique constraints. The driver should have nothing to do here.

Dave

regards sepp

---

Jetzt 30 Gratis-Emoticons für Windows Live Messenger downloaden! Windows Live Messenger

You could just use the glassfish implementation of JPA (Toplink) if you want to avoid a ton of jars in your classpath.
I'vetried out most of the other JPA implementations and found the glassfish implementation the easiest one to get
startedwith but have since moved to another implementation for various reasons. 

This is an old article but should get you started
http://blogs.sun.com/Glassfish_PostgreSQL/entry/introducing_support_for_postgresql_in

If you don't use an application server you will need to manage the entity manager yourself.

When you say resources, what resources in particular are you referring to?

The code below should work, check your dialect and if that's correct, try another JPA implementation. What's the exact
erroryou are getting? 

@Entity
@Table(name = "PRODUCTLINE", schema = "CLASSICCARS", uniqueConstraints = {})
public class Productline implements java.io.Serializable {


________________________________

From: pgsql-jdbc-owner@postgresql.org on behalf of Robert Wimmer
Sent: Sat 10/27/2007 2:04 PM
To: John R Pierce; pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] JPA and Postgresql



>
>
> minimal in what way? smallest possible memory footprint? easiest
> to deploy on some specific platform?
>


easiest to deploy on eclipse (3.3) with minimal resources in that sense
- if possible no Hibernate
- if possible no Application Server

regards sepp


________________________________

Jetzt 30 Gratis-Emoticons für Windows Live Messenger downloaden! Windows Live Messenger
<http://www.livemessenger-emoticons.com/de-at/>  

Oracle donated TopLink to Eclipse back in March. The project is still in
incubation but chances are, it's fairly stable. Check out
http://www.eclipse.org/eclipselink/

Regards,
Thomas Hallgren

Nicholas E. Wakefield wrote:
> You could just use the glassfish implementation of JPA (Toplink) if you want to avoid a ton of jars in your
classpath.I've tried out most of the other JPA implementations and found the glassfish implementation the easiest one
toget started with but have since moved to another implementation for various reasons. 
>
> This is an old article but should get you started
> http://blogs.sun.com/Glassfish_PostgreSQL/entry/introducing_support_for_postgresql_in
>
> If you don't use an application server you will need to manage the entity manager yourself.
>
> When you say resources, what resources in particular are you referring to?
>
> The code below should work, check your dialect and if that's correct, try another JPA implementation. What's the
exacterror you are getting? 
>
> @Entity
> @Table(name = "PRODUCTLINE", schema = "CLASSICCARS", uniqueConstraints = {})
> public class Productline implements java.io.Serializable {
>
>
> ________________________________
>
> From: pgsql-jdbc-owner@postgresql.org on behalf of Robert Wimmer
> Sent: Sat 10/27/2007 2:04 PM
> To: John R Pierce; pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] JPA and Postgresql
>
>
>
>>
>> minimal in what way? smallest possible memory footprint? easiest
>> to deploy on some specific platform?
>>
>
>
> easiest to deploy on eclipse (3.3) with minimal resources in that sense
> - if possible no Hibernate
> - if possible no Application Server
>
> regards sepp
>
>
> ________________________________
>
> Jetzt 30 Gratis-Emoticons für Windows Live Messenger downloaden! Windows Live Messenger
<http://www.livemessenger-emoticons.com/de-at/>  
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

On 10/28/07, Nicholas E. Wakefield <nwakefield@kineticnetworks.com> wrote:
> You could just use the glassfish implementation of JPA (Toplink) if you want to avoid a ton of jars in your
classpath.I've tried out most of the other JPA implementations and found the glassfish implementation the easiest one
toget started with but have since moved to another implementation for various reasons. 

Would it be possible to know more about this ("but have since moved to
another implementation for various reasons").

Thanks
Peter

>
> This is an old article but should get you started
> http://blogs.sun.com/Glassfish_PostgreSQL/entry/introducing_support_for_postgresql_in
>
> If you don't use an application server you will need to manage the entity manager yourself.
>
> When you say resources, what resources in particular are you referring to?
>
> The code below should work, check your dialect and if that's correct, try another JPA implementation. What's the
exacterror you are getting? 
>
> @Entity
> @Table(name = "PRODUCTLINE", schema = "CLASSICCARS", uniqueConstraints = {})
> public class Productline implements java.io.Serializable {
>
>
> ________________________________
>
> From: pgsql-jdbc-owner@postgresql.org on behalf of Robert Wimmer
> Sent: Sat 10/27/2007 2:04 PM
> To: John R Pierce; pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] JPA and Postgresql
>
>
>
> >
> >
> > minimal in what way? smallest possible memory footprint? easiest
> > to deploy on some specific platform?
> >
>
>
> easiest to deploy on eclipse (3.3) with minimal resources in that sense
> - if possible no Hibernate
> - if possible no Application Server
>
> regards sepp
>
>
> ________________________________
>
> Jetzt 30 Gratis-Emoticons für Windows Live Messenger downloaden! Windows Live Messenger
<http://www.livemessenger-emoticons.com/de-at/>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

I use TopLink Essentials + PostgreSQL JDBC 4 driver without any problems.
Glassfish has this problem woth getClientInfo method, but I did not see
it in standalone mode.
I have never used Eclipse's JPA plugin.

For toplink see:
http://www.oracle.com/technology/products/ias/toplink/jpa/howto/java-se-usage.html

> >
> > Robert Wimmer wrote:
> >
> > > if there would exist a postgresql jdbc4 driver that supports the
> features
> > > you need for the JPA extensions, i wouldnt have asked here.
> >
> > Well, what are the features that JPA needs that the current driver
> > doesn't provide? Assume that we know nothing about JPA.
> >
>
> qoute from jdbc.postgresql.org
>
> "JDK 1.6 - JDBC4. Support for JDBC4 methods is limited. The driver
> builds, but the majority of new methods are stubbed out"
>
> what i want to do is to use the new java annotations for
> "OR-Mapping".  so i dont have to do all these mappings by hand and via
> SQL Strings. the following is an example that runs with derby on
> eclipse. trying similar things with the new jdbc driver  didnt work.
>
> ** snippet
>
> @Entity
> @Table(name = "PRODUCTLINE", schema = "CLASSICCARS", uniqueConstraints
> = {})
> public class Productline implements java.io.Serializable {
>
> **
>
>
> regards sepp
>
> ------------------------------------------------------------------------
> Jetzt 30 Gratis-Emoticons für Windows Live Messenger downloaden!
> Windows Live Messenger <http://www.livemessenger-emoticons.com/de-at/>

Am 27.10.2007 um 22:32 schrieb Robert Wimmer:

> My question is - what is the MINIMAL configuration for using the
> JPA  features
> together with postgresql ?

A JDBC 3 driver. Dunno if JDBC 2 is enough, but any current driver
should work.