Mailing-List: contact user-help@uima.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@uima.apache.org
Subject: Re: CAS to RDBS
To: user@uima.apache.org
References: <9EF914716B6C1C4C807A0AAB68AA38BE141CDE3D@UABEXMB5.ad.uab.edu>
From: =?UTF-8?Q?Peter_Kl=c3=bcgl?= <peter.kluegl@averbis.com>
Message-ID: <55D0B787.9010704@averbis.com>
Date: Sun, 16 Aug 2015 18:17:11 +0200
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101
 Thunderbird/38.2.0
MIME-Version: 1.0
In-Reply-To: <9EF914716B6C1C4C807A0AAB68AA38BE141CDE3D@UABEXMB5.ad.uab.edu>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

Georg Fette has posted some time ago on the dev list about a component, 
but I don't know if it fulfills your requirements.

The code is here:
https://github.com/renaud/uima_sql
https://code.google.com/p/uima-sql/

Best,

Peter

Am 16.08.2015 um 17:34 schrieb John David Osborne (Campus):
> Can anybody tell me if there are any UIMA annotators/consumers that can write the CAS to the database in discrete tables dependent on the type system?
>
> I know the entire CAS can be dumped to the database as a varchar/lob but I was looking for something that would create a table for each object in the CAS and write the instances out as rows in that table. So it would have to be smart enough to map an uima.cas.Integer to the appropriate type in the database.
>
> I don't care if it is database specific or not.
>
> I just added some new types and I am not looking forward to writing a bunch of boiler-plate code to save it to the database.
>
> Any advice appreciated,
>
>   -John
>
>