Hi All, I'm looking for a way to connect to Sybase database at no-license-cost (meaning Oracle Gateway or similar 3rd party products), first coming idea was JDBC, I know I can run a java class in Oracle, the simple idea is to write a java class which connects to Sybase via JDBC thin driver and return the resultset of given query in a java class, the resultset will be presented in Oracle Apex framework. Does anyone know if this can be done or not, and how? Any howto articles are welcomed.
To connect to Sysbase or MsSQL Server you could use jTDS open source driver.
upload above driver (jar file) using loadjava, and grants the port connection using dbms_java.grant_permission procedure.
Because jTDS is pure java driver (mode 4) is possible to use directly inside the RDBMS.
Best regards, Marcelo.
PD: Latest jtds driver is compiled against 1.6 sources, but oldest version will work with 1.5 for 11g.