SQLException：找不到适用于jdbc：derby：// localhost：1527的驱动程序

25-02-21 15

如果您想了解SQLException：找不到适用于jdbc：derby：//localhost：1527的驱动程序的相关知识，那么本文是一篇不可错过的文章，我们将为您提供关于ClassNotFound

如果您想了解SQLException：找不到适用于jdbc：derby：// localhost：1527的驱动程序的相关知识，那么本文是一篇不可错过的文章，我们将为您提供关于ClassNotFoundException：com.mysql.jdbc.DriverWeb应用程序的JDBC MySQL驱动程序、ClassNotFoundException：com.mysql.jdbc.Driver。Web应用程序的JDBC MySQL驱动程序、Hibernate-找不到适用于jdbc的驱动程序：mysql // *、java – BIRT JDBCException“无法加载JDBC驱动程序类：com.mysql.jdbc.Driver”从2.6升级到3.7的有价值的信息。

本文目录一览：

SQLException：找不到适用于jdbc：derby：// localhost：1527的驱动程序
ClassNotFoundException：com.mysql.jdbc.DriverWeb应用程序的JDBC MySQL驱动程序
ClassNotFoundException：com.mysql.jdbc.Driver。Web应用程序的JDBC MySQL驱动程序
Hibernate-找不到适用于jdbc的驱动程序：mysql // *
java – BIRT JDBCException“无法加载JDBC驱动程序类：com.mysql.jdbc.Driver”从2.6升级到3.7

SQLException：找不到适用于jdbc：derby：// localhost：1527的驱动程序

如何解决SQLException：找不到适用于jdbc：derby：// localhost：1527的驱动程序？

java.sql.sqlException：找不到适合jdbc：derby：// localhost：1527 /的驱动程序

此异常有两个原因：

驱动程序未加载。
JDBC URL格式错误。

对于你的情况，我希望在连接字符串的末尾看到一个数据库名称。例如（create=true如果要创建不存在的数据库，请使用）：

jdbc:derby://localhost:1527/dbname;create=true

默认情况下，数据库是在启动网络服务器的目录中创建的。但是你也可以指定数据库位置的绝对路径：

jdbc:derby://localhost:1527//home/pascal/derbyDBs/dbname;create=true

并且以防万一，请检查derbyclient.jar是否在类路径上，以及org.apache.derby.jdbc.ClientDriver在服务器模式下工作时是否正在加载适当的驱动程序。

解决方法

我在Netbeans中收到此错误：

java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/

这是怎么引起的，我该如何解决？

ClassNotFoundException：com.mysql.jdbc.DriverWeb应用程序的JDBC MySQL驱动程序

因此，我有一个用于MySQL JDBC驱动程序的.jar文件，该文件位于我的库源文件夹下，并且具有以下代码：

public static Connection getConnection() throws SQLException {
        Connection conn = null;
        try{
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            String url = "jdbc:mysql://50.56.81.42:3306/GUEST_BOOK";
            String user = "user";
            String password = "pass";

            conn = (Connection) DriverManager.getConnection(url,user,password);
        }catch(ClassNotFoundException e){
            e.printStackTrace();
        }catch(InstantiationException e){
            e.printStackTrace();
        }catch(IllegalAccessException e){
            e.printStackTrace();
        }
            return conn;

    }

但是，它总是给我这个错误：

INFO: Server startup in 645 ms
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1678)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1523)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at gbook.DbHelper.getConnection(DbHelper.java:14)
    at gbook.DbHelper.getGuestBook(DbHelper.java:51)
    at org.apache.jsp.index_jsp._jspService(index_jsp.java:83)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:964)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:680)
Dec 1,2011 1:41:05 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [jsp] in context with path [/JDBC-MySQL] threw exception [javax.servlet.ServletException: java.lang.NoClassDefFoundError: com/mysql/jdbc/Connection] with root cause
java.lang.ClassNotFoundException: com.mysql.jdbc.Connection
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1678)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1523)
    at gbook.DbHelper.getGuestBook(DbHelper.java:52)
    at org.apache.jsp.index_jsp._jspService(index_jsp.java:83)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

这是我添加jar文件的方法。我创建了一个lib文件夹，并将jar放入其中，然后在eclipse中配置构建路径，并将lib文件夹中的jar添加到了项目中。

ClassNotFoundException：com.mysql.jdbc.Driver。Web应用程序的JDBC MySQL驱动程序

因此，我有一个用于MySQL JDBC驱动程序的.jar文件，该文件位于我的库源文件夹下，并且具有以下代码：

public static Connection getConnection() throws SQLException {        Connection conn = null;        try{            Class.forName("com.mysql.jdbc.Driver").newInstance();            String url = "jdbc:mysql://50.56.81.42:3306/GUEST_BOOK";            String user = "user";            String password = "pass";            conn = (Connection) DriverManager.getConnection(url, user, password);        }catch(ClassNotFoundException e){            e.printStackTrace();        }catch(InstantiationException e){            e.printStackTrace();        }catch(IllegalAccessException e){            e.printStackTrace();        }            return conn;    }

但是，它总是给我这个错误：

INFO: Server startup in 645 msjava.lang.ClassNotFoundException: com.mysql.jdbc.Driver    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1678)    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1523)    at java.lang.Class.forName0(Native Method)    at java.lang.Class.forName(Class.java:169)    at gbook.DbHelper.getConnection(DbHelper.java:14)    at gbook.DbHelper.getGuestBook(DbHelper.java:51)    at org.apache.jsp.index_jsp._jspService(index_jsp.java:83)    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:964)    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)    at java.lang.Thread.run(Thread.java:680)Dec 1, 2011 1:41:05 PM org.apache.catalina.core.StandardWrapperValve invokeSEVERE: Servlet.service() for servlet [jsp] in context with path [/JDBC-MySQL] threw exception [javax.servlet.ServletException: java.lang.NoClassDefFoundError: com/mysql/jdbc/Connection] with root causejava.lang.ClassNotFoundException: com.mysql.jdbc.Connection    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1678)    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1523)    at gbook.DbHelper.getGuestBook(DbHelper.java:52)    at org.apache.jsp.index_jsp._jspService(index_jsp.java:83)    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

这是我添加jar文件的方法。我创建了一个lib文件夹，并将jar放入其中，然后在eclipse中配置构建路径，并将lib文件夹中的jar添加到了项目中。

答案1

小编典典

您错过了类路径中的mysql-connector-j jar文件。使用“ java -cp。：mysql.jar …”。哦
这是一个webapp！然后把mysql jar文件放到WEB-INF / lib文件夹中。

Hibernate-找不到适用于jdbc的驱动程序：mysql // *

我正在尝试在Web项目引用的Java项目中运行hibernate模式。足够简单，除了无法hibernate以连接到数据库。我有很多人描述这个问题并获得大量答案，但是似乎没有一个对我有用。

这就是我的 hibernate.cfg.xml的 样子：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>
    <!-- Database connection settings -->
     <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
     <property name="hibernate.connection.url">jdbc:mysql//localhost:3306/dbname</property>
     <property name="hibernate.connection.username">root</property>
     <property name="hibernate.connection.password">commander</property>

     <!-- JDBC connection pool (use the built-in) -->
    <property name="connection.pool_size">50</property>

    <!-- SQL dialect -->
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>

    <!-- Enable Hibernate's automatic session context management -->
    <property name="current_session_context_class">thread</property>

    <!-- Enable the second-level cache  -->
    <property name="cache.provider_class">org.hibernate.cache.EhCacheProvider</property>

    <!-- Echo all executed SQL to stdout -->
    <property name="show_sql">true</property>

    <!-- Drop and re-create the database schema on startup -->
    <property name="hbm2ddl.auto">update</property>

    <mapping resource="com/amakena/profile/mapping/Credentials.hbm.xml"/>
    <mapping resource="com/amakena/profile/mapping/Profile.hbm.xml"/>
    <mapping resource="com/amakena/profile/mapping/City.hbm.xml"/>
    <mapping resource="com/amakena/profile/mapping/Country.hbm.xml"/>
    <mapping resource="com/amakena/profile/mapping/Gender.hbm.xml"/>
</session-factory>
</hibernate-configuration>

我将代码调试为 DriverManagerConnectionProvider 类，尝试使用 getConnection（） 方法会引发异常

Connection conn = DriverManager.getConnection(url,connectionProps);

我检查了url和connectionProps，它们是hibernate.cfg.xml中的

我在tomcat \ lib文件夹中添加了 mysql-connector-java-3.1.14-bin
，我可以在Eclipse中的Libraries> Apache Tomcat v6.0>下看到它。我也将它添加到我的％Javahome％\ lib \
ext和我的CLASSPATH变量中（我知道这是绝望的，这是没用的）。

我通过在 session.beginTransaction（） 之前运行以下代码来确保我的驱动程序已正确安装，这反过来导致
DriverManagerConnectionProvider.getConnection（）

