Pages: 1

Post reply

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Exception on BLOB and CLOB data types

#1 2008-03-06 09:51:51

nicolas.lledo@snef.fr
Member
Registered: 2008-02-19
Posts: 12

Exception on BLOB and CLOB data types

Tags: [bug, java, oracle, tos2.3.1]

Hi,

We monitored the issue [Bugtracker, bug 2258, fixed] Copy BLOB from 1 Oracle schema to another Oracle schema.
We still have the issue.

Talend is version 2.3.1 (build 11699)

Code:

StackTrace :
Exception in component tOracleOutput_1
java.sql.SQLException: Type de colonne non valide
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
    at oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.java:3150)
    at oracle.jdbc.driver.OraclePreparedStatement.setNullInternal(OraclePreparedStatement.java:3665)
    at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:3653)
    at migration_sgt.t_gq_site.t_gq_site.tOracleInput_1Process(t_gq_site.java:854)
    at migration_sgt.t_gq_site.t_gq_site.runJobInTOS(t_gq_site.java:1571)
    at migration_sgt.t_gq_site.t_gq_site.main(t_gq_site.java:1487)

Code:

 853>                   if (row4.PHOTO == null) {
 854>                      pstmt_tOracleOutput_1.setNull(12, java.sql.Types.OTHER);
 855>                  } else {
 856>                      pstmt_tOracleOutput_1.setObject(12, row4.PHOTO);
 857>                  }

regards

Offline

#2 2008-03-07 07:44:52

shong
Talend team
Registered: 2007-08-29
Posts: 10289
Website

Re: Exception on BLOB and CLOB data types

Hi

Can you show your job and the shema of Oracle ?

Best regards

          shong

Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2008-03-07 08:52:30

nicolas.lledo@snef.fr
Member
Registered: 2008-02-19
Posts: 12

Re: Exception on BLOB and CLOB data types

Here they are.
Do you need the whole code ?


Uploaded Images

Offline

#4 2008-09-09 18:53:41

nicolas.lledo@snef.fr
Member
Registered: 2008-02-19
Posts: 12

Re: Exception on BLOB and CLOB data types

Hi,

I have the same error again. Now with tos 2.4.2.

Code:

Starting job reprise_ot_vers_demande at 18:47 09/09/2008.
[statistics] connecting to socket on port 3475
[statistics] connected
Exception in component tOracleOutput_1
java.sql.SQLException: Type de colonne non valide: 1111
    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
    at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:3499)
    at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4307)
    at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4293)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:992)
    at gost_2_0_2_1.reprise_ot_vers_demande_0_1.reprise_ot_vers_demande.tOracleInput_1Process(reprise_ot_vers_demande.java:8430)
    at gost_2_0_2_1.reprise_ot_vers_demande_0_1.reprise_ot_vers_demande.runJobInTOS(reprise_ot_vers_demande.java:22600)
    at gost_2_0_2_1.reprise_ot_vers_demande_0_1.reprise_ot_vers_demande.main(reprise_ot_vers_demande.java:22489)
213797 milliseconds
[statistics] disconnected
Job reprise_ot_vers_demande ended at 18:51 09/09/2008. [exit code=1]

Code:

                        if (mapping_etat_Ok.COMMENTAIRE == null) {
                            pstmt_tOracleOutput_1.setNull(14,
                                    java.sql.Types.OTHER);
                        } else {
                            pstmt_tOracleOutput_1.setObject(14,
                                    mapping_etat_Ok.COMMENTAIRE);
                        }

Is there a workaround... this bug seemed to happen randomly. It looks pretty permanent now.

Last edited by nicolas.lledo@snef.fr (2008-09-09 19:28:55)

Offline

#5 2009-08-28 17:12:21

blep
Member
Registered: 2006-12-14
Posts: 67
Website

Re: Exception on BLOB and CLOB data types

I saw the bug was reported several times, mainly in http://talendforge.org/bugs/view.php?id=2258.

But with the latest release (3.2.0M3) the problem seems to remain.

Offline

#6 2010-08-26 11:45:44

Daika
Guest

Re: Exception on BLOB and CLOB data types

They solved the if( ... == null) part by using a BLOB instead of OTHER, but I guess in your case (and mine) setObject should be replaced by setBlob.

#7 2010-11-12 13:51:51

archenroot
Member
Company: CoeTech Unconnected
Registered: 2010-02-23
Posts: 161
Website

Re: Exception on BLOB and CLOB data types

I reported the bug at:
http://talendforge.org/bugs/view.php?id=16994

I also posted something related to this issue in another topic
http://www.talendforge.org/forum/viewtopic.php?id=8323

Best regards,

archenroot

Emperor wants to control outer space Yoda wants to explore inner space that's the fundamental difference between good and bad sides of the Force

Offline

Post reply

Pages: 1

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Exception on BLOB and CLOB data types

Board footer

Powered by FluxBB