Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
From: "Allgeyer, Jessica" <jallgeyer@GAIC.COM>
To: "Kristian.Waagan@Sun.COM" <Kristian.Waagan@Sun.COM>, Derby Discussion
	<derby-user@db.apache.org>, "Richard.Hillegas@Sun.COM"
	<Richard.Hillegas@Sun.COM>
CC: "Combs, Jeremy" <jcombs@GAIC.COM>, "McGrath, Phil" <pmcgrath@GAIC.COM>,
	"Ritchie, Erin" <eritchie@GAIC.COM>, "Lewis, Chris" <cmlewis@GAIC.COM>,
	"Allgeyer, Jessica" <jallgeyer@GAIC.COM>
Date: Wed, 4 Nov 2009 10:57:17 -0500
Subject: RE: Upgrading Issues
Thread-Topic: Upgrading Issues
Thread-Index: AcpdWXSYTcRTykinT5+QeeinpRuNnQADHSbw
Message-ID: 
 <C42B7AB10055184FA35CBB5213380998B8F8E44B@CVGEXCEMAIL01.ga.afginc.com>
References: 
 <C42B7AB10055184FA35CBB5213380998B8F8E09A@CVGEXCEMAIL01.ga.afginc.com>
 <4AF18C39.3010307@Sun.COM>
In-Reply-To: <4AF18C39.3010307@Sun.COM>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: multipart/mixed;
	boundary="_003_C42B7AB10055184FA35CBB5213380998B8F8E44BCVGEXCEMAIL01ga_"
MIME-Version: 1.0

--_003_C42B7AB10055184FA35CBB5213380998B8F8E44BCVGEXCEMAIL01ga_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Kristian/Rick

I've included 2 attachments. One is the full stack trace for the NullPointe=
rException. The other is the file the call is trying to use. The file is ze=
ro bytes and does not contain any characters. Our platform is Windows and w=
e are using Java to run the call.  Below is the full import call. =


CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE ('SA', 'CHACRGE', 'C:\bea\projects\claim=
s-dev\unzippedclaims\CHACRGE.rcsv','|','``',null,1) =


Thanks
Jessica Allgeyer
(513) 763 - 8523


-----Original Message-----
From: Kristian.Waagan@Sun.COM [mailto:Kristian.Waagan@Sun.COM] =

Sent: Wednesday, November 04, 2009 9:14 AM
To: Derby Discussion
Cc: Combs, Jeremy; McGrath, Phil; Ritchie, Erin; Lewis, Chris; Allgeyer, Je=
ssica
Subject: Re: Upgrading Issues

Allgeyer, Jessica wrote:
> Recently we have upgraded our Derby DB from 10.3.1.4  to 10.5.3.0. With t=
he latest version,  api CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE is throwing the =
error 'java.lang.NullPointerException' when a file is empty. After investig=
ation, any version above our previous version of 10.3.1.4 causes this error=
. Can you provide us with a solution or adjustments we need to make on our =
end? Please let me know if you need more information provided. =

>
>   =

Hello Jessica,

I'm not able to reproduce with neither 10.5 nor the development trunk, so m=
ore information would be useful.
(Just noticed Rick reporting the same.)

I simply tried importing a file of size zero bytes, and that worked (i.e. n=
othing happened).
Some suggestions:
 - Can you provide the stack trace from the NullPointerException?
  (remove traces you don't want to reveal if necessary)
 - Is the file zero bytes, or is there at least one character/byte (visible=
 or non-visible) in there?
 - Can you specify the full import call?
 - What's your platform? Do you already now that the bug occurs at any plat=
form?

The best thing you can do is to provide a small repro script :)


Regards,
--
Kristian

> Thanks
> Jessica Allgeyer
> (513) 763 - 8523
>
>
>
>
>
>
> ********************************************************************** =

> The content of this e-mail message and any attachments are =

> confidential and may be legally privileged, intended solely for the =

> addressee. If you are not the intended recipient, be advised that any =

> use, dissemination, distribution, or copying of this e-mail is =

> strictly prohibited. If you receive this message in error, please =

> notify the sender immediately by reply email and destroy the message =

> and its attachments. =

> **********************************************************************
>
>   =


********************************************************************** The =
content of this e-mail message and any attachments are confidential and may=
 be legally privileged, intended solely for the addressee. If you are not t=
he intended recipient, be advised that any use, dissemination, distribution=
, or copying of this e-mail is strictly prohibited. If you receive this mes=
sage in error, please notify the sender immediately by reply email and dest=
roy the message and its attachments. **************************************=
******************************** =


--_003_C42B7AB10055184FA35CBB5213380998B8F8E44BCVGEXCEMAIL01ga_
Content-Type: application/octet-stream; name="CHACRGE.rcsv"
Content-Description: CHACRGE.rcsv
Content-Disposition: attachment; filename="CHACRGE.rcsv";
	creation-date="Wed, 04 Nov 2009 10:43:48 GMT";
	modification-date="Wed, 04 Nov 2009 10:43:48 GMT"
Content-Transfer-Encoding: base64


--_003_C42B7AB10055184FA35CBB5213380998B8F8E44BCVGEXCEMAIL01ga_
Content-Type: text/plain; name="StackTraceErrorForDerbyCall.txt"
Content-Description: StackTraceErrorForDerbyCall.txt
Content-Disposition: attachment; filename="StackTraceErrorForDerbyCall.txt";
	size=4835; creation-date="Wed, 04 Nov 2009 10:33:16 GMT";
	modification-date="Wed, 04 Nov 2009 10:33:16 GMT"
Content-Transfer-Encoding: base64

VGhlcmUgd2FzIGEgZGF0YSB0cmFuc2ZlciBwcm9ibGVtIHdpdGggdGhlIGRhdGFiYXNlLg0KDQpD
bGljayBEZXRhaWxzIHRvIG9idGFpbiBtb3JlIGluZm9ybWF0aW9uIHRoYXQgY2FuIGJlIHByb3Zp
ZGVkIHRvIFRlY2ggU3VwcG9ydC4NCg0KICBUbyBjb3B5IHRoaXMgZW50aXJlIG1lc3NhZ2UsIGhp
Z2hsaWdodCBhbnkgbGluZSBhbmQgcmlnaHQgY2xpY2sgZm9yIG9wdGlvbnMuDQogIA0KICBTUUwg
U3RhdGUgQ29kZTogWElFMFINCiAgRXJyb3IgTWVzc2FnZTogSW1wb3J0IGVycm9yIG9uIGxpbmUg
MSBvZiBmaWxlIEM6XGJlYVxwcm9qZWN0c1xjbGFpbXMtZGV2XHVuemlwcGVkY2xhaW1zXENIQUNS
R0UucmNzdjogSmF2YSBleGNlcHRpb246ICc6IGphdmEubGFuZy5OdWxsUG9pbnRlckV4Y2VwdGlv
bicuIA0KICANCiAgU3RhY2sgVHJhY2U6DQogIGphdmEuc3FsLlNRTEV4Y2VwdGlvbjogSW1wb3J0
IGVycm9yIG9uIGxpbmUgMSBvZiBmaWxlIEM6XGJlYVxwcm9qZWN0c1xjbGFpbXMtZGV2XHVuemlw
cGVkY2xhaW1zXENIQUNSR0UucmNzdjogSmF2YSBleGNlcHRpb246ICc6IGphdmEubGFuZy5OdWxs
UG9pbnRlckV4Y2VwdGlvbicuIA0KICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuamRiYy5T
UUxFeGNlcHRpb25GYWN0b3J5LmdldFNRTEV4Y2VwdGlvbihVbmtub3duIFNvdXJjZSkNCiAgICAg
YXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLmpkYmMuVXRpbC5uZXdFbWJlZFNRTEV4Y2VwdGlvbihV
bmtub3duIFNvdXJjZSkNCiAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLmpkYmMuVXRpbC5z
ZWVOZXh0RXhjZXB0aW9uKFVua25vd24gU291cmNlKQ0KICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5
LmltcGwuamRiYy5UcmFuc2FjdGlvblJlc291cmNlSW1wbC53cmFwSW5TUUxFeGNlcHRpb24oVW5r
bm93biBTb3VyY2UpDQogICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5qZGJjLlRyYW5zYWN0
aW9uUmVzb3VyY2VJbXBsLmhhbmRsZUV4Y2VwdGlvbihVbmtub3duIFNvdXJjZSkNCiAgICAgYXQg
b3JnLmFwYWNoZS5kZXJieS5pbXBsLmpkYmMuRW1iZWRDb25uZWN0aW9uLmhhbmRsZUV4Y2VwdGlv
bihVbmtub3duIFNvdXJjZSkNCiAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLmpkYmMuQ29u
bmVjdGlvbkNoaWxkLmhhbmRsZUV4Y2VwdGlvbihVbmtub3duIFNvdXJjZSkNCiAgICAgYXQgb3Jn
LmFwYWNoZS5kZXJieS5pbXBsLmpkYmMuRW1iZWRTdGF0ZW1lbnQuZXhlY3V0ZVN0YXRlbWVudChV
bmtub3duIFNvdXJjZSkNCiAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLmpkYmMuRW1iZWRQ
cmVwYXJlZFN0YXRlbWVudC5leGVjdXRlU3RhdGVtZW50KFVua25vd24gU291cmNlKQ0KICAgICBh
dCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuamRiYy5FbWJlZENhbGxhYmxlU3RhdGVtZW50LmV4ZWN1
dGVTdGF0ZW1lbnQoVW5rbm93biBTb3VyY2UpDQogICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1w
bC5qZGJjLkVtYmVkUHJlcGFyZWRTdGF0ZW1lbnQuZXhlY3V0ZShVbmtub3duIFNvdXJjZSkNCiAg
ICAgYXQgY29tLmdyZWF0YWcuY2xhaW1zLnN0YW5kYWxvbmUuZG93bmxvYWQuRGVyYnlEYXRhTG9h
ZGVyLmltcG9ydERhdGEoRGVyYnlEYXRhTG9hZGVyLmphdmE6NjUpDQogICAgIGF0IGNvbS5ncmVh
dGFnLmNsYWltcy5zdGFuZGFsb25lLmRvd25sb2FkLkRlcmJ5RGF0YUxvYWRlci5yZXBsYWNlRGF0
YShEZXJieURhdGFMb2FkZXIuamF2YTo0OSkNCiAgICAgYXQgY29tLmdyZWF0YWcuY2xhaW1zLnN0
YW5kYWxvbmUuZG93bmxvYWQuRGVyYnlEYXRhTG9hZGVyLnByb2Nlc3MoRGVyYnlEYXRhTG9hZGVy
LmphdmE6ODApDQogICAgIGF0IGNvbS5ncmVhdGFnLmNsYWltcy5zdGFuZGFsb25lLmRvd25sb2Fk
LkNsYWltc0Rvd25sb2FkRGF0YUluc3RhbGxlci5wcm9jZXNzRG93bmxvYWRlZEZpbGUoQ2xhaW1z
RG93bmxvYWREYXRhSW5zdGFsbGVyLmphdmE6MTE2KQ0KICAgICBhdCBjb20uZ3JlYXRhZy5jbGFp
bXMuc3RhbmRhbG9uZS5kb3dubG9hZC5DbGFpbXNEb3dubG9hZERhdGFJbnN0YWxsZXIuc3RvcmVE
YXRhKENsYWltc0Rvd25sb2FkRGF0YUluc3RhbGxlci5qYXZhOjc3KQ0KICAgICBhdCBjb20uZ3Jl
YXRhZy5jbGFpbXMuc3RhbmRhbG9uZS5kb3dubG9hZC5DbGFpbXNEb3dubG9hZFByb2Nlc3Nvci5w
ZXJmb3JtRG93bmxvYWQoQ2xhaW1zRG93bmxvYWRQcm9jZXNzb3IuamF2YTo1MikNCiAgICAgYXQg
Y29tLmdyZWF0YWcuY2xhaW1zLnN0YW5kYWxvbmUudWkuRG93bmxvYWRDbGFpbXNIYW5kbGVyLnJ1
bihEb3dubG9hZENsYWltc0hhbmRsZXIuamF2YToxMDUpDQogIENhdXNlZCBieTogamF2YS5zcWwu
U1FMRXhjZXB0aW9uOiBKYXZhIGV4Y2VwdGlvbjogJzogamF2YS5sYW5nLk51bGxQb2ludGVyRXhj
ZXB0aW9uJy4NCiAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLmpkYmMuU1FMRXhjZXB0aW9u
RmFjdG9yeS5nZXRTUUxFeGNlcHRpb24oVW5rbm93biBTb3VyY2UpDQogICAgIGF0IG9yZy5hcGFj
aGUuZGVyYnkuaW1wbC5qZGJjLlV0aWwubmV3RW1iZWRTUUxFeGNlcHRpb24oVW5rbm93biBTb3Vy
Y2UpDQogICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5qZGJjLlV0aWwuamF2YUV4Y2VwdGlv
bihVbmtub3duIFNvdXJjZSkNCiAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLmpkYmMuVHJh
bnNhY3Rpb25SZXNvdXJjZUltcGwud3JhcEluU1FMRXhjZXB0aW9uKFVua25vd24gU291cmNlKQ0K
ICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuamRiYy5UcmFuc2FjdGlvblJlc291cmNlSW1w
bC5oYW5kbGVFeGNlcHRpb24oVW5rbm93biBTb3VyY2UpDQogICAgIGF0IG9yZy5hcGFjaGUuZGVy
YnkuaW1wbC5qZGJjLkVtYmVkQ29ubmVjdGlvbi5oYW5kbGVFeGNlcHRpb24oVW5rbm93biBTb3Vy
Y2UpDQogICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5qZGJjLkNvbm5lY3Rpb25DaGlsZC5o
YW5kbGVFeGNlcHRpb24oVW5rbm93biBTb3VyY2UpDQogICAgIGF0IG9yZy5hcGFjaGUuZGVyYnku
aW1wbC5qZGJjLkVtYmVkU3RhdGVtZW50LmV4ZWN1dGVTdGF0ZW1lbnQoVW5rbm93biBTb3VyY2Up
DQogICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5qZGJjLkVtYmVkUHJlcGFyZWRTdGF0ZW1l
bnQuZXhlY3V0ZVN0YXRlbWVudChVbmtub3duIFNvdXJjZSkNCiAgICAgYXQgb3JnLmFwYWNoZS5k
ZXJieS5pbXBsLmpkYmMuRW1iZWRQcmVwYXJlZFN0YXRlbWVudC5leGVjdXRlVXBkYXRlKFVua25v
d24gU291cmNlKQ0KICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwubG9hZC5JbXBvcnQucGVy
Zm9ybUltcG9ydChVbmtub3duIFNvdXJjZSkNCiAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBs
LmxvYWQuSW1wb3J0LmltcG9ydFRhYmxlKFVua25vd24gU291cmNlKQ0KICAgICBhdCBvcmcuYXBh
Y2hlLmRlcmJ5LmNhdGFsb2cuU3lzdGVtUHJvY2VkdXJlcy5TWVNDU19JTVBPUlRfVEFCTEUoVW5r
bm93biBTb3VyY2UpDQogICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuZXhlLmFjMzRjYzAyNjF4MDEy
NHhiYWU2eDdmMmN4MDAwMDBiZjA4MGJlM2YuZzAoVW5rbm93biBTb3VyY2UpDQogICAgIGF0IHN1
bi5yZWZsZWN0Lk5hdGl2ZU1ldGhvZEFjY2Vzc29ySW1wbC5pbnZva2UwKE5hdGl2ZSBNZXRob2Qp
DQogICAgIGF0IHN1bi5yZWZsZWN0Lk5hdGl2ZU1ldGhvZEFjY2Vzc29ySW1wbC5pbnZva2UoTmF0
aXZlTWV0aG9kQWNjZXNzb3JJbXBsLmphdmE6MzkpDQogICAgIGF0IHN1bi5yZWZsZWN0LkRlbGVn
YXRpbmdNZXRob2RBY2Nlc3NvckltcGwuaW52b2tlKERlbGVnYXRpbmdNZXRob2RBY2Nlc3Nvcklt
cGwuamF2YToyNSkNCiAgICAgYXQgamF2YS5sYW5nLnJlZmxlY3QuTWV0aG9kLmludm9rZShNZXRo
b2QuamF2YTozMjQpDQogICAgIGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zZXJ2aWNlcy5yZWZs
ZWN0LlJlZmxlY3RNZXRob2QuaW52b2tlKFVua25vd24gU291cmNlKQ0KICAgICBhdCBvcmcuYXBh
Y2hlLmRlcmJ5LmltcGwuc3FsLmV4ZWN1dGUuQ2FsbFN0YXRlbWVudFJlc3VsdFNldC5vcGVuKFVu
a25vd24gU291cmNlKQ0KICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5LmltcGwuc3FsLkdlbmVyaWNQ
cmVwYXJlZFN0YXRlbWVudC5leGVjdXRlU3RtdChVbmtub3duIFNvdXJjZSkNCiAgICAgYXQgb3Jn
LmFwYWNoZS5kZXJieS5pbXBsLnNxbC5HZW5lcmljUHJlcGFyZWRTdGF0ZW1lbnQuZXhlY3V0ZShV
bmtub3duIFNvdXJjZSkNCiAgICAgLi4uIDExIG1vcmUNCiAgQ2F1c2VkIGJ5OiBqYXZhLmxhbmcu
TnVsbFBvaW50ZXJFeGNlcHRpb24NCiAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLnNxbC5l
eGVjdXRlLkluc2VydFJlc3VsdFNldC5lbXB0eUluZGV4ZXMoVW5rbm93biBTb3VyY2UpDQogICAg
IGF0IG9yZy5hcGFjaGUuZGVyYnkuaW1wbC5zcWwuZXhlY3V0ZS5JbnNlcnRSZXN1bHRTZXQudXBk
YXRlQWxsSW5kZXhlcyhVbmtub3duIFNvdXJjZSkNCiAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5p
bXBsLnNxbC5leGVjdXRlLkluc2VydFJlc3VsdFNldC5idWxrSW5zZXJ0Q29yZShVbmtub3duIFNv
dXJjZSkNCiAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLnNxbC5leGVjdXRlLkluc2VydFJl
c3VsdFNldC5vcGVuKFVua25vd24gU291cmNlKQ0KICAgICBhdCBvcmcuYXBhY2hlLmRlcmJ5Lmlt
cGwuc3FsLkdlbmVyaWNQcmVwYXJlZFN0YXRlbWVudC5leGVjdXRlU3RtdChVbmtub3duIFNvdXJj
ZSkNCiAgICAgYXQgb3JnLmFwYWNoZS5kZXJieS5pbXBsLnNxbC5HZW5lcmljUHJlcGFyZWRTdGF0
ZW1lbnQuZXhlY3V0ZShVbmtub3duIFNvdXJjZSkNCiAgICAgLi4uIDI2IG1vcmU=


--_003_C42B7AB10055184FA35CBB5213380998B8F8E44BCVGEXCEMAIL01ga_--