个人中心
gpt4 book ai didi

mysql - C3P0 0.9.5-pre6 与 Jetty 9.1

转载 作者：行者123 更新时间：2023-11-29 00:22:06 25 4
gpt4 key购买 nike

我已经成功地将 C3P0 0.9.1.2 与 Jetty 8.1.13.v20130916 结合使用。在我的 Jetty 服务器实例中，我使用 Jetty XML 配置文件将 C3P0 支持的 DataSource 绑定(bind)到 JNDI。然后我的 Web 应用程序按名称查找此 DataSource。这一直有效。

我目前正在迁移到 C3P0 0.9.5-pre6 和 Jetty 9.1.0.v20131115。

自这次迁移以来，C3P0 连接池不再起作用。我尝试了不同的非合并和合并策略。

自迁移以来，以下两个unpooled绑定(bind)策略有效:

<Configure id="Server" class="org.eclipse.jetty.server.Server">
  ....
  <!-- raw mysql connection without C3P0 - THIS WORKS! -->
  <New id="jdbc-myds" class="org.eclipse.jetty.plus.jndi.Resource">
    <Arg></Arg>
    <Arg>jdbc/myds</Arg>
    <Arg>
      <New class="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource">
        <Set name="Url">jdbc:mysql://localhost:3306/myds?useUnicode=true&amp;characterEncoding=UTF-8</Set>
        <Set name="User">user</Set>
        <Set name="Password">pass</Set>
      </New>
    </Arg>
  </New>
</Configure>
<Configure id="Server" class="org.eclipse.jetty.server.Server">
  ....
  <!-- UNPOOLED c3p0 factory - THIS WORKS! -->
  <New id="jdbc-myds" class="org.eclipse.jetty.plus.jndi.Resource">
    <Arg></Arg>
    <Arg>jdbc/myds</Arg>
    <Arg>
      <Call class="com.mchange.v2.c3p0.DataSources" name="unpooledDataSource">
        <Arg>jdbc:mysql://localhost:3306/myds?useUnicode=true&amp;characterEncoding=UTF-8</Arg>
        <Arg>user</Arg>
        <Arg>pass</Arg>
      </Call>
    </Arg>
  </New>
</Configure>

自迁移以来，以下两个合并绑定(bind)策略不起作用:

<Configure id="Server" class="org.eclipse.jetty.server.Server">
  ....
  <!-- typical C3P0 pool configuration - THIS DOESN'T WORK FOR ME SINCE MIGRATION -->
  <New id="jdbc-myds" class="org.eclipse.jetty.plus.jndi.Resource">
    <Arg></Arg>
    <Arg>jdbc/myds</Arg>
    <Arg>
      <New class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <Set name="DriverClass">com.mysql.jdbc.Driver</Set>
        <Set name="JdbcUrl">jdbc:mysql://localhost:3306/myds?useUnicode=true&amp;characterEncoding=UTF-8</Set>
        <Set name="User">user</Set>
        <Set name="Password">password</Set>
      </New>
    </Arg>
  </New>
</Configure>
<Configure id="Server" class="org.eclipse.jetty.server.Server">
  ....
  <!-- wrapping the successfully working C3P0 unpooled DataSource in a pooled DataSource - THIS DOESN'T WORK -->
  <New id="jdbc-myds" class="org.eclipse.jetty.plus.jndi.Resource">
    <Arg></Arg>
    <Arg>jdbc/myds</Arg>
    <Arg>
      <Call class="com.mchange.v2.c3p0.DataSources" name="pooledDataSource">
        <Arg>
          <Call class="com.mchange.v2.c3p0.DataSources" name="unpooledDataSource">
            <Arg>jdbc:mysql://localhost:3306/myds?useUnicode=true&amp;characterEncoding=UTF-8</Arg>
            <Arg>user</Arg>
            <Arg>pass</Arg>
          </Call>
        </Arg>
      </Call>
    </Arg>
  </New>
</Configure>

