incubator-oodt-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dave Kale (JIRA)" <>
Subject [jira] Created: (OODT-50) Possible bug in grid configuration stuff
Date Tue, 19 Oct 2010 18:12:27 GMT
Possible bug in grid configuration stuff

                 Key: OODT-50
             Project: OODT
          Issue Type: Bug
          Components: grid
         Environment: OS:          Mac OS X 10.6.4
Java:       Java(TM) SE Runtime Environment (build 1.6.0_20-b02-279-10M3065)
                Java HotSpot(TM) 64-Bit Server VM (build 16.3-b01-279, mixed mode)
Tomcat:   5.5.28
JTDS driver version 1.2.5

Similar setup on Ubuntu linux system.
            Reporter: Dave Kale
            Assignee: Paul Ramirez

Followed Chris Mattmann's 13 steps for setting up XMLPS + grid to access a SQL Server, and
ran into a problem between steps 12 and 13...I pointed grid to my JDBC jar file (jtds-1.2.5.jar),
but upon trying step 13, I got no product and in checking $TOMCAT_HOME/log/catalina.out, I
saw a "no suitable driver found" error:

java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver://[DATABASE]

However, if i manually copy the driver jar into $TOMCAT_HOME/webapps/grid/WEB-INF/lib, works
fine.  Here are Chris's 13 steps, below.  BTW, I'm not convinced that "assembly:assembly"
is needed in step (6).

 1.  svn co latest OODT from trunk
 2.  mvn install from OODT/trunk top level
 3.  cd grid
 4.  mvn package war:war (builds target/web-grid-0.1-incubating.war)
 5.  cd ../xmlps
 6.  mvn package assembly:assembly (builds target/oodt-xmlps-0.1-incubating-with-dependencies.jar)
 7.  create test area, e.g., /usr/local/xmlpstest and copy oodt-xmlps-0.1-incubating-with-dependencies.jar
to it
 8.  copy example conf files out of xmlps/src/main/conf ( and example-ps.xml)
into test area
 9.  modify examples for your database (I used a local postgres instance and I created a simple
mapping file with 2 fields, one dynamic and one constant that queried 1 database)
 10. copy WAR file to $TOMCAT_HOME/webapps/grid.war
 11. visit http://localhost:8080/grid/
 12. Configure web-grid after logging in to use XMLPS handler, to reference your JDBC jar
file (that you copy into /usr/local/xmlpstest), and to reference XMLPS jar file in /usr/local/xmlpstest
 13. try a query at: http://localhost:8080/grid/prod?q=

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message