Datahub SQL data retrieval

[uldis]

Hi,

my questions what would be the best practice to go for retrieving info from a SQL table (using MySQL) trough DH. In my case, I am trying to retrieve data from the table publication retry to further use the data it in my datahub extension.

Thanks, Uldis

[former_member387866 · Accepted solution]

Hi Uldis,

As this is a Spring application and the local.properties has datasource.*.* properties you could try:

 @Autowired private DataSource dataSource;

And then just use it as a standard JDBC DataSource with Connection,PreparedStatement and ResultSet.

Regards,
Luke