Menu
▾
▴
hibernate-issues
|
From: <leg...@at...> - 2003-11-20 18:28:40
|
The following comment has been added to this issue:
Author: Benoit Menendez
Created: Thu, 20 Nov 2003 12:27 PM
Body:
I hit enter a little too soon... sorry...
This problem shows up with the latest SP2 Microsoft SQL Server driver
The problem query generated by Hibernate is:
2003-11-20 09:57:48,827 INFO [STDOUT] Hibernate: select kms_vers0_.id as id__, kms_vers0_.DOCUMENT_ID as DOCUMEN10___, kms_vers0_.id as id0_, kms_vers0_.name as name0_, kms_vers0_.description as descript3_0_, kms_vers0_.CREATED_BY as CREATED_BY0_, kms_vers0_.CREATION_TIME as CREATION5_0_, kms_vers0_.MODIFIED_BY as MODIFIED6_0_, kms_vers0_.MODIFICATION_TIME as MODIFICA7_0_, kms_vers0_.MIME_TYPE as MIME_TYPE0_, kms_vers0_.content as content0_, kms_vers0_.DOCUMENT_ID as DOCUMEN10_0_ from KMS_VERSION kms_vers0_ where kms_vers0_.DOCUMENT_ID=?
The version I use is 21beta6
details in the attached file
Thanks
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Thu, 20 Nov 2003 12:27 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-11-21 01:42:24
|
The following comment has been added to this issue:
Author: Gavin King
Created: Thu, 20 Nov 2003 7:41 PM
Body:
Ummmmm .... what exactly is the problem here? You are using a buggy driver?
The generated SQL is correct, right?
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Thu, 20 Nov 2003 7:41 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-11-21 02:05:24
|
The following comment has been added to this issue:
Author: Benoit Menendez
Created: Thu, 20 Nov 2003 8:05 PM
Body:
It appears from tracing the problem that Hibernate reads the columns out of order, for example reading the first column, the second, the third then the second column again which is not supported by this particular driver.
The SQL is perfectly fine, but Hibernate ends up reading the DOCUMENT_ID (second) column again after having read the entire record.
Again this is speculation.
This is the latest Microsoft SQL driver and look very good otherwise and only this particular construct I am using with file documents and versions (see file) causes this problem to occur.
I am building a proxy for ResultSet that will work around this problem (and Blob issues as well)
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Thu, 20 Nov 2003 8:05 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-11-21 18:44:25
|
The following comment has been added to this issue:
Author: Benoit Menendez
Created: Fri, 21 Nov 2003 12:44 PM
Body:
I have added a ResultSet proxy which buffers the column values and it now works, so this is definitely an issue with reading columns out of sequence.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Fri, 21 Nov 2003 12:44 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-11-21 19:48:24
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Fri, 21 Nov 2003 1:47 PM
Body:
If you can find the line in the JDBC spec that says a column may only be read in order - then please point me to it !? For me this looks like a faulty driver!
Text from related sites about the issue:
"
2) Using JDBC-ODBC into SQL Server, I cannot access the
ResultSet fields out of order. Will this be corrected?
...
when i posted this to JSP-Interest, they said that the fact you
can't access results out of order is a well-known bug. I asked
a sun engineer if they would correct that with JDBC 3, and he
said it was a problem with ODBC, not JDBC."
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Fri, 21 Nov 2003 1:47 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-11-21 19:57:24
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Fri, 21 Nov 2003 1:56 PM
Body:
hmm....the following is from the ResultSet JavaDoc:
"Columns are numbered from 1. For maximum portability, result set columns within each row should be read in left-to-right order, and each column should be read only once."
So, insanly stupid driver implementations could refrain from supporting accessing this data twice - sick!
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Fri, 21 Nov 2003 1:56 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-11-24 13:04:25
|
The following comment has been added to this issue:
Author: Gavin King
Created: Mon, 24 Nov 2003 7:03 AM
Body:
I am not inclined to "fix" this. Any driver which cannot handle random access to result set columns is likely of such low quality that no-one can use it for serious work anyway. We don't want to do tech support for drivers like this.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Mon, 24 Nov 2003 7:03 AM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-11-24 17:16:30
|
The following comment has been added to this issue:
Author: Benoit Menendez
Created: Mon, 24 Nov 2003 11:16 AM
Body:
I understand. I have added a Connection/Statement/Resultset proxy layer in which I implemented row buffering and Blob conversion. Everything works fine this way.
This restriction used to be current in the old days of ODBC/JDBC. I will post a message on the Microsoft support forum.
Thanks,
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Mon, 24 Nov 2003 11:16 AM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-11-24 19:08:25
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Mon, 24 Nov 2003 1:07 PM
Body:
so just to verify:
Your problem is NOT with the ODBC/JDBC bridge ?
The problem occurs with a JDBC driver type 4 - pure java, right?!
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Mon, 24 Nov 2003 1:07 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-11-24 19:26:26
|
The following comment has been added to this issue:
Author: Benoit Menendez
Created: Mon, 24 Nov 2003 1:25 PM
Body:
You are correct, I am using the latest SP2 version of the Microsoft JDBC driver (pure Java)...
I was just saying that many early ODBC and JDBC drivers has this problem of sequencial column access...
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Mon, 24 Nov 2003 1:25 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-11-24 20:01:25
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Mon, 24 Nov 2003 2:00 PM
Body:
yes - just wanted to be sure I did not misunderstood you ;)
Nice to know wher the problems are if other users have problems.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Mon, 24 Nov 2003 2:00 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-11-25 21:38:25
|
The following comment has been added to this issue:
Author: Benoit Menendez
Created: Tue, 25 Nov 2003 3:38 PM
Body:
Response from Microsoft
The driver supports random column access except in the case of long data,
like image columns. The following article describes the error that you
typically see when you try to retrieve binary data out of order:
PRB: "ResultSet Can Not Re-Read Row Data"' Error When Reading Data from a
JDBC ResultSet Object
ID: 824106
http://support.microsoft.com/?id=824106
If this is what you are running into, it is by design for the driver. For
performance reasons, we do not cache binary data to allow re-reads.
Regarding the true Blob support, SQL Server itself does not support Array
types or SQL3 blob/clob types as described in the JDBC reference, so we
have no plans to support these types at this point. Any possible support
for this would come in a future version of SQL (and I don't know if this is
even planned or not), so there are no plans to include this in the driver
in the near future.
Thanks!
Sarah Parra
Microsoft Developer Support
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Tue, 25 Nov 2003 3:38 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-28 22:54:28
|
The following comment has been added to this issue:
Author: Eric Pugh
Created: Sun, 28 Dec 2003 4:53 PM
Body:
Benoit, Can you share the result set proxy that you have? I have the same problem, and am getting around it by not loading all my data in one sql statement. While debugging this problem, I found quite a few posts on the net about it. It sounds like something we should update in the wiki (http://www.hibernate.org/80.html). MS SQL's JDBC driver may be buggy, but it is very popular because it is free and from Microsoft...
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Closed
Priority: Major
Resolution: WON'T FIX
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Sun, 28 Dec 2003 4:53 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2004-02-04 18:21:54
|
The following comment has been added to this issue:
Author: Eric Pugh
Created: Wed, 4 Feb 2004 12:21 PM
Body:
Hi all,
I have taken the code the Benoit shared with me, and slightly changed it so that regardless of what type of connection you would normally want, it just wraps it and proxies all the result set stuff. I am doing more testing with our fairly large app, but it seems to really fix some performance problems that we where having by forcing multiple sql queires to avoid the reread problem.
I'd like to publish this code for others to use. There are about 6 classes that 7 classes. What do you'all think of adding it to hibernateExt as mssql-proxy?. It seems large enough that pasting a ton of wiki pages isn't the right way to go...
Eric Pugh
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Closed
Priority: Major
Resolution: WON'T FIX
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Wed, 4 Feb 2004 12:21 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2004-02-04 18:58:54
|
The following comment has been added to this issue:
Author: Gavin King
Created: Wed, 4 Feb 2004 12:58 PM
Body:
We should conduct this discussion in dev list.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Closed
Priority: Major
Resolution: WON'T FIX
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Wed, 4 Feb 2004 12:58 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2004-02-25 10:41:20
|
The following comment has been added to this issue:
Author: Eric Pugh
Created: Wed, 25 Feb 2004 4:31 AM
Body:
If you have this problem, here is the solution: http://msjdbcproxy.sourceforge.net
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Closed
Priority: Major
Resolution: WON'T FIX
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Wed, 25 Feb 2004 4:31 AM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X