Thread: 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
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
> > - 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:
>
> > 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:
Dave
Well, this is simply defining a table, schema, and unique constraints. The driver should have nothing to do here..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 {
**
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.