#13178: Informix12.10 : On importing data with transaction batch causes exception and data is not displayed if same import window is used to retrive data.

deepalisalve reported 2015-03-26T06:03:53Z · last modified 2015-04-20T09:00:43Z

Informix12.10 : On importing data with transaction batch causes exception and data is not displayed if same import window is used to retrive data.

Dev	JennyNishimura
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Tools - Import Tool
Version	16.0

Product: Aqua Data Studio

Version: 16.0.1-8

Build #: 43117

Build Date: 2015-Mar-24 04:04:04 PM

Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / IN / Oracle Corporation 1.7.0_60-b19

Memory: Max=704,643,072; Total=475,529,216; Free=246,952,168; CPUs=8

Operating Environment : Windows, Linux
Issue : Informix12.10 : On importing data with transaction batch causes exception and data is not displayed if same import window is used to retrive data.

Steps to Reproduce :
1) Launch ADS and connect to Informix 12.10. Open View log.
2) Create table using any datatype. Use below scripts of Create and Insert

CREATE TABLE "informix".table_test ( c1 VARCHAR(25))

LOCK MODE PAGE

GO
//Insert

INSERT INTO "informix".table_test(c1)

VALUES('a')

3) Export this data in csv file using export tool.
4) Now right click on same table and select import tool
5) In Import tool, browse csv file then click Next button till Transaction tab.
In Transaction tab, select "Transaction Type->Batch"
Click Next button.
>>Data will successfully imported into specified table.
6) Now, In same import window, click on "Previous" button until first window
7) We have same csv file is selected. Just Click on Next button.
>>Here you will see, Under table Column Info=>Table data is missing and in view log it throws
java.sql.SQLException: Must terminate transaction before closing database.

Observation :
1) Issues occurs only if we perform batch operation and then use same window to import data.
2) For other DB's it works fine. Checked in Aster, Sybase.

Please see attached screenshot "import".png"

1 attachment

import.png

2015-03-26T06:22:59Z

220 KB

All Comments (5) Change History

JennyNishimura 2015-04-03T23:18:11Z

In step 5, when doing batch import, we set the auto commit mode to false.
In step 7, when extracting table information, we make a changeDatabase call. Informix complains if auto commit mode is false and returns the error message "must terminate transaction before closing database."

Fixed batch import code to reset the auto commit mode to true after batch import is done.

Fixed in ADS 16.0.3-7 and ADS 17.0.0-dev-12.

deepalisalve 2015-04-09T08:24:36Z

Verified in ADS16.0.3-11

tariqrahiman 2015-04-09T20:48:42Z

Verified in ADS v16.0.3-12

deepalisalve 2015-04-10T08:07:47Z

Verified in ADS 16.0.3-14

deepalisalve 2015-04-20T09:00:43Z

Verified in ADS 16.0.4

Search Tips

Aqua Data Studio / nhilam

Informix12.10 : On importing data with transaction batch causes exception and data is not displayed if same import window is used to retrive data.

1 attachment

Issue #13178

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Informix12.10 : On importing data with transaction batch causes exception and data is not displayed if same import window is used to retrive data.

1 attachment

Issue #13178

Completion