Is there any way to connect database without JDBC?

Thread view:

kevin Liu - 02 Oct 2008 20:10 GMT

Hi,

Anyone has experience to connect database without JDBC? I have a
project, and some application has conflict with JDBC. I have no
control on the application but I still need to connect to database.
Could somebody help me?

Thanks you so much.

Kevin

Reply to this Message

Lew - 03 Oct 2008 02:19 GMT

> Anyone has experience to connect database without JDBC? I have a
> project, and some application has conflict with JDBC. I have no
> control on the application but I still need to connect to database.
> Could somebody help me?

Short of writing your own wire-level protocol for the DBMS engine, I don't
know of a way to do what you ask. What sort of conflict could an application
have with JDBC? Are you sure it's JDBC that's at fault, and not a misuse of
some aspect of it? How are you sure?

Signature

Lew

Reply to this Message

Jeffrey H. Coffield - 03 Oct 2008 02:52 GMT

> Hi,
>
[quoted text clipped - 6 lines]
>
> Kevin

What database?

Jeff

Reply to this Message

kevin Liu - 03 Oct 2008 14:39 GMT

On Oct 2, 9:52 pm, "Jeffrey H. Coffield"
<jeff...@digitalsynergyinc.com> wrote:

> > Hi,
>
[quoted text clipped - 10 lines]
>
> Jeff

We use Oracle, do you have any suggestion?

Thanks,

Kevin

Reply to this Message

Arne Vajhøj - 04 Oct 2008 02:49 GMT

> On Oct 2, 9:52 pm, "Jeffrey H. Coffield"
> <jeff...@digitalsynergyinc.com> wrote:
[quoted text clipped - 4 lines]
>
> We use Oracle, do you have any suggestion?

Considering that Oracle comes with two different JDBC drivers
(thin and OCI based), then I would suggest you start by
trying if switch between them will fix your problem.

You could also consider posting the problem and see if
it could be resolved.

If you have tons of money to waste, then you could bypass
JDBC by writing your own Java classes that uses JNI to
make native calls.

But I really do not see the point.

Arne

Reply to this Message

Jeffrey H. Coffield - 04 Oct 2008 16:47 GMT

> On Oct 2, 9:52 pm, "Jeffrey H. Coffield"
> <jeff...@digitalsynergyinc.com> wrote:
[quoted text clipped - 14 lines]
>
> Kevin

No suggestions is you are using Oracle.

Jeff

Reply to this Message

jlp - 06 Oct 2008 10:13 GMT

Jeffrey H. Coffield a écrit :

>> On Oct 2, 9:52 pm, "Jeffrey H. Coffield"
>> <jeff...@digitalsynergyinc.com> wrote:
[quoted text clipped - 17 lines]
>
> Jeff

Oracle Call Interface ( OCI) + JNI, but you are going to re-invent the
wheel there is yet a JDBC Driver OCI .

Reply to this Message

Thomas Kellerer - 03 Oct 2008 15:40 GMT

kevin Liu wrote on 02.10.2008 21:10:

> Hi,
>
> Anyone has experience to connect database without JDBC?

If that is Oracle you can use ODBC or Oracle's native protocol OCI

If you are dealing with a Java application, then no, there is no way around JDBC.

You should try to solve the problem with the application that has "conflict with
JDBC". Whatever that means.

Thomas

Reply to this Message

kevin Liu - 03 Oct 2008 17:56 GMT

On Oct 3, 10:40 am, Thomas Kellerer <FJIFALSDG...@spammotel.com>
wrote:

> kevin Liu wrote on 02.10.2008 21:10:> Hi,
>
[quoted text clipped - 8 lines]
>
> Thomas

Thanks, I will try both.

Kevin

Reply to this Message

Arne Vajhøj - 04 Oct 2008 02:51 GMT

> If you are dealing with a Java application, then no, there is no way
> around JDBC.

I am not aware that it is prohibited in Java to write a database
API that is not JDBC compliant.

There are not much point, but it is possible.

Arne

Reply to this Message

Thomas Kellerer - 04 Oct 2008 08:26 GMT

Arne Vajhøj wrote on 04.10.2008 03:51:

>> If you are dealing with a Java application, then no, there is no way
>> around JDBC.
[quoted text clipped - 3 lines]
>
> There are not much point, but it is possible.

Thats true.
My "no way around" was more targeted at the senseless attempt to do so :)

Thomas

Reply to this Message

Jeffrey H. Coffield - 04 Oct 2008 16:47 GMT

>> If you are dealing with a Java application, then no, there is no way
>> around JDBC.
[quoted text clipped - 5 lines]
>
> Arne

Unless the database you are connecting to is non-relational and has
features that are not compatible with the relational approach but does
fits Java's object model. Such as RMS on OpenVMS.

Jeff Coffield
www.digitalsynergyinc.com

Reply to this Message

In the Middle of the Pack - 20 Oct 2008 19:31 GMT

> Hi,
>
[quoted text clipped - 6 lines]
>
> Kevin

Maybe it would help to know more about the conflict.
Is it possible that the conflict isn't directly between the application and JDBC, but the way they are used?

Example: A database system I used to work with had several "open" modes. One was "exclusive access." If an application opened the database in this mode, no other application could access the database until that application terminated.

Reply to this Message

Is there any way to connect database without JDBC?

Free Magazines