[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-447) SAPDB hangs with big strings.

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Gavin King
    Created: Mon, 3 Nov 2003 2:53 AM
       Body:
Ah ... if you can find some kind of "official" doco or statement that there is a limited max size to SAPDB varchars, I will change ... otherwise just keep working with a customized Dialect (can't you just subclass the built-in Dialect?)
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-447


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-447
    Summary: SAPDB hangs with big strings.
       Type: Bug

     Status: Unassigned
   Priority: Minor

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.2

   Assignee: 
   Reporter: the_Ellessar

    Created: Mon, 3 Nov 2003 2:44 AM
    Updated: Mon, 3 Nov 2003 2:44 AM
Environment: Sapdb 7.4, Linux red hat 9

Description:
I'm having a problem with SapDB and long strings. It is probably a bug in SapDB (driver) but I made an easy fix in the sapdb dialect. 

According to the SapDB documentation it is possible to put dat with a length 8k in a VARCHAR field, but when I define a string with length bigger than 1024 SapDB becomes REAL slow. 

As far as I know the clob type doesn't work very well with the SAP JDBC driver.

So I created the next patch:

Index: SAPDBDialect.java
===================================================================
RCS file: /cvsroot/hibernate/Hibernate2/src/net/sf/hibernate/dialect/SAPDBDialect.java,v
retrieving revision 1.12
diff -u -r1.12 SAPDBDialect.java
--- SAPDBDialect.java	30 Jul 2003 02:53:06 -0000	1.12
+++ SAPDBDialect.java	3 Nov 2003 08:43:48 -0000
@@ -25,7 +25,8 @@
 		register( Types.TINYINT, "FIXED(3,0)" );
 		register( Types.INTEGER, "INT" );
 		register( Types.CHAR, "CHAR(1)" );
-		register( Types.VARCHAR, "VARCHAR($l)" );
+		register( Types.VARCHAR, 512, "VARCHAR($l)" );
+		register( Types.VARCHAR, "LONG VARCHAR" );
 		register( Types.FLOAT, "FLOAT" );
 		register( Types.DOUBLE, "DOUBLE PRECISION" );
 		register( Types.DATE, "DATE" );



---------------------------------------------------------------------
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