I'm using the default JDBC-ODBC bridge to read an Access database.
When I mak e a query as simple as SELECT DISTINCT field_a FROM
table_a, it retrieves a ResultSet with as many real rows as expected,
but with a row count equal to the a SELECT * FROM table_a.

I just upgraded from 9.0.3 to 9.0.4 and I'm having problems with the
following code that performs the JNDI lookup to grab the Data source.
Any ideas what's wrong?  I am using the embedded OC4J instance and the
Database connections are setup.  Code works great in 9.0.3, the

  I'm looking for a databases that I can include with my applications
that doesn't required the user to devote time to maintaining the
database other then a simple pack to reclaim space do to deleted rows.
If I was windows only, MS access would be my first choice as a desktop

Have I missed something?
When you use setBinaryStream you must also tell it ahead of time how
many bytes you are going to write.
Yet on the way back out, it won't tell you how many bytes are coming.

Error: ORA-01002: fetch our of sequence
I have searched the groups and BEA's website for a solution.  While I
can find many references to this error, the problems reported and the
situations seem to be different from what I'm experiencing.

I'm new in this newsgroup and perhaps I have a simple question ...
I writing a programm that push data from db1 to db2.
What is faster?
    select * from table1 where id = x

I am trying to figure out whether there is any way to intercept or be
notified when application code obtains a database connection.
Specifically, I need to be able to do some auditing whenever someone
gets a connections and starts issuing statments but I want to do it

Chris Smith wrote: