whats the best/safest way to query a jira internal database with JJUPIN?

[eric anier]

Hi all,

We need to get a data from our internal oracle database and found that sql() routine of Jjupin could be use, but i cant find example and feedback about it if its the best and safe to use?

can anybody help us on this?

Thanks,

eric

[Silviu Burcea · Accepted solution]

Hi,

You can safely use the sql routine. You need to define a new datasource(even for the default JIRA database) and that's it. We also have the free Database Custom Field (DBCF) plugin. You can use it too if you just want to retrieve some data from database.

You can find examples here:

SQL Routine docs

Best regards,

Silviu

[eric anier]

Hi Silviu,

I was able to use the sql() routine with my internal database(Oracle) without defining the datasource, I just use my oracle SID as the JNDIstring and it works well, is this OK?

Also should I not worry about closing the session/connection everytime i use sql() routine?

Thanks,

eric

[Radu Dumitriu]

Yes, it is ok.

Do not bother, we close it correctly on finally so you do not need to care about it. So you should be fine all the time.

[Silviu Burcea]

Hi Eric,

Yes, that's ok, the first parameter is a JNDI name, as long as you have it configured, you can use it. You don't need to worry about session/connection. we handle that for you.

Best,

Silviu

[eric anier]

Thanks a lot guys, jjupin really give us more capability on jira.

[Silviu Burcea]

Hi,

You can safely use the sql routine. You need to define a new datasource(even for the default JIRA database) and that's it. We also have the free Database Custom Field (DBCF) plugin. You can use it too if you just want to retrieve some data from database.

You can find examples here:

SQL Routine docs

Best regards,

Silviu