Class.forName("com.mysql.jdbc.Driver");
Properties connectionProperties = new Properties();
connectionProperties.put("user","root");
connectionProperties.put("password","root");
DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname",connectionProperties);

我注意到发出第一行会导致相同的异常。

抛出异常

WARNING: Method execution failed: 
org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:99)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at     org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:345)
at $Proxy0.beginTransaction(Unknown Source)
at com.amakena.profile.dao.CredentialsDao.hydrate(CredentialsDao.java:45)
at com.amakena.profile.ProfileManager.login(ProfileManager.java:19)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)
at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)
at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)
at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)
at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)
at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)
at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql//localhost:3306/dbname
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 37 more
WARNING: --Erroring: batchId[24] message[org.hibernate.exception.JDBCConnectionException: Cannot open connection]

我感谢我能得到的所有帮助。提前致谢。

使用的版本：Tomcat v6.0-Hibernate 3.6.6-Java 6-Eclipse 3.5.2 R35x

java – BIRT JDBCException“无法加载JDBC驱动程序类：com.mysql.jdbc.Driver”从2.6升级到3.7

我正在尝试在我的Tomcat服务器上升级我的birt-viewer的版本,但似乎我在加载JDBC驱动程序时出错：

exception.error ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.MysqL.jdbc.Driver. (Element ID:1351)
    at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)
    at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216)
    at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
    at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
    at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
    at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
    at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
    at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
    at org.eclipse.birt.report.engine.layout.html.HTMLInlinestackingLM.resumeLayout(HTMLInlinestackingLM.java:111)
    at org.eclipse.birt.report.engine.layout.html.HTMLInlinestackingLM.layoutNodes(HTMLInlinestackingLM.java:160)
    at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
    at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
    at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
    at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)
    at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
    at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
    at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
    at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
    at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
    at org.eclipse.birt.report.service.ReportEngineservice.runAndRenderReport(ReportEngineservice.java:929)
    at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)
    at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(BirtRunAndRenderActionHandler.java:76)
    at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
    at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(EngineFragment.java:318)
    at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(AbstractBaseFragment.java:76)
    at org.eclipse.birt.report.servlet.BirtEngineservlet.__doGet(BirtEngineservlet.java:120)
    at org.eclipse.birt.report.servlet.BaseReportEngineservlet.doGet(BaseReportEngineservlet.java:185)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.eclipse.birt.report.servlet.BaseReportEngineservlet.service(BaseReportEngineservlet.java:116)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:662)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.MysqL.jdbc.Driver.
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
    at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:158)
    at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
    at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
    at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
    ... 47 more
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.MysqL.jdbc.Driver.
    at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:54)
    at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:177)
    at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
    at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
    at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
    at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
    at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)
    ... 51 more
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.MysqL.jdbc.Driver.
    at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:836)
    at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:941)
    at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:918)
    at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:266)
    at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:232)
    at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:243)
    at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:162)
    at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
    at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
    ... 61 more

我的情况有点特别,因为我不知道我是否做得恰到好处.我自己解释一下.

我有一些使用BIRT 2.6设计的报告和其他一些使用BIRT 3.7设计的报告.我在Tomcat服务器上所做的是我创建了两个存储库：
– birt-viewer
– birt-viewer3.7

我把MysqL驱动程序(mysql-connector-java-5.0.8-bin.jar)文件放在birt-viewer3.7 / WEB-INF / lib /中.

但我仍然有错误.我也尝试将它放在birt-viewer3.7 / WEB-INF / platform / plugins /中,但错误仍然相同.

首先：是否有可能使两个版本的birt-viewer共存？

如果可能,我该怎么做才能解决这个驱动问题？

谢谢.

解决方法

您是否在报表设计中配置了驱动程序？打开报表设计,双击数据源,然后单击“管理驱动程序…”按钮.

今天的关于SQLException：找不到适用于jdbc：derby：// localhost：1527的驱动程序的分享已经结束，谢谢您的关注，如果想了解更多关于ClassNotFoundException：com.mysql.jdbc.DriverWeb应用程序的JDBC MySQL驱动程序、ClassNotFoundException：com.mysql.jdbc.Driver。Web应用程序的JDBC MySQL驱动程序、Hibernate-找不到适用于jdbc的驱动程序：mysql // *、java – BIRT JDBCException“无法加载JDBC驱动程序类：com.mysql.jdbc.Driver”从2.6升级到3.7的相关知识，请在本站进行查询。

本文标签：