On Wed, 2 Feb 2005 18:03:56 +0100 (CET), Pedro Abelleira Seco <[EMAIL PROTECTED]> wrote:

Please put this patch in JIRA with
failing test case otherwise we can't test if it works ;)

-max

Hi,

I got weird errors with hibernate (2.1.8) using it to
access SQL Server 2000 with the jTDS driver (1.0). It
complained about a FORWARD_ONLY resultset. The weird
thing was that my app was running perfectly until I
changed a varchar field to nvarchar and the errors
seemed quite random.

After playing around a bit it turned out that jtds
tried in the first place to get a cursor, failing down
to use a custom resultset if that was not possible,
and this recordset is of type FORWARD_ONLY. So,
depending of the actual results you get, the same
query can throw an exception or not.

The patch makes the Loader check the actual type of
the resultset, besides checking the requested size.

Although each jdbc driver has its own implementation
of the getType() method I think is safe to assume that
it is lightweight enough so as no to incur in
performance penalty.

Regards,
Pedro


______________________________________________ Renovamos el Correo Yahoo!: ˇ250 MB GRATIS! Nuevos servicios, más seguridad http://correo.yahoo.es



-- Max Rydahl Andersen callto://max.rydahl.andersen

Hibernate
[EMAIL PROTECTED]
http://hibernate.org

JBoss Inc
[EMAIL PROTECTED]
http://jboss.com


------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel

Reply via email to