|
|
ODBC driver needed need for the java app
Hi,Do anyone have idea of the ODBC driver needed for a simple javaapplication accessing the ORACLE DB? do we need to1. install the oracle client in local (for the ODBC driver) Or2.the ODBC driver for oracle installed with windows will besufficient?Thanks in advance,Mahesh
|
|
0
|
|
|
|
Reply
|
 registered.here (11)
|
3/7/2007 2:12:55 PM |
|
Mahesh wrote:
> Hi,
>
> Do anyone have idea of the ODBC driver needed for a simple java
> application accessing the ORACLE DB? do we need to
> 1. install the oracle client in local (for the ODBC driver) Or
> 2.the ODBC driver for oracle installed with windows will be
> sufficient?
You'd be better off using the JDBC driver. Oracle provides one for free
download (ojdbc,jar - there might be a version number embedded in the name,
I'm not sure).
Snoop around Oracle's database site and you'll find it.
-- Lew
|
|
|
0
|
|
|
|
Reply
|
 Lew
|
3/7/2007 2:23:18 PM
|
|
thanks Lew,I will be installing this app in different machines, so need to knowwhether we need to install any driver or the drver avaialble withwindows is sufficient?Thanks,Mahesh
|
|
|
0
|
|
|
|
Reply
|
Mahesh
|
3/7/2007 2:27:57 PM
|
|
Mahesh wrote:> thanks Lew,> I will be installing this app in different machines, so need to know> whether we need to install any driver or the drver avaialble with> windows is sufficient?Oracle's JDBC drivers are written in Java. Since JDBC is used from Java only, it is safe to assume that there will be Java available on any machine where you use JDBC. It is like any other JAR in the application's classpath that way.-- Lew
|
|
|
0
|
|
|
|
Reply
|
Lew
|
3/7/2007 2:50:31 PM
|
|
Mahesh wrote:> I will be installing this app in different machines, so need to know> whether we need to install any driver or the drver avaialble with> windows is sufficient?Windows doesn't come with any kind of driver for Oracle (unless there'ssomething new in Vista). So whether you use the Oracle JDBC driver or theOracle ODBC driver, you'll have to install /something/ on the users' machines.And the JDBC<->ODBC bridge which comes with Java is not intended for productionuse, so the chances are that the Oracle JDBC driver will work best. -- chris
|
|
|
0
|
|
|
|
Reply
|
Chris
|
3/7/2007 3:24:44 PM
|
|
Mahesh wrote:> I will be installing this app in different machines, so need to know> whether we need to install any driver or the drver avaialble with> windows is sufficient?Actually Oracle comes with 2 JDBC drivers.The OCI requires Oracle Client installed on the system.The thin does not require anything installed on the system.I will strongly recommend the thin JDBC driver.The jar in classpath, load the driver, use thecorrect connection URL and you are going.Arne
|
|
|
0
|
|
|
|
Reply
|
ISO
|
3/13/2007 1:41:57 AM
|
|
|
5 Replies
107 Views
(page loaded in 0.047 seconds)
Similiar Articles: Newbie question: Importing .csv data into Java DB tables - comp ...With a simple iteration you need to write the SQL ... as for (2), but then of course by using an ODBC-driver ... be respected when calling the db from a Java app. using ODBC/JDBC ... ODBC Driver Install - comp.databases.btrieve... to install the Pervasive SQL 2000 ODBC driver onto a W98 client PC, to enable an app ... just isn't worth the hours of time needed ... functionality that they don't need, or ... BTRCALL do i need to get entire record? - comp.databases.btrieve ...I am currently using the ODBC driver and Scalable SQL ... what is a phantom read ? - comp.lang.java ... the entire ... lang.awk... comp.graphics.apps.paint ... do I need ... getResourceAsStream() problem - comp.lang.java.programmer ...> You're supposed to include libraries needed by a web app in the ... That you need to call a method on a completely ... filemaker ... Non-unique columns via ODBC driver ... Connect to database from C++? - comp.lang.c++... to connect to a database, using an ODBC connection, from a C++ application. ... But you'll still need database driver for your system ... to a remote MySQL database using Java ... Accessing BTrieve database from Visual C++/Visual Basic - comp ...Is there some sort of ODBC driver or anything ... It has the drivers needed to access the data. You will need the DDF files ... access 2003...cannot save - comp ... java ... database connection to oracle - comp.unix.solaris... possible to write a platform independent c-application ... all be a lot easier if you did this with Java ... In Mac OSX, there's the "ODBC Import Drivers Installer". Is anybody using Visual Studio to access NonStop SQL tables thru ...I know I need (or believe so) a ... Server Express vs. sqlite ... application does is connect to a SQL database by an ODBC ... ODBC Driver Doesn't Show Up - comp.databases ... text field length - comp.databases.filemaker... tried up; 2) create the recordset you need and use 'em in the application ... When setting up the ODBC driver for FM, in Start ... restricting length of input - comp.lang.java ... copy data from on db to another db - comp.databases.btrieve ...Hi, I am running Pervasive 2003 I need to copy ... Non-unique columns via ODBC driver - comp.lang.perl.misc ... ... Application data back up: Copy the application database to ... JDBC driver - Wikipedia, the free encyclopediaA JDBC driver is a software component enabling a Java application to interact with ... Unlike the type 3 drivers, it does not need ... Open Database Connectivity (ODBC) References Jdbc-Odbc bridge driver create connection between java application ...Jdbc-Odbc bridge driver create connection between java application and 'MS ... Since 'java.sql' class support all the methods needed to create connection. we need to ... 7/30/2012 9:50:34 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
35 followers. 