作者a46911a149 (a149)
看板java
标题[问题] jsp连接sql遇到之问题
时间Fri Oct 26 20:25:54 2018
今天在写jsp连接到资料库sql的程式。
程式如下
<%}
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
out.println("有驱动程式24 ");
}
catch(ClassNotFoundException ce)
{
out.println("无驱动程式21232 ");
}
Connection h=null;
h = DriverManager.getConnection(""+ +
"jdbc:sqlserver://localhost:1433;user=****;password=****;database=A01");
%>
然而在DriverManager.getConnection 这个步骤遇到问题，我之前有用完全一样的
程式码，在以java写 jdbc并有成功连上。但不知为何在tomcat上的jsp档就出了问题。
差别之一可能是我先前的java语言是在eplice上撰写，而jsp档并不是
(但不知和这个有无相关。) 实际错误讯息如下:
HTTP Status 500 – Internal Server Error
Type Exception Report
Message org.apache.jasper.JasperException: Unable to compile class for JSP
Description The server encountered an unexpected condition that prevented it
from fulfilling the request.
Exception
org.apache.jasper.JasperException: org.apache.jasper.JasperException: Unable
to compile class for JSP
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:586)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:404)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
Root Cause
org.apache.jasper.JasperException: Unable to compile class for JSP
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:619)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:383)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
Root Cause
java.lang.IllegalStateException: java.io.IOException:
java.lang.reflect.InvocationTargetException
org.apache.catalina.webresources.AbstractSingleArchiveResourceSet.getArchiveEntry(AbstractSingleArchiveResourceSet.java:101)
org.apache.catalina.webresources.AbstractArchiveResourceSet.getResource(AbstractArchiveResourceSet.java:256)
org.apache.catalina.webresources.StandardRoot.getResourceInternal(StandardRoot.java:281)
org.apache.catalina.webresources.Cache.getResource(Cache.java:62)
org.apache.catalina.webresources.StandardRoot.getResource(StandardRoot.java:216)
org.apache.catalina.webresources.StandardRoot.getClassLoaderResource(StandardRoot.java:225)
org.apache.catalina.loader.WebappClassLoaderBase.getResourceAsStream(WebappClassLoaderBase.java:1087)
org.apache.jasper.servlet.JasperLoader.getResourceAsStream(JasperLoader.java:139)
org.apache.jasper.compiler.JDTCompiler$1.findType(JDTCompiler.java:198)
org.apache.jasper.compiler.JDTCompiler$1.findType(JDTCompiler.java:183)
org.eclipse.jdt.internal.compiler.lookup.LookupEnvironment.createPackage(LookupEnvironment.java:1094)
org.eclipse.jdt.internal.compiler.lookup.CompilationUnitScope.buildTypeBindings(CompilationUnitScope.java:129)
org.eclipse.jdt.internal.compiler.lookup.LookupEnvironment.buildTypeBindings(LookupEnvironment.java:457)
org.eclipse.jdt.internal.compiler.Compiler.internalBeginToCompile(Compiler.java:838)
org.eclipse.jdt.internal.compiler.Compiler.beginToCompile(Compiler.java:387)
org.eclipse.jdt.internal.compiler.Compiler.compile(Compiler.java:437)
org.eclipse.jdt.internal.compiler.Compiler.compile(Compiler.java:419)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:460)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:392)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:362)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:346)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:603)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:383)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
Root Cause
java.io.IOException: java.lang.reflect.InvocationTargetException
org.apache.tomcat.util.compat.Jre9Compat.jarFileNewInstance(Jre9Compat.java:212)
org.apache.tomcat.util.compat.JreCompat.jarFileNewInstance(JreCompat.java:149)
org.apache.catalina.webresources.AbstractArchiveResourceSet.openJarFile(AbstractArchiveResourceSet.java:307)
org.apache.catalina.webresources.AbstractSingleArchiveResourceSet.getArchiveEntry(AbstractSingleArchiveResourceSet.java:97)
org.apache.catalina.webresources.AbstractArchiveResourceSet.getResource(AbstractArchiveResourceSet.java:256)
org.apache.catalina.webresources.StandardRoot.getResourceInternal(StandardRoot.java:281)
org.apache.catalina.webresources.Cache.getResource(Cache.java:62)
org.apache.catalina.webresources.StandardRoot.getResource(StandardRoot.java:216)
org.apache.catalina.webresources.StandardRoot.getClassLoaderResource(StandardRoot.java:225)
org.apache.catalina.loader.WebappClassLoaderBase.getResourceAsStream(WebappClassLoaderBase.java:1087)
org.apache.jasper.servlet.JasperLoader.getResourceAsStream(JasperLoader.java:139)
org.apache.jasper.compiler.JDTCompiler$1.findType(JDTCompiler.java:198)
org.apache.jasper.compiler.JDTCompiler$1.findType(JDTCompiler.java:183)
org.eclipse.jdt.internal.compiler.lookup.LookupEnvironment.createPackage(LookupEnvironment.java:1094)
org.eclipse.jdt.internal.compiler.lookup.CompilationUnitScope.buildTypeBindings(CompilationUnitScope.java:129)
org.eclipse.jdt.internal.compiler.lookup.LookupEnvironment.buildTypeBindings(LookupEnvironment.java:457)
org.eclipse.jdt.internal.compiler.Compiler.internalBeginToCompile(Compiler.java:838)
org.eclipse.jdt.internal.compiler.Compiler.beginToCompile(Compiler.java:387)
org.eclipse.jdt.internal.compiler.Compiler.compile(Compiler.java:437)
org.eclipse.jdt.internal.compiler.Compiler.compile(Compiler.java:419)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:460)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:392)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:362)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:346)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:603)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:383)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
Root Cause
java.lang.reflect.InvocationTargetException
java.base/jdk.internal.reflect.GeneratedConstructorAccessor9.newInstance(Unknown
Source)
java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:488)
org.apache.tomcat.util.compat.Jre9Compat.jarFileNewInstance(Jre9Compat.java:209)
org.apache.tomcat.util.compat.JreCompat.jarFileNewInstance(JreCompat.java:149)
org.apache.catalina.webresources.AbstractArchiveResourceSet.openJarFile(AbstractArchiveResourceSet.java:307)
org.apache.catalina.webresources.AbstractSingleArchiveResourceSet.getArchiveEntry(AbstractSingleArchiveResourceSet.java:97)
org.apache.catalina.webresources.AbstractArchiveResourceSet.getResource(AbstractArchiveResourceSet.java:256)
org.apache.catalina.webresources.StandardRoot.getResourceInternal(StandardRoot.java:281)
org.apache.catalina.webresources.Cache.getResource(Cache.java:62)
org.apache.catalina.webresources.StandardRoot.getResource(StandardRoot.java:216)
org.apache.catalina.webresources.StandardRoot.getClassLoaderResource(StandardRoot.java:225)
org.apache.catalina.loader.WebappClassLoaderBase.getResourceAsStream(WebappClassLoaderBase.java:1087)
org.apache.jasper.servlet.JasperLoader.getResourceAsStream(JasperLoader.java:139)
org.apache.jasper.compiler.JDTCompiler$1.findType(JDTCompiler.java:198)
org.apache.jasper.compiler.JDTCompiler$1.findType(JDTCompiler.java:183)
org.eclipse.jdt.internal.compiler.lookup.LookupEnvironment.createPackage(LookupEnvironment.java:1094)
org.eclipse.jdt.internal.compiler.lookup.CompilationUnitScope.buildTypeBindings(CompilationUnitScope.java:129)
org.eclipse.jdt.internal.compiler.lookup.LookupEnvironment.buildTypeBindings(LookupEnvironment.java:457)
org.eclipse.jdt.internal.compiler.Compiler.internalBeginToCompile(Compiler.java:838)
org.eclipse.jdt.internal.compiler.Compiler.beginToCompile(Compiler.java:387)
org.eclipse.jdt.internal.compiler.Compiler.compile(Compiler.java:437)
org.eclipse.jdt.internal.compiler.Compiler.compile(Compiler.java:419)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:460)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:392)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:362)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:346)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:603)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:383)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
Root Cause
java.nio.file.NoSuchFileException:
C:\Users\User\Desktop\apache-tomcat-9.0.12\webapps\ROOT\WEB-INF\lib\sqljdbc41.jar
java.base/sun.nio.fs.WindowsException.translateToIOException(WindowsException.java:85)
java.base/sun.nio.fs.WindowsException.rethrowAsIOException(WindowsException.java:103)
java.base/sun.nio.fs.WindowsException.rethrowAsIOException(WindowsException.java:108)
java.base/sun.nio.fs.WindowsFileAttributeViews$Basic.readAttributes(WindowsFileAttributeViews.java:53)
java.base/sun.nio.fs.WindowsFileAttributeViews$Basic.readAttributes(WindowsFileAttributeViews.java:38)
java.base/sun.nio.fs.WindowsFileSystemProvider.readAttributes(WindowsFileSystemProvider.java:194)
java.base/java.nio.file.Files.readAttributes(Files.java:1755)
java.base/java.util.zip.ZipFile$Source.get(ZipFile.java:1220)
java.base/java.util.zip.ZipFile$CleanableResource.<init>(ZipFile.java:727)
java.base/java.util.zip.ZipFile$CleanableResource.get(ZipFile.java:845)
java.base/java.util.zip.ZipFile.<init>(ZipFile.java:245)
java.base/java.util.zip.ZipFile.<init>(ZipFile.java:175)
java.base/java.util.jar.JarFile.<init>(JarFile.java:341)
java.base/jdk.internal.reflect.GeneratedConstructorAccessor9.newInstance(Unknown
Source)
java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:488)
org.apache.tomcat.util.compat.Jre9Compat.jarFileNewInstance(Jre9Compat.java:209)
org.apache.tomcat.util.compat.JreCompat.jarFileNewInstance(JreCompat.java:149)
org.apache.catalina.webresources.AbstractArchiveResourceSet.openJarFile(AbstractArchiveResourceSet.java:307)
org.apache.catalina.webresources.AbstractSingleArchiveResourceSet.getArchiveEntry(AbstractSingleArchiveResourceSet.java:97)
org.apache.catalina.webresources.AbstractArchiveResourceSet.getResource(AbstractArchiveResourceSet.java:256)
org.apache.catalina.webresources.StandardRoot.getResourceInternal(StandardRoot.java:281)
org.apache.catalina.webresources.Cache.getResource(Cache.java:62)
org.apache.catalina.webresources.StandardRoot.getResource(StandardRoot.java:216)
org.apache.catalina.webresources.StandardRoot.getClassLoaderResource(StandardRoot.java:225)
org.apache.catalina.loader.WebappClassLoaderBase.getResourceAsStream(WebappClassLoaderBase.java:1087)
org.apache.jasper.servlet.JasperLoader.getResourceAsStream(JasperLoader.java:139)
org.apache.jasper.compiler.JDTCompiler$1.findType(JDTCompiler.java:198)
org.apache.jasper.compiler.JDTCompiler$1.findType(JDTCompiler.java:183)
org.eclipse.jdt.internal.compiler.lookup.LookupEnvironment.createPackage(LookupEnvironment.java:1094)
org.eclipse.jdt.internal.compiler.lookup.CompilationUnitScope.buildTypeBindings(CompilationUnitScope.java:129)
org.eclipse.jdt.internal.compiler.lookup.LookupEnvironment.buildTypeBindings(LookupEnvironment.java:457)
org.eclipse.jdt.internal.compiler.Compiler.internalBeginToCompile(Compiler.java:838)
org.eclipse.jdt.internal.compiler.Compiler.beginToCompile(Compiler.java:387)
org.eclipse.jdt.internal.compiler.Compiler.compile(Compiler.java:437)
org.eclipse.jdt.internal.compiler.Compiler.compile(Compiler.java:419)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:460)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:392)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:362)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:346)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:603)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:383)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
希望各位不吝提点问题出在何处，谢谢。
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 140.113.129.149
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/java/M.1540556759.A.97F.html
1F：→ inxbone: 有确认java 和 web容器的版本有相容吗？ 10/26 21:21
我安装的java是java10.0.1 tomcat是9.0.12 请问这样否会出问题呢
※ 编辑: a46911a149 (140.113.129.149), 10/26/2018 21:54:51
2F：→ kogrs: 有权限问题吗?看起来有找到jdbc driver jar 但是又有io问题 10/26 22:24
3F：推 swpoker: import啦，jsp编辑没过啦 10/27 07:32
4F：→ a46911a149: 可以请s大说明一下吗@@ 因为我import的语法看不出哪里 10/27 13:40
5F：→ a46911a149: 走错，如果去掉connect那行也没问题 10/27 13:40
6F：→ adrianshum: java.nio.file.NoSuchFileException: 10/27 15:05
7F：→ adrianshum: C:\Users\User\Desktop\apache-tomcat-9.0.12\webapps 10/27 15:05
8F：→ adrianshum: \ROOT\WEB-INF\lib\sqljdbc41.jar 10/27 15:05
9F：→ juice820715: 试试看把getConnection的分号改成逗点?! 11/08 16:29
10F：→ juice820715: "jdbc:sqlserver://localhost:1433/A01”,”username 11/08 17:02
11F：→ juice820715: ”,“password”); 这样试试 11/08 17:02