Hi Sean, I have used JdbcWriterTemplate in some private projects using i2b2 https://www.i2b2.org/ The template is actually set up to write to an i2b2-style table by default.
Unfortunately I cannot provide specifics on those configurations, but if you look at JdbcWriterTemplate.xml in ctakes-core's desc/cas_consumer/ you should get an idea of what parameter values you need to set from the <!-- CHANGE ME --> comments. Creating your own copy of that xml descriptor and adding it at the end of a pipeline descriptor should do the trick. If you want to use a piper file then just add those parameter names and values indicated in the descriptor xml using piper commands in a copy of the DefaultFastPipeline.piper in ctakes-clinical-pipeline-res , adding JdbcWriterTemplate to the end of the pipeline. https://cwiki.apache.org/confluence/display/CTAKES/Piper+Files Sean -----Original Message----- From: Mullane, Sean *HS [mailto:sp...@hscmail.mcc.virginia.edu] Sent: Monday, June 05, 2017 10:06 AM To: Finan, Sean; dev@ctakes.apache.org Subject: RE: ctakes 4.0.0 YTEX DBConsumer not populating v_document_cui_sent Do you know of any example code using JdbcWriterTemplate? I'm loathe to abandon a setup that has worked for me in the past but example code would help. Thanks, Sean -----Original Message----- From: Finan, Sean [mailto:sean.fi...@childrens.harvard.edu] Sent: Monday, June 05, 2017 9:03 AM To: dev@ctakes.apache.org Subject: RE: ctakes 4.0.0 YTEX DBConsumer not populating v_document_cui_sent Hi Sean, I am unfamiliar with all things ytex, but a cursory glance at that class makes me think that it is only meant to write an XMI file. You can have a look at JdbcWriterTemplate and its parent AbstractJdbcWriter in ctakes core.cc, which can write to an sql database. Sean -----Original Message----- From: Mullane, Sean *HS [mailto:sp...@hscmail.mcc.virginia.edu] Sent: Friday, June 02, 2017 6:04 PM To: dev@ctakes.apache.org Subject: ctakes 4.0.0 YTEX DBConsumer not populating v_document_cui_sent I am using the DBConsumer AE to write annotations to a SQL Server database, but I can't get it to write out the CUIs to the database. Trying the prettyWriter consumer does show that my pipeline (the default fast piper) is annotating the CUIs; the problem seems to be between that and the YTEX DBConsumer. Can anyone suggest how I might figure out the problem? I have been working through the debugger in Eclipse but haven't had luck so far. I can provide detailed config information upon request. For what it's worth I have had a similar lack of success using the standard XML pipeline descriptor instead of the piper. The odd thing is that I had this working fine in 3.2.2, now when I revisit I can't get it to write CUI annotations to the database either. This leads me to believe this is a configuration issue but again, I have so far been unable to track it down. Thanks, Sean
