xerial / sqlite-jdbc

SQLite JDBC Driver
Apache License 2.0
2.82k stars 615 forks source link

Are we ready to support getBlob #1183

Closed SpaceMiao closed 1 week ago

SpaceMiao commented 1 week ago

Describe the bug I'm using Quartz as a scheduling middleware in SpringBoot project, but I found that it doesn't work very well with sqlite. When I create a scheduled task, an error occurs in the program.

org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: null
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2923) ~[quartz-2.3.2.jar:na]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:2805) ~[quartz-2.3.2.jar:na]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:2803) ~[quartz-2.3.2.jar:na]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3864) ~[quartz-2.3.2.jar:na]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2802) ~[quartz-2.3.2.jar:na]
    at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:287) ~[quartz-2.3.2.jar:na]
Caused by: org.quartz.JobPersistenceException: Couldn't retrieve trigger: null
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1538) ~[quartz-2.3.2.jar:na]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2854) ~[quartz-2.3.2.jar:na]
    ... 5 common frames omitted
Caused by: java.sql.SQLFeatureNotSupportedException: null
    at org.sqlite.jdbc4.JDBC4ResultSet.unused(JDBC4ResultSet.java:347) ~[sqlite-jdbc-3.36.0.3.jar:na]
    at org.sqlite.jdbc4.JDBC4ResultSet.getBlob(JDBC4ResultSet.java:390) ~[sqlite-jdbc-3.36.0.3.jar:na]
    at com.alibaba.druid.pool.DruidPooledResultSet.getBlob(DruidPooledResultSet.java:1157) ~[druid-1.2.23.jar:na]
    at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.getObjectFromBlob(StdJDBCDelegate.java:3190) ~[quartz-2.3.2.jar:na]
    at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1780) ~[quartz-2.3.2.jar:na]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1536) ~[quartz-2.3.2.jar:na]
    ... 6 common frames omitted

To Reproduce Provide a sample code that reproduces the error.

Quartz.propertites org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate

        <dependency>
            <groupId>org.xerial</groupId>
            <artifactId>sqlite-jdbc</artifactId>
            <version>3.36.0.3</version>
        </dependency>

Expected behavior A clear and concise description of what you expected to happen.

Logs If applicable, provide logs.

Environment (please complete the following information):

Additional context Add any other context about the problem here.

image

gotson commented 1 week ago

Duplicate of #622