You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ctakes.apache.org by "Finan, Sean" <Se...@childrens.harvard.edu> on 2017/03/31 15:16:58 UTC
Calling all ytex experts! Urgent!
Challenging all ytex gurus and officianados ...
One of the main goals for ctakes 4.0 is to get the dictionary databases upgraded from hsqldb 1.8 to the current 2.3.4.
We have lvg and the fast dictionary lookup straightened out, but we are having issues with the ytex dictionary. Can anybody out there push forward and claim the "ytex master" prize by helping us sort this out?
The RM team was hoping to freeze a release candidate today, but time spent on ytex is causing postponement.
Thanks,
Sean
RE: Calling all ytex experts! Urgent!
Posted by "Finan, Sean" <Se...@childrens.harvard.edu>.
Thanks James!
-----Original Message-----
From: James Masanz [mailto:masanz.james@gmail.com]
Sent: Friday, March 31, 2017 12:38 PM
To: dev@ctakes.apache.org
Subject: Re: Calling all ytex experts! Urgent!
The issue I was seeing was caused by this line:
cost double DEFAULT '0',
in ctakes-ytex\scripts\data\hsql\kernel\create_tables.sql
fixed by removing the quotes around the 0 in any double and int declarations
But still if anyone is using ctakes-ytex with hsqlbd 2.3.4 I'd be interested in any hearing if you ran into any other issues
On Fri, Mar 31, 2017 at 11:27 AM, James Masanz <ma...@gmail.com>
wrote:
> Here's the error I'm seeing when I try mvn clean install
> -DskipTests=true
>
> java.sql.SQLSyntaxErrorException: incompatible data types in
> combination
>
> Here's the part of the log
>
> jdbc.sqlcmd:
> [echo] db.schemaPUBLIC
> [echo] umls.schema ${db.schema}
> [echo] umls.catalog
> [echo] execute ./hsql/kernel/create_tables.sql
> [copy] Copying 1 file to C:\Users\james\AppData\Local\Temp
> [echo] executing
> C:\Users\james\AppData\Local\Temp\ytex1924671612.sql
> 31 Mar 2017 11:21:08 INFO ENGINE - open start - state not modified
> 31 Mar 2017 11:21:08 INFO ENGINE - dataFileCache open start
> 31 Mar 2017 11:21:08 INFO ENGINE - dataFileCache open end
> [sql] Executing resource: C:\Users\james\AppData\Local\
> Temp\ytex1924671612.sql
> [sql] Failed to execute: CREATE CACHED TABLE classifier_eval_svm (
> classifier_eval_id int not null , cost double DEFAULT '0', weight
> varchar(50), degree int DEFAULT '0', gamma double DEFAULT 0', kernel
> int NULL, supportVectors int null, vcdim double null )
> 31 Mar 2017 11:21:08 INFO ENGINE - dataFileCache commit start
> 31 Mar 2017 11:21:08 INFO ENGINE - dataFileCache commit end
> 31 Mar 2017 11:21:08 INFO ENGINE - Database closed
>
> On Fri, Mar 31, 2017 at 11:16 AM, Finan, Sean <
> Sean.Finan@childrens.harvard.edu> wrote:
>
>> Challenging all ytex gurus and officianados ...
>>
>> One of the main goals for ctakes 4.0 is to get the dictionary
>> databases upgraded from hsqldb 1.8 to the current 2.3.4.
>>
>> We have lvg and the fast dictionary lookup straightened out, but we
>> are having issues with the ytex dictionary. Can anybody out there
>> push forward and claim the "ytex master" prize by helping us sort this out?
>>
>> The RM team was hoping to freeze a release candidate today, but time
>> spent on ytex is causing postponement.
>>
>> Thanks,
>> Sean
>>
>
>
Re: Calling all ytex experts! Urgent!
Posted by James Masanz <ma...@gmail.com>.
The issue I was seeing was caused by this line:
cost double DEFAULT '0',
in ctakes-ytex\scripts\data\hsql\kernel\create_tables.sql
fixed by removing the quotes around the 0 in any double and int declarations
But still if anyone is using ctakes-ytex with hsqlbd 2.3.4 I'd be
interested in any hearing if you ran into any other issues
On Fri, Mar 31, 2017 at 11:27 AM, James Masanz <ma...@gmail.com>
wrote:
> Here's the error I'm seeing when I try mvn clean install -DskipTests=true
>
> java.sql.SQLSyntaxErrorException: incompatible data types in combination
>
> Here's the part of the log
>
> jdbc.sqlcmd:
> [echo] db.schemaPUBLIC
> [echo] umls.schema ${db.schema}
> [echo] umls.catalog
> [echo] execute ./hsql/kernel/create_tables.sql
> [copy] Copying 1 file to C:\Users\james\AppData\Local\Temp
> [echo] executing C:\Users\james\AppData\Local\Temp\ytex1924671612.sql
> 31 Mar 2017 11:21:08 INFO ENGINE - open start - state not modified
> 31 Mar 2017 11:21:08 INFO ENGINE - dataFileCache open start
> 31 Mar 2017 11:21:08 INFO ENGINE - dataFileCache open end
> [sql] Executing resource: C:\Users\james\AppData\Local\
> Temp\ytex1924671612.sql
> [sql] Failed to execute: CREATE CACHED TABLE classifier_eval_svm (
> classifier_eval_id int not null , cost double DEFAULT '0', weight
> varchar(50), degree int DEFAULT '0', gamma double DEFAULT
> 0', kernel int NULL, supportVectors int null, vcdim double null )
> 31 Mar 2017 11:21:08 INFO ENGINE - dataFileCache commit start
> 31 Mar 2017 11:21:08 INFO ENGINE - dataFileCache commit end
> 31 Mar 2017 11:21:08 INFO ENGINE - Database closed
>
> On Fri, Mar 31, 2017 at 11:16 AM, Finan, Sean <
> Sean.Finan@childrens.harvard.edu> wrote:
>
>> Challenging all ytex gurus and officianados ...
>>
>> One of the main goals for ctakes 4.0 is to get the dictionary databases
>> upgraded from hsqldb 1.8 to the current 2.3.4.
>>
>> We have lvg and the fast dictionary lookup straightened out, but we are
>> having issues with the ytex dictionary. Can anybody out there push forward
>> and claim the "ytex master" prize by helping us sort this out?
>>
>> The RM team was hoping to freeze a release candidate today, but time
>> spent on ytex is causing postponement.
>>
>> Thanks,
>> Sean
>>
>
>
Re: Calling all ytex experts! Urgent!
Posted by James Masanz <ma...@gmail.com>.
Here's the error I'm seeing when I try mvn clean install -DskipTests=true
java.sql.SQLSyntaxErrorException: incompatible data types in combination
Here's the part of the log
jdbc.sqlcmd:
[echo] db.schemaPUBLIC
[echo] umls.schema ${db.schema}
[echo] umls.catalog
[echo] execute ./hsql/kernel/create_tables.sql
[copy] Copying 1 file to C:\Users\james\AppData\Local\Temp
[echo] executing C:\Users\james\AppData\Local\Temp\ytex1924671612.sql
31 Mar 2017 11:21:08 INFO ENGINE - open start - state not modified
31 Mar 2017 11:21:08 INFO ENGINE - dataFileCache open start
31 Mar 2017 11:21:08 INFO ENGINE - dataFileCache open end
[sql] Executing resource:
C:\Users\james\AppData\Local\Temp\ytex1924671612.sql
[sql] Failed to execute: CREATE CACHED TABLE classifier_eval_svm (
classifier_eval_id int not null , cost double DEFAULT '0', weight
varchar(50), degree int DEFAULT '0', gamma double DEFAULT
0', kernel int NULL, supportVectors int null, vcdim double null )
31 Mar 2017 11:21:08 INFO ENGINE - dataFileCache commit start
31 Mar 2017 11:21:08 INFO ENGINE - dataFileCache commit end
31 Mar 2017 11:21:08 INFO ENGINE - Database closed
On Fri, Mar 31, 2017 at 11:16 AM, Finan, Sean <
Sean.Finan@childrens.harvard.edu> wrote:
> Challenging all ytex gurus and officianados ...
>
> One of the main goals for ctakes 4.0 is to get the dictionary databases
> upgraded from hsqldb 1.8 to the current 2.3.4.
>
> We have lvg and the fast dictionary lookup straightened out, but we are
> having issues with the ytex dictionary. Can anybody out there push forward
> and claim the "ytex master" prize by helping us sort this out?
>
> The RM team was hoping to freeze a release candidate today, but time spent
> on ytex is causing postponement.
>
> Thanks,
> Sean
>