File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JSP and the fly likes Can't run a JSP page due to error 500 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Can Watch "Can New topic
Author

Can't run a JSP page due to error 500

Al Kaiser
Ranch Hand

Joined: Nov 20, 2003
Posts: 35
This is the error I get. Wonder if it's a dB error:
500 Internal Server Error
javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "No suitable driver"
at org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport.getConnection(UpdateTagSupport.java:270)
at org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport.doStartTag(UpdateTagSupport.java:151)
at org.apache.taglibs.standard.tag.el.sql.UpdateTag.doStartTag(UpdateTag.java:97)
at _chapter13._dbSetup._jspService(dbSetup.jsp:9)
[/chapter13/dbSetup.jsp]
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:347)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:778)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:536)
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61082
    
  66

Yes, it indicates that you do not have a database driver loaded for the DB. Might help if you filled us in on the details.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Chris Hall
Ranch Hand

Joined: Dec 04, 2002
Posts: 39
Seems like the database driver jar file(s) is not on your classpath.
Nicholas Cheung
Ranch Hand

Joined: Nov 07, 2003
Posts: 4982
In case you got the driver in the classpath, you may also check whether you have downloaded the correct driver.
I have an experience before. I connect to the DB via Servlet. I downloaded DB2 driver db2java.zip, however, it turns out Not Suitable Driver.
I then unzip the file to check whether the driver exists. I found that this is a type 2 driver, which does not contain type 3/4 drivers, while my connection is type 4.
Thus, in case everything seems correct, you may also check this case.
Nick.


SCJP 1.2, OCP 9i DBA, SCWCD 1.3, SCJP 1.4 (SAI), SCJD 1.4, SCWCD 1.4 (Beta), ICED (IBM 287, IBM 484, IBM 486), SCMAD 1.0 (Beta), SCBCD 1.3, ICSD (IBM 288), ICDBA (IBM 700, IBM 701), SCDJWS, ICSD (IBM 348), OCP 10g DBA (Beta), SCJP 5.0 (Beta), SCJA 1.0 (Beta), MCP(70-270), SCBCD 5.0 (Beta), SCJP 6.0, SCEA for JEE5 (in progress)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can't run a JSP page due to error 500