#335: reduce DataBuilder dependencies to i2b2 platform: ant, JVM, JDBC, jboss
--------------------------+------------------------
Reporter: dconnolly | Owner:
Type: enhancement | Status: assigned
Priority: major | Milestone: gpc2sites
Component: data-sharing | Resolution:
Keywords: | Blocked By:
Blocking: |
--------------------------+------------------------
Comment (by dconnolly):
I got this working in one case:
-
[https://bitbucket.org/gpcnetwork/heron_extract/src/?at=onejar_groovy_g355
onejar_groovy_g355]
- 5524966 build CSV files from ant
- see esp. `src/main/dist/run-builder-job.xml`
Ant writes `...,null,...` for null in the CSV output. I hope it doesn't
write the same thing for a four-character string "null".
I'm moving toward queuing jobs in the existing QT_* tables rather than
having a separate data_builder account. The trade-off is that it involves
adding a few columns; I haven't checked in code to do this:
{{{
alter table
blueherondata.qt_query_instance
add (
patient_set int,
date_lo date,
date_hi date
);
alter table blueherondata.qt_query_result_instance
add (
path varchar2(4000)
);
}}}
I also have not committed the SQL code in the middle tier that inserts
this way.
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/335#comment:18>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
