× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2013-11-07T00:53:05Z  · last modified 2013-11-15T00:28:27Z

Oracle Batch import with BLOB gives exception


Dev
Jenny Nishimura
JennyNishimura
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Tools - Import Tool
Version 14.0

 

Version: 14.0.4
Build #: 34739
Build Date: 2013-Nov-06 12:43:19 PM
 
Oracle Batch import with BLOB gives exception
 

1. Created a oracle table in 11g having a BLOB column

CREATE TABLE "HR"."LOB_TABLE"  ( 

 

        "ID"    NUMBER NULL,

        "DOC"   BLOB NULL 

        )

 

2. Used the attached file to import in ADSA 13.0 with Transaction=Batch and 1 row is successfully imported

3. Now opened in ADS v14.0.4 and imported the same file with Transaction=Batch and you get below exception

 

java.lang.ClassCastException: javax.sql.rowset.serial.SerialBlob cannot be cast to oracle.sql.BLOB

        at oracle.jdbc.driver.OraclePreparedStatement.setBlob(OraclePreparedStatement.java:6663)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.setBlob(OraclePreparedStatementWrapper.java:128)

        at \\...\\ .\\हिñçêČάй語简??한\\.aꉷꐿꎿ⣿ 6 super.setBlob(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.jꉦ⠶ꐆꄻ.a(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.jꉦ⠶ꐆꄻ.process(Unknown Source)

        at \\...\\ .\\हिñçêČάй語简??한\\.jꉦ⠶ꐆꄻ.run(Unknown Source)

2 attachments

Issue #10706

Closed
Fixed
Resolved 2013-11-12T21:15:22Z
 
 
Completion
No due date
Fixed Build ADS 14.0.5-1
No time estimate

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