473,378 Members | 1,438 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,378 software developers and data experts.

How to connect Jsp with Databases

Hi all,

My pc has installed Tomcat5.0.12 and j2sdk1.4.2_03. I want to develop
jsp for my project. My question is that i want to access the database
such as oracle 9i or mysqL which is not install in my PC.They come
from web hosting company Should i need to install the jdbc driver in
my local PC in order to get the connection.Could anyone tell me some
basic steps that can use to find and set up the jdbc drivers.

Thx !

JSP Beginner
Jul 17 '05 #1
2 4684
<ka*******@hotmail.com> wrote in message
news:d8**************************@posting.google.c om...
Hi all,

My pc has installed Tomcat5.0.12 and j2sdk1.4.2_03. I want to develop
jsp for my project. My question is that i want to access the database
such as oracle 9i or mysqL which is not install in my PC.They come
from web hosting company Should i need to install the jdbc driver in
my local PC in order to get the connection.Could anyone tell me some
basic steps that can use to find and set up the jdbc drivers.

Thx !

JSP Beginner


http://java.sun.com/docs/books/tutor...ics/index.html
Jul 17 '05 #2
There are many JDBC tutorials online. This is Sun's:
http://java.sun.com/docs/books/tutorial/jdbc/index.html

These two pages will get you up and running:
http://java.sun.com/docs/books/tutor...onnecting.html
http://java.sun.com/docs/books/tutor...etrieving.html

The only twist with JSP is getting the JDBC driver into the classpath.
I usually put the jar file in the /WEB-INF/libs directory.

-Nathan

ka*******@hotmail.com wrote in message news:<d8**************************@posting.google. com>...
Hi all,

My pc has installed Tomcat5.0.12 and j2sdk1.4.2_03. I want to develop
jsp for my project. My question is that i want to access the database
such as oracle 9i or mysqL which is not install in my PC.They come
from web hosting company Should i need to install the jdbc driver in
my local PC in order to get the connection.Could anyone tell me some
basic steps that can use to find and set up the jdbc drivers.

Thx !

JSP Beginner

Jul 17 '05 #3

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

Similar topics

20
by: Mr Dygi | last post by:
Hi, PHP 4.3.4 installed manually from package *.zip and Apache 2. I have a problem with this simple code: <?php $link = mysql_connect("127.0.0.1","","") or die("Could not connect: " ....
10
by: Ed Stevens | last post by:
A tale of woe, and a question . . . Last week my boss said to me "we've installed DB2 Connect on this Solaris box. Make it work." Now, I've barely seen DB2 Connect on Windows, having fumbled...
1
by: Dave | last post by:
I am trying to learn .NET with the standard edition of VC++.NET 2003 Standard edition. When I use the wizard in the toolbox to connect to a non-microsoft ODBC data source, I get the error message...
4
by: Frank | last post by:
Hi I am a poor student studying towards my MCSD. I have managed to get a cheapish student version of vb.net. Problem is that this version does not connect to sql databases and I need it to...
1
by: Tom Andersen | last post by:
Hi all Im trying to install DB2 Connect from a central installation point. and the program installs as it should, on the target machine, Is there a way to implement the databases into the...
2
by: vikas.bhatia | last post by:
Is this still true? http://groups.google.com/group/comp.databases.ibm-db2/browse_thread/thread/58c6c36ce9006d50/778f98749d8e2983?lnk=st&q=DB2+Connect+product+license&rnum=6#778f98749d8e2983 would...
4
by: gwise | last post by:
We're running DB2 v8.2 (fix pak 11) on Red Hat Linux Enterprise 3 (kernel 2.4.21-32) on Itanium (IA64). For a few months now, we've had a recurring problem where a shell script that we run nightly...
3
by: cberthu | last post by:
Hi all, Is it possible to have two connects in the same rexx script to different DB's? I have to get data form on DB (with specifics selects and filter out some values with RExx) and save the...
5
by: Alan Silver | last post by:
Hello, Server configuration: Windows 2003 Server SP2 SQL Server 2000 SP4 ..NET v2.0.50727 just built up a new server using the same configuration as my current one. I even used the same CDs...
7
by: sanjay | last post by:
Hi to all the people. please will u tell how can i Connect to the Database through C program. i have No clarity in that.
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.