hibernate-devel — development

[Hibernate] [ hibernate-Bugs-662501 ] Length af aliases too long

[SourceForge.net <no...@so...>]

Bugs item #662501, was opened at 2003-01-04 23:35
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=428708&aid=662501&group_id=40712

Category: None
Group: None
Status: Open
Resolution: None
>Priority: 7
Submitted By: Mark Woon (unkyaku)
Assigned to: Nobody/Anonymous (nobody)
Summary: Length af aliases too long

Initial Comment:
Does Hibernate doesn't do any checking on the length of
the aliases it generates when it creates it's SQL
statements, which causes problems.

I've went ahead and created a patch against Hibernate1
that resolves this problem.  I've moved all the code
for figuring out the proper length of the alias to
StringHelper.suffix().  This eliminated
OuterJoinLoader.aliasColumn(),
OuterJoinLoader.aliasCore(), and
AbstractEntityPersister.aliasColumn(), which you'd
marked as needing to be refactored anyway.  The patch
also cleans up some unused variables in the affected
classes, and adds a bit more information to an
exception thrown in ReflectHelper.

We might also want to do the same thing for table
names, which is handled as a special case in
OuterJoinLoader.alias(), where the length is reduced to
5.  In either case, I didn't bother to make the max
length of column names configurable dependent on
Dialect.  I just cut it to 20 if it was greater than
20.  Anyone know if there are db's out there whose max
length for column names is less than 20?

-Mark


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=428708&aid=662501&group_id=40712

[Hibernate] [ hibernate-Bugs-662501 ] Length af aliases too long

[SourceForge.net <no...@so...>]

Bugs item #662501, was opened at 2003-01-04 23:35
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=428708&aid=662501&group_id=40712

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Mark Woon (unkyaku)
Assigned to: Nobody/Anonymous (nobody)
Summary: Length af aliases too long

Initial Comment:
Does Hibernate doesn't do any checking on the length of
the aliases it generates when it creates it's SQL
statements, which causes problems.

I've went ahead and created a patch against Hibernate1
that resolves this problem.  I've moved all the code
for figuring out the proper length of the alias to
StringHelper.suffix().  This eliminated
OuterJoinLoader.aliasColumn(),
OuterJoinLoader.aliasCore(), and
AbstractEntityPersister.aliasColumn(), which you'd
marked as needing to be refactored anyway.  The patch
also cleans up some unused variables in the affected
classes, and adds a bit more information to an
exception thrown in ReflectHelper.

We might also want to do the same thing for table
names, which is handled as a special case in
OuterJoinLoader.alias(), where the length is reduced to
5.  In either case, I didn't bother to make the max
length of column names configurable dependent on
Dialect.  I just cut it to 20 if it was greater than
20.  Anyone know if there are db's out there whose max
length for column names is less than 20?

-Mark


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=428708&aid=662501&group_id=40712

[Hibernate] [ hibernate-Patches-661750 ] Table.uniqueColumnString

[SourceForge.net <no...@so...>]

Patches item #661750, was opened at 2003-01-04 04:56
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=428710&aid=661750&group_id=40712

Category: None
Group: None
>Status: Closed
>Resolution: Rejected
Priority: 5
Submitted By: Benoit Menendez (bmenendez)
Assigned to: Nobody/Anonymous (nobody)
Summary: Table.uniqueColumnString

Initial Comment:
Would it be more appropriate to do:

public String uniqueColumnString(Iterator iterator) {
        int result = name.hashCode();
        while ( iterator.hasNext() ) result += iterator.next
().hashCode();
        return Integer.toHexString(result).toUpperCase();
}

instead of

public String uniqueColumnString(Iterator iterator) {
        int result = 0;
        while ( iterator.hasNext() ) result += iterator.next
().hashCode();
        return ( Integer.toHexString( name.hashCode() ) + 
Integer.toHexString(result) ).toUpperCase();
}

This would generate shorter names

----------------------------------------------------------------------

>Comment By: Gavin King (oneovthafew)
Date: 2003-01-05 11:58

Message:
Logged In: YES 
user_id=384580

I'd rather *not* change this now, since people are already
using the existing name generation. It destroys the whole
point of having consistent name generation if we keep
changing the algorithm underneath them ;)

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=428710&aid=661750&group_id=40712

