StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POInsert JSP data into MS Access database?
primarykey
Id
17278016
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2013-06-24T14:31:22.827
FavoriteCount
0
LastActivityDate
2013-06-25T11:59:32.430
LastEditDate
2013-06-25T09:55:16.173
LastEditorUserId
2516590
OwnerUserId
2516590
ParentId
0
PostTypeId
1
Score
0
ViewCount
2053
LastEditorDisplayName
text
Body
<p>I keep getting different errors while trying to insert data retrieved from a html page using JSP into a table in my MS Access database. Everyone time I try to fix or change my code I get a different error. the current error is: </p> <p>(ps. i'm using apache tomcat. my database is called "tico" and "Contacts" is the name of the table. the field names in MS access are "Job Code:" and "TICo's Client:"). If anyone can help, it would be much appreciated. thanks. :)</p> <pre><code>------------------------------------------------------------------------- enter code here HTTP Status 500 - An exception occurred processing JSP page /TICo Website/onejsp.jsp at line 21 type Exception report message An exception occurred processing JSP page /TICo Website/onejsp.jsp at line 21 description The server encountered an internal error that prevented it from fulfilling this request.`` exception org.apache.jasper.JasperException: An exception occurred processing JSP page /TICo Website/onejsp.jsp at line 21 18: url = "jdbc:odbc:tico" 19: /> 20: 21: <sql:update var="tico" scope="request" dataSource ="${tico}"> 22: INSERT INTO Contacts 23: ([Job Code:], [TICo's Client:]) 24: VALUES (?, ?) </code></pre> <hr> <pre><code> Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException (JspServletWrapper.java:521) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:412) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:723) root cause javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified" org.apache.jasper.runtime.PageContextImpl.doHandlePageException (PageContextImpl.java:865) org.apache.jasper.runtime.PageContextImpl.handlePageException (PageContextImpl.java:794) org.apache.jsp.TICo_0020Website.onejsp_jsp._jspService(onejsp_jsp.java:215) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:723) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:723) root cause javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport. getConnection(UpdateTagSupport. java:243) org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport.doStartTag (UpdateTagSupport.jav a:124) org.apache.jsp.TICo_0020Website.onejsp_jsp._jspx_meth_sql_005fupdate_005f0 (onejsp_jsp.java: 264) org.apache.jsp.TICo_0020Website.onejsp_jsp._jspService(onejsp_jsp.java:80) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:723) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:723) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.37 logs. Apache Tomcat/6.0.37 ---------------------------------------------------------------------------------- full stack trace ------------------------------------------------------------------------------- enter code hereJun 25, 2013 9:54:33 AM org.apache.catalina.core.AprLifecycleListener init INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Apache Software Foundation\Tomcat 6.0\bin;C:\Windows\Sun\Java\bin;C: \Windows \system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\System32 \Wbem;C:\Windows \System32\WindowsPowerShell\v1.0\;;. Jun 25, 2013 9:54:33 AM org.apache.coyote.http11.Http11Protocol init INFO: Initializing Coyote HTTP/1.1 on http-8080 Jun 25, 2013 9:54:33 AM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 438 ms Jun 25, 2013 9:54:33 AM org.apache.catalina.core.StandardService start INFO: Starting service Catalina Jun 25, 2013 9:54:33 AM org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/6.0.37 Jun 25, 2013 9:54:33 AM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deploying configuration descriptor manager.xml Jun 25, 2013 9:54:33 AM org.apache.catalina.startup.HostConfig deployDirectory INFO: Deploying web application directory docs Jun 25, 2013 9:54:33 AM org.apache.catalina.startup.HostConfig deployDirectory INFO: Deploying web application directory ROOT Jun 25, 2013 9:54:34 AM org.apache.coyote.http11.Http11Protocol start INFO: Starting Coyote HTTP/1.1 on http-8080 Jun 25, 2013 9:54:34 AM org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8009 Jun 25, 2013 9:54:34 AM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/15 config=null Jun 25, 2013 9:54:34 AM org.apache.catalina.startup.Catalina start INFO: Server startup in 800 ms Jun 25, 2013 10:03:14 AM org.apache.coyote.http11.Http11Protocol pause INFO: Pausing Coyote HTTP/1.1 on http-8080 Jun 25, 2013 10:03:15 AM org.apache.catalina.core.StandardService stop INFO: Stopping service Catalina Jun 25, 2013 10:03:15 AM org.apache.coyote.http11.Http11Protocol destroy INFO: Stopping Coyote HTTP/1.1 on http-8080 Jun 25, 2013 10:03:21 AM org.apache.catalina.core.AprLifecycleListener init INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Apache Software Foundation\Tomcat 6.0\bin;C:\Windows\Sun\Java\bin;C:\Windows \system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C: \Windows \System32\WindowsPowerShell\v1.0\;;. Jun 25, 2013 10:03:21 AM org.apache.coyote.http11.Http11Protocol init INFO: Initializing Coyote HTTP/1.1 on http-8080 Jun 25, 2013 10:03:21 AM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 348 ms Jun 25, 2013 10:03:21 AM org.apache.catalina.core.StandardService start INFO: Starting service Catalina Jun 25, 2013 10:03:21 AM org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/6.0.37 Jun 25, 2013 10:03:21 AM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deploying configuration descriptor manager.xml Jun 25, 2013 10:03:21 AM org.apache.catalina.startup.HostConfig deployDirectory INFO: Deploying web application directory docs Jun 25, 2013 10:03:21 AM org.apache.catalina.startup.HostConfig deployDirectory INFO: Deploying web application directory ROOT Jun 25, 2013 10:03:22 AM org.apache.coyote.http11.Http11Protocol start INFO: Starting Coyote HTTP/1.1 on http-8080 Jun 25, 2013 10:03:22 AM org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8009 Jun 25, 2013 10:03:22 AM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/15 config=null Jun 25, 2013 10:03:22 AM org.apache.catalina.startup.Catalina start INFO: Server startup in 495 ms` </code></pre> <hr> <h2> JSP Page</h2> <pre><code><%@page contentType="text/html" pageEncoding="UTF-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <%@ taglib uri="http://java.sun.com/jstl/core" prefix="c" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %> <html> <head> <title>Using GET and POST Method to Read Form Data</title> </head> <body> <sql:setDataSource var = "tico" scope = "session" driver = "sun.jdbc.odbc.JdbcOdbcDriver" url = "jdbc:odbc:tico" /> <sql:update var="tico" scope="request" dataSource ="${tico}"> INSERT INTO Contacts (Job Code:, TICo's Client:) VALUES (?, ?) <sql:param value = "${param.jobcode}" /> <sql:param value = "${param.ticosclient}" /> </sql:update> <center> <h1>Using GET Method to Read Form Data</h1> <div style="position:absolute; top:20px; width:100%; height:80px;"> <ul> <table align='center' style="width: 1000px; height: 81px;" border="0" cellpadding="0" cellspacing="0" align="center"> <col width="33"> <col width="33"> <col width="33"> <col width="33"></br></br></br> <tr><td> <li><p><b>Job Code:</b> <%= request.getParameter("jobcode")%> </p></li> </td></tr> <tr><td> <li><p><b>TICo's Client:</b> <%= request.getParameter("ticosclient")%> </p></li> </td></tr> </body> </html> </code></pre>
Tags
<html><jsp><ms-access>
Title
Insert JSP data into MS Access database?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USConor Caslin
UserOwnerUserId
1. USConor Caslin
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.