I am trying to convert Oracle Stored Procedures to PostgreSQl. According to the PostgreSQL documentation, the way to do this is by using their extensions to the JDBC API which allows you to add your own functions to the backend, which can then be called from queries. Following the example in the PostgreSQL 7.2.1 Documentation, Chapter 8. JDBC Interface, which says to do the following:
When I compile, it complains about not knowing about the Connection class. It does not complain about the import statement.
My questions are:
- Is this the best way to convert Oracle stored procedures to PostgreSQL?
- If so, what am I missing to get this to compile?
Thanks in advance,
Bob
Code:
import org.postgresql.fastpath.*;
...
Fastpath fp = ((org.postgresql.Connection)db).getFastpathAPI();
When I compile, it complains about not knowing about the Connection class. It does not complain about the import statement.
My questions are:
- Is this the best way to convert Oracle stored procedures to PostgreSQL?
- If so, what am I missing to get this to compile?
Thanks in advance,
Bob