Ticket #602 (closed task: fixed)

Opened 13 years ago

Last modified 13 years ago

[M] exist installation modified to support JDBC

Reported by: mpritcha Owned by: mpritcha
Priority: blocker Milestone: ReFactored_Discovery_WebServices
Component: discovery Version:
Keywords: WS-Discovery2 MDIP Cc:

Description

Current proposed solution to search spatio / temporal info in postgres involves using sql module of exist, to fire off sql query via JDBC from within xquery.

Procedure:

  • Add following to exist/WEB-INF/conf.xml in "builtin-modules" section :

<module class="org.exist.xquery.modules.sql.SQLModule" uri=" http://e xist-db.org/xquery/sql" />

  • Copy postgres JDBC driver jar file (e.g. postgresql-8.1-405.jdbc3.jar) to exist/WEB-INF/lib
  • reload exist context from with tomcat manager

Need to re-do this whenever a new version of exist is installed.

Change History

comment:1 Changed 13 years ago by mpritcha

  • Status changed from new to assigned

comment:2 Changed 13 years ago by mpritcha

  • Status changed from assigned to closed
  • Resolution set to fixed
Note: See TracTickets for help on using tickets.