473,324 Members | 2,473 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Java vs. .Net support for Oracle

Java JDBC defines four types of database drivers. A type 4 driver is a
native protocol, fully Java-enabled driver. For Oracle, this means the
driver is written to the socket based protocol supported by Oracle's TNS
Listener. Oracle's type 4 driver for Java has been widely used in the Java
community since it does not require an Oracle client to be installed on each
workstation.

A quick look at Oracle's downloads suggests they aren't making it easy for
..Net developers. For Java they provide both type 2 and 4 drivers, where
their type 2 driver even has a small 200K download that installs the
necessary OCI libraries for JDBC only. However, for .Net they only provide
a 75MB Oracle data provider for .Net that requires the Oracle client to be
installed, and also comes with a large, cumbersome, non-redistributable
installation.

Is Oracle or Microsoft planning to rectify this situation by providing an
equivalent to a Java type 4 driver for .Net? It seems a pre-requisite for
commercial software vendors to write .Net applications that interact with
Oracle.

Joe

Nov 13 '05 #1
5 3680
Yes, but it requires that the Oracle client is installed. To the best of my
understanding, the Oracle client is not redistributable with an application.
This means that with .Net I must require that my customers install and
configure the Oracle client on each workstation running our application.
However, with Java and the Oracle thin drivers, I do not have this
restriction (since the thin driver from Oracle does not rely on OCI but on
the TNS protocol).

Joe
Nov 13 '05 #2
If your clients have Oracle at their location, they already have rights to
the Oracle client, and likely have it installed already.

If your application is a web app, only your server(s) should have to access
the database, no end user access should be required.

What is your deployment scenario?

Your situation is pretty much typical for doing any MS development work
against an Oracle back end. It's a PITA but there's not much getting around
it.

"Joe Kinsella" <jk*******@silverbacktech.com> wrote in message
news:uh**************@TK2MSFTNGP10.phx.gbl...
Yes, but it requires that the Oracle client is installed. To the best of my understanding, the Oracle client is not redistributable with an application. This means that with .Net I must require that my customers install and
configure the Oracle client on each workstation running our application.
However, with Java and the Oracle thin drivers, I do not have this
restriction (since the thin driver from Oracle does not rely on OCI but on
the TNS protocol).

Joe

Nov 13 '05 #3
It's a traditional software install, so yes, customers do have rights to the
Oracle client.

You are right that there is no getting around it in .Net today. I guess my
point was that a solution is available for free from Oracle for Java today -
and is quite widely used. In addition, the equivalent OCI solution for Java
is significantly easier than the equivalent for .Net (since it has
redistributable components that do not require the full Oracle client).

Certainly if Oracle can make a client-less solution for Java based on TNS,
they can do the same for .Net. And if Oracle is not planning on providing
this, I would hope Microsoft would be stepping in to fill the gap.

I'm surprised that other .Net developers - particularly those who have
developed with Java - are not finding the available solutions unacceptable.

My current solution is to stay with Java for this area of our product.
Unfortunately, this is not ideal.

Joe
Nov 13 '05 #4
Yes, I think your explanation hits the nail on head: neither Oracle nor
Microsoft has a vested interest in solving this problem. It's pretty clear
this is the case when you compare the connection options available from
Oracle for Java versus .Net.

There is nothing about my appication that makes Java a better option than
..Net. However, it's not acceptable to change our installation to require
customers to install and setup the Oracle client (it will make our
installation significantly more complex; plus we would now need to support
troubleshooting OCI). Therefore the only option available is to go with a
client-less option. Today, this means Java.

I'm not sure if the TNS protocol from Oracle is published or not. I assume
it must be since software companies are providing connectivity products that
rely on the TNS Listener. If so, you would think it would fairly easy for
Microsoft to provide such a product.

Joe
Nov 13 '05 #5
Besides Oracle data provider for .Net, you may have two other choice:

1. SYSTEM.DATA.OLEDB. This only require your client have MDAC and Oracle
client installed.
2. ODP.NET Provided by Oracle:
http://otn.oracle.com/tech/windows/odpnet/content.html

And here may be a good article for reference:

http://www.fawcette.com/vsm/2003_07/...design/default.
asp

Luke

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: asj | last post by:
luke: BORRRRRRRRING......the most interesting initiatives are happening on the client side - in small wireless devices such as cellphones and smartphones, where J2ME has become the de facto...
7
by: Hawkeye | last post by:
I am investigating the Java Stored Procedure, first to gain better understanding on what this is, and also if it would be suitable for a new project which will be running on Sun One AS7 (Client...
1
by: CM | last post by:
Hi, when i want connect me in my BD with a JSP (with this simple code), this exception is throw. Thank's for ur help Mathieu CODE of my JSP ---------------------
11
by: DrUg13 | last post by:
In java, this seems so easy. You need a new object Object test = new Object() gives me exactly what I want. could someone please help me understand the different ways to do the same thing in...
14
by: Tony | last post by:
Can someone a little more clever than I (which means just about anyone on this list) tell me what the implications/benefits are of this are please? ...
1
by: Chuck | last post by:
Hello, Does anyone know if SQL Server supports invoking Java methods from a Stored Procedure or even a Trigger. For example, it looks like oracle provides this capability based on the article...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.