[vtp-dev] Error using JDBC jars in VTP Dependencies folder

[Derek Moore]

I'm putting together a little Skunkworks project for my employer, demoing
interactive document retrieval with VTP and dynamic voice grammars derived
from ImageNow views.

I'm trying to add some SQL statements to a script block in a call flow, but
I'm encountering problems adding any sort of JDBC driver for SQL Server. (A
connection to SQL Server is not critical to the demo, but it will help me
clean up license sessions that are rapidly consumed since I can't persist
my ImageNowService Java object for either the life of a call or the life of
a voice app [without implementing my own palette object or an IScriptable].)

I've tried the lastest jars from jTDS & Microsoft, and they both give the
same error, which is basically a broken WAR file that returns 404 from
Tomcat.

Using these JDBC jars, catalina.out contains only the following error on
first deploy:

INFO: Deploying web application archive
/opt/apache-tomcat-7.0.30/webapps/invoic
eIVR.war
Listening on port 0.0.0.0/0.0.0.0:12345 ...
!SESSION 2012-10-05 16:49:19.648
-----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_35
java.vendor=Apple Inc.
BootLoader constants: OS=macosx, ARCH=x86_64, WS=cocoa, NL=en_US
Command-line arguments: -console 12345 -consoleLog
!ENTRY org.eclipse.update.configurator 4 0 2012-10-05 16:49:19.649
!MESSAGE Unable to access file
"/opt/apache-tomcat-7.0.30/work/Catalina/localhos
t/invoiceIVR/eclipse/plugins/NLP.4d97cd42ee6d49f0bcb5b5da73da6ff2_0.0.0/META-INF
/MANIFEST.MF".
INFO|2012/10/05|16:49:19> Host Started


If I restart Tomcat the manifest error goes away, but then this happens:

java.lang.ArrayIndexOutOfBoundsException: 0
at
org.eclipse.vtp.framework.engine.runtime.Blueprint.linkExecutables(Blueprint.java:365)
at
org.eclipse.vtp.framework.engine.runtime.Blueprint.<init>(Blueprint.java:84)
at
org.eclipse.vtp.framework.engine.main.ProcessEngine.createProcess(ProcessEngine.java:327)
at
org.eclipse.vtp.framework.engine.http.Deployment.<init>(Deployment.java:70)
...


I seem to remember using JDBC jars with OpenVXML back in 2007.

I'm using the latest builds of VTP 4.0 from VTP's Indigo update site on OS
X 10.8 & Eclipse 3.7.2.

Any help is appreciated! Thanks!

Derek
--
Derek Moore
Software Engineer
Solution Architecture
Perceptive Software

***@perceptivesoftware.com
www.perceptivesoftware.com

[phone] corporate
[phone] direct
[phone] mobile