[rt-users] RT - Java connection

[Todd Chapman]

On Wed, Sep 07, 2005 at 12:11:40PM -0500, Tuvik Beker wrote:
> Hi,
> 
> We are currently looking into RT and would like to connect it to a
> web-application written in Java. The idea is to maintain full RT
> functionality as a standalone ticketing system, but also be able to
> query RT and manipulate tickets from our own Java-based web interface. 
> 
> We considered three options for connecting the two applications:
> 1. Direct calls to Perl methods
> 2. SQL interface (our application already communicates with MySQL)
> 3. Using RT's command-line interface (CLI)
> 
> Java-Perl interfaces seem to be rather poor and cumbersome, unlike the
> pretty good C/C++-Perl connectors out there, so we'll probably skip
> option 1. Between the other two, it seemed the CLI should offer a more
> consistent interface, less prone to future changes than internal
> database table structure. Is that a valid assumption?
> 
> There was one particular problem we came across with the CLI - we didn't
> find a way to search and/or alter custom fields from the command line. I
> read all the documentation I could find and searched the mailing lists,
> but most of the stuff I found was pretty outdated. Can someone enlighten
> me on the status of that issue in the current release?
> 
> Thanks in advance for any inputs,
>   Tuvik
> 

Option 4. Use the RT REST or RTx::Atom interfaces. This avoids the
problem with possible changes to RT API/schema in option 2. Also
should perform better than option 3 unless you can reliably make
the CLI persistent, which probably wouldn't be that hard.

-Todd