database connectivity

[Jimi Rock]

Hi all,
I have an Access database and jdk 1.3. I want to query my database through a jsp page using beans.
what I need to connect to my database? any separate installation is required in order to use jdbc?
Regards,
mac.

[Jimi Rock]

plz some one answer me!!!
it urgent.
Regards.

[parul patidar]

no seperate installation as long as u r willing to use jdbc.odbc.JdbcOdbcDriver
u need to import java.sql package
and load sun.jdbc.odbc.JdbcOdbcDriver using Class.forName()

[Jimi Rock]

Hi,
thanks for reply.
can u provide me with the segment of code that will do the connection part?
Regards.
mac.

[Bosun Bello]

here is an example from one of my books....

try
{
// Load the driver class
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// Define the data source for the driver
String sourceURL = "jdbc dbc:yourDataSourceName";
// Create a connection through the DriverManager
Connection databaseConnection =
DriverManager.getConnection(sourceURL);
}
catch(ClassNotFoundException cnfe)
{
System.err.println(cnfe);
}
catch(SQLException sqle)
{
System.err.println(sqle);
}
}

------------------
Bosun

[Jimi Rock]

Hi Bosun,
thanks a lot for ur reply...
I have tried the code but have the following error:
"Data source name not found and no default driver specified"
this is may be becauae my connection url. I want to connect to an access database using jsp. servlet engine is tomcat.
what to do then?
Thanks in advance,
mac.

[Pranit Saha]

U have to connect the database with ur frontend through Jdbc/Odbc driver.. and for that u have to use ODBC and connect through System DSN..
Pranit..

Originally posted by Jimi Rock:
Hi Bosun,
thanks a lot for ur reply...
I have tried the code but have the following error:
"Data source name not found and no default driver specified"
this is may be becauae my connection url. I want to connect to an access database using jsp. servlet engine is tomcat.
what to do then?
Thanks in advance,
mac.

[Jimi Rock]

Hi Pranit,
can u tell plz how to connect to system DSN?
Thanks.

[Pranit Saha]

Assuming that u r using Windows.. Go to start->settings->control panel->ODBC drivers->click on system DSN.. and follow the steps as it says.. tell me if u face ne prob
Pranit..

[Jimi Rock]

Hi Pranit,
finally I have got it...
saying "Thank you" cannot express my appreciation...
Regards,
mac.

[Pranit Saha]

It's nice to hear that u've solved ur prob.. U r always welcome..
Pranit..

Originally posted by Jimi Rock:
Hi Pranit,
finally I have got it...
saying "Thank you" cannot express my appreciation...
Regards,
mac.