How can I execute SQL with my plugin?

[Leandro Larroulet]

Hi everyone,

I'm working on a plugin migration which happens to use a DAO class that extends JdbcDaoSupport.

Now that it is not available anymore (JdbcDaoSupport) I was wondering how could I execute an SQL statement without changing everything to use ActiveObjects.

If someone could give me a hint, that'd be great!

Regards,

Ripka

[Onkar Ahire · Accepted solution]

org.ofbiz.core.entity.jdbc.SQLProcessor sqlProcessor = null;

sqlProcessor = new org.ofbiz.core.entity.jdbc.SQLProcessor("defaultDS");

ResultSet rs=sqlProcessor.executeQuery("QUERY");

[todor kolev]

How to determine the data source name (in this case defaultDS) but it might vary...

[todor kolev]

Is there any ORM framework provided by Jira as we can't know what the underlying database is.

[Christian Vieweg]

I determined the data source name like this:

ComponentAccessor.getOfBizDelegator().getDelegatorInterface().getEntityHelperName("Issue")

[Florin Manaila]

Try to use org.ofbiz.core.entity.jdbc.SQLProcessor if you're looking for another way, but as Mizan said, why not just add the required dependency to your project?

[Mizan]

How about adding this class/ package as a dependency in your plugin ? what you mean by

Now that it is not available anymore

[Onkar Ahire]

org.ofbiz.core.entity.jdbc.SQLProcessor sqlProcessor = null;

sqlProcessor = new org.ofbiz.core.entity.jdbc.SQLProcessor("defaultDS");

ResultSet rs=sqlProcessor.executeQuery(SQL_QUERY);

Regards

Onkar Ahire