Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using PostgreSQL extensions to the JDBC API

Status
Not open for further replies.

moobob

Programmer
Nov 12, 2002
1
0
0
US
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:

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top