Hi, Recently, I started to Hibernate at work after playing with it @ home on and off for more than 6 months. At home, I use MySQL but at work, we use Sybase 11.92.
I ran into a huge problem with "OUTER" join syntax generation when using Sybase 11 - b/c it does not support ANSI/92 syntax. I was able to hack and created "SybaseJoinFragement" based on OracleJoinFragment. It uses Sybase's TransSQL outer join syntax 'WHERE a.id *= b.id' but I did not bother to implement FULL OUTER JOIN b/c Sybase 11 does not support them. I could have changed it using "UNION" but it would have SybaseJoinFragment very complicated [ well - i don't know if this would be possible b/c I need to have basically two SQL statements joined by 'UNION' ] So my question is do when does Hibernate use "FULL" join. If it is not used any meaningful way, I would like to continue to use my hacked version of Hibernate. Thanks in advance CREDIT | FIRST SUISSE | BOSTON Michael J. Lee Securities IT - FI Prime Broker 11 Madison Avenue, 4th Floor New York, NY 10010 E-mail: [EMAIL PROTECTED] Phone: (212) 325-7633 ============================================================================== This message is for the sole use of the intended recipient. If you received this message in error please delete it and notify us. If this message was misdirected, CSFB does not waive any confidentiality or privilege. CSFB retains and monitors electronic communications sent through its network. Instructions transmitted over this system are not binding on CSFB until they are confirmed by us. Message transmission is not guaranteed to be secure. ============================================================================== ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
