postgresql « oracle « Java Database Q&A

1. What is the equivalent of Oracle's REF CURSOR in Postgresql when using JDBC? stackoverflow.com

In Oracle I can declare a reference cursor...

TYPE t_spool IS REF CURSOR RETURN spool%ROWTYPE;

...and use it to pass a cursor as the return value...

FUNCTION end_spool
    RETURN t_spool
  ...

2. Oracle to Postgres data transfer stackoverflow.com

A couple of years ago I wrote a small utility to move data from an Oracle db to a Postgres db. I used Java and JDBC to accomplish this because I ...

3. Performance Testing Various Databases stackoverflow.com

I am currently testing a few different relational database management systems. (MySQL, PostgreSQL, Oracle and Firebird SQL) using a Java application to do so. I was debating what tests I should run ...

4. Are long high volume transactions bad stackoverflow.com

Hallo, I am writing a database application that does a lot of inserts and updates with fake serialisable isolation level (snapshot isolation). To not do tonnes of network roundtrips I'm batching inserts and ...

5. Oracle 10g to Postgresql 8.1 coderanch.com

I have 2 PC's on a network. PC1 and PC2. PC1 has an Oracle 10g database. PC2 has a Postgresql 8.1 database. I need to tranfer data on a regular basis, which will include Insert and Update, from PC1 (Oracle) to PC2 (Postgresql). There are about 7 tables from the Oracle database that need to be transferred. Some of the Oracle ...

6. PostgreSQL / Oracle - Optimization coderanch.com

7. Postgresql connection from oracle jdeveloper forums.oracle.com

It gives this error Could not load the driver java.lang.ClassNotFoundException: org.postgresql.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:199) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:187) at java.lang.ClassLoader.loadClass(ClassLoader.java:289) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274) at java.lang.ClassLoader.loadClass(ClassLoader.java:235) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at mypackage1.JDBCTest.main(JDBCTest.java:23) Connecting to the local database java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:532) at java.sql.DriverManager.getConnection(DriverManager.java:171) at mypackage1.JDBCTest.main(JDBCTest.java:40) Exception in thread main Process exited with exit code 1. I need urgent ...