java 无法存储作业：驱动程序的Blob表示形式属于不受支持的类型：oracle.sql.BLOB

8e2ybdfx 于 2023-01-24 发布在 Java

关注(0)|答案(4)|浏览(291)

我得到这个错误：

org.quartz.JobPersistenceException: Couldn't store job: Driver's Blob representation is of an unsupported type: oracle.sql.BLOB [See nested exception: java.sql.SQLException: Driver's Blob representation is of an unsupported type: oracle.sql.BLOB]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1103)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport$3.execute(JobStoreSupport.java:1042)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:3670)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3742)
    at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:90)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3666)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1030)
    at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:743)
    at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:243)
    at com.akbank.bsa.core.ApplicationStartup.run(ApplicationStartup.java:66)
    at com.akbank.bsa.core.ApplicationStartup.initialize(ApplicationStartup.java:24)
    at com.akbank.bsa.listener.Startup.contextInitialized(Startup.java:17)
    at org.apache.catalina.core.StandardContext.contextListenerStart(StandardContext.java:3392)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:3850)
    at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:90)
    at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)
    at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)
    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:662)
Caused by: java.sql.SQLException: Driver's Blob representation is of an unsupported type: oracle.sql.BLOB
    at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.writeDataToBlob(OracleDelegate.java:646)
    at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.insertJobDetail(OracleDelegate.java:207)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1097)
    ... 19 more

使用：

Jboss AS 7.1.1
Java 1.6

Oracle数据库11 g企业版11.2.0.2.0-64位生产

ojdbc6.jar实现版本：11.2.0.2.0
石英-2.1.6

有什么问题吗？

Java

来源：https://stackoverflow.com/questions/14518407/couldnt-store-job-drivers-blob-representation-is-of-an-unsupported-type-orac

4条答案

按热度按时间

6fe3ivhb1#

从类路径中删除ojdbc6.jar并添加JBoss模块（ojdbc6模块）作为依赖项解决了这个问题。

赞(0）回复(0）举报 2023-01-24

svmlkihl2#

我们找到了这个问题的优雅的解决方案。它工作。我们需要添加oracle模块在全局模块如下。

<subsystem xmlns="urn:jboss:domain:ee:1.1">
        <global-modules>
            <module name="com.oracle" slot="main"/>
        </global-modules>

        <spec-descriptor-property-replacement>false</spec-descriptor-property-replacement>
        <jboss-descriptor-property-replacement>true</jboss-descriptor-property-replacement>
    </subsystem>

赞(0）回复(0）举报 2023-01-24

bqjvbblv3#

成功地解决了JBoss EAP 6的相同问题。主要思想是相同的-从war中删除jar（如果它在那里的话），让应用服务器提供它。详细信息如下。
1)添加了WEB-INF/jboss-deployment-structure.xml：

<jboss-deployment-structure>
<deployment>
    <dependencies>
        <module name="com.oracle" />
    </dependencies>
</deployment>
</jboss-deployment-structure>

2)已定义jboss\eap640\modules\system\layers\base\com\oracle\main\module.xml

<module xmlns="urn:jboss:module:1.1" name="com.oracle">
  <resources>
    <resource-root path="ojdbc7.jar"/>
  </resources>
  <dependencies>
    ...
  </dependencies>
</module>

3)将ojdbc7.jar放入jboss\eap640\modules\system\layers\base\com\oracle\main中。

赞(0）回复(0）举报 2023-01-24

eiee3dmh4#

这对我很有效

<subsystem xmlns="urn:jboss:domain:datasources:7.0">
      <datasources>
        <datasource jndi-name="*******" pool-name="****" enabled="true" use-java-context="true" statistics-e$
          <connection-url>******</connection-url>
          <driver>oracle</driver>
          <security>
            <user-name>***</user-name>
            <password>***</password>
          </security>
        </datasource>
        <drivers>
          <driver name="oracle" module="com.oracle">
            <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
          </driver>
        </drivers>
      </datasources>
</subsystem>
.
.
.
<subsystem xmlns="urn:jboss:domain:ee:6.0">
     .
     .
     .
     <global-modules>
         <module name="com.oracle" slot="main"/>
     </global-modules>
     .
     .
     .
</subsystem>

赞(0）回复(0）举报 2023-01-24

我来回答

java 无法存储作业：驱动程序的Blob表示形式属于不受支持的类型：oracle.sql.BLOB

4条答案

相关问题

热门标签

最新问答