Re: [Hibernate] Postgres problem - idle in transaction.

2003-01-03 Thread Juozas Baliuka
Try DBCPConnectionProvider. - Original Message - From: "Jim Downing" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 03, 2003 10:24 PM Subject: [Hibernate] Postgres problem - idle in transaction. > Hi all, > > I have a problem with hibernate and postgresql that I suspe

RE: [Hibernate] Suggestion: Encapsulate SQLException in HibernateException

2003-01-03 Thread Schnitzer, Jeff
Why not HibernateException extends SQLException? Jeff > -Original Message- > From: One Ovthafew [mailto:[EMAIL PROTECTED] > Sent: Friday, January 03, 2003 8:30 AM > To: [EMAIL PROTECTED] > Subject: Re: [Hibernate] Suggestion: Encapsulate SQLException in > HibernateException > > I am happ

[Hibernate] hbm2java in Hibernate 2...

2003-01-03 Thread Max Rydahl Andersen
How much back-wards compability should there be for hibernate-1.1 dtd in hbm2java ? (Here thinking on the recent 'role to name' name change)... Just wanting to hear the general opinion ? (Im +1 on having hbm2java only support hibernate-2.0.dtd) /max -

Re: [Hibernate] Using CLOBs

2003-01-03 Thread Ugo Cei
Gavin King wrote: Ugo, would you please produce a page documenting your approach to this for the Wiki. Other people will also need to know this stuff. Done. I also hope I can find the time to write some reusable code that spares me from having to do all this every single time I want to store a Cl

Re: [Hibernate] Middlegen and XDoclet marriage

2003-01-03 Thread Max Rydahl Andersen
- Original Message - From: "Aslak Hellesoy" <[EMAIL PROTECTED]> To: "One Ovthafew" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, January 03, 2003 6:10 PM Subject: RE: [Hibernate] Middlegen and XDoclet marriage > > >>>>XDoclet>>>>>SchemaExport > > java + @t

[Hibernate] Postgres problem - idle in transaction.

2003-01-03 Thread Jim Downing
Hi all, I have a problem with hibernate and postgresql that I suspect might be related to Matt Raible's Oracle problems. Every time hibernate does it's stuff to update the database, postgres spawns another "idle in transaction" process. Eventually it gives up and the driver throws: - Backend star

Re: [Hibernate] Suggestion: Encapsulate SQLException in HibernateException

2003-01-03 Thread Max Rydahl Andersen
Im approx +0 on this one :) Gavin, why was this done in the first place ? Seem to remember somewhere that the docs states: Free from my mind: "Hibernate does not hide what's happening. e.g. SQLExceptions is propagated all the way up to the user." . /max - Original Message - From: "One

Re: [Hibernate] Hibernate 2

2003-01-03 Thread Max Rydahl Andersen
> * Remove the exception that occurs if you save an object > that is already associated with the session. This > makes save() consistent with saveOrUpdate(). >Lets make this change. > * Remove the exception that occurs if you delete an object > that is already deleted in that session. >Let

RE: [Hibernate] Getting a sorted list of results

2003-01-03 Thread Raible, Matt
And so it begins - I eliminated about 100 lines of code by passing in a List of longs, vs. a List of objects with their id's set. Thank you from the bottom of my heart ;) Matt - Forwarded message - > This *looks* to be exactly what I'm looking for, however, I'm getting an

Re: [Hibernate] saving to pgsql

2003-01-03 Thread Juozas Baliuka
postgres closes connection if it detects error in protocol, something like this can produce this error: char c = '\u'; String query = "select " + c; statement.execute(query);// error not detected by driver, server closes connection; I am not sure about all driver versions, but it must be possib

RE: [Hibernate] Middlegen and XDoclet marriage

2003-01-03 Thread Aslak Hellesoy
>>>>XDoclet>>>>>SchemaExport > java + @tags hbm.xml SQL DDL ><< Oh, the beauty! > > The the only leg of the roundtripping that is not > fully reproduceable without user interaction is the > DDL -> hbm.xml (ie. Middlegen) step. > Middlegen

Re: [Hibernate] Middlegen and XDoclet marriage

2003-01-03 Thread Konstantin Priblouda
--- One Ovthafew <[EMAIL PROTECTED]> wrote: > > We havn't actually had much discussion of middlegen > on > this list (though it has come up a couple of times). > This > recent burst of activity is mainly in response to > the > thinking Max has been doing recently and I'm just > kinda > following

