Wrox Home  
Search P2P Archive for: Go

  Return to Index  

servlets thread: MYSQL and JDBC 2


Message #1 by "jsplist" <jsplist@w...> on Thu, 14 Nov 2002 16:36:22 -0500
> Hi again. When I try to establish a connection using the code...

import java.sql.*;

I get the error from the command prompt

Exception in thread "main" java.lang.NoClassDefFoundError: 
CreateTable


---------- Original Message ----------------------------------
From: "jsplist" <jsplist@w...>
Reply-To: "Servlets" <servlets@p...>
Date:  Thu, 14 Nov 2002 15:49:05 -0500

>Hello everyone, I'm running tomcat 3.3 on Windows 2000 server and 
>jdsdk1.4.1 and Im trying get the the jdbc driver to see mysql. 
Any 
>Ideas on some good websites that explain this pretty well ?
>
>thanks...
>
>
>
>---------- Original Message ----------------------------------
>From: "Greg Dunn" <greg.dunn@n...>
>Reply-To: "Servlets" <servlets@p...>
>Date:  Thu, 14 Nov 2002 09:08:16 -0600
>
>>It's all in the JavaDocs, which you should read so you know what 
>it's doing,
>>but this is the basic code:
>>
>>StringTokenizer st = new StringTokenizer(myString, "\n\r");
>>while (buf.hasMoreTokens()) {
>>   out.println(buf.nextToken() + "<br>");
>>}
>>
>>
>>Greg
>>
>>
>>
>>-----Original Message-----
>>From: Shashank Arora [mailto:niceguyleo@i...]
>>Sent: Thursday, November 14, 2002 7:46 AM
>>To: Servlets
>>Subject: [servlets] RE: Problems with getParameter() function!!
>>
>>
>>Hey Greg :)
>>
>>thanks 4 ur tip...but i really din't know how do i replace 
>the /n's
>>and /r's when tokenising the given String...can u let me know a 
>bit bout
>>that..it would be really nive if u can write me an exapmle.
>>i know that's a bit of trouble but if u can help me that way 
i'll 
>be so
>>much greatful.
>>
>>Thanks,
>>Shashank Arora
>>
>>> When you read the data to display use a StringTokenizer, and 
>tokenize
>>the \n
>>and \r's, then replace them with <br>.
>>
>>Greg
>>
>>
>>-----Original Message-----
>>From: Shashank Arora [mailto:niceguyleo@i...]
>>Sent: Wednesday, November 13, 2002 9:38 AM
>>To: Servlets
>>Subject: [servlets] Problems with getParameter() function!!
>>
>>
>>Hi :)
>>I am having this very weird problem. I have this html from 
>wherein i am
>>inputtin data using different fields which includes a textarea. 
>and i need
>>the data to be printed at the client end in the same form as it 
is
>>inputted. For that i am using the property of textarea i.e.
>>(wrap=Physical) and when i am accesssin the data f the form 
using 
>the
>>getParameter() function the data seems to be lsing all its 
>formatting..and
>>then it's inserted into the database and when i am displaying 
the 
>data
>>from the database it is displayed as simple single line of text 
>without
>>any formatting like it had when the user entered it using the 
>form.
>>i hope i am clear with my problem but i am not to sure about the 
>area of
>>the problem whether it's realy the getParameter() function or 
>something
>>else that is creating the problem.
>>if anybody can help me out i'll really be so much greatful.
>>
>>Thanks n regards.
>>Shashank Arora
>>---
>>Change your mail options at http://p2p.wrox.com/manager.asp or
>>to unsubscribe send a blank email to 
>>
>>
>>---
>>Change your mail options at http://p2p.wrox.com/manager.asp or
>>to unsubscribe send a blank email to 
>>
>>
>>
>>---
>>Change your mail options at http://p2p.wrox.com/manager.asp or 
>>to unsubscribe send a blank email to leave-servlets-
>1639440V@p...
>>
> 
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or 
>to unsubscribe send a blank email to leave-servlets-
1639440V@p...
>

Where is your Driver class located ?

When you get ClassNotFoundException try to detect where it occurs using: 
printStackTrace(System.out);
catch (ClassNotFoundException cnfe) 
  { 
  System.out.println("ClassNotFoundException: Could not locate driver"); 
  cnfe.printStackTrace(System.out);
  } 

May be your servlet can not find org.gjt.mm.mysql.Driver
try to place org/gjt/mm ... as subfolders of the folder, the servlet class 
is located.


  Return to Index