From derby-user-return-13632-apmail-db-derby-user-archive=db.apache.org@db.apache.org Thu May 26 22:38:17 2011 Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E5FBA6E12 for ; Thu, 26 May 2011 22:38:17 +0000 (UTC) Received: (qmail 6499 invoked by uid 500); 26 May 2011 22:38:17 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 6473 invoked by uid 500); 26 May 2011 22:38:17 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 6466 invoked by uid 99); 26 May 2011 22:38:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 May 2011 22:38:17 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of laran.evans@gmail.com designates 209.85.212.171 as permitted sender) Received: from [209.85.212.171] (HELO mail-px0-f171.google.com) (209.85.212.171) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 May 2011 22:38:11 +0000 Received: by pxi7 with SMTP id 7so1077919pxi.16 for ; Thu, 26 May 2011 15:37:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:date:x-google-sender-auth :message-id:subject:from:to:content-type; bh=pHsAIp6//2GwxqDCrNvh7JZkTWtgVgq6eZaQ6ZeHZug=; b=v5Rcxpmf2qpSyg0HS3/x2yRWguhv5Q8Wl8foX8+DPRIpdw9+pdKrCslZbq/+B+/yQm KuaOW5i1emfScXoBBK5vMAijd+SZoSDGhjkmIeqqVXgiJUIc/OkavIYtkPARtggCKJv5 IoDmdibaEXvQkS357pU6aHVSVU1HeWM979ZLA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:date:x-google-sender-auth:message-id:subject :from:to:content-type; b=ShwrCyCBWvGezw1lYoo6cVX3VxvR+b/o75twvTrRmwMNtiFmnPKD6IJAcdIch0uswK PU1B8hTbg5duYmozOprqj+ge3v+GK8tH+JT/xNW4j7JKkqaRhVrqBrDJeeWtlh98nqPx DjYDyJASE7dR/r/m6aNh7KGAGGhpr/9Ye/6UY= MIME-Version: 1.0 Received: by 10.142.126.14 with SMTP id y14mr191585wfc.388.1306449471043; Thu, 26 May 2011 15:37:51 -0700 (PDT) Sender: laran.evans@gmail.com Received: by 10.142.171.15 with HTTP; Thu, 26 May 2011 15:37:51 -0700 (PDT) Date: Thu, 26 May 2011 15:37:51 -0700 X-Google-Sender-Auth: Q6BvJC8kW5_7Sn4Bl4P1nKSvHLE Message-ID: Subject: SQLDataException after upgrading Hibernate: Reading an Integer column with a Reader? From: Laran Evans To: derby-user@db.apache.org Content-Type: multipart/alternative; boundary=000e0cd30630a3790d04a435781f --000e0cd30630a3790d04a435781f Content-Type: text/plain; charset=UTF-8 I'm not sure if this is an issue with the Derby driver or Hibernate. I do know that it surfaced after upgrading Hibernate to 3.5.6 Final from 3.3.2. Final. Any suggestions as to what might cause this? We've tried with several different versions of Derby without success. Caused by: java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Types 4' from a data value of type 'java.io.Reader'. at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.ResultSet.getCharacterStream(Unknown Source) at org.apache.derby.client.am.ResultSet.getCharacterStream(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.getCharacterStream(DelegatingResultSet.java:299) at org.hibernate.type.AbstractLongStringType.get(AbstractLongStringType.java:54) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:186) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:212) at org.hibernate.loader.criteria.CriteriaLoader.getResultColumnOrRow(CriteriaLoader.java:148) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:647) at org.hibernate.loader.Loader.doQuery(Loader.java:745) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270) at org.hibernate.loader.Loader.doList(Loader.java:2449) ... 42 more Caused by: org.apache.derby.client.am.ColumnTypeConversionException: An attempt was made to get a data value of type 'java.sql.Types 4' from a data value of type 'java.io.Reader'. at org.apache.derby.client.am.Cursor.getCharacterStream(Unknown Source) ... 53 more Thanks! --000e0cd30630a3790d04a435781f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I'm not sure if this is an issue with the Derby driver or Hibernat= e. I do know that it surfaced after upgrading Hibernate to 3.5.6 Final from= 3.3.2. Final.

Any suggestions as to what might ca= use this? We've tried with several different versions of Derby without = success.

Caused by: java.sql.SQLDataException: An attempt was ma= de to get a data value of type 'java.sql.Types 4' from a data value= of type 'java.io.Reader'.
=C2=A0 =C2=A0 at org.apache.de= rby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
=C2=A0 =C2=A0 at org.apache.derby.client.am.SqlException.getSQLExcepti= on(Unknown Source)
=C2=A0 =C2=A0 at org.apache.derby.client.am.Re= sultSet.getCharacterStream(Unknown Source)
=C2=A0 =C2=A0 at org.a= pache.derby.client.am.ResultSet.getCharacterStream(Unknown Source)
=C2=A0 =C2=A0 at org.apache.commons.dbcp.DelegatingResultSet.getCharac= terStream(DelegatingResultSet.java:299)
=C2=A0 =C2=A0 at org.hibe= rnate.type.AbstractLongStringType.get(AbstractLongStringType.java:54)
=
=C2=A0 =C2=A0 at org.hibernate.type.NullableType.nullSafeGet(NullableT= ype.java:186)
=C2=A0 =C2=A0 at org.hibernate.type.NullableType.nullSafeGet(NullableT= ype.java:212)
=C2=A0 =C2=A0 at org.hibernate.loader.criteria.Crit= eriaLoader.getResultColumnOrRow(CriteriaLoader.java:148)
=C2=A0 = =C2=A0 at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:647)<= /div>
=C2=A0 =C2=A0 at org.hibernate.loader.Loader.doQuery(Loader.java:745)<= /div>
=C2=A0 =C2=A0 at org.hibernate.loader.Loader.doQueryAndInitialize= NonLazyCollections(Loader.java:270)
=C2=A0 =C2=A0 at org.hibernat= e.loader.Loader.doList(Loader.java:2449)
=C2=A0 =C2=A0 ... 42 more
Caused by: org.apache.derby.client= .am.ColumnTypeConversionException: An attempt was made to get a data value = of type 'java.sql.Types 4' from a data value of type 'java.io.R= eader'.
=C2=A0 =C2=A0 at org.apache.derby.client.am.Cursor.getCharacterStream(= Unknown Source)
=C2=A0 =C2=A0 ... 53 more

Thanks!
--000e0cd30630a3790d04a435781f--