Skip to Content
author's profile photo Former Member
Former Member

Read/Write Oracle database

Hello all,

I was thinking about having a look at reading from and writing to tables in an Oracle DB.

Immediately I thought about using JCA, but then started thinking... Is JCA only a method of running RFC enabled functions? I used JCo before to connect to R3 and run an RFC enabled function to read from tables. Since Oracle is a DB I'm assuming that it doesn't have functions to be run, just tables to be read/written.

So then I'm thinking JDBC. Is this the way for me? I know that using JDBC will require that I have access to Oracle JDBC drivers, are these freely available or proprietary?

Do any of you have experience with this? It sounded as though it would be so straight forward at first....

As always, any help is greatly appreciated.

P.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 06, 2005 at 11:16 AM

    Hi Patrick,

    you can use JCA as well as JDBC. In my eyes the JCA way is a bit anti-standard, because most frameworks doing persistance stuff for you use JDBC, so it's the more natural way; at least, if you won't ever change the fact that you are accessing a DB (and won't retrieve data some day via another kind of EIS). Anyhow, even JCA uses JDBC if the EIS is a DB...

    For the JCA way, there have been some examples here on SDN in December, it's a pity, I don't find them anymore. Anyhow, I didn't find them very intuitive.

    For JDBC, see for example this topic: How to retrieve data from a MSSQL?

    If you have Oracle, you also will have Oracle Drivers. Alternatively, you can use the SAP Oracle Drivers, see Configuring JDBC Driver for JDBC System

    Hope it helps

    Detlev

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Detlev,

      Thanks again.

      Some time next week I've to go and work on this on a short project. I had a look at the links you posted and I think they'll do the job.

      Thanks for the JCA info as well.

      Patrick.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.