Hi all, I am trying to track down an outer join problem where I am attempting to use the outer join, but with MSSQL it fails: [junit] Could not retrieveDistributor.: SQLException initializing collection : [Microsoft][SQLServer JDBC Driver]ResultSet can not re-read row data for colum n 3. [junit] java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]ResultSet c an not re-read row data for column 3. [junit] at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown S ource) [junit] at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unk nown Source) [junit] at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Sourc e) [junit] at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Sourc e) [junit] at net.sf.hibernate.type.StringType.get(StringType.java:14) [junit] at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.j ava:59)
This is because the same column is used twice. However, according to this posting on OFBiz, the MSSQL driver is working correctly: http://www.geocrawler.com/archives/3/12465/2002/8/0/9458588/ It should throw an exception, because the column 3 is also the same column in 2: distribu1___ catalogNumber0_ catalogn2_0_ ------------ ---------------- ---------------- 1 01-101 01-101 2 01-102 01-102 3 01-106 01-106 According to the ofbix site, it seems that we should just eat the exception. However, really, it seems like hibernate should just use the column once, versus including it twice in the SQL. If I wanted to persue this, where would I start looking? Eric ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel