# JSP project with sqlserver database

shubha ke
Greenhorn
Posts: 1
Hi

Installed apache tomcat D:\apache-tomcat-6.0.37,C:\Program Files\Java,microsoft sql server 2005.
Crs is the folder where all my jsp files and database exixts.

Copied crs folder as D:\apache-tomcat-6.0.37\webapps\ROOT\crs and set env variables as below

CATALINA_HOME = D:\apache-tomcat-6.0.37\webapps\ROOT\crs
CLASSPATH = D:\apache-tomcat-6.0.37\lib\servlet-api.jar;D:\apache-tomcat-6.0.37\lib\jsp-api.jar;C:\Program Files\Java\jdk1.6.0_11\lib\tools.jar;
JAVA_HOME = C:\Program Files\Java\jdk1.6.0_11
PATH = C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Java\jdk1.6.0_11\bin

Typing the url http://localhst:8080/crs and click on view conference getting the error.

Thanks

error1.png
error2.png

Saif Asif
Ranch Hand
Posts: 440
Greetings shubha ke and welcome to the ranch .

From the screenshot that you have attached , its quite clear that you are facing a ClassNotFoundException. Make sure that the class mybean/dbcon exists where is it supposed to be. Also you mentioned that you have copied your directory to the D:\apache-tomcat-6.0.37\webapps\ROOT\crs , why inside the ROOT ? it should be outside the ROOT folder.

Bear Bibeault
Author and ninkuma
Marshal
Posts: 64720
86
In the future, please post text rather than images. Images can be hard for some people to see, and are not searchable.