hi, can the following work? ” select tree from Tree as tree where lower(tree.name) like ‘%:name%’ “
i want to use a parameter there

pass the % in with setParameter
I think that works
does anybody know if hibernate supports date arithmetic?

oh thanks I did not think about that

does hibernate actually support the seconds_between function?

Hi everybody

hi!
I have some persisted object, with as a property a “bag” of other objects.. and I would like to delete something from that collection
but when I remove it from the collection, and then use the update function on that first object.. it doesn’t remove anything from the database
is there some setting I’m missing? or isn’t it supposed to work this way?

far as i have understod it right, everything in bag goes

hm.. I’m still hacking around (A)
brb.. I’ll ask again if I can’t find it

how can i perform a query like this with hibernate? (using criteria):
SELECT
team.*, COUNT(player.teamID)
FROM
team
INNER JOIN player ON player.teamID = team.ID
GROUP BY
player.teamID
i’m looking everywhere
but i have not found any example like this..

is it possible do relationship that’s both one to many and many to one?

it’s called bi-directional
and it’s possible

I’m sorry
I mean it’s Many to one and one to one
for example, many B’s can be associated with a single A, but A has a column referring only to a single B which is the “active” one

hello all !

I would consider that two separate relationsips.
One is a many-to-one, the other is a one-to-one.
hi!

yes, I agree. I’m trying to figure out how to implement it using jpa.

As long as you keep their names different, I’d imagine it’s like any other mapping.

I guess it’s two separate unidrectional relationships.
I was just confused by the use of the mappedBy attribute
let’s try removing that hehe
yes that worketh. Thanks NfNitLoop

nedankinde.

hi!
I have this problem

what’s the problem
actually hold that thought… i’m getting a drink

Hy
Hi***
I’m getting this error when trying to run hibernate annotations with entitymanager
http://rifers.org/paste/show/5349

Hey, Im trying to gain access to a legacy database (still in use, so modifying those tables are out of the question) using hibernate. The mappings are good, I can access the data, however the tables are latin1 and I am getting garbage characters out for what looks like an en/em dash… is there something I can do to the jdbc string to fix this (the database is mysql)

I have been trying to find information on this online, but haven had much success. Does anyone know if Hibernate 3.2 plays well with Glassfish?

HI, I’m trying to connect to mysql using persistence.xml hibernate implementation
This is my persistence.xml http://rafb.net/p/V4sGe338.html

dcestari, so what’s the problem?

I get EOF exception connecting to mysq
l

Does anyone know if it is possible to use Hibernate with Glassfish without using JPA/EJB 3.0?

dcestari, ii’m fairly new to hibernate but my configuration is placed id hibernate.cfg.xml

I think is more a mysql hosting problem

me to
*too

hello, i’ve got question
is it possible that lets say i’ve got class User and two classes User1 and User2 which extends User
and now i’ve got the user which can be User1 or User2

user1 and user2 are different table right?

yes but they have the same id
loaded object was of wrong class class
myUser is in table User1 and User2 whith the same id and Hibernate doesnt know which one select
umyUser is in table User1 and User2 whith the same id and Hibernate doesnt know which one select/u