[Hibernate] [ hibernate-Patches-661753 ] Could you please add...

[SourceForge.net <no...@so...>]

Patches item #661753, was opened at 2003-01-04 05:03
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=428710&aid=661753&group_id=40712

Category: None
Group: None
Status: Open
>Resolution: Postponed
Priority: 5
Submitted By: Benoit Menendez (bmenendez)
Assigned to: Nobody/Anonymous (nobody)
Summary: Could you please add...

Initial Comment:
The readonly attribute to the map element in the DTD. 
This is necessary for bidirectional map. Thanks.

  <!ATTLIST map readonly (true|false) "false">


----------------------------------------------------------------------

>Comment By: Gavin King (oneovthafew)
Date: 2003-01-05 11:56

Message:
Logged In: YES 
user_id=384580

This was already added to hibernate-mapping-2.0.dtd.

If you want to add it to your local copy of
hibernate-mapping-1.1.dtd, its perfectly safe to do so.....

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=428710&aid=661753&group_id=40712

[Hibernate] [ hibernate-Patches-662319 ] Codegen for Hibernate 2 - beta

[SourceForge.net <no...@so...>]

Patches item #662319, was opened at 2003-01-04 21:15
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=428710&aid=662319&group_id=40712

Category: Codegen
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Max R. Andersen (maxcsaucdk)
Assigned to: Nobody/Anonymous (nobody)
Summary: Codegen for Hibernate 2  - beta

Initial Comment:
Hi!




Here is my 98% complete patch for Hibernate 2.0's new 
and improved codegenerator :) I'm submitting this one 
know in hope that someone might test it and see if they 
like the new functionallity. Remember to use the 
hibernate-2.0.dtd and Hibernate2 CVS






Things that are new:


- <meta> tag support.




Look at http://hibernate.bluemars.net/57.html for 
examples of meta tag usage.




Currently class, subclass, id and property is allowed to 
have <meta> tags. As soon as I get to it i'll add support 
for it in the DTD for composite-id, version, timestamp, all 
the collection types (any others ?)




Thing that I have changed/fixed:




- fixed timestamp support.


  It assumed timestamp could support an type via the 
DTD. It could not. Now it uses java.util.Data as it's 
default - is this the correct thing to do ? (maybe we 
should add an type to timestamp in DTD ?)




- Uses logging instead of directly to System.out/err  (I've 
modified log4j.properties to have a console-friendly 
output of the tool logging)




### log for tools output, more console userfriendly. 
(purely optional)


log4j.appender.toolout=org.apache.log4j.ConsoleAppender


log4j.appender.toolout.Target=System.out


log4j.appender.toolout.layout=org.apache.log4j.PatternLa
yout


log4j.appender.toolout.layout.ConversionPattern=%p - 
%m%n




log4j.logger.net.sf.hibernate.tool=debug, toolout


log4j.additivity.net.sf.hibernate.tool=false




----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=428710&aid=662319&group_id=40712

[Hibernate] [Hibernate2] <meta> tag in hbm2java

[Max R. A. <ma...@eo...>]

I've just submitted a patch for hbm2java (the codegenerator) .... are anyone
willing to take it for a testdrive ? :)

The newsworthy stuff can be seen at http://hibernate.bluemars.net/57.html

Look at TestMeta.hbm.xml and the other hbm.xml files in the tool.test
package for inspiration :)

/max

Re: [Hibernate] wiki ... creating tables ?

[Max R. A. <ma...@eo...>]

bummer - guess i'll have to refresh my ascii-arts lessons :)

/max

----- Original Message -----
From: "Christian Bauer" <chr...@bl...>
To: <hib...@li...>
Sent: Saturday, January 04, 2003 6:03 PM
Subject: Re: [Hibernate] wiki ... creating tables ?


> On 04 Jan (16:14), Max Rydahl Andersen wrote:
>
> > Is it possible to create any form of tables in the wiki ?
> > Can't seem to use standard wiki syntax ( | col 1 | col 2 | ) nor html
table
> > syntax ;(
> >
> > Im writing on the docs for hbm2java, and I need a table :)
>
> Sorry, there's currently no support for tables in coWiki.
>
> --
> Christian Bauer
> tu...@in...
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> hibernate-devel mailing list
> hib...@li...
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel
>

Re: [Hibernate] wiki ... creating tables ?