在不成功的情况下，当访问服务器时，服务器的 HTTP 响应是 Jetty 服务的 HTTP ERROR: 503, Service Unavailable。
尽管服务器启动日志显示 JNDI 资源已成功注册，但目前我正尝试在我的 Web 应用程序中按名称访问该 JNDI 资源，但它已不存在:调用 

DataSource myds = new InitialContext().lookup("java:comp/env/jdbc/myds");

抛出 InvalidClassException 和 NamingException:

17:08:33.907 [main] WARN  jndi -
java.io.InvalidClassException: com.mchange.v2.c3p0.WrapperConnectionPoolDataSource; local class incompatible: stream classdesc serialVersionUID = -7086951306718003710, local class serialVersionUID = 7806429541739165290
        at java.io.ObjectStreamClass.initNonProxy(ObjectStreamClass.java:617) ~[na:1.7.0_45]
        at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1622) ~[na:1.7.0_45]
        at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1517) ~[na:1.7.0_45]
        at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1771) ~[na:1.7.0_45]
        at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350) ~[na:1.7.0_45]
        at java.io.ObjectInputStream.readObject(ObjectInputStream.java:370) ~[na:1.7.0_45]
        at com.mchange.v2.ser.SerializableUtils.deserializeFromByteArray(SerializableUtils.java:132) ~[mchange-commons-java-0.2.6.3.jar:0.2.6.3]
        at com.mchange.v2.ser.SerializableUtils.fromByteArray(SerializableUtils.java:111) ~[mchange-commons-java-0.2.6.3.jar:0.2.6.3]
        at com.mchange.v2.naming.JavaBeanObjectFactory.createPropertyMap(JavaBeanObjectFactory.java:98) ~[mchange-commons-java-0.2.6.3.jar:0.2.6.3]
        at com.mchange.v2.naming.JavaBeanObjectFactory.getObjectInstance(JavaBeanObjectFactory.java:59) ~[mchange-commons-java-0.2.6.3.jar:0.2.6.3]
        at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321) ~[na:1.7.0_45]
        at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:476) [jetty-jndi-9.1.0.v20131115.jar:9.1.0.v20131115]
        at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:518) [jetty-jndi-9.1.0.v20131115.jar:9.1.0.v20131115]
        at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:533) [jetty-jndi-9.1.0.v20131115.jar:9.1.0.v20131115]
        at javax.naming.InitialContext.lookup(InitialContext.java:411) [na:1.7.0_45]
        at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:468) [jetty-jndi-9.1.0.v20131115.jar:9.1.0.v20131115]
        at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:536) [jetty-jndi-9.1.0.v20131115.jar:9.1.0.v20131115]
        at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:536) [jetty-jndi-9.1.0.v20131115.jar:9.1.0.v20131115]
        at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:536) [jetty-jndi-9.1.0.v20131115.jar:9.1.0.v20131115]
        at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:551) [jetty-jndi-9.1.0.v20131115.jar:9.1.0.v20131115]
        at org.eclipse.jetty.jndi.java.javaRootURLContext.lookup(javaRootURLContext.java:117) [jetty-jndi-9.1.0.v20131115.jar:9.1.0.v20131115]
        at javax.naming.InitialContext.lookup(InitialContext.java:411) [na:1.7.0_45]
        at com.example.spring.config.MainConfig.dataSource(MainConfig.java:65) [classes/:na]
        at com.example.spring.config.MainConfig$$EnhancerByCGLIB$$8673699d.CGLIB$dataSource$0(<generated>) [cglib-nodep-2.2.2.jar:na]
        at com.example.spring.config.MainConfig$$EnhancerByCGLIB$$8673699d$$FastClassByCGLIB$$554d588d.invoke(<generated>) [cglib-nodep-2.2.2.jar:na]
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) [cglib-nodep-2.2.2.jar:na]
        at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:280) [spring-context-3.1.2.RELEASE.jar:3.1.2.RELEASE]
        at com.example.spring.config.MainConfig$$EnhancerByCGLIB$$8673699d.dataSource(<generated>) [cglib-nodep-2.2.2.jar:na]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_45]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_45]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_45]
        at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_45]
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:149) [spring-beans-3.1.2.RELEASE.jar:3.1.2.RELEASE]
        at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:570) [spring-beans-3.1.2.RELEASE.jar:3.1.2.RELEASE]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1015) [spring-beans-3.1.2.RELEASE.jar:3.1.2.RELEASE]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:911) [spring-beans-3.1.2.RELEASE.jar:3.1.2.RELEASE]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) [spring-beans-3.1.2.RELEASE.jar:3.1.2.RELEASE]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) [spring-beans-3.1.2.RELEASE.jar:3.1.2.RELEASE]
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) [spring-beans-3.1.2.RELEASE.jar:3.1.2.RELEASE]
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) [spring-beans-3.1.2.RELEASE.jar:3.1.2.RELEASE]
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) [spring-beans-3.1.2.RELEASE.jar:3.1.2.RELEASE]
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) [spring-beans-3.1.2.RELEASE.jar:3.1.2.RELEASE]
        at  .............(shortened for brevity)
