db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tomohito Nakayama (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1610) Engine take it as type compatibility error to update column typed as CHAR to value passed via setBinaryStream(null), though Network Client and Network Server does not take it as error.
Date Sun, 30 Jul 2006 07:27:14 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1610?page=all ]

Tomohito Nakayama updated DERBY-1610:
-------------------------------------

    Attachment: TestNullChar.java

Result of the execution is as next :

In the case of Network Client/Server :
naka@rufelza:~/derby/test/20060730$ java TestNullChar
streamAsNull:
null
setNull:
null

In the case of Engine :
naka@rufelza:~/derby/test/20060730$ java TestNullChar embedded
streamAsNull:
java.sql.SQLException: An attempt was made to get a data value of type 'CHAR' from a data
value of type 'java.io.InputStream'.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:44)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:88)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:94)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:180)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java:1958)
	at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(ConnectionChild.java:153)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.dataTypeConversion(EmbedPreparedStatement.java:1611)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.checkBinaryStreamConditions(EmbedPreparedStatement.java:923)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setBinaryStream(EmbedPreparedStatement.java:839)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setBinaryStream(EmbedPreparedStatement.java:853)
	at TestNullChar.updateStreamAsNull(TestNullChar.java:118)
	at TestNullChar.main(TestNullChar.java:46)
java.sql.SQLException: Invalid cursor state - no current row.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:44)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:88)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:104)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:168)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java:1952)
	at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(ConnectionChild.java:147)
	at org.apache.derby.impl.jdbc.EmbedResultSet.checkOnRow(EmbedResultSet.java:325)
	at org.apache.derby.impl.jdbc.EmbedResultSet.getColumn(EmbedResultSet.java:4378)
	at org.apache.derby.impl.jdbc.EmbedResultSet.getString(EmbedResultSet.java:680)
	at TestNullChar.updateStreamAsNull(TestNullChar.java:139)
	at TestNullChar.main(TestNullChar.java:46)
setNull:
null

> Engine take it as type compatibility error to update column typed as CHAR to value passed
via setBinaryStream(null), though Network Client and Network Server does not take it as error.
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1610
>                 URL: http://issues.apache.org/jira/browse/DERBY-1610
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Server, Network Client
>            Reporter: Tomohito Nakayama
>         Assigned To: Tomohito Nakayama
>         Attachments: TestNullChar.java
>
>
> There exists difference between Engine and Network Client/Engine around type compatibility
judgement in character typed column when null value was passed as InputStream.

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