Queries when creating EntityManager

2007-09-20 Thread Evgeny Shepelyuk
Hello! Im using OpenJPA with Spring transactional management and EntityManager injection to DAO under Postgresql 8.2.1 Seems when new EntityManager is created those queries are executing to database SELECT t.typlen FROM pg_catalog.pg_type t, pg_catalog.pg_namespace n WHERE t.typ

Re: Queries when creating EntityManager

2007-09-20 Thread ben short
Do you want to turn of the logging of sql? You'll need to set on of the log properties [1] but I'm not sure which one relates to the sql being logged, sorry. You can do this as show below..

Re: Queries when creating EntityManager

2007-09-20 Thread Patrick Linskey
Hi, Can you post your current persistence.xml file? I don't think that OpenJPA directly issues these statements. Where are you seeing them being logged? I'd guess that maybe they're a result of some DatabaseMetaData calls while the LazySchemaFactory is looking for indexes. -Patrick On 9/20/07,

Re: Query returns right number of results, but they're all null?

2007-09-20 Thread Patrick Linskey
I've not seen that behavior, no. You don't have a reproducible test case that you could attach to a JIRA issue, do you? Also, what happens if you turn on trace-level debugging? -Patrick On 9/19/07, Cannon, Derry <[EMAIL PROTECTED]> wrote: > Has anyone had an issue with a query finding the

Re: SequenceGenerator not using cached ids.

2007-09-20 Thread Patrick Linskey
Hi, Have you done any other configuration of the sequence elsewhere? Also, can you turn SQL and JDBC logging to TRACE and post the logs? I think I remember a thread about a similar topic in the last couple of months, btw. I don't remember what, if anything, the resolution was. -Patrick On 9/20/

Re: Queries when creating EntityManager

2007-09-20 Thread Evgeny Shepelyuk
20.09.07 в 12:02 Patrick Linskey в своём письме писал(а): Hi, Can you post your current persistence.xml file? http://java.sun.com/xml/ns/persistence"; version="1.0"> org.apache.openjpa.persistence.PersistenceProviderImpl . my entities value="jdbc:postgresql://localhost:5432/test"

SequenceGenerator not using cached ids.

2007-09-20 Thread ben short
Hi, I have a simple class as shown below... Entity @SequenceGenerator(name="CategoryIdGen", sequenceName = "CategoryIdSeq") public class Category { @Id @Column(name="id") @GeneratedValue(strategy= GenerationType.SEQUENCE, generator = "CategoryIdGen") private Long mId; } Given t

Re: SequenceGenerator not using cached ids.

2007-09-20 Thread ben short
Patrick, This is a re post [1] , I got zero response from the last time, i wonder if that's what you are thinking of? I'm doing no configuration apart from what you can see in class. Here's the log.. log4j:WARN No appenders could be found for logger (org.springframework.util.ClassUtils). log4j

Re: SequenceGenerator not using cached ids.

2007-09-20 Thread Takeichi Kanzaki Cabrera
I have the same problem using postgresql + openjpa-1.0 and at this time I have no solution for it. -- Regards, Takeichi Kanzaki Cabrera Linux Registered User #308138 If you want to be original, be your self.

Re: SequenceGenerator not using cached ids.

2007-09-20 Thread ben short
My work around was to set the allocationSize property to 1, but that kind of defeats the point of caching the id's. Regards Ben On 9/20/07, Takeichi Kanzaki Cabrera <[EMAIL PROTECTED]> wrote: > I have the same problem using postgresql + openjpa-1.0 and at this > time I have no solution for it. >

Spring + OpenJPA FetchType.LAZY

2007-09-20 Thread Gregg Bolinger
I seem to be having an issue with Lazy loading. I am using the latest Spring and the latest OpenJPA. I have the following: @Entity @Table(name = "category") public class Category { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Integer id; private String category;

What's the sequence of calling Persist and Update interceptors in the persist scenario?

2007-09-20 Thread Gene Woo
Hi, When I try to persist a brand new entity instance into database. What's the correct sequence of interceptor's invocation? The result I got is: persist @PrePersist @PostPersist commit @PreUpdate @PostUpdate I just doubt openjpa invokes "update" interceptors after commit. -- Best