[Christian B. <chr...@bl...>]

On 04 Jan (16:14), Max Rydahl Andersen wrote:

> Is it possible to create any form of tables in the wiki ?
> Can't seem to use standard wiki syntax ( | col 1 | col 2 | ) nor html table
> syntax ;(
> 
> Im writing on the docs for hbm2java, and I need a table :)

Sorry, there's currently no support for tables in coWiki.

-- 
Christian Bauer
tu...@in...

[Hibernate] wiki ... creating tables ?

[Max R. A. <ma...@eo...>]

Hi!

Is it possible to create any form of tables in the wiki ?
Can't seem to use standard wiki syntax ( | col 1 | col 2 | ) nor html table
syntax ;(

Im writing on the docs for hbm2java, and I need a table :)

/max

Re: [Hibernate] Improving schemas support

[Christian M. <vc...@cl...>]

I am not sure it's that simple ;)

Using a setProperty method, you will globally set a property that all
session will got. I need to locally to a session specify on which schema i
wish to work by default. Using your method, all threads at a given time work
on the same schema, this is of course not a desired behaviour.

Regards
Chris

----- Original Message -----
From: "One Ovthafew" <1ov...@mb...>
To: <hib...@li...>
Sent: Saturday, January 04, 2003 3:53 PM
Subject: Re: [Hibernate] Improving schemas support


> Set the property
>
> hibernate.default_schema
>
> :)
>
> ---------------------------------------------------------------------
> Would you like to receive faxes to your personal email address?
> You can with mBox.  Visit http://www.mbox.com.au/fax
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> hibernate-devel mailing list
> hib...@li...
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel
>
>

Re: [Hibernate] Improving schemas support

[One O. <1ov...@mb...>]

Set the property

hibernate.default_schema

:)

---------------------------------------------------------------------
Would you like to receive faxes to your personal email address?
You can with mBox.  Visit http://www.mbox.com.au/fax

Re: [Hibernate] tabs?

[One O. <1ov...@mb...>]

> "beautiful, shiny, happy TABS!" - are you on drugs or something :)

You want some?

> Just wanted to know if I have to enable "Use tabs for indention" in my
> editors from now on when im editing hibernate ?

Not necessarily; I also checked a little indent.py script that will
enforce my drug-induced code formatting preferences.....

It was actually getting *really* out of hand having a mixture of tab,
3-space and 4-space indent styles. I had to do something. Spent hours
experimenting with Jalopy and prettyprinter before I decided I could do
it in half an hour with a script...

> (I thought TABS was considered harmfull in code on the same level as
GOTO's
> are :)

Its wierd; this may actually be a regional thing. I have never actually
worked on any project where space-indenting was used. I've only ever
come across it in open source projects. 

Anyway its quite obviously an insane convention ;) .... 4 keystrokes
instead of 1? Inability to adjust indent size to suit reader preference?
The only thing it has going for it is that certain jurassic-age editors
weren't able to adjust tab-stops. I have never once run into this issue
in real life.

:)


---------------------------------------------------------------------
Would you like to receive faxes to your personal email address?
You can with mBox.  Visit http://www.mbox.com.au/fax

[Hibernate] Improving schemas support

[Christian M. <vc...@cl...>]

CarrierWaveHi all,

now that postgresql support schemas, i would like to leverage this in my =
next project.In this project, i will have 1 to N schema(s) having the =
exactly same table names. What i would like to do it to be able to =
specify at runtime, once i open a hibernate session the schema name on =
which i would like to work. Such mutator could temporarly update ( for =
the duration of the session) the schema name specified by the root =
<hibernate-mapping> element.

It might be usefull too, to find a way to specify a schema name in the =
query language (if we want to be able to do a query working on more than =
one schema at a time that got the same table names)

What do you think about this ? Is hibernate already support what i would =
like to do ?

Thanks in advance and happy new year everyone.
Christian Meunier

[Hibernate] tabs?

[Max R. A. <ma...@eo...>]

Hi Gavin :)

"beautiful, shiny, happy TABS!" - are you on drugs or something :)
Just wanted to know if I have to enable "Use tabs for indention" in my
editors from now on when im editing hibernate ?
(I thought TABS was considered harmfull in code on the same level as GOTO's
are :)

/max

[Hibernate] RE: Setting autocommit=false [SOLVED]

[Matt R. <ma...@ra...>]

Nevermind - I figured it out.  I needed to add the following in Tomcat's
DBCP configuration:

        <!-- Autocommit setting -->
        <parameter>
            <name>defaultAutoCommit</name>
            <value>false</value>
        </parameter>

Thanks,

Matt

>  -----Original Message-----
> From: 	Matt Raible [mailto:ma...@ra...] 
> Sent:	Saturday, January 04, 2003 3:07 AM
> To:	'hib...@li...'
> Subject:	Setting autocommit=false
> 
> I am setting up JNDI in Tomcat and using Hibernate to get 
> this connection and do persistence appropriately.  All this 
> worked fine on Oracle, but with MySQL, I'm getting the following:
> 
> java.sql.SQLException: Can't call commit when autocommit=true
>         at org.gjt.mm.mysql.Connection.commit(Unknown Source)
>         at 
> org.apache.commons.dbcp.DelegatingConnection.commit(Delegating
> Connection.java:219)
>         at 
> org.appfuse.persistence.UserDAOHibernate.getUser(UserDAOHibern
> ate.java:58)
> 
> So, my question is, how do I turn off autocommit?  Can I do 
> it based on the URL for my Resource definition in Tomcat, such that:
> 
> jdbc:mysql://localhost:3306/appfuse?autoReconnect=true&amp;aut
> oCommit=false
> 
> This doesn't seem to work - is there a hibernate 
> setting/property I can change?
> 
> Thanks,
> 
> Matt
> 

[Hibernate] Setting autocommit=false

[Matt R. <ma...@ra...>]

I am setting up JNDI in Tomcat and using Hibernate to get this
connection and do persistence appropriately.  All this worked fine on
Oracle, but with MySQL, I'm getting the following:

java.sql.SQLException: Can't call commit when autocommit=true
        at org.gjt.mm.mysql.Connection.commit(Unknown Source)
        at
org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection
.java:219)
        at
org.appfuse.persistence.UserDAOHibernate.getUser(UserDAOHibernate.java:5
8)

So, my question is, how do I turn off autocommit?  Can I do it based on
the URL for my Resource definition in Tomcat, such that:

jdbc:mysql://localhost:3306/appfuse?autoReconnect=true&autoCommit=fa
lse

This doesn't seem to work - is there a hibernate setting/property I can
change?

Thanks,

Matt

RE: [Hibernate] Middlegen and XDoclet marriage

[Matt R. <ma...@ra...>]

Personally, I would say "give me anything I can run from Ant" and I'll
be a Happy Camper.  Allow me to run it from Maven and I'll be tickled
pink - as soon as I get the time to truly grok maven.

Matt

> -----Original Message-----
> From: hib...@li... 
> [mailto:hib...@li...] On 
> Behalf Of Max Rydahl Andersen
> Sent: Friday, January 03, 2003 1:32 PM
> To: hib...@li...
> Subject: Re: [Hibernate] Middlegen and XDoclet marriage
> 
> 
> ----- Original Message -----
> From: "Aslak Hellesoy" <asl...@ne...>
> To: "One Ovthafew" <1ov...@mb...>; 
> <hib...@li...>
> Sent: Friday, January 03, 2003 6:10 PM
> Subject: RE: [Hibernate] Middlegen and XDoclet marriage
> 
> 
> >
> > >        >>>>>>>XDoclet>>>>>>    >>>SchemaExport>>>>
> > > java + @tags             hbm.xml             SQL DDL
> > >        <<<CodeGenerator<<<<    <<<<<Middlegen<<<<<
> > >
> >
> > Oh, the beauty!
> 
> Before I saw Gavin's beautifull drawing I also viewed both 
> approaches as legitimate. But I wanted BOTH possibilities, 
> because of two things:
> 
> 1. I like the codegenerator and the hbm.xml -> java approach
> 2. I like XDoclet and saw the ability to provide an 
> java+@tags approach for the beginner and intermediate user 
> would be GREAT :)
> 
> But with the beautifuly drawing I saw symmetry (which is good 
> :) The only real "issue" is that if you are doing 
> Middlegen->hbm.xml->java@tags with the purpose of using the 
> java@tags version to do java@tags->hbm.xml, then it seems 
> rather "redundant"....
> 
> but then again, the XDoclet generation in the code generator 
> would ofcourse be optional....hey, i got to think....with my 
> local version of hbm2java (which the codegenerator is called 
> now :) we got the <meta attribute="description"></meta>, 
> which is an ideal place for MiddleGen to place it's 
> "additional" XDoclet tags...if that is in any way advantageous...
> 
> /max
> 
> >
> > >
> > > The the only leg of the roundtripping that is not
> > > fully reproduceable without user interaction is the
> > > DDL -> hbm.xml (ie. Middlegen) step.
> > >
> >
> > Middlegen can indeed be run without user interaction. Just say 
> > gui="false" to the middlegen task. If you run it without 
> the gui, it 
> > will use defaults or look at the preferences file (which 
> will exist if 
> > Middlegen has been
> run
> > previously).
> >
> > http://boss.bekk.no/boss/middlegen/ant/index.html#gui
> > http://boss.bekk.no/boss/middlegen/ant/index.html#prefsdir
> >
> > Aslak
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf 
> > _______________________________________________
> > hibernate-devel mailing list hib...@li...
> > https://lists.sourceforge.net/lists/listinfo/hibernate-devel
> >
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> hibernate-devel mailing list
> hib...@li...
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel
> 

Re: [Hibernate] Suggestion: Encapsulate SQLException in HibernateException

[Mark W. <mor...@SM...>]

One Ovthafew wrote:

>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....
>  
>

If JDBCException extended HibernateException, then I'd be +1 on this.

Fewer catch statements to write is always a good thing.  Besides, I 
think people are getting used to the idea of nested exceptions by now 
anyway.

-Mark

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

[Mark W. <mor...@SM...>]

max wrote:

> Another one is to rewrite the code that produces those aliases (and as 
> I remember - the logic are well-defined but unfortunatly not in a 
> single method).
>
> That alias generation should of course use the Dialect class which 
> would have an getMaxColumnNameLength and getMaxTableNameLength.
> If the aliases generated exceeds that amount "do something" :)
>
> Maybe we should just postfix the names with 0_ instead of prefixing 
> them with _0 (and then chop them of with the dialects max lengths..) - 
> that would
> make them unique ....and avoid name colisions (as long as the max 
> lenght is not near 3-4 chars ....)


I think you meant prefix the names with 0_ and postfixing them with 
_0...  ;)

But yeah, I think this is an extremely simple solution to the problem. 
 And I'd be more than happy to implement the fix, if I can just figure 
out which methods are actually producing the offending SQL.  I'll try 
looking at it later tonight.  I'm getting really tired of renaming my db 
columns...

-Mark

RE: [Hibernate] Getting a sorted list of results

[Matt R. <ma...@ra...>]

If I'm not using hibernate.properties (well, for Junit tests I am), but
rather hibernate.cfg.xml - can I add this property there?

I'm trying to get both ids and names so I can create a LabelValueBean
for rendering in a drop-down list on the UI.  A LabelValueBean is a
class w/in Struts, but now that I think of it, I might just be able to
use my object with the <html:options> tag.

Thanks,

Matt

> -----Original Message-----
> From: hib...@li... 
> [mailto:hib...@li...] On 
> Behalf Of One Ovthafew
> Sent: Friday, January 03, 2003 6:05 PM
> To: hib...@li...
> Subject: Re: [Hibernate] Getting a sorted list of results
> 
> 
> Add 
> 
> hibernate.query.imports=com.comcast.cable.dmc.itd.cct.persistence
> 
> to hibernate.properties
> 
> 
> P.S. Something earlier gave me the impression you were really 
> only trying to get back a list of names, rather than objects 
> sorted by name; you might want to try:
> 
> Query q = ses.createQuery(
>  "select m.name from m in class MSO where m.id in (:id_list) 
> order by upper(m.name)" ); q.setParameterList("id_list", 
> msoIds); List nameList = q.list();
> 
> 
> ---------------------------------------------------------------------
> NEW to mBox, receive faxes to any email address!
> Find out more http://www.mbox.com.au/fax
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf 
> _______________________________________________
> hibernate-devel mailing list hib...@li...
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel
> 

Re: [Hibernate] Getting a sorted list of results

[One O. <1ov...@mb...>]

Add 

hibernate.query.imports=com.comcast.cable.dmc.itd.cct.persistence

