Show me an simple example of Oracle Streams?

java oracle jms oracle-streams
jeph perro picture jeph perro · Oct 26, 2010 · Viewed 8.1k times · Source

I am just getting started with on a project and hope to use Oracle streams.

I am looking for a straight-forward, hello-world type of example using Oracle Streams. Can you point me to a tutorial or show me an example?

Thanks

Answer

Craig picture Craig · Oct 27, 2010

A pretty good resource is the blog: We Do Streams

A good starting point is: Oracle Streams One Way Table Replication 101

Related questions

Java JDBC - How to connect to Oracle using Service Name instead of SID

I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, like this: jdbc:oracle:thin:@oracle.hostserver1.mydomain.ca:1521:XYZ XYZ was the Oracle SID. Now I …

Read More
java.sql.SQLException: - ORA-01000: maximum open cursors exceeded

I am getting an ORA-01000 SQL exception. So I have some queries related to it. Are maximum open cursors exactly related to number of JDBC connections, or are they also related to the statement and resultset objects we have created …

Read More
Using setDate in PreparedStatement

In order to make our code more standard, we were asked to change all the places where we hardcoded our SQL variables to prepared statements and bind the variables instead. I am however facing a problem with the setDate(). Here …

Read More