tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anto Paul <antop...@gmail.com>
Subject Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
Date Fri, 20 Jan 2006 06:56:50 GMT
On 1/20/06, gupta vidhi <vidhi_gupta2002@yahoo.com> wrote:
>   my problem of Tomcat is been solved.now my simple JSP pages(without DB connectivity)
is been solved.
>   but when i'm executing my JSP page(with DB Connectivity) is creating problems and showing
the following error :
>
>   javax.servlet.ServletException: No suitable driver
> at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:498)
> at org.apache.jsp.test_DB1_jsp._jspService(test_DB1_jsp.java:98)
>  and so on.


Are you sure that the classes12.jar is not corrupted ?.

>   i'd set the CLASSPATH of classes12.jar as:
>
>   C:\Program Files\Tomcat\jakarta-tomcat-4.1.31\webapps\ROOT\WEB-INF\lib
>


There is no use of setting the CLASSPATH variable. Tomcat wont take
this for running the application.

If it is not solving your problem you may have to download ojdbc14.jar
from oracle.com and use it as it may be due to the JDK 1.5.


>   Kindly help.
>
>   Regards,
>   Vidhi
>   David Smith <dns4@cornell.edu> wrote:
>   I'd recommend checking that your classes12.jar file is valid. This
> should work:
>
> $JAVA_HOME/bin/jar -v -t -f webapps/ROOT/WEB-INF/lib/classes12.jar
>
> It'll list the table of contents of the archive and be verbose about it.
> Replace -t with -x to extract files for further inspection.
>
> --David
>
> gupta vidhi wrote:
>
> >i'm sending you the whole localhost file:
> > 2006-01-19 12:11:09 HostConfig[localhost]: Deploying configuration descriptor admin.xml
> >2006-01-19 12:11:29 HostConfig[localhost]: Deploying configuration descriptor manager.xml
> >
> >
>
> >....... on and on and on .........
> >
>
> >2006-01-19 12:11:31 HostConfig[localhost]: Deploying web application directory ROOT
> >2006-01-19 12:11:31 StandardHost[localhost]: Installing web application at context
path from URL file:C:\Program Files\Tomcat\jakarta-tomcat-4.1.31\webapps\ROOT
> >2006-01-19 12:11:31 WebappLoader[]: Deploying class repositories to work directory
C:\Program Files\Tomcat\jakarta-tomcat-4.1.31\work\Standalone\localhost\_
> >2006-01-19 12:11:31 WebappLoader[]: Deploy JAR /WEB-INF/lib/classes12.jar to C:\Program
Files\Tomcat\jakarta-tomcat-4.1.31\webapps\ROOT\WEB-INF\lib\classes12.jar
> >2006-01-19 12:11:31 StandardHost[localhost]: ContainerBase.addChild: start:
> >LifecycleException: start: : java.lang.ClassCastException: org.apache.naming.resources.FileDirContext
> > at org.apache.catalina.loader.WebappLoader.start(WebappLoader.java:631)
> > at org.apache.catalina.core.StandardContext.start(StandardContext.java:3486)
> > at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:774)
> > at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:760)
> > at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:548)
> > at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:260)
> > at org.apache.catalina.core.StandardHost.install(StandardHost.java:741)
> > at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:512)
> > at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:354)
> > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:671)
> > at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
> > at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1149)
> > at org.apache.catalina.core.StandardHost.start(StandardHost.java:707)
> > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1141)
> > at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:316)
> > at org.apache.catalina.core.StandardService.start(StandardService.java:450)
> > at org.apache.catalina.core.StandardServer.start(StandardServer.java:2143)
> > at org.apache.catalina.startup.Catalina.start(Catalina.java:463)
> > at org.apache.catalina.startup.Catalina.execute(Catalina.java:350)
> > at org.apache.catalina.startup.Catalina.process(Catalina.java:129)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:585)
> > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:156)
> >----- Root Cause -----
> >java.lang.ClassCastException: org.apache.naming.resources.FileDirContext
> > at org.apache.catalina.loader.WebappLoader.setRepositories(WebappLoader.java:1012)
> > at org.apache.catalina.loader.WebappLoader.start(WebappLoader.java:618)
> > at org.apache.catalina.core.StandardContext.start(StandardContext.java:3486)
> > at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:774)
> > at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:760)
> > at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:548)
> > at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:260)
> > at org.apache.catalina.core.StandardHost.install(StandardHost.java:741)
> > at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:512)
> > at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:354)
> > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:671)
> > at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
> > at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1149)
> > at org.apache.catalina.core.StandardHost.start(StandardHost.java:707)
> > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1141)
> > at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:316)
> > at org.apache.catalina.core.StandardService.start(StandardService.java:450)
> > at org.apache.catalina.core.StandardServer.start(StandardServer.java:2143)
> > at org.apache.catalina.startup.Catalina.start(Catalina.java:463)
> > at org.apache.catalina.startup.Catalina.execute(Catalina.java:350)
> > at org.apache.catalina.startup.Catalina.process(Catalina.java:129)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:585)
> > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:156)
> > 2006-01-19 12:11:31 StandardHost[localhost]: Error deploying application at context
path
> >java.lang.IllegalStateException: ContainerBase.addChild: start: LifecycleException:
start: :
> >
> .... and more semi relevant stuff in the remaining logs .......
>
> >
> > Regards,
> > Vidhi
> >
> >
> >
> >Anto Paul wrote:
> > On 1/19/06, gupta vidhi wrote:
> >
> >
> >>i'd made some JSP & HTML pages(without DB Connectivity) and also execute
them successfully, before copying classes12.jar file in WEB-INF\lib, but now when i'm executing
my pages with or without DB Connec.,they aren't executing and showing the same error as i'd
told you in my previous mail.
> >>now i'm unable to understand, what shud i do,bcoz i'm unable to understand the
problem?
> >>if Tomcat would have not been installed properly,then how could the pages had
executed successfully before.but now the same Tomcat is showing error with every page.
> >>what could be the reason behind this?
> >>
> >>
> >>
> >
> >If other JSP pages work Tomcat is configured properly.
> >As a next step check log files in the logs directory of Tomcat. See
> >the files like localhost*. The error message will be there. Post it.
> >
> >
> >
> >>Anto Paul wrote:
> >>On 1/19/06, gupta vidhi wrote:
> >>
> >>
> >>>Hello,
> >>>thanx for the code.i'd executed but facing some problems.its showing the
following error:
> >>>
> >>>HTTP Status 500 - No Context configured to process this request
> >>>---------------------------------
> >>>
> >>>type Status report
> >>>message No Context configured to process this request
> >>>description The server encountered an internal error (No Context configured
to process this request) that prevented it from fulfilling this request.
> >>>
> >>>---------------------------------
> >>>
> >>>Apache Tomcat/4.1.31
> >>>
> >>>
> >>It should be because that Tomcat is not configured. To test this you
> >>should create a file named index.html with some text in it and try
> >>accessing it. If it works Tomcat is configured. BTW where tomcat is
> >>installed and what is the path to the application you are trying to
> >>access ?.
> >>
> >>
> >>
> >>>as you had asked me to copy classes12.zip from Oracle\jdbc\lib. but i'm bot
finding the jdbc folder in my ORACLE_HOME. its in my :
> >>>C:\oracle1\jdk\lib\classes\sun\jdbc path.now this path don't have lib folder
in it.this jdbc folder consists of odbc folder which again don't have any lib folder.
> >>>
> >>>
> >>>
> >>You should use Search -> Find from Windows start menu to locate the
> >>file classes12.zip or search for jdbc in your computer. If it is not
> >>found you should download it from oracle.com. Ritchie has given the
> >>link in a prevoius post. There you can download driver for any higher
> >>version of Oracle database and it will work for 8.0 also. Put the file
> >>in WEB-INF\lib and restart Tomcat.
> >>
> >>
> >>
> >>
> >>>i feel the above error might be coming bcoz of the same reason.
> >>>now you say, what should i do and what the matter is all about?
> >>>
> >>>Regards,
> >>>
> >>>Vidhi
> >>>Anto Paul wrote:
> >>>On 1/18/06, gupta vidhi wrote:
> >>>
> >>>
> >>>>i've JDBC installed in other path than Tomcat.you asked me to put the
JDBC driver library into WEB-INF\lib. there's WEB-INF directory,but it do not have lib as
its sub directory.what can be done for this?
> >>>>kindly tell me how to do the path setting of JDBC with JSP.
> >>>>i'd made a page in JSP,but when executing its generating error as:
> >>>>
> >>>>javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified
> >>>>and so on.
> >>>>kindly tell how to connect my JSP page with JDBC.
> >>>>
> >>>>
> >>>>
> >>>A JDBC tutorial is here
> >>>http://www-db.stanford.edu/~ullman/fcdb/oracle/or-jdbc.html
> >>>
> >>>Don't use JDBC-ODBC bridge. From the error message it seems that
> >>>it is using JDBC-ODBC bridge.
> >>>You will get the JDBC driver from ORACLE_HOME\jdbc\lib. For 8i the
> >>>file will be classes12.zip. Create a lib directory in WEB-INF
> >>>directory. Tomcat is case sensitive and lib must be in small letters.
> >>>Copy classes12.zip to WEB-INF\lib and rename it to classes12.jar. Now
> >>>to connect to database use the JDBC URL like
> >>>jdbc:oracle:thin:hr/hr@localhost:1521:orcl.
> >>>
> >>>Don't for to restart Tomcat after putting the JAR file in WEB-INF\lib.
> >>>
> >>>The Oracle installation provides some sample Java code. Look in
> >>>jdbc folder for it.
> >>>
> >>>--
> >>>rgds
> >>>Anto Paul
> >>>
> >>>---------------------------------------------------------------------
> >>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >>>For additional commands, e-mail: users-help@tomcat.apache.org
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>---------------------------------
> >>>Yahoo! Photos
> >>>Ring in the New Year with Photo Calendars. Add photos, events, holidays,
whatever.
> >>>
> >>>
> >>>
> >>--
> >>rgds
> >>Anto Paul
> >>
> >>---------------------------------------------------------------------
> >>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >>For additional commands, e-mail: users-help@tomcat.apache.org
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>---------------------------------
> >>Yahoo! Photos
> >>Got holiday prints? See all the ways to get quality prints in your hands ASAP.
> >>
> >>
> >>
> >
> >
> >--
> >rgds
> >Anto Paul
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >For additional commands, e-mail: users-help@tomcat.apache.org
> >
> >
> >
> >
> >
> >---------------------------------
> >Yahoo! Photos � Showcase holiday pictures in hardcover
> > Photo Books. You design it and we�ll bind it!
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
>
>
>
> ---------------------------------
> Yahoo! Photos
>  Got holiday prints? See all the ways to get quality prints in your hands ASAP.
>


--
rgds
Anto Paul
Mime
View raw message