Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Critical |
| Complexity | Unknown |
| Component | Tools - Import Tool |
| Version | 15.0 |
Create the table :
CREATE TABLE public.test_table (
rid uuid NOT NULL,
rtype text NOT NULL,
rvalue text NOT NULL
)
GO
Using Import Tool in Batch mode, import the attached file and you get this error.
Import started ...
Execute batch failed: Batch entry 0 INSERT INTO "public"."test_table"("rid", "rtype", "rvalue") VALUES('FAF53CC4-459A-4BCE-B796-B31814E903F8', 'ip_address', '203.16.1.123') was aborted. Call getNextException to see the cause.
ERROR: column "rid" is of type uuid but expression is of type character varying
Hint: You will need to rewrite or cast the expression.
Position: 68
Import completed.
|
378 B
@jenny: to support UUID in postgresql using prepared statements: http://crafted-software.blogspot.com/2013/03/uuid-values-from-jdbc-to-postgres.html
Verified UUID import in ADS v15.0.14-14 in the BATCH mode. Works fine now
Verified UUID import in ADS v15.0.14-14 in the BATCH mode. Works fine now
Tested in FluidShell as well and it works now in 15.0.14-14
Tested in FluidShell as well and it works now in 15.0.14-14
Customer reported problems with MONEY data type and NULL data for INT4 data type.
For NULL data, there are two cases:
1. specify (null) in import data and check "Set value to NULL on (null) text" option in the Options tab
2. specify an empty string in import data
These are now also fixed.
Customer reported problems with MONEY data type and NULL data for INT4 data type.
For NULL data, there are two cases:
1. specify (null) in import data and check "Set value to NULL on (null) text" option in the Options tab
2. specify an empty string in import data
These are now also fixed.
Issue #13118 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 15.0.14-18 |
| No time estimate |
@jenny: to support UUID in postgresql using prepared statements: http://crafted-software.blogspot.com/2013/03/uuid-values-from-jdbc-to-postgres.html