You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2007/05/27 00:20:16 UTC
[jira] Commented: (DERBY-1501) PreparedStatement#setNull(int
parameterIndex, int sqlType) throws SQL Exception if given sqlType is
LONGVARBINARY in embedded mode
[ https://issues.apache.org/jira/browse/DERBY-1501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12499359 ]
Myrna van Lunteren commented on DERBY-1501:
-------------------------------------------
I don't see any particular check-in for this bug, the fix went in referring to DERBY-1610. So I'd like to remove the application impact check.
See also my recent comment re DERBY-1610.
> PreparedStatement#setNull(int parameterIndex, int sqlType) throws SQL Exception if given sqlType is LONGVARBINARY in embedded mode
> ----------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1501
> URL: https://issues.apache.org/jira/browse/DERBY-1501
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.1.1.0
> Environment: WindowsXP
> Reporter: Markus Fuchs
> Fix For: 10.3.0.0
>
> Attachments: ByteArrayTest.java
>
>
> 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.
-
You can reply to this email to add a comment to the issue online.