× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Tariq Rahiman
tariqrahiman reported 2014-05-02T00:31:38Z  · last modified 2014-06-26T21:02:53Z

Number Format Exception during Export in PostgreSQL


Dev
Thomas Conrad
tomconrad
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Tools - Export Tool
Version 15.0

Version: 15.0.0-dev-262

Number Format Exception during Export in PostgreSQL

To reproduce:

1. Connect to PostgreSQL 9.2 with login postgres and our standard passwrod

Host is 10.168.11.56 and Port: 5432 with database postgres

2. Go to AquaFold Database and Create a Table with below SQL

CREATE TABLE "ivan"."num_fmt_exp"  ( 
"bit_col"    bit(3) NOT NULL,
"varbit_col" varbit NULL,
PRIMARY KEY("bit_col")
)
GO
 

3. Use below Insert for the table

INSERT INTO "ivan"."num_fmt_exp"  VALUES('011', '111')
GO
INSERT INTO "ivan"."num_fmt_exp"  VALUES('001', '0111')
GO

 

4. Now Export the table to a File and Format Delimited Data

5. You will get below exception on completion of the Export

java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:504)
at java.lang.Integer.valueOf(Integer.java:582)
at \\...\\ .\\हिñçêČάй語简�?한\\.s͂⢭ꑬꌺ break.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.I⠔ꑼꃣ⡱ enum.b(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.I⠔ꑼꃣ⡱ enum.run(Unknown Source)
 

 

 

 

1 attachment
  •  
  •  
  • No shares
  •  
All Comments (2) Change History
Sort 

Issue #12003
Closed
Fixed
Resolved 2014-06-22T18:25:54Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017