[jira] Commented: (OODT-50) Possible bug in grid configuration stuff

["Chris A. Mattmann (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OODT-50?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13002707#comment-13002707 ] 

Chris A. Mattmann commented on OODT-50:
---------------------------------------

I'm tempted to call this fixed :)

We just deployed a brand new config out of SVN and it seems to work, at least at CHLA.

A couple of notes:

1. I baked in the config to the web grid instance, and put the JTDS as a mvn dependency on the inherited project.
2. I didn't do assembly:assembly, as dave noted, I just included xmlps as a mvn dependency on the inherited project.


> Possible bug in grid configuration stuff
> ----------------------------------------
>
>                 Key: OODT-50
>                 URL: https://issues.apache.org/jira/browse/OODT-50
>             Project: OODT
>          Issue Type: Bug
>          Components: grid
>    Affects Versions: 0.1-incubating
>         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
>             Fix For: 0.3
>
>   Original Estimate: 672h
>  Remaining Estimate: 672h
>
> 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 (example.db.properties 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.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira