how to access jira DB from my webservice

[safir]

Hi!

I want to create a table into the jira database and insert,update and
select the table information from my webservice.

any one have any idea how to do this.

waiting for any response.

thanks
safir

[Matt Doar]

If possible, create an issue type with custom fields that contain the information you want to save. That way you don't have to change the schema and upgrading is easier. If you do want to modify the schema, change the entitymodel.xml file and add methods to use the normal database delegator object.

~Matt

--
You received this message because you are subscribed to the Google Groups "jira-extended-webservice" group.
To post to this group, send email to jira-extende...@googlegroups.com.
To unsubscribe from this group, send email to jira-extended-webs...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/jira-extended-webservice?hl=en.

[Ath]

Safir,

I wouldn't store any private tables in the same database as Jira is
stored. Not even if the data is directly related to your Jira
instance.
The solution Matt gives is the easiest way, using custom fields if you
need to, but if a lookup table, for example holding customer
information, is to be referenced, you'd better create a plugin (if
that's not yet available, I wouldn't know) and connect to your
external database from the plugin, not the other way around.

If you just need a totally un-related database-table on the same
server, then ask the database maintainer/owner for an account to your
private database, still away from the Jira db, and connect that in the
usual way from your application.

HTH