Spring Quartz i PostresSQL

Question

Witam. Mam problem z Spring Quart Scheduler. A mianowicie mam program który działa elegancko na bazie danych h2. Jednak chce go zmienić na postressql. Sciągam więc zamiast skrypt tworzenia danych na h2 dla postgresa i bum wyskakują błędy. Przeczytałem gdzieś ze trzeba dodać  plik quart.properties i dodać org.quartz.dataSource.default.driver = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate jednak to nie pomogło .... 
Link do gita z projektem:
https://github.com/Redzikes/test5/tree/master/src/main 

org.springframework.context.ApplicationContextException: Failed to start bean 'schedulerFactoryBean'; nested exception is org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Zła wartość dla typu long: \xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c770800000010000000017400096a6f6244657461696c7372001d6f72672e71756172747a2e696d706c2e4a6f6244657461696c496d706cabc3caec015a54af0200075a000a6475726162696c6974795a000d73686f756c645265636f7665724c000b6465736372697074696f6e7400124c6a6176612f6c616e672f537472696e673b4c000567726f757071007e00094c00086a6f62436c6173737400114c6a6176612f6c616e672f436c6173733b4c000a6a6f62446174614d61707400174c6f72672f71756172747a2f4a6f62446174614d61703b4c00046e616d6571007e0009787001007074000744454641554c5476720026706c2e78656e7469766f2e61707032776f726b2e717561727a2e6a6f622e456d61696c4a6f62000000000000000000000078707371007e0000017371007e00053f4000000000000c77080000001000000001740002573174000761736461647361780074001f64796e616d69634a6f624265616e31353331353930343132333035686f6d657800 [See nested exception: org.postgresql.util.PSQLException: Zła wartość dla typu long: \xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c770800000010000000017400096a6f6244657461696c7372001d6f72672e71756172747a2e696d706c2e4a6f6244657461696c496d706cabc3caec015a54af0200075a000a6475726162696c6974795a000d73686f756c645265636f7665724c000b6465736372697074696f6e7400124c6a6176612f6c616e672f537472696e673b4c000567726f757071007e00094c00086a6f62436c6173737400114c6a6176612f6c616e672f436c6173733b4c000a6a6f62446174614d61707400174c6f72672f71756172747a2f4a6f62446174614d61703b4c00046e616d6571007e0009787001007074000744454641554c5476720026706c2e78656e7469766f2e61707032776f726b2e717561727a2e6a6f622e456d61696c4a6f62000000000000000000000078707371007e0000017371007e00053f4000000000000c77080000001000000001740002573174000761736461647361780074001f64796e616d69634a6f624265616e31353331353930343132333035686f6d657800]]
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178) ~[spring-context-4.3.13.RELEASE.jar:4.3.13.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:50) ~[spring-context-4.3.13.RELEASE.jar:4.3.13.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:348) ~[spring-context-4.3.13.RELEASE.jar:4.3.13.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:151) ~[spring-context-4.3.13.RELEASE.jar:4.3.13.RELEASE]
at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:114) ~[spring-context-4.3.13.RELEASE.jar:4.3.13.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:880) ~[spring-context-4.3.13.RELEASE.jar:4.3.13.RELEASE]
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.finishRefresh(EmbeddedWebApplicationContext.java:144) ~[spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546) ~[spring-context-4.3.13.RELEASE.jar:4.3.13.RELEASE]
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122) ~[spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:693) [spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:360) [spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:303) [spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1118) [spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1107) [spring-boot-1.5.9.RELEASE.jar:1.5.9.RELEASE]
at pl.xentivo.app2work.quarz.Application.main(Application.java:10) [classes/:na]
Caused by: org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Zła wartość dla typu long: \xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c770800000010000000017400096a6f6244657461696c7372001d6f72672e71756172747a2e696d706c2e4a6f6244657461696c496d706cabc3caec015a54af0200075a000a6475726162696c6974795a000d73686f756c645265636f7665724c000b6465736372697074696f6e7400124c6a6176612f6c616e672f537472696e673b4c000567726f757071007e00094c00086a6f62436c6173737400114c6a6176612f6c616e672f436c6173733b4c000a6a6f62446174614d61707400174c6f72672f71756172747a2f4a6f62446174614d61703b4c00046e616d6571007e0009787001007074000744454641554c5476720026706c2e78656e7469766f2e61707032776f726b2e717561727a2e6a6f622e456d61696c4a6f62000000000000000000000078707371007e0000017371007e00053f4000000000000c77080000001000000001740002573174000761736461647361780074001f64796e616d69634a6f624265616e31353331353930343132333035686f6d657800 [See nested exception: org.postgresql.util.PSQLException: Zła wartość dla typu long: \xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c770800000010000000017400096a6f6244657461696c7372001d6f72672e71756172747a2e696d706c2e4a6f6244657461696c496d706cabc3caec015a54af0200075a000a6475726162696c6974795a000d73686f756c645265636f7665724c000b6465736372697074696f6e7400124c6a6176612f6c616e672f537472696e673b4c000567726f757071007e00094c00086a6f62436c6173737400114c6a6176612f6c616e672f436c6173733b4c000a6a6f62446174614d61707400174c6f72672f71756172747a2f4a6f62446174614d61703b4c00046e616d6571007e0009787001007074000744454641554c5476720026706c2e78656e7469766f2e61707032776f726b2e717561727a2e6a6f622e456d61696c4a6f62000000000000000000000078707371007e0000017371007e00053f4000000000000c77080000001000000001740002573174000761736461647361780074001f64796e616d69634a6f624265616e31353331353930343132333035686f6d657800]] at org.springframework.scheduling.quartz.SchedulerFactoryBean.start(SchedulerFactoryBean.java:718) ~[spring-context-support-4.3.13.RELEASE.jar:4.3.13.RELEASE] at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:175) ~[spring-context-4.3.13.RELEASE.jar:4.3.13.RELEASE] ... 14 common frames omitted Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:692) ~[quartz-2.2.1.jar:na] at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:567) ~[quartz-2.2.1.jar:na] at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) ~[quartz-2.2.1.jar:na] at org.springframework.scheduling.quartz.SchedulerFactoryBean.startScheduler(SchedulerFactoryBean.java:646) ~[spring-context-support-4.3.13.RELEASE.jar:4.3.13.RELEASE] at org.springframework.scheduling.quartz.SchedulerFactoryBean.start(SchedulerFactoryBean.java:715) ~[spring-context-support-4.3.13.RELEASE.jar:4.3.13.RELEASE] ... 15 common frames omitted Caused by: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Zła wartość dla typu long: \xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c770800000010000000017400096a6f6244657461696c7372001d6f72672e71756172747a2e696d706c2e4a6f6244657461696c496d706cabc3caec015a54af0200075a000a6475726162696c6974795a000d73686f756c645265636f7665724c000b6465736372697074696f6e7400124c6a6176612f6c616e672f537472696e673b4c000567726f757071007e00094c00086a6f62436c6173737400114c6a6176612f6c616e672f436c6173733b4c000a6a6f62446174614d61707400174c6f72672f71756172747a2f4a6f62446174614d61703b4c00046e616d6571007e0009787001007074000744454641554c5476720026706c2e78656e7469766f2e61707032776f726b2e717561727a2e6a6f622e456d61696c4a6f62000000000000000000000078707371007e0000017371007e00053f4000000000000c77080000001000000001740002573174000761736461647361780074001f64796e616d69634a6f624265616e31353331353930343132333035686f6d657800 at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1533) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:979) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:866) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.executeVoid(JobStoreSupport.java:838) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3703) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3701) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:834) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:690) ~[quartz-2.2.1.jar:na] ... 19 common frames omitted Caused by: org.postgresql.util.PSQLException: Zła wartość dla typu long: \xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c770800000010000000017400096a6f6244657461696c7372001d6f72672e71756172747a2e696d706c2e4a6f6244657461696c496d706cabc3caec015a54af0200075a000a6475726162696c6974795a000d73686f756c645265636f7665724c000b6465736372697074696f6e7400124c6a6176612f6c616e672f537472696e673b4c000567726f757071007e00094c00086a6f62436c6173737400114c6a6176612f6c616e672f436c6173733b4c000a6a6f62446174614d61707400174c6f72672f71756172747a2f4a6f62446174614d61703b4c00046e616d6571007e0009787001007074000744454641554c5476720026706c2e78656e7469766f2e61707032776f726b2e717561727a2e6a6f622e456d61696c4a6f62000000000000000000000078707371007e0000017371007e00053f4000000000000c77080000001000000001740002573174000761736461647361780074001f64796e616d69634a6f624265616e31353331353930343132333035686f6d657800 at org.postgresql.jdbc.PgResultSet.toLong(PgResultSet.java:2861) ~[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7] at org.postgresql.jdbc.PgResultSet.getLong(PgResultSet.java:2072) ~[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7] at org.postgresql.jdbc.PgResultSet.getBlob(PgResultSet.java:420) ~[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7] at org.postgresql.jdbc.PgResultSet.getBlob(PgResultSet.java:407) ~[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7] at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.getObjectFromBlob(StdJDBCDelegate.java:3190) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1780) ~[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1531) ~[quartz-2.2.1.jar:na] ... 27 common frames omitted

Process finished with exit code 1

=

Comments

Może ogarnij podstawy najpierw...  pracy z Javą i JavąCore- debuuger,consola - to podstawy narzędzi programistycznych bo tak co chwile pytasz  o błędy ... a wszystko masz jasno opisane

Answer 1

A mógłbyś czytać całą dokumentacje debuggera- i w końcu ogarnąć PODSTAWY PROGRAMOWANIA -> PRACY Z DEBUGGEREM JAKO programista? 

 

[See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Zła wartość dla typu long: \

może złe kodowanie dla Id- encji ? Logn to nie mały long, też może to wynikać z struktury tabeli bazy danych, albo encji. Sprawdź dokładnie.