Umm this problem is not occurring in the test suite.
would you mind putting together something very simple to help reproduce it?
thanks!
|---------+------------------------------------------->
| | "Eric Pugh" <[EMAIL PROTECTED]> |
| | Sent by: |
| | [EMAIL PROTECTED]|
| | ceforge.net |
| | |
| | |
| | 11/08/03 07:47 PM |
| | Please respond to epugh |
| | |
|---------+------------------------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: [Hibernate] Bug in Hibernate maybe? Not is MSSQL?
|
>------------------------------------------------------------------------------------------------------------------------------|
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
**********************************************************************
Any personal or sensitive information contained in this email and
attachments must be handled in accordance with the Victorian Information
Privacy Act 2000, the Health Records Act 2001 or the Privacy Act 1988
(Commonwealth), as applicable.
This email, including all attachments, is confidential. If you are not the
intended recipient, you must not disclose, distribute, copy or use the
information contained in this email or attachments. Any confidentiality or
privilege is not waived or lost because this email has been sent to you in
error. If you have received it in error, please let us know by reply
email, delete it from your system and destroy any copies.
**********************************************************************
-------------------------------------------------------
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
