select tb2.* from tb1, tb2 where tb1.id = tb2.idtb1 and tb1.id = 2
idtb1 is a multiple value field which contains multiple id from tb1
the reverse query (the other side of the relasionship) will be:
select tb1.* from tb1, tb2 where tb2.id = 5 and tb2.idtb1 = tb1.id
in term of sql query there is no difference between 1 to n and n to n
relasionship, the database engine will do a join on a multiple value field
automatically...
Regards,
Ced.
-------- Message d'origine--------
De: Steve Ebersole [mailto:[EMAIL PROTECTED]
Date: mer. 08.02.2006 17:29
À: Bompart Cedric; hibernate-devel@lists.sourceforge.net
Cc:
Objet: RE: [Hibernate] livelink collections server
What does the SQL look like to access this?
-----Original Message-----
From: Bompart Cedric [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 08, 2006 3:40 AM
To: Steve Ebersole; hibernate-devel@lists.sourceforge.net
Subject: RE : [Hibernate] livelink collections server
Hello,
The livelink product handles n to n relationship without intermediate
table but with a field with multiple values. Is it possible to instruct
Hibernate to comply to this? if so how do I do it? via the dialect?
Regards,
Ced.
-------- Message d'origine--------
De: Steve Ebersole [mailto:[EMAIL PROTECTED]
Date: mar. 24.01.2006 17:58
À: Bompart Cedric; hibernate-devel@lists.sourceforge.net
Cc:
Objet: RE: [Hibernate] livelink collections server
A custom Dialect should be enough, although you may need to
appropriately set some configuration properties as well...
The best thing to do is to simply try running the Hibernate
test suite
using your custom dialect; that'll give you an idea of what
type/level
of SQL support Hibernate is expecting that this particular
database
may/may not provide.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Bompart Cedric
Sent: Tuesday, January 24, 2006 3:56 AM
To: hibernate-devel@lists.sourceforge.net
Subject: [Hibernate] livelink collections server
Hello,
I'm just wondering what do I need to do to support another
database
vendor with Hibernate 3.1 ?
The database is LiveLink Collections Server from OpenText (known
previously as Basis) and they provide a JDBC driver.
So far I've seen that I need to write a new implementation of
"org.hibernate.dialect.Dialect" and what else ? any
documentation
related to that subject ? or anything to look at will be
nice... :-)
Regards,
Ced.
--
M. Cedric Bompart
J2EE Architect
THALES Suisse SA
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep
through log
files
for problems? Stop! Download the new AJAX search engine that
makes
searching your log files as easy as surfing the web. DOWNLOAD
SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=k&kid3432&bid#0486&dat1642
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
