Re: Problem with Postgresql TIMESTAMP objects

2008-04-04 Thread David Goodenough
On Friday 04 April 2008, Brill Pappin wrote: > Isn't type timestamp a long value? > > - Brill Pappin > > -Original Message- > From: David Goodenough [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2008 4:46 PM > To: users@openjpa.apache.org > Subject: Problem with Postgresql TIMESTAMP

Re: How to PERSIST object without loading references?

2008-04-04 Thread Ognjen Blagojevic
It is, indeed. Thanks. Now I really understand why did the specification declared both "find" and "getReference". O:) Regards, Ognjen Patrick Linskey wrote: Hi, EntityManager.getReference() is your friend here. -Patrick On Thu, Apr 3, 2008 at 4:19 AM, Ognjen Blagojevic <[EMAIL PROTECTED]

Re: JPA and persistence context

2008-04-04 Thread Adam Hardy
I do not use OpenJPA in deployment, because there are some show-stopper issues with it. But I do use it in testing and I'll use it in the future for live sites when the issues are sorted. I use the extended persistence context though. In this case if you don't manage the transactions yourself,

Re: JPA and persistence context

2008-04-04 Thread Nino Saturnino Martinez Vazquez Wael
Okay thanks, sounds a little like youre at the stage im at too. I'll upgrade my spring then... Adam Hardy wrote: I do not use OpenJPA in deployment, because there are some show-stopper issues with it. But I do use it in testing and I'll use it in the future for live sites when the issues are s

Re: How to get I get to the read JDBC Connection object...

2008-04-04 Thread David Goodenough
On Tuesday 01 April 2008, Patrick Linskey wrote: > Or, even more simply: > > em.getTransaction().begin(); > Connection c = OpenJPAPersistence.cast(em).getConnection(); Actually for what I need I need to cast this to a DelegatingConnection and then get the PGConnection by casting its InnermostDelega

RE: Slow JPA

2008-04-04 Thread Patrick T
My issue is even just fetching the entities. Despite of changing relationships to LAZY fetch, I find that querying the DB takes a really long time. I have experienced the commit issue as well,but I've worked around that by being careful on what I cascade through different entities. Brill Pappin

Re: Slow JPA

2008-04-04 Thread Brill Pappin
We were using 1.0 in this project, but its showing up in another project using 1.1. I really *want* to use ojpa but I don't have time to mess around and the problem is significant. There seem to be other inefficiencies as well that don't seem to need to be there. Not sure what we're going to do a

Re: Slow JPA

2008-04-04 Thread Patrick Linskey
Hi, Are you calling merge() or persist() a lot? There's a known inefficiency in 1.1.0-SNAPSHOT (not 1.0) with merging right now. Also, what does the generated SQL look like in your examples? -Patrick On Fri, Apr 4, 2008 at 7:55 AM, Brill Pappin <[EMAIL PROTECTED]> wrote: > We were using 1.0 in

Re: Slow JPA

2008-04-04 Thread Kevin Sutter
Brill and others, Thanks for the feedback. As one of the notes indicated, any orm framework is going to be slower than straight JDBC, but it shouldn't be significant. Understanding and controlling what entities get fetched (lazy vs eager) is an excellent first step. It sounds like you are already

Re: How to get I get to the read JDBC Connection object...

2008-04-04 Thread Patrick Linskey
> > Additionally, note that OpenJPA 1.1.0-SNAPSHOT has support for fields > > of type InputStream; with this support, OpenJPA will never fully load > > the data into memory. > I can see how this will work for readonly values, how about write ones? > Also looking in the 1.1.0 manual I can not f

Table per class problem

2008-04-04 Thread Jan Kotek
Hello, It seems there is bug in table-per-class inheritance. I have this herarchy: @Inheritance(strategy=InheritanceType.SINGLE_TABLE) class Car1 { int maxSpeed } @Inheritance(strategy=InheritanceType.SINGLE_TABLE) class Car2 {..} extends Car1 @Inheritance(strategy=InheritanceType.TABLE_PER_CL

Re: How to get I get to the read JDBC Connection object...

2008-04-04 Thread Ignacio Andreu
Hi, The InputStream / reader support is not documented yet, I want to provide some documentation soon. BTW I sent a patch for the InputStream / Reader support a week ago, this patch solves some bugs, Can you review and commit the patch? Thanks in advance!! On Fri, Apr 4, 2008 at 5:32 PM, Patr

Re: How to get I get to the read JDBC Connection object...

2008-04-04 Thread Ignacio Andreu
I review the conversation If you're using PostgreSQL, the actual InputStream / Reader don't have support for PostgreSQL, although if you've a good solution for Large Object in PostgreSQL please e-mail me. - Ignacio On Fri, Apr 4, 2008 at 7:16 PM, Ignacio Andreu <[EMAIL PROTECTED]> wrote: > Hi,

Re: How to get I get to the read JDBC Connection object...

2008-04-04 Thread David Goodenough
On Friday 04 April 2008, Ignacio Andreu wrote: > I review the conversation If you're using PostgreSQL, the actual > InputStream / Reader don't have support for PostgreSQL, although if you've > a good solution for Large Object in PostgreSQL please e-mail me. > When I have got everything working I wi

RE: Slow JPA

2008-04-04 Thread Brill Pappin
We don't have time to run it through YourKit and try to trace the issues, but my partner and I feel strongly that if we want something good, we can pitch in to help get it fixed. To that end, we'll attempt to provide some sample code that can reproduce the specific problem we were having. Not sur