Connecting database from flow

Question

How should I need to connect with the database from flow to fetch the data instead of vault querying?

1.Instead of using custom query criteria, I am planning to use query command(like SQL command) to fetch the data from database.

2.Is it possible?

3.If it is possible, how to achieve it?

Dan Newton · Accepted Answer · 2019-07-12 11:15:52Z

3

serviceHub.jdbcSession().prepareStatement() or serviceHub.withEntityManager { }

answered Jul 12, 2019 at 11:15

Dan Newton

9206 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gokulnath Over a year ago

Hello @Dan Newton Can you give me an example code? because i m getting the exception("com.esotericsoftware.kryo.KryoException: java.lang.UnsupportedOperationException: com.zaxxer.hikari.pool.HikariProxyPreparedStatement, which is a closeable resource, has been detected during flow checkpointing. Restoring such resources across node restarts is not supported. Make sure code accessing it is confined to a private method or the reference is nulled out.")

Gokulnath Over a year ago

For further details refer the link: stackoverflow.com/questions/57095232/…

Collectives™ on Stack Overflow

Connecting database from flow

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related