Details
Description
After completion of a new installation using the 1.7.00 Ant scripts and documentation, the jar file for the appropriate database driver is not placed in $JBOSS_HOME/standalone/deployments/i2b2.war/WEB-INF/lib. This results in failure to execute queries in the webclient subsequent to login. JBoss logs NoClassDefFoundError entries in $JBOSS_HOME/standalone/log/server.log as well.
The i2b2 1.7 virtual machine has both sqljdbc4.jar and ojdbc.jar in $JBOSS_HOME/standalone/deployments/i2b2.war/WEB-INF/lib as well as $JBOSS_HOME/standalone/deployments. A current workaround for the installation process is to copy these files down into the i2b2.war/WEB-INF/lib directory.
I suggest the solution is either modification of the Ant scripts, or directions in the documentation to manually copy the appropriate driver. If there is a design reason for having both drivers, rather than just the one needed for the corresponding back-end database, it would be nice if that was documented.
See "i2b2 Install Help" Google Group topic "Once more?" dated 1/31/2014.
https://groups.google.com/forum/#!msg/i2b2-install-help/Mv8gK9x03_Y/7m8DBdFGb5sJ
The i2b2 1.7 virtual machine has both sqljdbc4.jar and ojdbc.jar in $JBOSS_HOME/standalone/deployments/i2b2.war/WEB-INF/lib as well as $JBOSS_HOME/standalone/deployments. A current workaround for the installation process is to copy these files down into the i2b2.war/WEB-INF/lib directory.
I suggest the solution is either modification of the Ant scripts, or directions in the documentation to manually copy the appropriate driver. If there is a design reason for having both drivers, rather than just the one needed for the corresponding back-end database, it would be nice if that was documented.
See "i2b2 Install Help" Google Group topic "Once more?" dated 1/31/2014.
https://groups.google.com/forum/#!msg/i2b2-install-help/Mv8gK9x03_Y/7m8DBdFGb5sJ