[Hibernate] RE : [Hibernate] livelink collections server
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
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
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
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