Writting to a DB with cMap

Anonymous — Sat, 16 Nov 2024 09:00:32 GMT

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:

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: ]

Re: Writting to a DB with cMap

Anonymous — Mon, 27 Nov 2017 16:39:49 GMT

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

Re: Writting to a DB with cMap

Anonymous — Tue, 28 Nov 2017 11:47:26 GMT

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?

Re: Writting to a DB with cMap

Anonymous — Tue, 28 Nov 2017 13:02:15 GMT

Hi,

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

Eric

Re: Writting to a DB with cMap

Anonymous — Wed, 29 Nov 2017 09:22:36 GMT

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

Re: Writting to a DB with cMap

Anonymous — Wed, 29 Nov 2017 11:17:21 GMT

Hi,

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

Eric

topic Writting to a DB with cMap in Talend Studio

Writting to a DB with cMap

Re: Writting to a DB with cMap

Re: Writting to a DB with cMap

Re: Writting to a DB with cMap

Re: Writting to a DB with cMap

Re: Writting to a DB with cMap