Yes, the login name and password are correct. I created the database name, teh, 
with field username and password, using Microsoft Works Database and saved it 
in directory catalina_home\webapps\ROOT\. I'm not sure whether it is the 
correct directory to put the database. However, in the program there was a 
statement .....(insert into login_table values(?,?)"); I do not understand the 
usage of login_table. Does it mean that I should create login_table in database 
teh? Really need to get this working today. Please help. Thank you.
   
  TEH
 

Foo Shyn <[EMAIL PROTECTED]> wrote:
  Hi,

Is your login name and password correct? It shows 'root' and the 
password is 'root' in the code you posted there.

- I put the database name, teh in directory catalina_home\webapps\ROOT\
hmm i can't really get what you meant here.

Thanx.
FooShyn

Teh Noranis Mohd Aris wrote:
> Dear All,
> 
> I already put mysql database driver (jar file) in directory 
> catalina_home\common\lib and changed 8080 to 3306 but I got the error 
> "java.sql.SQLException: Unable to connect to any hosts due to exception: 
> java.net.ConnectException: Connection refused: connect". What should be the 
> matter? I put the database name, teh in directory 
> catalina_home\webapps\ROOT\. Is this correct? In which directory should I 
> actually put the database name? Please help. I'm running out of time! Thank 
> you so much.
> 
> Yours Sincerely,
> TEH
>
> Foo Shyn wrote:
> Hi,
>
> You'll need to get the MySQL database driver and put them in the 
> {catalina_home}\common\lib folder. The driver can be easily obtained 
> through MySQL site.
> BTW, as far as i know, the default port for MySQL database is 3306, so 
> you might wanna change that. 8080 is for Tomcat, not the database.
>
> Seems like not many new users of connection pooling went through 
> Apache's documents. Please don't waste their effort, take a look at it 
> before you start to attempt anything.
>
> HTH,
> FooShyn
>
> Teh Noranis Mohd Aris wrote:
> 
>> Thank you so much for the reply. I've put "jdbc:mysql://localhost:8080/teh 
>> but I got the error java.lang.ClassNotFoundException: com.mysql.jdbc.Driver. 
>> I'm very new to using mysql database and servlet. Can you please explain to 
>> me how to create the database name and its fields? Should I install any 
>> driver? How can it be done? Please help. Thank you.
>>
>> Yours Sincerely,
>> TEH 
>>
>> Foo Shyn wrote:
>> Hi,
>>
>> yyyy would be ur database port, xxx will be ur database name
>>
>> HTH
>> FooShyn
>>
>> Teh Noranis Mohd Aris wrote:
>>
>> 
>>> Hi,
>>>
>>> I would like to access mysql database from a servlet but I'm not sure what 
>>> to initialize for the String connectionURL marked as 
>>> "jdbc:mysql://localhost:yyyy/xxx" in the program below. I got this program 
>>> from the internet which I would like to run in my computer. Can anyone 
>>> please explain to me what the parameters "yyyy" and "xxx" should be?
>>>
>>> Yours Sincerely,
>>> TEH
>>>
>>> Following is part of the program:
>>> .......
>>> public void doPost(HttpServletRequest request, HttpServletResponse 
>>> response) throws ServletException, IOException{
>>> response.setContentType("text/html");
>>> PrintWriter pw = response.getWriter();
>>> String connectionURL = "jdbc:mysql://localhost:yyyy/xxx";
>>> Connection connection=null;
>>> try{
>>> String username = request.getParameter("username");
>>> String password = request.getParameter("password");
>>> pw.println(username);
>>> pw.println(password);
>>> Class.forName("com.mysql.jdbc.Driver").newInstance();
>>> connection = DriverManager.getConnection(connectionURL, "root", "root");
>>> PreparedStatement pst = connection.prepareStatement
>>> ("insert into login_table values(?,?)");
>>> .......
>>>
>>>
>>> ---------------------------------
>>> Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's 
>>> on, when. 
>>>
>>> ------------------------------------------------------------------------
>>>
>>> No virus found in this incoming message.
>>> Checked by AVG Free Edition. 
>>> Version: 7.5.472 / Virus Database: 269.8.0/821 - Release Date: 5/27/2007 
>>> 3:05 PM
>>>
>>>
>>> 
>> ---------------------------------------------------------------------
>> To start a new topic, e-mail: users@tomcat.apache.org
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>>
>>
>> ---------------------------------
>> Shape Yahoo! in your own image. Join our Network Research Panel today!
>>
>> ------------------------------------------------------------------------
>>
>> No virus found in this incoming message.
>> Checked by AVG Free Edition. 
>> Version: 7.5.472 / Virus Database: 269.8.0/821 - Release Date: 5/27/2007 
>> 3:05 PM
>>
>> 
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
> 
> ---------------------------------
> Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, 
> news, photos & more. 
> 
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition. 
> Version: 7.5.472 / Virus Database: 269.8.0/821 - Release Date: 5/27/2007 3:05 
> PM
> 


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



       
---------------------------------
Choose the right car based on your needs.  Check out Yahoo! Autos new Car 
Finder tool.

Reply via email to