Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Are we ready to support getBlob #1183

Closed
SpaceMiao opened this issue Sep 25, 2024 · 1 comment
Closed

Are we ready to support getBlob #1183

SpaceMiao opened this issue Sep 25, 2024 · 1 comment

Comments

@SpaceMiao
Copy link

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):

  • OS: [e.g. Windows 7]
  • CPU architecture: [e.g. x86_64, arm64]
  • sqlite-jdbc version: 3.36.0.3

Additional context
Add any other context about the problem here.

image

@gotson
Copy link
Collaborator

gotson commented Sep 25, 2024

Duplicate of #622

@gotson gotson marked this as a duplicate of #622 Sep 25, 2024
@gotson gotson closed this as not planned Won't fix, can't repro, duplicate, stale Sep 25, 2024
@gotson gotson added duplicate and removed triage labels Sep 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants