#14696: Apache Derby: java.lang.NullPointerException throws when we export System tables

raghavsingh reported 2016-09-13T10:01:02Z · last modified 2018-07-12T22:43:41Z

Apache Derby: java.lang.NullPointerException throws when we export System tables

Dev	tomconrad
QA	tomconrad

Priority	Low
Complexity	Unknown

Component	DB - Apache Derby
Version	Future - PM

Product: Aqua Data Studio

Version: 18.0.0-devi-231

Build #: 51117

Build Date: 2016-Sep-12 08:59:44 PM

Steps to Reproduce:

1. Connect Apache Derby Database

2. Expand Schema Node and select system generated 'SYS' schema .

3. Expand System Tables and Select 'SYSCHECKS'.

4. Right click on Table and select Tools option >> Export Data .

5. Export Data window opened , selected Table displayed in Objects box.Click on Next Button

6. Under Option tab add file path and Click on Next button.

Actual Result : When we click on Next button, Exceptions thrown under Status Tab.

Observation: File exported successfully but data not exported under saved file

This issue occurs in all previous ADS versions [ADS-16 and ADS-17]

Export started ...

java.lang.NullPointerException

at \\.\\.\\हिñçêČάй語简�?한\\.pꆝ᠊᠌ꐠ.a(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.cꁎꑸ⠩ꃕcontinue.b(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.cꁎꑸ⠩ꃕcontinue.a(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.Jꑨꀬꈣꈞ.run(Unknown Source)

Export completed.

1 attachment

SystemTable_Export.png

2016-09-13T10:01:03Z

180 KB

All Comments (2) Change History

SachinPrakash 2016-10-01T00:06:40Z

Pls provide complete matrix of results

raghavsingh 2016-10-01T10:08:49Z · (edited)

Issue is reproducible some SYSTEM Tables on SYS Schema

Below table names which are not Exported successfully under SYS Schema and exception throws under status tab.

"SYS"."SYSCHECKS"

"SYS"."SYSALIASES"

"SYS"."SYSCOLPERMS"

"SYS"."SYSCOLUMNS"

"SYS"."SYSCONGLOMERATES"

"SYS"."SYSDEPENDS"

"SYS"."SYSSEQUENCES"

"SYS"."SYSSTATISTICS"

"SYS"."SYSTRIGGERS"

Tables names those are Exported successfully under SYS Schema

"SYS"."SYSCONSTRAINTS"

"SYS"."SYSFILES"

"SYS"."SYSFOREIGNKEYS"

"SYS"."SYSKEYS"

"SYS"."SYSPERMS"

"SYS"."SYSROLES"

"SYS"."SYSROUTINEPERMS"

"SYS"."SYSSCHEMAS"

"SYS"."SYSSTATEMENTS"

"SYS"."SYSTABLEPERMS"

"SYS"."SYSTABLES"

"SYS"."SYSUSERS"

"SYS"."SYSVIEWS"

BEHAVIOUR	Database
Under Status Tab Exception Throws, File exported successfully but data not exported under saved file	Apache Derby 10.12		Apache Derby 10.11
	WINDOWS	LINUX	WINDOWS	LINUX
ADS Version 18 build – 249	N	N	N	N
ADS Version 17	N	N	N	N
ADS Version 16	N	N	N	N
N- No, Data not exported successfully and Exceptions throws under status tab

Comments:

1. The issue is reproducing for all versions of ADS i.e. v16, v17 and v18.

2. Issue is reproducing for Apache Derby Version 10.12 and 10.11

3. This issue is occurring for Windows and Linux.

Search Tips

Aqua Data Studio / nhilam

Apache Derby: java.lang.NullPointerException throws when we export System tables

1 attachment

Issue #14696

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Apache Derby: java.lang.NullPointerException throws when we export System tables

1 attachment

Issue #14696

Completion