to hibernate.properties


P.S. Something earlier gave me the impression you were really only
trying to get back a list of names, rather than objects sorted by name;
you might want to try:

Query q = ses.createQuery(
 "select m.name from m in class MSO where m.id in (:id_list) order by
upper(m.name)"
);
q.setParameterList("id_list", msoIds);
List nameList = q.list();


---------------------------------------------------------------------
NEW to mBox, receive faxes to any email address!
Find out more http://www.mbox.com.au/fax

RE: [Hibernate] Getting a sorted list of results

[Raible, M. <Mat...@ca...>]

In an effort to "shorten things up" and order by name alphabetically by Name
(ignoring case), I'm doing the following:

String clazz = MSO.class.getName();
Query q = ses.createQuery("from m in class "+clazz+" where m.id in
(:id_list) order by upper(m.name)");
q.setParameterList("id_list", msoIds);

msoList = q.list();

My reasoning for using class.getName() is because of the long package name:
com.comcast.cable.dmc.itd.cct.persistence.MSO.

This seems to work great, just wanted to see if there's anything wrong with
this - or a better way to do it.

Thanks,

Matt

-----Original Message-----
From: Raible, Matt 
Sent: Friday, January 03, 2003 1:07 PM
To: 'hib...@li...'
Subject: RE: [Hibernate] Getting a sorted list of results


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.  

Matt

------------- Forwarded message -------------
> 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? 

Well, by the looks of your code, you aren't *actually* passing in a List
of Longs....it looks like you're passing instances of Headend. If you
pass a List of java.lang.Long I would expect it to work.

Alternatively you could use:

q.setParameterList(
  "id_list", 
  headends,    // a list of Headend instances
  Hibernate.association(Headend.class) // the Hibernate Type for Headend
);

Gavin

---------------------------------------------------------------------
Never lose a fax again, receive faxes to your personal email account!
Visit http://www.mbox.com.au/fax

-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
hibernate-devel mailing list
hib...@li...
https://lists.sourceforge.net/lists/listinfo/hibernate-devel

-- Matt Raible, Raible Designs, Morrison CO US
-- Tel: +1 303 979-5340
-- Mob: +1 720 560-8460
-- Fax: +1 508 256-6471
-- Web: http://www.raibledesigns.com

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

[One O. <1ov...@mb...>]

I have never seen this problem (I test with Postgres 7.3 running under
cygwin), but I imagine that it is to do with how you have configured
connection pooling. You can set

hibernate.connection.pool_size=0

to disable pooling, if you like, or try out Juozas' suggestion and use a
different pooling implementation.

I do not think this is related to Matt Raible's problem, unless you are
also opening multiple Sessions per transaction (which is a very very bad
antipattern).

Note that you can always bypass Hibernate's Connection and Transaction
handling _altogether_, if you have persistent problems....

  s = sf.openSession( getMyJDBCConnection() );
  // do some work
  s.connection().commit();
  closeMyJDBCConnection( s.close() );

That way you can be CERTAIN that Hibernate is not to blame when you see
these kinds of issues.

> 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 start-up failed: FATAL 1:  Sorry, too many clients already
> 
>         at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:306)
>         at org.postgresql.Driver.connect(Driver.java:122)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:140)
>         at
cirrus.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:81)



---------------------------------------------------------------------
NEW to mBox, receive faxes to any email address!
Find out more http://www.mbox.com.au/fax

Re: [Hibernate] Suggestion: Encapsulate SQLException in HibernateException

[One O. <1ov...@mb...>]

> Why not HibernateException extends SQLException?

Lotsa reasons .... for one, we want to be able to
use exception chaining.


If no consensus forms on this issue, then I will
stay in conservative mode and leave things as they
are.

Gavin

---------------------------------------------------------------------
NEW to mBox, receive faxes to any email address!
Find out more http://www.mbox.com.au/fax

Re: [Hibernate] ClassNotFoundException Problem with Orion with 1.2.1

[One O. <1ov...@mb...>]

As I mentioned in answer to that post, this is a
known problem on some JVMs. Either:
(1) grab a cvs update
(2) revert to 1.2 until I release 1.2.2 today
    or tomorrow



---------------------------------------------------------------------
NEW to mBox, receive faxes to any email address!
Find out more http://www.mbox.com.au/fax