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