Re: [Hibernate] Middlegen and XDoclet marriage

2003-01-03 Thread One Ovthafew
We havn't actually had much discussion of middlegen on this list (though it has come up a couple of times). This recent burst of activity is mainly in response to the thinking Max has been doing recently and I'm just kinda following up on his ideas. I'd particularly like to know what Konstantin t

Re: [Hibernate] Suggestion: Encapsulate SQLException in HibernateException

2003-01-03 Thread One Ovthafew
I am happy to introduce a JDBCException that wraps any SQLExceptions that occur. However, I don't have a strong view either way. So lets just vote on this Gavin >> I was thinking about wrapping SQLException in HibernateException, so that we don't need to worry about catch HibernateException a

[Hibernate] Middlegen and XDoclet marriage

2003-01-03 Thread Aslak Hellesøy
Hi! I'm new on the Hibernate list, so I haven't followed your discussions about XDoclet and Middlegen integration lately. -But I've seen your Wiki. As some of you probably know already, Gavin has developed a Hibernate plugin for Middlegen that should work with the recent XDoclet module for Hiberna

RE: [Hibernate] Getting a sorted list of results

2003-01-03 Thread Raible, Matt
This *looks* to be exactly what I'm looking for, however, I'm getting an "inconsistent datatypes" error from Oracle. Is there something I need to do to get :id_list to be recognized as Longs? I tried the query that Hibernate is using, and substituted the test case parameters, and everything worke

[Hibernate] Suggestion: Encapsulate SQLException in HibernateException

2003-01-03 Thread rmiranda
Hi, I was thinking about wrapping SQLException in HibernateException, so that we don't need to worry about catch HibernateException and SQLException. Since now the work is focused on some changes for Hibernate 2, this could be the right time to do this kind of change. This would simplify the er

[Hibernate] Proposal: Encapsulate

2003-01-03 Thread rmiranda
--- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibern

Re: [Hibernate] Should be: xdoclet/hibernate/jboss example - config issues

2003-01-03 Thread Konstantin Priblouda
> One question, I'm new to JBoss. Should the example > run in a vanilla JBoss > 3.0.4 (with Tomcat) install? I changed the > hibernate.properties before > building and now it deploy's fine. But when I run > the client (run.sh) I get > two errors: 1) cannot fine DefaultDS data source and > 2) no use

[Hibernate] Re: xdoclet hibernate problem

2003-01-03 Thread Konstantin Priblouda
> Really? I just downloaded the 1.2b2 jars and there > is an > xdoclet-module-hibernate-1.2b2.jar file. It appears > to be doing something > (but not functioning, still need to dig). Well, they were released too. I do not know much about maven, but from ant everything works fine regards, ==

[Hibernate] ms access 4

2003-01-03 Thread dev
hi, - counter: I can now exclude general support for identity columns as in access autonumber can be only of its type "long integer", and hence cannot be prescribed by the user - while fighting with foobar test on access (on this I am still working), I tried it also on mysql, where it gives: o

RE: [Hibernate] Hibernate Thread Local Session and JUnit

