0 Replies Latest reply on Oct 22, 2002 6:32 AM by Sanjay

    how to connect to POSTGRES  for XSQL from ORACLE

    Sanjay Newbie

      Hello,
      I am facing a serious problem. Actually I am using XSQL Servlet from oracle to execute xsql. But, default its getting connected to oracle.
      Please find below my XSQLConfig.xml file provided by oracle. I have changed the connection element for Postgres. But the thing here I am not getting is the XSQL connection Manager Factory they have asked for and default it points to the oracle factory. Let me know the solution as early as you can.

      XSQLConfig.xml
      ---------------


      <!--

      scott
      tiger
      jdbc:oracle:thin:@localhost:1521:ORCL
      oracle.jdbc.driver.OracleDriver
      true


      xmlbook
      xmlbook
      jdbc:oracle:thin:@localhost:1521:ORCL
      oracle.jdbc.driver.OracleDriver
      true


      system
      manager
      jdbc:Polite:POlite
      oracle.lite.poljdbc.POLJDBCDriver

      -->

      postgres
      postgres
      jdbc:postgresql://172.16.100.15:5432/mydatabase
      org.postgresql.Driver
      true




      I am not getting this block specified by them in the same xml file.

      <!--
      | Set the name of the XSQL Connection Manager Factory
      | implementation. The class must implement the
      | oracle.xml.xsql.XSQLConnectionManagerFactory interface.
      | If unset, the default is to use the built-in connection
      | manager implementation in
      | oracle.xml.xsql.XSQLConnectionManagerFactoryImpl
      +-->
      <!-- <connection-manager>
      oracle.xml.xsql.XSQLConnectionManagerFactoryImpl
      </connection-manager>
      -->


      Thanks & Regards
      Sanjay