You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@oodt.apache.org by "Dave Kale (JIRA)" <ji...@apache.org> on 2010/10/19 20:12:27 UTC
[jira] Created: (OODT-50) Possible bug in grid configuration stuff
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
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 (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.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OODT-50) Possible bug in grid configuration stuff
Posted by "David Woollard (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OODT-50?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Woollard updated OODT-50:
-------------------------------
Affects Version/s: 0.1-incubating
Fix Version/s: 0.2-incubating
Per mailing list discussion, I am moving this issue to 0.2-incubating as it is not a blocker for 0.1-incubating's release
> 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.2-incubating
>
> 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.
-
You can reply to this email to add a comment to the issue online.