I am writing a jdbc application. if

[vkarthik]

I am writing a jdbc application. if i want to install it in somebody's system after finishing, is it always necessary that i install the odbc dsn along with the program. can it b made automatic like some regular setup program? (right now, i create a user dsn using the odbc32 in control panel). if it is possible, how do i modify the java code and where do i put my database file in the target system. any help is appreciated.

luv
Karthik.
LOL A ship is safe in the harbour, but that's not what it is meant for!!! LOL

 

[richardbergquist]

JDBC2 connects to the database in two ways
[1] Thick client
[2] Thin client

The thick client plugs into the locally installed database connectivity software (eg ig it was an Oracle connection, we are speaking of the Oracle client software). As it is calling third party libraries (ie DLL's for ODBC) it is not 100% Java

The thin client does not require any seperate local software to be installed. It uses 100% Java (i.e no local libraries are called). It takes a connection string that completely specfifies the connection (host, port, protocol, DB instance etc).

I'm no expert w/ ODBC as I'm an Oracle type of guy - but yes if you register the ODBC driver with the DriverManager class you should be able to perform a thin connection.

For more info checkout :

http://java.sun.com/products/jdbc/faq.html#2

RjB.