17:08:33.908 [main] ERROR c.example.spring.config.MainConfig - Couldn't either create InitialContext or couldn't lookup jdbc/myds
javax.naming.NamingException: com.mchange.v2.c3p0.WrapperConnectionPoolDataSource; local class incompatible: stream classdesc serialVersionUID = -7086951306718003710, local class serialVersionUID = 7806429541739165290
        at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:485)
        at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:518)
        at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:533)
        at javax.naming.InitialContext.lookup(InitialContext.java:411)
        at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:468)
        at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:536)
        at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:536)
        at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:536)
        at org.eclipse.jetty.jndi.NamingContext.lookup(NamingContext.java:551)
        at org.eclipse.jetty.jndi.java.javaRootURLContext.lookup(javaRootURLContext.java:117)
        at javax.naming.InitialContext.lookup(InitialContext.java:411)
        at com.example.spring.config.MainConfig.dataSource(MainConfig.java:65)
        at com.example.spring.config.MainConfig$$EnhancerByCGLIB$$8673699d.CGLIB$dataSource$0(<generated>)
        at com.example.spring.config.MainConfig$$EnhancerByCGLIB$$8673699d$$FastClassByCGLIB$$554d588d.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
        at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:280)
        at com.example.spring.config.MainConfig$$EnhancerByCGLIB$$8673699d.dataSource(<generated>)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at .............(shortened for brevity)

任何人都可以看到我这边的配置错误吗？

最佳答案

@Joakim 的建议帮助我找到了问题的根源并找到了解决方案。问题的根源与 Jetty 9.1 没有任何关系，而是源于一个 Maven 依赖库，该库对较旧的 C3P0 版本 0.9.1.1 具有传递依赖性:

我的 web 应用程序使用 Quartz 调度程序，所以我的应用程序的 pom.xml 包含在内

<dependency>
    <groupId>org.quartz-scheduler</groupId>
    <artifactId>quartz</artifactId>
    <version>2.2.0</version>
</dependency>

org.quartz-scheduler:quartz:2.2.0 依赖于 c3p0:c3p0:0.9.1.1。

旧版本的 C3P0 与我的 Jetty 服务器实例的 lib/etc/ 中的较新的 com.mchange:c3p0:0.9.5-pre6 发生冲突> 目录。

我的问题的解决方案是明确排除 Quartz 对旧 C3P0 工件的依赖:

<dependency>
    <groupId>org.quartz-scheduler</groupId>
    <artifactId>quartz</artifactId>
    <version>2.2.0</version>
        <exclusions>
            <exclusion> 
                <groupId>c3p0</groupId> 
                <artifactId>c3p0</artifactId>
            </exclusion>
        </exclusions>
    </dependency>

至少对于我特定的 Quartz 使用，Quartz 仍然运行良好。

关于mysql - C3P0 0.9.5-pre6 与 Jetty 9.1，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/20687044/

25 4 0
文章推荐： PHP 和 Mysql - 如何让我的登录系统与我的数据库一起工作？
文章推荐： php - 将自定义元数据插入数据库
文章推荐： ios - 如何以多部分形式将多个图像文件发送到服务器？
文章推荐： mysql - 根据其中一个表中特定列中的最大值返回 JOIN 结果
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com