#335: reduce DataBuilder dependencies to i2b2 platform: ant, JVM, JDBC, jboss
--------------------------+------------------------
Reporter: dconnolly | Owner:
Type: enhancement | Status: closed
Priority: major | Milestone: gpc2sites
Component: data-sharing | Resolution: fixed
Keywords: | Blocked By:
Blocking: |
--------------------------+------------------------
Comment (by gkowalski):
Ahh , lets try :
ant builder-job.run -Djdbc.lib=/Users/gkowalsk/java/jdbc_drivers/
-Djob_id=16833 -Ddataset=mcwOutput
{{{
Buildfile: /Users/gkowalsk/Projects/seine-
minibuilder-0.5-f08eb078cb97/build.xml
builder-job.run:
sql-script.run:
[echo]
[echo] running as FH_CDWDEMODATA_DEV in
jdbc:oracle:thin:@fhoradev.ctsi.mcw.edu:1521:cdwdev1 ...
[echo]
[sql] Executing resource: /Users/gkowalsk/Projects/seine-
minibuilder-0.5-f08eb078cb97/sql-ora/job_extract.sql
[sql] 1 of 1 SQL statements executed successfully
sql-script.run:
[echo]
[echo] running as FH_CDWDEMODATA_DEV in
jdbc:oracle:thin:@fhoradev.ctsi.mcw.edu:1521:cdwdev1 ...
[echo]
[sql] Executing resource: /Users/gkowalsk/Projects/seine-
minibuilder-0.5-f08eb078cb97/sql-ora/variable_extract.sql
[sql] Failed to execute: select QUERY_INSTANCE_ID job_id ,
v.result_instance_id variable_id , v.description variable , v.path key ,
substr(key, instr(v.path, '\', 3)) path from
blueherondata.qt_query_result_instance v where v.QUERY_INSTANCE_ID = 16833
order by result_instance_id
BUILD FAILED
/Users/gkowalsk/Projects/seine-minibuilder-0.5-f08eb078cb97/build-tasks
/builder-job.xml:62: The following error occurred while executing this
line:
/Users/gkowalsk/Projects/seine-minibuilder-0.5-f08eb078cb97/build-tasks
/sql-script.xml:46: java.sql.SQLSyntaxErrorException: ORA-00942: table or
view does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1916)
at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878)
at
oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:773)
at
org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:743)
at
org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:1053)
at
org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:983)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:651)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:435)
at org.apache.tools.ant.Target.performTasks(Target.java:456)
at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
at
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:440)
at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:435)
at org.apache.tools.ant.Target.performTasks(Target.java:456)
at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
at org.apache.tools.ant.Project.executeTarget(Project.java:1364)
at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
at org.apache.tools.ant.Main.runBuild(Main.java:851)
at org.apache.tools.ant.Main.startAnt(Main.java:235)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
Total time: 1 second
CTSI-iMac-gkowalski:seine-minibuilder-0.5-f08eb078cb97 gkowalsk$
}}}
I'm getting the shotgun on this blueherondata thats popping up in the sql
:-)
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/335#comment:35>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
