Re: [eclipselink-users] EclipseLink problems with Postgres 9.1

[Tom Ware <tom.ware@xxxxxxxxxx>]

If you change the EclipseLink logging level to FINER, do you see SQL logged
when you do an insert/update? (persistence unit property
eclipselink.logging.level=FINER)

On 24/05/2013 8:34 AM, Vladimir Blagojevic wrote:
> I use JTA, JBoss container does all the tx managment, I use mix of CMT
> and BMT where appropriate. As you can see I did not list any
> persistent classes as some documentation might suggest - everything
> worked as expected.
>
> Much appreciated,
> Vladimir
>
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence version="2.0"
> xmlns="http://java.sun.com/xml/ns/persistence";
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
> http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd";>
>    <persistence-unit name="acme" transaction-type="JTA">
>      <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
>      <jta-data-source>java:/DefaultDS</jta-data-source>
>      <properties>
>        <property name="eclipselink.ddl-generation"
> value="create-or-extend-tables" />
>        <property name="javax.persistence.validation.mode" value="NONE"/>
>      </properties>
>    </persistence-unit>
> </persistence>
>
> On Fri, May 24, 2013 at 2:24 PM, Tom Ware <tom.ware@xxxxxxxxxx> wrote:
> > How are you connecting to the database.  Are you using a JTA datasource?  A
> > non-JPA-datasource?  A RESOURCE_LOCAL connecton?  How is it configured
> >
> > If you change the EclipseLink logging level to FINER, do you see SQL logged
> > when you do an insert/update? (persistence unit property
> > eclipselink.logging.level=FINER)
> >
> > -Tom
> >
> >
> > On 24/05/2013 6:07 AM, Vladimir Blagojevic wrote:
> > > Hi,
> > >
> > > I have a working J2EE web application using EclipseLink 2.4.1,
> > > Postgres 8.4 and JBoss 7.1. I even made an option in persistence.xml
> > > to switch between Hibernate and Eclipselink. Everything worked great
> > > until I needed to upgrade to Postgres 9.1 database. I updated Postgres
> > > driver to 9.1-901.jdbc4, first tried Hibernate persistence and
> > > everything worked without a hiccup. However, for some reason
> > > EclipseLink simply does not write to a Postgres 9.1 DB. I thought this
> > > might be related to Java/platform specifics I am running (Linux Fedora
> > > 16/jdk7u21) so I tried it on a colleagues Windows laptop - the exact
> > > same issue occurs - there are no writes to the database. I tried
> > > different versions of Postgres driver, trying 9.2-1002 .jdbc4 and even
> > > 8.4-703.jdbc4 that I used with Postgres 8.4 installation to no avail.
> > > Mind you DDL generation works fine, everything seems normal in the
> > > logs [1] and yet when the writes are supposed to happen my database
> > > does not record any changes.
> > >
> > > What could be the culprit?
> > >
> > > Regards,
> > > Vladimir
> > >
> > >
> > > [1]
> > > 10:57:51,532 INFO  [stdout]  [EL Info]: 2013-05-24
> > > 10:57:51.52--ServerSession(1448020230)--EclipseLink, version: Eclipse
> > > Persistence Services - 2.4.1.v20121003-ad44345
> > > 10:57:51,987 INFO  [stdout] [EL Info]: connection: 2013-05-24
> > >
> > > 10:57:51.986--ServerSession(1448020230)--vfs:/content/acme.war/WEB-INF/classes/_acme
> > > login successful
> > > _______________________________________________
> > > eclipselink-users mailing list
> > > eclipselink-users@xxxxxxxxxxx
> > > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> > _______________________________________________
> > eclipselink-users mailing list
> > eclipselink-users@xxxxxxxxxxx
> > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users