[Hibernate] RE : [Hibernate] livelink collections server

2006-02-09 Thread Bompart Cedric
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=kkid3432bid#0486dat1642
___
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=lnkkid3432bid#0486dat1642
___
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel


[Hibernate] RE : [Hibernate] livelink collections server

2006-02-08 Thread Bompart Cedric
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=kkid3432bid#0486dat1642
___
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=lnkkid3432bid#0486dat1642
___
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel


RE: [Hibernate] livelink collections server

2006-02-08 Thread Steve Ebersole
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=kkid3432bid#0486dat1642
___
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=lnkkid3432bid#0486dat1642
___
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel


RE: [Hibernate] livelink collections server

2006-01-24 Thread Steve Ebersole
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=kkid3432bid#0486dat1642
___
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=lnkkid3432bid#0486dat1642
___
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel