Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
hello, i was searching Oracle 8i driver for jdk1.5, but not getting.i had downloaded classes12.jar from oracle.com and saved in my c:\Program Files\Tomcat\jakarta-tomcat-1.4.31\webapps\ROOT\WEB-INF\lib\ Is this path correct or i've to store it in my ORACLE_H0ME\jdbc\lib ? may be ojdbc14.jar is for jdk1.4? is it possible to download both in the lib folder? Thanks Regards, Vidhi Anto Paul [EMAIL PROTECTED] wrote: On 1/20/06, gupta vidhi 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 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
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
On 1/20/06, gupta vidhi [EMAIL PROTECTED] wrote: hello, i was searching Oracle 8i driver for jdk1.5, but not getting.i had downloaded classes12.jar from oracle.com and saved in my c:\Program Files\Tomcat\jakarta-tomcat-1.4.31\webapps\ROOT\WEB-INF\lib\ Is this path correct or i've to store it in my ORACLE_H0ME\jdbc\lib ? may be ojdbc14.jar is for jdk1.4? is it possible to download both in the lib folder? You need to use either one. and put it in WEB-INF\lib and not ORACLE_HOME\jdbc\lib. You should check the log files there may be more errors in it. First stop Tomcat delete log files start Tomcat and test and post the log files. Check Tomcat console also if you have one. There are other log files mainly stdout, stderr other than localhost*. and post the relevant error messages. Thanks Regards, Vidhi Anto Paul [EMAIL PROTECTED] wrote: On 1/20/06, gupta vidhi 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 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
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
On 1/19/06, gupta vidhi [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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/[EMAIL PROTECTED]: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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. -- rgds Anto Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
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? Anto Paul [EMAIL PROTECTED] 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/[EMAIL PROTECTED]: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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. -- rgds Anto Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Yahoo! Photos Got holiday prints? See all the ways to get quality prints in your hands ASAP.
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
is it necessary to set the path of classes12.jar file? gupta vidhi [EMAIL PROTECTED] 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? 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/[EMAIL PROTECTED]: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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. -- rgds Anto Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Yahoo! Photos Got holiday prints? See all the ways to get quality prints in your hands ASAP. - Yahoo! Photos Showcase holiday pictures in hardcover Photo Books. You design it and well bind it!
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
is it necessary to set the path of classes12.jar file? gupta vidhi [EMAIL PROTECTED] 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? 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/[EMAIL PROTECTED]: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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. -- rgds Anto Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Yahoo! Photos Got holiday prints? See all the ways to get quality prints in your hands ASAP. - Yahoo! Photos Showcase holiday pictures in hardcover Photo Books. You design it and well bind it!
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
On 1/19/06, gupta vidhi [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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/[EMAIL PROTECTED]: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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. -- rgds Anto Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Yahoo! Photos Got holiday prints? See all the ways to get quality prints in your hands ASAP. -- rgds Anto Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
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. i'd set the CLASSPATH of classes12.jar as: C:\Program Files\Tomcat\jakarta-tomcat-4.1.31\webapps\ROOT\WEB-INF\lib Kindly help. Regards, Vidhi David Smith [EMAIL PROTECTED] 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
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
On 1/20/06, gupta vidhi [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
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. Regards, Vidhi Anto Paul [EMAIL PROTECTED] wrote: On 1/18/06, gupta vidhi wrote: hello, i'm using jakarta-tomcat-4.1.31and jdk-1_5_0_02-windows-i586-p-iftw in WIN 2000 Professional. I wish to connect Oracle 8.0(plus) with JSP pages. i request you to kindly tell me how to do this? If you are learning JSP you can connect to a database using JDBC. It is same as using JDBC in any other java application. What you should take care is to put the JDBC driver library in the WEB-INF\lib directory of the application so that Tomcat sees it. -- rgds Anto Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
On 1/18/06, gupta vidhi [EMAIL PROTECTED] 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/[EMAIL PROTECTED]: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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
i'd copied the classes12.zip from C:\jdbc\lib. there's no folder of ORACLE_HOME. now,what else to be done? i'm sending you my JSP page. kindly tell me what code should be written/added to execute it successfully. i'd created the table named as user1 in oracle 8.0 and inserted some values in it. the name of the database in which this table is been created is prime.Regards, VidhiAnto Paul [EMAIL PROTECTED] wrote: On 1/18/06, gupta vidhi <[EMAIL PROTECTED]>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 setti ng 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 herehttp://www-db.stanford.edu/~ullman/fcdb/oracle/or-jdbc.htmlDon't use JDBC-ODBC bridge. From the error message it seems thatit is using JDBC-ODBC bridge.You will get the JDBC driver from ORACLE_HOME\jdbc\lib. For 8i thefile will be classes12.zip. Create a lib directory in WEB-INFdirectory. Tomcat is case sensitive and lib must be in small letters.Copy classes12.zip to WEB-INF\lib and rename it to classes12.jar. Nowto connect to database use the JDBC URL likejdbc:oracle:thin:hr/[EMAIL PROTECTED]: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 injdbc folder for it.--rgdsAnto Paul-To unsubscribe, e-mail: [EMAIL PROTECTED]For additional commands, e-mail: [EMAIL PROTECTED] Yahoo! Photos Got holiday prints? See all the ways to get quality prints in your hands ASAP.- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
On 1/18/06, gupta vidhi [EMAIL PROTECTED] wrote: i'd copied the classes12.zip from C:\jdbc\lib. there's no folder of ORACLE_HOME. now,what else to be done? By ORACLE_HOME I meant where oracle is installed. You cannot attach files while sending mail to this list. The code should look like this %@ page import=java.sql.*% %@ page import=oracle.jdbc.driver.*% % String url = jdbc:oracle:thin:@192.168.4.220:1521:ora9i; String user = scott; String password = tiger; DriverManager.registerDriver(new oracle.jdbc.OracleDriver()); Connection conn = DriverManager.getConnection (url,user, password); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery (select empno from emp); while (rs.next()) { out.print(rs.getString (1) + br); } rs.close(); stmt.close(); conn.close(); % i'm sending you my JSP page. kindly tell me what code should be written/added to execute it successfully. i'd created the table named as user1 in oracle 8.0 and inserted some values in it. the name of the database in which this table is been created is prime. Regards, Vidhi Anto Paul [EMAIL PROTECTED] 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 setti ng 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/[EMAIL PROTECTED]: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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Yahoo! Photos Got holiday prints? See all the ways to get quality prints in your hands ASAP. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- rgds Anto Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
Vidhi wrote: i'd copied the classes12.zip from C:\jdbc\lib. there's no folder of ORACLE_HOME. now,what else to be done? i'm sending you my JSP pagae. kindly tell me what code should be written/added to execute it successfully. i'd created the table named as user1 in oracle 8.0 and inserted some values in it. the name of the database in which this table is been created is prime. Regards, Vidhi I do not use Oracle. I use MS Access driver. From Data Sources (ODBC) in WinXP, after selecting MS Access as your database driver, create a blank database (anything.mdb) and populate it by running MadeDB, which should be run (compiled) from the same folder where you have your database files. Then create a properties file listing the database created and that should go in the class folder of your web application. Maybe for Oracle, you need to copy jdbc classes to lib. But above is for my webapp! Hope it helps.
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
Which version of JVM are you using? Ritchie [EMAIL PROTECTED] 18/01/2006 11:02:31 am Vidhi wrote: i'd copied the classes12.zip from C:\jdbc\lib. there's no folder of ORACLE_HOME. now,what else to be done? i'm sending you my JSP pagae. kindly tell me what code should be written/added to execute it successfully. i'd created the table named as user1 in oracle 8.0 and inserted some values in it. the name of the database in which this table is been created is prime. Regards, Vidhi I do not use Oracle. I use MS Access driver. From Data Sources (ODBC) in WinXP, after selecting MS Access as your database driver, create a blank database (anything.mdb) and populate it by running MadeDB, which should be run (compiled) from the same folder where you have your database files. Then create a properties file listing the database created and that should go in the class folder of your web application. Maybe for Oracle, you need to copy jdbc classes to lib. But above is for my webapp! Hope it helps. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
the one that comes with the latest rel of jre, jre5.0 Which version of JVM are you using? Ritchie [EMAIL PROTECTED] 18/01/2006 11:02:31 am Vidhi wrote: i'd copied the classes12.zip from C:\jdbc\lib. there's no folder of ORACLE_HOME. now,what else to be done? i'm sending you my JSP pagae. kindly tell me what code should be written/added to execute it successfully. i'd created the table named as user1 in oracle 8.0 and inserted some values in it. the name of the database in which this table is been created is prime. Regards, Vidhi I do not use Oracle. I use MS Access driver. From Data Sources (ODBC) in WinXP, after selecting MS Access as your database driver, create a blank database (anything.mdb) and populate it by running MadeDB, which should be run (compiled) from the same folder where you have your database files. Then create a properties file listing the database created and that should go in the class folder of your web application. Maybe for Oracle, you need to copy jdbc classes to lib. But above is for my webapp! Hope it helps. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
I believe that classes12.zip is for Version 1.2 and 1.3 only. JRE5.0 uses 1.5. Your solution would be to download ojdbc14.jar which is for JVM 1.4 or 1.5 and put that in either you application/WEB-INF/lib directory or Tomcat's common/lib directory. Follow this link to download ojdbc14.jar: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html Ritchie [EMAIL PROTECTED] 18/01/2006 12:32 pm the one that comes with the latest rel of jre, jre5.0 Which version of JVM are you using? Ritchie [EMAIL PROTECTED] 18/01/2006 11:02:31 am Vidhi wrote: i'd copied the classes12.zip from C:\jdbc\lib. there's no folder of ORACLE_HOME. now,what else to be done? i'm sending you my JSP pagae. kindly tell me what code should be written/added to execute it successfully. i'd created the table named as user1 in oracle 8.0 and inserted some values in it. the name of the database in which this table is been created is prime. Regards, Vidhi I do not use Oracle. I use MS Access driver. From Data Sources (ODBC) in WinXP, after selecting MS Access as your database driver, create a blank database (anything.mdb) and populate it by running MadeDB, which should be run (compiled) from the same folder where you have your database files. Then create a properties file listing the database created and that should go in the class folder of your web application. Maybe for Oracle, you need to copy jdbc classes to lib. But above is for my webapp! Hope it helps. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database Connectivity of JSP(Tomcat 4.x) with Oracle 8i
On 1/18/06, gupta vidhi [EMAIL PROTECTED] wrote: hello, i'm using jakarta-tomcat-4.1.31and jdk-1_5_0_02-windows-i586-p-iftw in WIN 2000 Professional. I wish to connect Oracle 8.0(plus) with JSP pages. i request you to kindly tell me how to do this? If you are learning JSP you can connect to a database using JDBC. It is same as using JDBC in any other java application. What you should take care is to put the JDBC driver library in the WEB-INF\lib directory of the application so that Tomcat sees it. -- rgds Anto Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]