2003-01-03 Thread Gavin King
In that implementation the JNDI server maintains the reference to the singleton SessionFactory, and the ThreadLocal holds the reference to the "single-per-transaction" Session. There are, of course, other ways to accomplish this > -Original Message- > From: Matt Raible [mailto:[EMAIL P

RE: [Hibernate] Hibernate Thread Local Session and JUnit

2003-01-03 Thread Matt Raible
I'm using the Thread Local Session as described at http://hibernate.bluemars.net/42.html. To my knowledge, this is a singleton - or do I need to get fancier, as this (http://members.tripod.com/rwald/java/articles/Singleton_in_Java.html) suggests? Thanks, Matt > -Original Message- > From

[Hibernate] Should be: xdoclet/hibernate/jboss example - config issues

2003-01-03 Thread Richard Mixon
(Sorry, to repost, I forgot to change subject) Konstantin/all, Thanks very much for your xdoclet/hibernate/jboss example. I have learned a lot. It has made me re-think my current application approach. Maybe I will use EJB's after all. One question, I'm new to JBoss. Should the example run in a va

[Hibernate] RE: [hibernate - Open Discussion] There is *working* example

2003-01-03 Thread Richard Mixon
Konstantin/all, Thanks very much for your xdoclet/hibernate/jboss example. I have learned a lot. It has made me re-think my current application approach. Maybe I will use EJB's after all. One question, I'm new to JBoss. Should the example run in a vanilla JBoss 3.0.4 (with Tomcat) install? I chan

Re: [Hibernate] saving to pgsql

2003-01-03 Thread cheeser
Here's the pgsql log. See anything wrong? LOG: query: set autocommit = on; commit; LOG: query: set autocommit = off; LOG: query: select nextval ('uid_sequence') LOG: query: insert into CommentTable ( Value, DateEntered, PrimaryKey, subclass ) values ( null, null, 4, 'Comment' ) LOG: query

RE: [Hibernate] Using CLOBs

2003-01-03 Thread Gavin King
> it *mostly* works. The only problem seems to be > that Oracle > apparently does not distinguish between zero-length strings > and NULL, so I have run into this before with Oracle. Very yucky. > if you initialize the CLOB with Hibernate.createClob(""), the actual > database column is nullifi

RE: [Hibernate] Hibernate 2

2003-01-03 Thread Gavin King
> * Rename the 'role' attribute to 'name' in all collection > elements in the new DTD, for consistency with , >and elements. The role attribute no longer > has any extra semantics beyond being a simple property > name. Done. > * Change the default for unsaved-value to "null" in the ne

RE: [Hibernate] saving to pgsql

2003-01-03 Thread Gavin King
That "unexpected EOF" usually occurs if somehow the connection between client and database processes is broken (eg. the VM dies). What happens if you use a sequence, instead of hi/lo generation? (And remember that you can't use HiLoGenerator in an appserver) > -Original Message- > From

[Hibernate] saving to pgsql

2003-01-03 Thread cheeser
I'm having troubles getting my objects to persist. In my pgsql.err, i get error messages about "unexpected EOF on client connection." Has anyone seen this? I create the bean and call session.save() with it. When I'm done with the session, I call flush() and close() (trying to force it) and n

RE: [Hibernate] sorted collection

2003-01-03 Thread Gavin King
Sorry, thats nowhere near enough information. You should show the code that uses the Hibernate Session and also the full stack trace. A Hibernate TRACE-level log is also sometimes useful. -Original Message- From: Laurent Fleuriot [mailto:[EMAIL PROTECTED] Sent: Friday, 3 January 2003 1:5

Re[2]: [Hibernate] Length of Hibernate-generated aliases in SQL

2003-01-03 Thread Pablo I. Lalloni
Same problem on Interbase/Firebird. pil m> Could you give an hbm.xml and query example that gives that error ? (it m> would be nice to have some test scenario :) m> (especially, since it would be nice to know what one could do to avoid m> such a thing- it would also be a problem on db2 sinc

RE: [Hibernate] Getting a sorted list of results

2003-01-03 Thread Gavin King
Try something like: Query q = sess.createQuery("from h in class Headend where h.id in (:id_list) order by h.name"); q.setParameterList("id_list", headendIds); List sorted = q.list(); Note that this is might not be very good if the id List is very long... > -Original Message- > From: Raib

RE: [Hibernate] Hibernate Thread Local Session and JUnit

2003-01-03 Thread Gavin King
> The old way I was doing it - now obviously kludgy - was to > create a new session factory everytime I initialized a DAO. That would have been your problem. You *must* make sure that ALL DAOs are using the same Session instance. (And SessionFactory _should_ certainly be a singleton.) *

[Hibernate] Getting a sorted list of results

2003-01-03 Thread Raible, Matt
I am using the following method to get back a list of objects based on ids. What I would prefer is to get back a list of objects sorted by object.name. I know there's an easier way to do this with hibernate, but I can't seem to find it. // loop through the list of headend ids and get t

Re: [Hibernate] Oracle error: exceeded simultaneous SESSIONS_PER_USER limit

2003-01-03 Thread Matt Raible
I'd be interested in your code, and would love to come up with a *recommended* way to implement Hibernate in webapps. However, I prefer to keep any database connections out of my web tier. Since I only use them in my dao's that's where I prefer to use them. I also am using a Business Delegate to

RE: [Hibernate] List only returns first row, rather than both

2003-01-03 Thread Raible, Matt
I was able to "work-around" this problem by doing the following: We have a table - user_sys_access, where the primary key is the combination of userid, mso_id, and headend_id. There can be multiple rows so that you might end up with something like the following: userid mso_id headend_i