db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Markus Fuchs (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1501) PreparedStatement#setNull(int parameterIndex, int sqlType) throws SQL Exception if given sqlType is LONGVARBINARY in embedded mode
Date Tue, 11 Jul 2006 19:50:29 GMT
PreparedStatement#setNull(int parameterIndex, int sqlType) throws SQL Exception if given sqlType
is LONGVARBINARY in embedded mode
----------------------------------------------------------------------------------------------------------------------------------

         Key: DERBY-1501
         URL: http://issues.apache.org/jira/browse/DERBY-1501
     Project: Derby
        Type: Bug

    Versions: 10.1.1.0    
 Environment: WindowsXP
    Reporter: Markus Fuchs


When inserting a row into following table

BYTEARRAY_TEST( ID int, BYTEARRAY_VAL blob)

PreparedStatement#setNull(int parameterIndex, int sqlType) throws SQL Exception if given sqlType
is LONGVARBINARY. You must give sqlType BLOB to make the insert work. The same test works
using sqlType LONGVARBINARY in network mode. The following combinations don't work:

Column type               sqlType not working             mandatory sqlType
BLOB                           LONGVARBINARY                 BLOB
CLOB                           LONGVARCHAR                    CLOB

The issue here is that first Derby behaves differently in network and embedded mode. And secondly,
should accept LONGVARBINARY/LONGVARCHAR for BLOB/CLOB columns.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message