Six Stars

Writting to a DB with cMap

I am trying to write a JSON file to DB with the use of cMap. From the logs it seems nothing is wrong. Maybe I am not committing it?

My route setup:

Untitled1.png

Logs from the Route:

...
[INFO ]: org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
[INFO ]: org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 15
[INFO ]: org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
[INFO ]: org.hibernate.connection.DriverManagerConnectionProvider - using driver: oracle.jdbc.OracleDriver at URL: jdbc:oracle:thin:@//xxx:1521/xxx.de
[INFO ]: org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=TALEND_INT, password=****}
[INFO ]: org.hibernate.cfg.SettingsFactory - RDBMS: Oracle, version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[INFO ]: org.hibernate.cfg.SettingsFactory - JDBC driver: Oracle JDBC driver, version: 11.2.0.4.0
[INFO ]: org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.Oracle9Dialect
[WARN ]: org.hibernate.dialect.Oracle9Dialect - The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect instead
[INFO ]: org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
[INFO ]: org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[INFO ]: org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
[INFO ]: org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
[INFO ]: org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Connection release mode: auto
[INFO ]: org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 1000
[INFO ]: org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
[INFO ]: org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[INFO ]: org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
[INFO ]: org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
[INFO ]: org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Query cache: disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge
[INFO ]: org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge - Cache provider: org.hibernate.cache.NoCacheProvider
[INFO ]: org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Statistics: disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Default entity-mode: dynamic-map
[INFO ]: org.hibernate.cfg.SettingsFactory - Named query checking : enabled
[INFO ]: org.hibernate.cfg.SettingsFactory - Check Nullability in Core (should be disabled when Bean Validation is on): enabled
[INFO ]: org.hibernate.impl.SessionFactoryImpl - building session factory
[INFO ]: org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
[INFO ]: org.hibernate.impl.SessionFactoryImpl - closing
[INFO ]: org.hibernate.connection.DriverManagerConnectionProvider - cleaning up connection pool: jdbc:oracle:thin:@//xxx:1521/xxx.de
[INFO ]: Testing.cLog_1 - Exchange[ExchangePattern: InOnly, BodyType: String, Body: ]
5 REPLIES
Eight Stars

Re: Writting to a DB with cMap

Hi,

-Does it work when you run your map from mapping perspective ?

-Does it work if you run your map in a DI job with a thmap ?

 

Keep in mind that "Database support in TDM is deprecated since 6.4.1"

"The following features are deprecated in the current release. Deprecated features are no longer recommended for use and may cease to exist in future versions of the product.

Database support is deprecated from version 6.4.1. There will be no more developements and features using JDBC drivers, and you are encouraged to use other Data Integration components instead"

https://help.talend.com/reader/uCysbjfyKZbxWfRj_OAB4w/ma3pX8md8Y1dBWuAfx6hGQ

 

Regards.


Eric

Six Stars

Re: Writting to a DB with cMap

I will not go into it if writing to DB from cMap is deprecated in the newest Talend Studio.

 

 There will be no more developements and features using JDBC drivers, and you are encouraged to use other Data Integration components instead"

Which are those components?

Eight Stars

Re: Writting to a DB with cMap

Hi,

 

I guess they are talking about calling DI DB components through a cTalendJob.

 

Eric

Six Stars

Re: Writting to a DB with cMap

"I guess they are talking about calling DI DB components through a cTalendJob." I guess with tHmap it won't work as well?
Eight Stars

Re: Writting to a DB with cMap

Hi,

 

The fact the DB functions are deprecated is related to tHmap too.

 

Eric