Skip to content

Instantly share code, notes, and snippets.

@marzdgzmn

marzdgzmn/gist:4d5ad1f51ff387043b5393a624de03c9

Created May 18, 2017 05:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marzdgzmn/4d5ad1f51ff387043b5393a624de03c9 to your computer and use it in GitHub Desktop.
Save marzdgzmn/4d5ad1f51ff387043b5393a624de03c9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
/home/marz/.sdkman/candidates/java/6u45/bin/java -javaagent:/opt/idea-IU-171.4249.39/lib/idea_rt.jar=33423:/opt/idea-IU-171.4249.39/bin -Dfile.encoding=UTF-8 -classpath /home/marz/.sdkman/candidates/java/6u45/jre/lib/charsets.jar:/home/marz/.sdkman/candidates/java/6u45/jre/lib/deploy.jar:/home/marz/.sdkman/candidates/java/6u45/jre/lib/ext/dnsns.jar:/home/marz/.sdkman/candidates/java/6u45/jre/lib/ext/localedata.jar:/home/marz/.sdkman/candidates/java/6u45/jre/lib/ext/sunjce_provider.jar:/home/marz/.sdkman/candidates/java/6u45/jre/lib/ext/sunpkcs11.jar:/home/marz/.sdkman/candidates/java/6u45/jre/lib/javaws.jar:/home/marz/.sdkman/candidates/java/6u45/jre/lib/jce.jar:/home/marz/.sdkman/candidates/java/6u45/jre/lib/jsse.jar:/home/marz/.sdkman/candidates/java/6u45/jre/lib/management-agent.jar:/home/marz/.sdkman/candidates/java/6u45/jre/lib/plugin.jar:/home/marz/.sdkman/candidates/java/6u45/jre/lib/resources.jar:/home/marz/.sdkman/candidates/java/6u45/jre/lib/rt.jar:/home/marz/ut/idea/Router/build/classes/main:/home/marz/ut/idea/Router/build/resources/main:/home/marz/.gradle/caches/modules-2/files-2.1/org.apache.activemq/activemq-core/5.5.1/aaf6b3e685097edacbe870df9216e13f706bb250/activemq-core-5.5.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.hibernate/hibernate-entitymanager/3.6.10.Final/c74f1e1bf4fb6b8eaa7e501e6ccba9e055e52974/hibernate-entitymanager-3.6.10.Final.jar:/home/marz/.gradle/caches/modules-2/files-2.1/commons-daemon/commons-daemon/1.0.10/554ee15db14522cff9a074b2be703e49d8195e60/commons-daemon-1.0.10.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.springframework/spring-beans/3.0.7.RELEASE/5915c3eee8dc193b19b648719d653439c57fc0d8/spring-beans-3.0.7.RELEASE.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.springframework/spring-context/3.0.7.RELEASE/e0072743c5c485e0b36a8fce109dcd5c08c5323f/spring-context-3.0.7.RELEASE.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.springframework/spring-context-support/3.0.7.RELEASE/3e934568df693c94f476e1f721470766093c19f9/spring-context-support-3.0.7.RELEASE.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.springframework/spring-core/3.0.7.RELEASE/2c90825834a037aab6f6a71bbd05d81680832c49/spring-core-3.0.7.RELEASE.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.springframework/spring-expression/3.0.7.RELEASE/61999bb2e1e5f7a1c13e91a58761c48dc1d71cf9/spring-expression-3.0.7.RELEASE.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.springframework/spring-jdbc/3.0.7.RELEASE/c53d9bf4e6a6a6cf49c7d7630e612042364295a1/spring-jdbc-3.0.7.RELEASE.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.springframework/spring-jms/3.0.7.RELEASE/1647b17010e96c713f589ec1b0265556443db00e/spring-jms-3.0.7.RELEASE.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.springframework/spring-orm/3.0.7.RELEASE/12dd243decf20222de7e2abbafdc915d83c9252a/spring-orm-3.0.7.RELEASE.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.springframework/spring-test/3.0.7.RELEASE/99881ecdc4b03a4181757a66a7e80665afa1268a/spring-test-3.0.7.RELEASE.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.springframework/spring-tx/3.0.7.RELEASE/c340bf8606f6bf235bc1277d25315df1abe51c31/spring-tx-3.0.7.RELEASE.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.apache.activemq/activemq-pool/5.5.1/5f8e265f716425fb806ab773bafab494fb60f7f7/activemq-pool-5.5.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.projectlombok/lombok/0.11.4/f7e39c90d7a437ab3a77043afeb9d07ecbcaefc/lombok-0.11.4.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.aspectj/aspectjweaver/1.7.0/cae712e9794b184640bdb15e6fc1ace8b5483e0a/aspectjweaver-1.7.0.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.aspectj/aspectjrt/1.7.0/c64a0e2045058263b28e53dcc4f9abaaf259c173/aspectjrt-1.7.0.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.6.1/bd245d6746cdd4e6203e976e21d597a46f115802/slf4j-log4j12-1.6.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/joda-time/joda-time/2.2/a5f29a7acaddea3f4af307e8cf2d0cc82645fd7d/joda-time-2.2.jar:/home/marz/ut/idea/LegacyModel/build/classes/main:/home/marz/ut/idea/LegacyModel/build/resources/main:/home/marz/.gradle/caches/modules-2/files-2.1/javax.validation/validation-api/1.0.0.GA/b6bd7f9d78f6fdaa3c37dae18a4bd298915f328e/validation-api-1.0.0.GA.jar:/home/marz/.gradle/caches/modules-2/files-2.1/commons-dbcp/commons-dbcp/1.4/30be73c965cc990b153a100aaaaafcf239f82d39/commons-dbcp-1.4.jar:/home/marz/.gradle/caches/modules-2/files-2.1/postgresql/postgresql/9.1-901.jdbc4/153f2f92a786f12fc111d0111f709012df87c808/postgresql-9.1-901.jdbc4.jar:/home/marz/ut/idea/Model/build/classes/main:/home/marz/ut/idea/Model/build/resources/main:/home/marz/.gradle/caches/modules-2/files-2.1/org.hibernate/hibernate-core/3.6.10.Final/6b36a1eef76cbccc2757f22a795b5e12ab56b3d5/hibernate-core-3.6.10.Final.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.hibernate/hibernate-c3p0/3.6.10.Final/4b0c72abf87e2179122394967f420e5827e71cd5/hibernate-c3p0-3.6.10.Final.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.hibernate/hibernate-validator/4.3.1.Final/49b31d8ea51fa21cc78a89e9d4ddb11d6bfb4669/hibernate-validator-4.3.1.Final.jar:/home/marz/.gradle/caches/modules-2/files-2.1/commons-lang/commons-lang/2.4/16313e02a793435009f1e458fa4af5d879f6fb11/commons-lang-2.4.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.postgresql/postgresql/9.3-1101-jdbc4/9da59f12badea19b3b2884161f624bcf6750f985/postgresql-9.3-1101-jdbc4.jar:/home/marz/.gradle/caches/modules-2/files-2.1/com.thoughtworks.xstream/xstream/1.4.2/97e5013f391487cce4de6b0eebcde21549e91872/xstream-1.4.2.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.hsqldb/hsqldb/2.2.6/cf35e8222e4af7aa9d7423b6c1f7a68b6d543867/hsqldb-2.2.6.jar:/home/marz/.gradle/caches/modules-2/files-2.1/commons-beanutils/commons-beanutils/1.8.3/686ef3410bcf4ab8ce7fd0b899e832aaba5facf7/commons-beanutils-1.8.3.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.apache.httpcomponents/httpclient/4.2.3/37ced84d839a02fb856255eca85f0a4be95aa634/httpclient-4.2.3.jar:/home/marz/.gradle/caches/modules-2/files-2.1/commons-httpclient/commons-httpclient/3.1/964cd74171f427720480efdec40a7c7f6e58426a/commons-httpclient-3.1.jar:/home/marz/ut/idea/Exceptions/build/classes/main:/home/marz/ut/idea/Utils/build/classes/main:/home/marz/.gradle/caches/modules-2/files-2.1/org.apache.tika/tika-core/0.7/70397f3c21284ccd4b96b3e808351bb624e73c3a/tika-core-0.7.jar:/home/marz/.gradle/caches/modules-2/files-2.1/commons-io/commons-io/1.4/a8762d07e76cfde2395257a5da47ba7c1dbd3dce/commons-io-1.4.jar:/home/marz/.gradle/caches/modules-2/files-2.1/commons-codec/commons-codec/1.6/b7f0fc8f61ecadeb3695f0b9464755eee44374d4/commons-codec-1.6.jar:/home/marz/.gradle/caches/modules-2/files-2.1/javax.jms/jms-api/1.1-rev-1/af256c6e1b77f1599c33b61c730fb1ff591cbfb0/jms-api-1.1-rev-1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-api/1.6.1/6f3b8a24bf970f17289b234284c94f43eb42f0e4/slf4j-api-1.6.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/log4j/log4j/1.2.16/7999a63bfccbc7c247a9aea10d83d4272bd492c6/log4j-1.2.16.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.apache.geronimo.specs/geronimo-jms_1.1_spec/1.1.1/c872b46c601d8dc03633288b81269f9e42762cea/geronimo-jms_1.1_spec-1.1.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.apache.activemq/activeio-core/3.1.2/91348a918fcea7d967ca3f1bb8ed19065bbf819d/activeio-core-3.1.2.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.apache.activemq/kahadb/5.5.1/aaba9d7dd31453812b50d1e79012322f828ec8c2/kahadb-5.5.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.apache.activemq.protobuf/activemq-protobuf/1.1/26682eb801f70563511f7c424dc10e8b3e66340e/activemq-protobuf-1.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.osgi/org.osgi.core/4.1.0/b88cd082b5b6774e9db939e28c0e3dc526c92d89/org.osgi.core-4.1.0.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.apache.geronimo.specs/geronimo-j2ee-management_1.1_spec/1.0.1/5372615b0c04c1913c95c34a0414cef720ca2855/geronimo-j2ee-management_1.1_spec-1.0.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/commons-net/commons-net/2.0/1f75887afe587df7c2435f2f6d3199f05a324c8d/commons-net-2.0.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.jasypt/jasypt/1.7/5edddc5dfaad7bea399c680b7514c69cfc8ed818/jasypt-1.7.jar:/home/marz/.gradle/caches/modules-2/files-2.1/antlr/antlr/2.7.6/cf4f67dae5df4f9932ae7810f4548ef3e14dd35e/antlr-2.7.6.jar:/home/marz/.gradle/caches/modules-2/files-2.1/commons-collections/commons-collections/3.1/40fb048097caeacdb11dbb33b5755854d89efdeb/commons-collections-3.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/dom4j/dom4j/1.6.1/5d3ccc056b6f056dbf0dddfdf43894b9065a8f94/dom4j-1.6.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.hibernate/hibernate-commons-annotations/3.2.0.Final/ce990611448fc2865469e3b68d2fe76b050e3c4f/hibernate-commons-annotations-3.2.0.Final.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.hibernate.javax.persistence/hibernate-jpa-2.0-api/1.0.1.Final/3306a165afa81938fc3d8a0948e891de9f6b192b/hibernate-jpa-2.0-api-1.0.1.Final.jar:/home/marz/.gradle/caches/modules-2/files-2.1/javax.transaction/jta/1.1/2ca09f0b36ca7d71b762e14ea2ff09d5eac57558/jta-1.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/cglib/cglib/2.2/97d03461dc1c04ffc636dcb2579aae7724a78ef2/cglib-2.2.jar:/home/marz/.gradle/caches/modules-2/files-2.1/javassist/javassist/3.12.0.GA/88b21d1ef06323beff58664cffa62848c033ecd2/javassist-3.12.0.GA.jar:/home/marz/.gradle/caches/modules-2/files-2.1/c3p0/c3p0/0.9.1/759f6c11f515ee799814c43e4a50281220014ca/c3p0-0.9.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.jboss.logging/jboss-logging/3.1.0.CR2/28725380c07f917ace4e511db21cc45e9ae5a72b/jboss-logging-3.1.0.CR2.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.springframework/spring-asm/3.0.7.RELEASE/cadd0ed7b1aeea0c2858ada0d6397e8423aad6a3/spring-asm-3.0.7.RELEASE.jar:/home/marz/.gradle/caches/modules-2/files-2.1/commons-logging/commons-logging/1.1.1/5043bfebc3db072ed80fbd362e7caf00e885d8ae/commons-logging-1.1.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/aopalliance/aopalliance/1.0/235ba8b489512805ac13a8f9ea77a1ca5ebe3e8/aopalliance-1.0.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.springframework/spring-aop/3.0.7.RELEASE/e52176ba360e47d132bbc80dc144a916dd75eee7/spring-aop-3.0.7.RELEASE.jar:/home/marz/.gradle/caches/modules-2/files-2.1/commons-pool/commons-pool/1.5.4/75b6e20c596ed2945a259cea26d7fadd298398e6/commons-pool-1.5.4.jar:/home/marz/.gradle/caches/modules-2/files-2.1/xmlpull/xmlpull/1.1.3.1/2b8e230d2ab644e4ecaa94db7cdedbc40c805dfa/xmlpull-1.1.3.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/xpp3/xpp3_min/1.1.4c/19d4e90b43059058f6e056f794f0ea4030d60b86/xpp3_min-1.1.4c.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.apache.geronimo.specs/geronimo-jta_1.0.1B_spec/1.0.1/c9e67d21082a497f20e4ce87be1379faceb9c087/geronimo-jta_1.0.1B_spec-1.0.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.apache.httpcomponents/httpcore/4.2.2/b76bee23cd3f3ee9b98bc7c2c14670e821ddbbfd/httpcore-4.2.2.jar:/home/marz/.gradle/caches/modules-2/files-2.1/asm/asm/3.1/c157def142714c544bdea2e6144645702adf7097/asm-3.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/org.codehaus.jettison/jettison/1.3.1/56dcc8480ecd2c03ec004aa76278d1f2d621561/jettison-1.3.1.jar:/home/marz/.gradle/caches/modules-2/files-2.1/stax/stax-api/1.0.1/49c100caf72d658aca8e58bd74a4ba90fa2b0d70/stax-api-1.0.1.jar net.utbox.router.jms.RouterApplication
12:45:06,783 INFO ClassPathXmlApplicationContext:456 - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@37bd2664: startup date [Thu May 18 12:45:06 PHT 2017]; root of context hierarchy
12:45:06,829 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [Router-main-spring.xml]
12:45:06,933 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [Model-main-exports.xml]
12:45:06,953 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [Model-main-exports-noConversionService.xml]
12:45:06,977 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [Model-main-exports-noDataSource.xml]
12:45:07,013 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [Model-common-spring.xml]
12:45:07,053 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [db-templates.xml]
12:45:07,093 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [Model-jms-main-spring.xml]
12:45:07,107 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [Model-jms-spring.xml]
12:45:07,295 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [Router-common-spring.xml]
12:45:07,350 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [Router-spring-jms.xml]
12:45:07,370 INFO DefaultListableBeanFactory:623 - Overriding bean definition for bean 'jmsTemplate': replacing [Generic bean: class [org.springframework.jms.core.JmsTemplate]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [Model-jms-main-spring.xml]] with [Generic bean: class [org.springframework.jms.core.JmsTemplate]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [Router-spring-jms.xml]]
12:45:07,375 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [Router-spring-scheduled-tasks.xml]
12:45:07,716 INFO PropertyPlaceholderConfigurer:177 - Loading properties file from class path resource [Router-config.properties]
12:45:07,717 INFO PropertyPlaceholderConfigurer:177 - Loading properties file from class path resource [utbox-config.properties]
12:45:07,719 INFO PropertyPlaceholderConfigurer:177 - Loading properties file from URL [file:/etc/utbox/utbox-config.properties]
12:45:07,723 INFO PropertyPlaceholderConfigurer:177 - Loading properties file from URL [file:/etc/utbox/Router-config.properties]
12:45:07,724 WARN PropertyPlaceholderConfigurer:205 - Could not load properties from URL [file:/etc/utbox/Router-config.properties]: /etc/utbox/Router-config.properties (No such file or directory)
12:45:07,732 INFO PropertyPlaceholderConfigurer:177 - Loading properties file from class path resource [utbox-config.properties]
12:45:07,734 INFO PropertyPlaceholderConfigurer:177 - Loading properties file from URL [file:/etc/utbox/utbox-config.properties]
12:45:07,777 INFO MLog:80 - MLog clients using log4j logging.
12:45:07,852 INFO C3P0Registry:204 - Initializing c3p0-0.9.1 [built 16-January-2007 14:46:42; debug? true; trace: 10]
12:45:08,007 INFO Version:37 - Hibernate Commons Annotations 3.2.0.Final
12:45:08,010 INFO Environment:603 - Hibernate 3.6.10.Final
12:45:08,011 INFO Environment:636 - hibernate.properties not found
12:45:08,013 INFO Environment:814 - Bytecode provider name : javassist
12:45:08,015 INFO Environment:695 - using JDK 1.4 java.sql.Timestamp handling
12:45:08,151 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.FpsBlocklist
12:45:08,175 INFO EntityBinder:530 - Bind entity net.utbox.model.FpsBlocklist on table fps_blocklist
12:45:08,197 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.MergeField
12:45:08,198 INFO EntityBinder:530 - Bind entity net.utbox.model.MergeField on table merge_field
12:45:08,210 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.RoutedFaxMessageAttemptSet
12:45:08,211 INFO EntityBinder:530 - Bind entity net.utbox.model.RoutedFaxMessageAttemptSet on table routed_fax_message_attempt_set
12:45:08,228 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.FaxMessage
12:45:08,228 INFO EntityBinder:530 - Bind entity net.utbox.model.FaxMessage on table fax_message
12:45:08,258 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.FaxServer
12:45:08,258 INFO EntityBinder:530 - Bind entity net.utbox.model.FaxServer on table fax_server
12:45:08,260 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.WhirlwindFaxServer
12:45:08,261 INFO EntityBinder:530 - Bind entity net.utbox.model.WhirlwindFaxServer on table whirlwind_fax_server
12:45:08,267 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.GlobalRoutingRule
12:45:08,268 INFO EntityBinder:530 - Bind entity net.utbox.model.GlobalRoutingRule on table global_routing_rule
12:45:08,270 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.Transaction
12:45:08,270 INFO EntityBinder:530 - Bind entity net.utbox.model.Transaction on table transaction
12:45:08,273 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.FaxMessageStatusModifier
12:45:08,274 INFO EntityBinder:530 - Bind entity net.utbox.model.FaxMessageStatusModifier on table fax_message_status_modifier
12:45:08,285 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.FaxMessageAttempt
12:45:08,285 INFO EntityBinder:530 - Bind entity net.utbox.model.FaxMessageAttempt on table fax_message_attempt
12:45:08,296 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.PrefixGroup
12:45:08,296 INFO EntityBinder:530 - Bind entity net.utbox.model.PrefixGroup on table prefix_group
12:45:08,299 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.FaxFailureHistory
12:45:08,299 INFO EntityBinder:530 - Bind entity net.utbox.model.FaxFailureHistory on table fax_failure_history
12:45:08,301 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.RoutingPrefix
12:45:08,301 INFO EntityBinder:530 - Bind entity net.utbox.model.RoutingPrefix on table routing_prefix
12:45:08,303 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.SmsReplyPool
12:45:08,303 INFO EntityBinder:530 - Bind entity net.utbox.model.SmsReplyPool on table sms_reply_pool
12:45:08,307 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.Prefix
12:45:08,307 INFO EntityBinder:530 - Bind entity net.utbox.model.Prefix on table prefix
12:45:08,307 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.MsConversionServer
12:45:08,308 INFO EntityBinder:530 - Bind entity net.utbox.model.MsConversionServer on table ms_conversion_server
12:45:08,309 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.IncomingFaxServer
12:45:08,309 INFO EntityBinder:530 - Bind entity net.utbox.model.IncomingFaxServer on table incoming_fax_server
12:45:08,312 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.HylafaxIncomingFaxServer
12:45:08,312 INFO EntityBinder:530 - Bind entity net.utbox.model.HylafaxIncomingFaxServer on table hylafax_incoming_fax_server
12:45:08,313 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.Provider
12:45:08,314 INFO EntityBinder:530 - Bind entity net.utbox.model.Provider on table provider
12:45:08,315 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.FaxProvider
12:45:08,315 INFO EntityBinder:530 - Bind entity net.utbox.model.FaxProvider on table fax_provider
12:45:08,317 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.FaxDocument
12:45:08,317 INFO EntityBinder:530 - Bind entity net.utbox.model.FaxDocument on table fax_document
12:45:08,319 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.hylafax.IncomingFaxNumber
12:45:08,320 INFO EntityBinder:530 - Bind entity net.utbox.model.hylafax.IncomingFaxNumber on table incoming_fax_number
12:45:08,321 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.hylafax.ReceivedFaxMessage
12:45:08,321 INFO EntityBinder:530 - Bind entity net.utbox.model.hylafax.ReceivedFaxMessage on table received_fax_message
12:45:08,326 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.hylafax.IncomingFaxProvider
12:45:08,327 INFO EntityBinder:530 - Bind entity net.utbox.model.hylafax.IncomingFaxProvider on table incoming_fax_provider
12:45:08,330 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.hylafax.IncomingFaxUserNumber
12:45:08,330 INFO EntityBinder:530 - Bind entity net.utbox.model.hylafax.IncomingFaxUserNumber on table incoming_fax_user_number
12:45:08,336 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.hylafax.CallCollectionArea
12:45:08,337 INFO EntityBinder:530 - Bind entity net.utbox.model.hylafax.CallCollectionArea on table call_collection_area
12:45:08,338 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.TiffPayload
12:45:08,338 INFO EntityBinder:530 - Bind entity net.utbox.model.TiffPayload on table tiff_payload
12:45:08,340 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.GlobalBlocklist
12:45:08,340 INFO EntityBinder:530 - Bind entity net.utbox.model.GlobalBlocklist on table global_blocklist
12:45:08,341 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.SiteNode
12:45:08,341 INFO EntityBinder:530 - Bind entity net.utbox.model.SiteNode on table site_node
12:45:08,343 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.SmsMessage
12:45:08,344 INFO EntityBinder:530 - Bind entity net.utbox.model.SmsMessage on table sms_message
12:45:08,348 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.FaxDocumentSetEntry
12:45:08,349 INFO EntityBinder:530 - Bind entity net.utbox.model.FaxDocumentSetEntry on table fax_document_set_entry
12:45:08,351 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.UserProfile
12:45:08,351 INFO EntityBinder:530 - Bind entity net.utbox.model.UserProfile on table user_profile
12:45:08,353 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.ImageStampMergeField
12:45:08,353 INFO EntityBinder:530 - Bind entity net.utbox.model.ImageStampMergeField on table image_stamp_merge_field
12:45:08,355 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.FaxProviderRoutingPrefix
12:45:08,355 INFO EntityBinder:530 - Bind entity net.utbox.model.FaxProviderRoutingPrefix on table fax_provider_routing_prefix
12:45:08,356 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.CustomerTokenRoutingRule
12:45:08,357 INFO EntityBinder:530 - Bind entity net.utbox.model.CustomerTokenRoutingRule on table customer_token_routing_rule
12:45:08,358 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.TextStampMergeField
12:45:08,359 INFO EntityBinder:530 - Bind entity net.utbox.model.TextStampMergeField on table text_stamp_merge_field
12:45:08,360 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.DocMergeField
12:45:08,360 INFO EntityBinder:530 - Bind entity net.utbox.model.DocMergeField on table doc_merge_field
12:45:08,361 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.lock.Lock
12:45:08,361 INFO EntityBinder:530 - Bind entity net.utbox.model.lock.Lock on table lock
12:45:08,362 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.PrefixMaxRetries
12:45:08,362 INFO EntityBinder:530 - Bind entity net.utbox.model.PrefixMaxRetries on table prefix_max_retries
12:45:08,364 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.UserRoutingRule
12:45:08,364 INFO EntityBinder:530 - Bind entity net.utbox.model.UserRoutingRule on table user_routing_rule
12:45:08,366 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.InboundSmsMessage
12:45:08,366 INFO EntityBinder:530 - Bind entity net.utbox.model.InboundSmsMessage on table inbound_sms_message
12:45:08,368 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.SmsProvider
12:45:08,368 INFO EntityBinder:530 - Bind entity net.utbox.model.SmsProvider on table sms_provider
12:45:08,369 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.RangeBlocklist
12:45:08,369 INFO EntityBinder:530 - Bind entity net.utbox.model.RangeBlocklist on table range_blocklist
12:45:08,370 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.router.FaxRouteLimit
12:45:08,370 INFO EntityBinder:530 - Bind entity net.utbox.model.router.FaxRouteLimit on table fax_route_limit
12:45:08,372 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.router.FaxRouteStatus
12:45:08,372 INFO EntityBinder:530 - Bind entity net.utbox.model.router.FaxRouteStatus on table fax_route_status
12:45:08,373 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.router.GlobalOverflowProviderOrder
12:45:08,373 INFO EntityBinder:530 - Bind entity net.utbox.model.router.GlobalOverflowProviderOrder on table global_overflow_provider_order
12:45:08,375 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.router.UserOverflowProviderOrder
12:45:08,375 INFO EntityBinder:530 - Bind entity net.utbox.model.router.UserOverflowProviderOrder on table user_overflow_provider_order
12:45:08,377 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.router.SimpleRouterRule
12:45:08,377 INFO EntityBinder:530 - Bind entity net.utbox.model.router.SimpleRouterRule on table simple_router_rule
12:45:08,379 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.router.CustomerTokenOverflowProviderOrder
12:45:08,379 INFO EntityBinder:530 - Bind entity net.utbox.model.router.CustomerTokenOverflowProviderOrder on table customer_token_overflow_provider_order
12:45:08,381 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.ProviderBlacklist
12:45:08,381 INFO EntityBinder:530 - Bind entity net.utbox.model.ProviderBlacklist on table provider_blacklist
12:45:08,383 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.SummaryReport
12:45:08,383 INFO EntityBinder:530 - Bind entity net.utbox.model.SummaryReport on table summary_report
12:45:08,385 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.FaxDocumentSet
12:45:08,386 INFO EntityBinder:530 - Bind entity net.utbox.model.FaxDocumentSet on table fax_document_set
12:45:08,387 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.config.Preference
12:45:08,388 INFO EntityBinder:530 - Bind entity net.utbox.model.config.Preference on table preference
12:45:08,392 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.FaxRoute
12:45:08,392 INFO EntityBinder:530 - Bind entity net.utbox.model.FaxRoute on table fax_route
12:45:08,394 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.PrefixGroupSet
12:45:08,394 INFO EntityBinder:530 - Bind entity net.utbox.model.PrefixGroupSet on table prefix_group_set
12:45:08,395 INFO AnnotationBinder:532 - Binding entity from annotated class: net.utbox.model.Account
12:45:08,395 INFO EntityBinder:530 - Bind entity net.utbox.model.Account on table account
12:45:08,407 INFO CollectionBinder:762 - Mapping collection: net.utbox.model.RoutedFaxMessageAttemptSet.faxMessageAttempts -> fax_message_attempt
12:45:08,407 INFO CollectionBinder:762 - Mapping collection: net.utbox.model.FaxMessage.attempts -> fax_message_attempt
12:45:08,407 INFO CollectionBinder:762 - Mapping collection: net.utbox.model.FaxDocument.faxDocumentSetEntries -> fax_document_set_entry
12:45:08,408 INFO CollectionBinder:762 - Mapping collection: net.utbox.model.hylafax.IncomingFaxProvider.incomingFaxNumbers -> incoming_fax_number
12:45:08,408 INFO CollectionBinder:762 - Mapping collection: net.utbox.model.TiffPayload.faxMessages -> fax_message
12:45:08,408 INFO CollectionBinder:762 - Mapping collection: net.utbox.model.SiteNode.faxServers -> fax_server
12:45:08,408 INFO CollectionBinder:762 - Mapping collection: net.utbox.model.SiteNode.incomingFaxServers -> incoming_fax_server
12:45:08,408 INFO CollectionBinder:762 - Mapping collection: net.utbox.model.FaxDocumentSetEntry.mergeFields -> merge_field
12:45:08,408 INFO CollectionBinder:762 - Mapping collection: net.utbox.model.FaxDocumentSet.faxDocumentSetEntries -> fax_document_set_entry
12:45:08,409 INFO CollectionBinder:762 - Mapping collection: net.utbox.model.FaxDocumentSet.faxMessages -> fax_message
12:45:08,412 INFO Configuration:1676 - Hibernate Validator not found: ignoring
12:45:08,432 INFO Version:27 - HV000001: Hibernate Validator 4.3.1.Final
12:45:08,591 INFO AnnotationSessionFactoryBean:777 - Building new Hibernate SessionFactory
12:45:08,658 INFO HibernateSearchEventListenerRegister:75 - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
12:45:08,679 INFO ConnectionProviderFactory:173 - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
12:45:08,706 INFO AbstractPoolBackedDataSource:462 - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> z8kfsx9o76g12c1k8vwbb|128ae45a, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.postgresql.ds.PGSimpleDataSource, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> z8kfsx9o76g12c1k8vwbb|128ae45a, idleConnectionTestPeriod -> 29, initialPoolSize -> 3, jdbcUrl -> jdbc:postgresql://localhost/utjava, lastAcquisitionFailureDefaultUser -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 60, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
12:45:08,773 INFO Dialect:136 - Using dialect: org.hibernate.dialect.PostgreSQLDialect
12:45:08,778 INFO JdbcSupportLoader:108 - Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
12:45:08,779 INFO SettingsFactory:126 - Database ->
name : PostgreSQL
version : 9.6.2
major : 9
minor : 6
12:45:08,779 INFO SettingsFactory:132 - Driver ->
name : PostgreSQL Native Driver
version : PostgreSQL 9.0 JDBC4 (build 801)
major : 9
minor : 0
12:45:08,780 INFO TransactionFactoryFactory:65 - Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory
12:45:08,781 INFO TransactionManagerLookupFactory:83 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
12:45:08,781 INFO SettingsFactory:179 - Automatic flush during beforeCompletion(): disabled
12:45:08,781 INFO SettingsFactory:183 - Automatic session close at end of transaction: disabled
12:45:08,781 INFO SettingsFactory:190 - JDBC batch size: 20
12:45:08,781 INFO SettingsFactory:193 - JDBC batch updates for versioned data: disabled
12:45:08,781 INFO SettingsFactory:448 - Batcher factory: net.utbox.postgres.PostgresPartitionBatcherFactory
12:45:08,782 INFO SettingsFactory:198 - Scrollable result sets: enabled
12:45:08,782 INFO SettingsFactory:206 - JDBC3 getGeneratedKeys(): enabled
12:45:08,782 INFO SettingsFactory:214 - Connection release mode: auto
12:45:08,782 INFO SettingsFactory:241 - Default batch fetch size: 1
12:45:08,782 INFO SettingsFactory:245 - Generate SQL with comments: disabled
12:45:08,782 INFO SettingsFactory:249 - Order SQL updates by primary key: disabled
12:45:08,783 INFO SettingsFactory:253 - Order SQL inserts for batching: disabled
12:45:08,783 INFO SettingsFactory:431 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
12:45:08,784 INFO ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory
12:45:08,784 INFO SettingsFactory:261 - Query language substitutions: {}
12:45:08,784 INFO SettingsFactory:266 - JPA-QL strict compliance: disabled
12:45:08,784 INFO SettingsFactory:271 - Second-level cache: enabled
12:45:08,784 INFO SettingsFactory:275 - Query cache: disabled
12:45:08,784 INFO SettingsFactory:406 - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
12:45:08,785 INFO SettingsFactory:285 - Optimize cache for minimal puts: disabled
12:45:08,785 INFO SettingsFactory:294 - Structured second-level cache entries: disabled
12:45:08,787 INFO SettingsFactory:323 - Statistics: disabled
12:45:08,787 INFO SettingsFactory:327 - Deleted entity synthetic identifier rollback: disabled
12:45:08,788 INFO SettingsFactory:343 - Default entity-mode: pojo
12:45:08,788 INFO SettingsFactory:347 - Named query checking : enabled
12:45:08,788 INFO SettingsFactory:351 - Check Nullability in Core (should be disabled when Bean Validation is on): disabled
12:45:08,797 INFO SessionFactoryImpl:202 - building session factory
12:45:08,800 INFO BasicTypeRegistry:150 - Type registration [materialized_blob] overrides previous : org.hibernate.type.MaterializedBlobType@17072b90
12:45:09,204 INFO SessionFactoryObjectFactory:105 - Not binding factory to JNDI, no JNDI name configured
12:45:09,264 INFO SpringDaoGenerator:97 - Generated DAO bean "fpsBlocklistDao" for net.utbox.model.FpsBlocklist
12:45:09,264 INFO SpringDaoGenerator:97 - Generated DAO bean "mergeFieldDao" for net.utbox.model.MergeField
12:45:09,265 INFO SpringDaoGenerator:97 - Generated DAO bean "routedFaxMessageAttemptSetDao" for net.utbox.model.RoutedFaxMessageAttemptSet
12:45:09,265 INFO SpringDaoGenerator:97 - Generated DAO bean "faxMessageDao" for net.utbox.model.FaxMessage
12:45:09,265 INFO SpringDaoGenerator:97 - Generated DAO bean "whirlwindFaxServerDao" for net.utbox.model.WhirlwindFaxServer
12:45:09,265 INFO SpringDaoGenerator:97 - Generated DAO bean "globalRoutingRuleDao" for net.utbox.model.GlobalRoutingRule
12:45:09,265 INFO SpringDaoGenerator:97 - Generated DAO bean "transactionDao" for net.utbox.model.Transaction
12:45:09,265 INFO SpringDaoGenerator:97 - Generated DAO bean "faxMessageStatusModifierDao" for net.utbox.model.FaxMessageStatusModifier
12:45:09,265 INFO SpringDaoGenerator:97 - Generated DAO bean "faxMessageAttemptDao" for net.utbox.model.FaxMessageAttempt
12:45:09,265 INFO SpringDaoGenerator:97 - Generated DAO bean "prefixGroupDao" for net.utbox.model.PrefixGroup
12:45:09,265 INFO SpringDaoGenerator:97 - Generated DAO bean "faxFailureHistoryDao" for net.utbox.model.FaxFailureHistory
12:45:09,266 INFO SpringDaoGenerator:97 - Generated DAO bean "routingPrefixDao" for net.utbox.model.RoutingPrefix
12:45:09,266 INFO SpringDaoGenerator:97 - Generated DAO bean "prefixDao" for net.utbox.model.Prefix
12:45:09,266 INFO SpringDaoGenerator:97 - Generated DAO bean "msConversionServerDao" for net.utbox.model.MsConversionServer
12:45:09,266 INFO SpringDaoGenerator:97 - Generated DAO bean "hylafaxIncomingFaxServerDao" for net.utbox.model.HylafaxIncomingFaxServer
12:45:09,266 INFO SpringDaoGenerator:97 - Generated DAO bean "faxProviderDao" for net.utbox.model.FaxProvider
12:45:09,266 INFO SpringDaoGenerator:97 - Generated DAO bean "faxDocumentDao" for net.utbox.model.FaxDocument
12:45:09,266 INFO SpringDaoGenerator:97 - Generated DAO bean "providerDao" for net.utbox.model.Provider
12:45:09,266 INFO SpringDaoGenerator:97 - Generated DAO bean "incomingFaxNumberDao" for net.utbox.model.hylafax.IncomingFaxNumber
12:45:09,266 INFO SpringDaoGenerator:97 - Generated DAO bean "receivedFaxMessageDao" for net.utbox.model.hylafax.ReceivedFaxMessage
12:45:09,266 INFO SpringDaoGenerator:97 - Generated DAO bean "incomingFaxProviderDao" for net.utbox.model.hylafax.IncomingFaxProvider
12:45:09,267 INFO SpringDaoGenerator:97 - Generated DAO bean "incomingFaxUserNumberDao" for net.utbox.model.hylafax.IncomingFaxUserNumber
12:45:09,267 INFO SpringDaoGenerator:97 - Generated DAO bean "tiffPayloadDao" for net.utbox.model.TiffPayload
12:45:09,267 INFO SpringDaoGenerator:97 - Generated DAO bean "faxServerDao" for net.utbox.model.FaxServer
12:45:09,267 INFO SpringDaoGenerator:97 - Generated DAO bean "siteNodeDao" for net.utbox.model.SiteNode
12:45:09,267 INFO SpringDaoGenerator:97 - Generated DAO bean "faxDocumentSetEntryDao" for net.utbox.model.FaxDocumentSetEntry
12:45:09,267 INFO SpringDaoGenerator:97 - Generated DAO bean "imageStampMergeFieldDao" for net.utbox.model.ImageStampMergeField
12:45:09,267 INFO SpringDaoGenerator:97 - Generated DAO bean "faxProviderRoutingPrefixDao" for net.utbox.model.FaxProviderRoutingPrefix
12:45:09,267 INFO SpringDaoGenerator:97 - Generated DAO bean "customerTokenRoutingRuleDao" for net.utbox.model.CustomerTokenRoutingRule
12:45:09,267 INFO SpringDaoGenerator:97 - Generated DAO bean "textStampMergeFieldDao" for net.utbox.model.TextStampMergeField
12:45:09,267 INFO SpringDaoGenerator:97 - Generated DAO bean "docMergeFieldDao" for net.utbox.model.DocMergeField
12:45:09,268 INFO SpringDaoGenerator:97 - Generated DAO bean "lockDao" for net.utbox.model.lock.Lock
12:45:09,268 INFO SpringDaoGenerator:97 - Generated DAO bean "prefixMaxRetriesDao" for net.utbox.model.PrefixMaxRetries
12:45:09,268 INFO SpringDaoGenerator:97 - Generated DAO bean "userRoutingRuleDao" for net.utbox.model.UserRoutingRule
12:45:09,268 INFO SpringDaoGenerator:97 - Generated DAO bean "incomingFaxServerDao" for net.utbox.model.IncomingFaxServer
12:45:09,268 INFO SpringDaoGenerator:97 - Generated DAO bean "globalOverflowProviderOrderDao" for net.utbox.model.router.GlobalOverflowProviderOrder
12:45:09,268 INFO SpringDaoGenerator:97 - Generated DAO bean "userOverflowProviderOrderDao" for net.utbox.model.router.UserOverflowProviderOrder
12:45:09,268 INFO SpringDaoGenerator:97 - Generated DAO bean "simpleRouterRuleDao" for net.utbox.model.router.SimpleRouterRule
12:45:09,268 INFO SpringDaoGenerator:97 - Generated DAO bean "customerTokenOverflowProviderOrderDao" for net.utbox.model.router.CustomerTokenOverflowProviderOrder
12:45:09,268 INFO SpringDaoGenerator:97 - Generated DAO bean "summaryReportDao" for net.utbox.model.SummaryReport
12:45:09,269 INFO SpringDaoGenerator:97 - Generated DAO bean "faxDocumentSetDao" for net.utbox.model.FaxDocumentSet
12:45:09,269 INFO SpringDaoGenerator:97 - Generated DAO bean "preferenceDao" for net.utbox.model.config.Preference
12:45:09,269 INFO SpringDaoGenerator:97 - Generated DAO bean "faxRouteDao" for net.utbox.model.FaxRoute
12:45:09,269 INFO SpringDaoGenerator:97 - Generated DAO bean "prefixGroupSetDao" for net.utbox.model.PrefixGroupSet
12:45:09,269 INFO SpringDaoGenerator:97 - Generated DAO bean "accountDao" for net.utbox.model.Account
12:45:09,271 INFO DefaultListableBeanFactory:623 - Overriding bean definition for bean 'globalOverflowProviderOrderDao': replacing [Generic bean: class [net.utbox.dao.HibernateDao]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Generic bean: class [net.utbox.dao.HibernateDao]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
12:45:09,271 INFO SpringDaoGenerator:97 - Generated DAO bean "globalOverflowProviderOrderDao" for net.utbox.model.router.GlobalOverflowProviderOrder
12:45:09,271 INFO DefaultListableBeanFactory:623 - Overriding bean definition for bean 'userOverflowProviderOrderDao': replacing [Generic bean: class [net.utbox.dao.HibernateDao]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Generic bean: class [net.utbox.dao.HibernateDao]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
12:45:09,271 INFO SpringDaoGenerator:97 - Generated DAO bean "userOverflowProviderOrderDao" for net.utbox.model.router.UserOverflowProviderOrder
12:45:09,271 INFO DefaultListableBeanFactory:623 - Overriding bean definition for bean 'simpleRouterRuleDao': replacing [Generic bean: class [net.utbox.dao.HibernateDao]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Generic bean: class [net.utbox.dao.HibernateDao]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
12:45:09,272 INFO SpringDaoGenerator:97 - Generated DAO bean "simpleRouterRuleDao" for net.utbox.model.router.SimpleRouterRule
12:45:09,272 INFO DefaultListableBeanFactory:623 - Overriding bean definition for bean 'customerTokenOverflowProviderOrderDao': replacing [Generic bean: class [net.utbox.dao.HibernateDao]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Generic bean: class [net.utbox.dao.HibernateDao]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
12:45:09,272 INFO SpringDaoGenerator:97 - Generated DAO bean "customerTokenOverflowProviderOrderDao" for net.utbox.model.router.CustomerTokenOverflowProviderOrder
12:45:09,273 INFO DefaultListableBeanFactory:623 - Overriding bean definition for bean 'preferenceDao': replacing [Generic bean: class [net.utbox.dao.HibernateDao]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Generic bean: class [net.utbox.dao.HibernateDao]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
12:45:09,273 INFO SpringDaoGenerator:97 - Generated DAO bean "preferenceDao" for net.utbox.model.config.Preference
12:45:09,329 INFO DefaultListableBeanFactory:557 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@7c0b6548: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,dataSource,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#1,abstractPooledPgDataSource,abstractPgDataSource,abstractInMemoryHsqlDataSource,abstractDiskHsqlDataSource,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,txManager,txAdvice,jmsErrorHandler,transactionRunner,jmsQueueService,abstractJmsConnectionFactory,jmsConnectionFactory,jmsTransactionManager,jmsProducerConnectionFactory,jmsConsumerConnectionFactory,jmsTemplate,daoGenerator1,daoGenerator2,daoGenerator3,faxStatusModifierPauseProcessor,faxStatusModifierStopProcessor,faxStatusModifierResumeProcessor,imageStampMergeFieldServiceImpl,overflowProviderOrderServiceImpl,whirldwindFaxServerServiceImpl,prefixGroupServiceImpl,globalRoutingRuleServiceImpl,prefixGroupSetServiceImpl,hylafaxIncomingFaxServerServiceImpl,globalOverflowProviderOrderServiceImpl,tiffPayloadServiceImpl,incomingFaxProviderServiceImpl,faxDocumentSetServiceImpl,routedFaxMessageAttemptSetServiceImpl,receivedFaxMessageServiceImpl,incomingFaxNumberServiceImpl,faxMessageAttemptServiceImpl,customerTokenOverflowProviderOrderServiceImpl,faxMessageStatusModifierServiceImpl,simpleRouterRuleServiceImpl,faxStatusModifierServiceImpl,msConversionServerServiceImpl,siteNodeServiceImpl,faxProviderService,inboundSmsMessageServiceImpl,faxDocumentServiceImpl,transactionServiceImpl,lockServiceImpl,docMergeFieldServiceImpl,rawPreferenceServiceImpl,customerTokenRoutingRuleServiceImpl,userOverflowProviderOrderServiceImpl,incomingFaxUserNumberServiceImpl,prefixServiceImpl,preferenceServiceImpl,faxMessageServiceImpl,faxDocumentSetEntryServiceImpl,userRoutingRuleServiceImpl,faxRouteServiceImpl,textStampMergeFieldServiceImpl,routingPrefixServiceImpl,prefixMaxRetriesServiceImpl,faxFailureHistoryServiceImpl,sessionFactory,conversionService,overflowRuleCommandTieringDelegate,duplicateScoredProviderReducer,scoredProviderReducer,quickOverflowRuleCommandTieringDelegate,overflowRuleCommand,simpleRouterRuleCommandDelegate,simpleRuleCommand,router,scoreReducer,setReducer,streamingRouter,routingPrefixCache,groupRouter,activeMQConnectionFactory,routerGrouper,jmsGrouperDelegate,routerUtility,listenerContainer,streamingRouterListener,groupRouterListener,net.utbox.jms.DefaultJmsListenerController#0,routerSettingsChangeListener,org.springframework.scheduling.support.MethodInvokingRunnable#0,org.springframework.scheduling.config.ScheduledTaskRegistrar#0,taskScheduler,fpsBlocklistDao,mergeFieldDao,routedFaxMessageAttemptSetDao,faxMessageDao,whirlwindFaxServerDao,globalRoutingRuleDao,transactionDao,faxMessageStatusModifierDao,faxMessageAttemptDao,prefixGroupDao,faxFailureHistoryDao,routingPrefixDao,prefixDao,msConversionServerDao,hylafaxIncomingFaxServerDao,faxProviderDao,faxDocumentDao,providerDao,incomingFaxNumberDao,receivedFaxMessageDao,incomingFaxProviderDao,incomingFaxUserNumberDao,tiffPayloadDao,faxServerDao,siteNodeDao,faxDocumentSetEntryDao,imageStampMergeFieldDao,faxProviderRoutingPrefixDao,customerTokenRoutingRuleDao,textStampMergeFieldDao,docMergeFieldDao,lockDao,prefixMaxRetriesDao,userRoutingRuleDao,incomingFaxServerDao,globalOverflowProviderOrderDao,userOverflowProviderOrderDao,simpleRouterRuleDao,customerTokenOverflowProviderOrderDao,summaryReportDao,faxDocumentSetDao,preferenceDao,faxRouteDao,prefixGroupSetDao,accountDao]; root of factory hierarchy
12:45:09,355 INFO HibernateTransactionManager:415 - Using DataSource [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> z8kfsx9o76g12c1k8vwbb|128ae45a, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.postgresql.ds.PGSimpleDataSource, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> z8kfsx9o76g12c1k8vwbb|128ae45a, idleConnectionTestPeriod -> 29, initialPoolSize -> 3, jdbcUrl -> jdbc:postgresql://localhost/utjava, lastAcquisitionFailureDefaultUser -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 60, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] of Hibernate SessionFactory for HibernateTransactionManager
12:45:09,965 INFO RouterUtility:78 - Initializing prefix table..
12:45:10,045 INFO RouterUtility:81 - Prefix group sets: 12
12:45:10,144 INFO RouterUtility:70 - Finished initializing prefix table in 179 ms
12:45:10,145 INFO RouterUtility:100 - Loading providers..
12:45:10,148 INFO RouterUtility:105 - Loading routes..
12:45:10,151 INFO RouterUtility:111 - Loading protocol ratio map..
12:45:10,358 INFO RoutingPrefixCache:35 - Started loading RoutingPrefix data
12:45:10,366 INFO RoutingPrefixCache:37 - Finished loading RoutingPrefix data with 0 records.
12:45:10,404 INFO LockableJmsGrouper:83 - Starting grouper thread
12:45:10,445 INFO ThreadPoolTaskScheduler:115 - Initializing ExecutorService 'taskScheduler'
12:45:10,453 INFO DefaultLifecycleProcessor:330 - Starting beans in phase 2147483647
12:45:10,631 INFO FailoverTransport:891 - Successfully connected to nio://localhost:61616?wireFormat.maxInactivityDuration=0
12:45:10,646 INFO FailoverTransport:891 - Successfully connected to nio://localhost:61616?wireFormat.maxInactivityDuration=0
12:45:10,651 INFO DefaultLifecycleProcessor:330 - Starting beans in phase 2147483647
12:45:33,247 INFO StreamingRouter:60 - Running Streaming Commands for attemptId=3006
12:45:33,258 INFO SimpleRouterRuleCommand:108 - No SimpleRouterRule found for PrefixGroupSet: Australia
12:45:33,258 INFO SimpleRouterRuleCommand:109 - Using default FaxProvider for attempt: 3006
12:45:33,258 INFO SimpleRouterRuleCommand:126 - SimpleRouterRule results: [[provider: FaxProvider(super=Provider(id=1, name=hylafax-loop, orderNumber=1, enabled=true), numberFormat=LOCALIZED_AUSTRALIA) score: 1.0 protocol limit: null tier: 0 smartblock candidate: false]]
12:45:33,275 WARN JDBCExceptionReporter:233 - SQL Error: 0, SQLState: 42601
12:45:33,275 ERROR JDBCExceptionReporter:234 - ERROR: syntax error at or near ")"
Position: 1616
12:45:33,280 ERROR JmsErrorHandler:23 - Error in JMS listener
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
at net.utbox.service.hb.FaxFailureHistoryServiceImpl.fetchByNumberAndFaxRoutes(FaxFailureHistoryServiceImpl.java:30)
at net.utbox.router.command.OverflowRuleCommand.findHistoryOfFailedRoutesForTheNumber(OverflowRuleCommand.java:85)
at net.utbox.router.command.OverflowRuleCommand.route(OverflowRuleCommand.java:36)
at net.utbox.router.command.OverflowRuleCommand$$FastClassByCGLIB$$d314a678.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
at net.utbox.router.command.OverflowRuleCommand$$EnhancerByCGLIB$$553162e8.route(<generated>)
at net.utbox.router.RouterImpl.runStreamingCommands(RouterImpl.java:98)
at net.utbox.router.jms.StreamingRouter.process(StreamingRouter.java:61)
at net.utbox.router.jms.StreamingRouter.onMessage(StreamingRouter.java:44)
at net.utbox.router.jms.StreamingRouter$$FastClassByCGLIB$$3967ac3b.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617)
at net.utbox.router.jms.StreamingRouter$$EnhancerByCGLIB$$4f026349.onMessage(<generated>)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:535)
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:495)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
Position: 1616
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 32 more
12:45:34,290 INFO StreamingRouter:60 - Running Streaming Commands for attemptId=3006
12:45:34,295 INFO SimpleRouterRuleCommand:108 - No SimpleRouterRule found for PrefixGroupSet: Australia
12:45:34,295 INFO SimpleRouterRuleCommand:109 - Using default FaxProvider for attempt: 3006
12:45:34,295 INFO SimpleRouterRuleCommand:126 - SimpleRouterRule results: [[provider: FaxProvider(super=Provider(id=1, name=hylafax-loop, orderNumber=1, enabled=true), numberFormat=LOCALIZED_AUSTRALIA) score: 1.0 protocol limit: null tier: 0 smartblock candidate: false]]
12:45:34,298 WARN JDBCExceptionReporter:233 - SQL Error: 0, SQLState: 42601
12:45:34,299 ERROR JDBCExceptionReporter:234 - ERROR: syntax error at or near ")"
Position: 1616
12:45:34,301 ERROR JmsErrorHandler:23 - Error in JMS listener
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
at net.utbox.service.hb.FaxFailureHistoryServiceImpl.fetchByNumberAndFaxRoutes(FaxFailureHistoryServiceImpl.java:30)
at net.utbox.router.command.OverflowRuleCommand.findHistoryOfFailedRoutesForTheNumber(OverflowRuleCommand.java:85)
at net.utbox.router.command.OverflowRuleCommand.route(OverflowRuleCommand.java:36)
at net.utbox.router.command.OverflowRuleCommand$$FastClassByCGLIB$$d314a678.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
at net.utbox.router.command.OverflowRuleCommand$$EnhancerByCGLIB$$553162e8.route(<generated>)
at net.utbox.router.RouterImpl.runStreamingCommands(RouterImpl.java:98)
at net.utbox.router.jms.StreamingRouter.process(StreamingRouter.java:61)
at net.utbox.router.jms.StreamingRouter.onMessage(StreamingRouter.java:44)
at net.utbox.router.jms.StreamingRouter$$FastClassByCGLIB$$3967ac3b.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617)
at net.utbox.router.jms.StreamingRouter$$EnhancerByCGLIB$$4f026349.onMessage(<generated>)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:535)
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:495)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
Position: 1616
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 32 more
12:45:35,325 INFO StreamingRouter:60 - Running Streaming Commands for attemptId=3006
12:45:35,336 INFO SimpleRouterRuleCommand:108 - No SimpleRouterRule found for PrefixGroupSet: Australia
12:45:35,337 INFO SimpleRouterRuleCommand:109 - Using default FaxProvider for attempt: 3006
12:45:35,337 INFO SimpleRouterRuleCommand:126 - SimpleRouterRule results: [[provider: FaxProvider(super=Provider(id=1, name=hylafax-loop, orderNumber=1, enabled=true), numberFormat=LOCALIZED_AUSTRALIA) score: 1.0 protocol limit: null tier: 0 smartblock candidate: false]]
12:45:35,342 WARN JDBCExceptionReporter:233 - SQL Error: 0, SQLState: 42601
12:45:35,342 ERROR JDBCExceptionReporter:234 - ERROR: syntax error at or near ")"
Position: 1616
12:45:35,346 ERROR JmsErrorHandler:23 - Error in JMS listener
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
at net.utbox.service.hb.FaxFailureHistoryServiceImpl.fetchByNumberAndFaxRoutes(FaxFailureHistoryServiceImpl.java:30)
at net.utbox.router.command.OverflowRuleCommand.findHistoryOfFailedRoutesForTheNumber(OverflowRuleCommand.java:85)
at net.utbox.router.command.OverflowRuleCommand.route(OverflowRuleCommand.java:36)
at net.utbox.router.command.OverflowRuleCommand$$FastClassByCGLIB$$d314a678.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
at net.utbox.router.command.OverflowRuleCommand$$EnhancerByCGLIB$$553162e8.route(<generated>)
at net.utbox.router.RouterImpl.runStreamingCommands(RouterImpl.java:98)
at net.utbox.router.jms.StreamingRouter.process(StreamingRouter.java:61)
at net.utbox.router.jms.StreamingRouter.onMessage(StreamingRouter.java:44)
at net.utbox.router.jms.StreamingRouter$$FastClassByCGLIB$$3967ac3b.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617)
at net.utbox.router.jms.StreamingRouter$$EnhancerByCGLIB$$4f026349.onMessage(<generated>)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:535)
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:495)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
Position: 1616
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 32 more
12:45:36,369 INFO StreamingRouter:60 - Running Streaming Commands for attemptId=3006
12:45:36,382 INFO SimpleRouterRuleCommand:108 - No SimpleRouterRule found for PrefixGroupSet: Australia
12:45:36,382 INFO SimpleRouterRuleCommand:109 - Using default FaxProvider for attempt: 3006
12:45:36,383 INFO SimpleRouterRuleCommand:126 - SimpleRouterRule results: [[provider: FaxProvider(super=Provider(id=1, name=hylafax-loop, orderNumber=1, enabled=true), numberFormat=LOCALIZED_AUSTRALIA) score: 1.0 protocol limit: null tier: 0 smartblock candidate: false]]
12:45:36,388 WARN JDBCExceptionReporter:233 - SQL Error: 0, SQLState: 42601
12:45:36,389 ERROR JDBCExceptionReporter:234 - ERROR: syntax error at or near ")"
Position: 1616
12:45:36,392 ERROR JmsErrorHandler:23 - Error in JMS listener
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
at net.utbox.service.hb.FaxFailureHistoryServiceImpl.fetchByNumberAndFaxRoutes(FaxFailureHistoryServiceImpl.java:30)
at net.utbox.router.command.OverflowRuleCommand.findHistoryOfFailedRoutesForTheNumber(OverflowRuleCommand.java:85)
at net.utbox.router.command.OverflowRuleCommand.route(OverflowRuleCommand.java:36)
at net.utbox.router.command.OverflowRuleCommand$$FastClassByCGLIB$$d314a678.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
at net.utbox.router.command.OverflowRuleCommand$$EnhancerByCGLIB$$553162e8.route(<generated>)
at net.utbox.router.RouterImpl.runStreamingCommands(RouterImpl.java:98)
at net.utbox.router.jms.StreamingRouter.process(StreamingRouter.java:61)
at net.utbox.router.jms.StreamingRouter.onMessage(StreamingRouter.java:44)
at net.utbox.router.jms.StreamingRouter$$FastClassByCGLIB$$3967ac3b.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617)
at net.utbox.router.jms.StreamingRouter$$EnhancerByCGLIB$$4f026349.onMessage(<generated>)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:535)
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:495)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
Position: 1616
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 32 more
12:45:37,412 INFO StreamingRouter:60 - Running Streaming Commands for attemptId=3006
12:45:37,424 INFO SimpleRouterRuleCommand:108 - No SimpleRouterRule found for PrefixGroupSet: Australia
12:45:37,424 INFO SimpleRouterRuleCommand:109 - Using default FaxProvider for attempt: 3006
12:45:37,424 INFO SimpleRouterRuleCommand:126 - SimpleRouterRule results: [[provider: FaxProvider(super=Provider(id=1, name=hylafax-loop, orderNumber=1, enabled=true), numberFormat=LOCALIZED_AUSTRALIA) score: 1.0 protocol limit: null tier: 0 smartblock candidate: false]]
12:45:37,431 WARN JDBCExceptionReporter:233 - SQL Error: 0, SQLState: 42601
12:45:37,431 ERROR JDBCExceptionReporter:234 - ERROR: syntax error at or near ")"
Position: 1616
12:45:37,435 ERROR JmsErrorHandler:23 - Error in JMS listener
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
at net.utbox.service.hb.FaxFailureHistoryServiceImpl.fetchByNumberAndFaxRoutes(FaxFailureHistoryServiceImpl.java:30)
at net.utbox.router.command.OverflowRuleCommand.findHistoryOfFailedRoutesForTheNumber(OverflowRuleCommand.java:85)
at net.utbox.router.command.OverflowRuleCommand.route(OverflowRuleCommand.java:36)
at net.utbox.router.command.OverflowRuleCommand$$FastClassByCGLIB$$d314a678.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
at net.utbox.router.command.OverflowRuleCommand$$EnhancerByCGLIB$$553162e8.route(<generated>)
at net.utbox.router.RouterImpl.runStreamingCommands(RouterImpl.java:98)
at net.utbox.router.jms.StreamingRouter.process(StreamingRouter.java:61)
at net.utbox.router.jms.StreamingRouter.onMessage(StreamingRouter.java:44)
at net.utbox.router.jms.StreamingRouter$$FastClassByCGLIB$$3967ac3b.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617)
at net.utbox.router.jms.StreamingRouter$$EnhancerByCGLIB$$4f026349.onMessage(<generated>)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:535)
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:495)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
Position: 1616
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 32 more
12:45:38,454 INFO StreamingRouter:60 - Running Streaming Commands for attemptId=3006
12:45:38,459 INFO SimpleRouterRuleCommand:108 - No SimpleRouterRule found for PrefixGroupSet: Australia
12:45:38,459 INFO SimpleRouterRuleCommand:109 - Using default FaxProvider for attempt: 3006
12:45:38,459 INFO SimpleRouterRuleCommand:126 - SimpleRouterRule results: [[provider: FaxProvider(super=Provider(id=1, name=hylafax-loop, orderNumber=1, enabled=true), numberFormat=LOCALIZED_AUSTRALIA) score: 1.0 protocol limit: null tier: 0 smartblock candidate: false]]
12:45:38,461 WARN JDBCExceptionReporter:233 - SQL Error: 0, SQLState: 42601
12:45:38,462 ERROR JDBCExceptionReporter:234 - ERROR: syntax error at or near ")"
Position: 1616
12:45:38,463 ERROR JmsErrorHandler:23 - Error in JMS listener
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
at net.utbox.service.hb.FaxFailureHistoryServiceImpl.fetchByNumberAndFaxRoutes(FaxFailureHistoryServiceImpl.java:30)
at net.utbox.router.command.OverflowRuleCommand.findHistoryOfFailedRoutesForTheNumber(OverflowRuleCommand.java:85)
at net.utbox.router.command.OverflowRuleCommand.route(OverflowRuleCommand.java:36)
at net.utbox.router.command.OverflowRuleCommand$$FastClassByCGLIB$$d314a678.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
at net.utbox.router.command.OverflowRuleCommand$$EnhancerByCGLIB$$553162e8.route(<generated>)
at net.utbox.router.RouterImpl.runStreamingCommands(RouterImpl.java:98)
at net.utbox.router.jms.StreamingRouter.process(StreamingRouter.java:61)
at net.utbox.router.jms.StreamingRouter.onMessage(StreamingRouter.java:44)
at net.utbox.router.jms.StreamingRouter$$FastClassByCGLIB$$3967ac3b.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617)
at net.utbox.router.jms.StreamingRouter$$EnhancerByCGLIB$$4f026349.onMessage(<generated>)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:535)
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:495)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
Position: 1616
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 32 more
12:45:39,484 INFO StreamingRouter:60 - Running Streaming Commands for attemptId=3006
12:45:39,495 INFO SimpleRouterRuleCommand:108 - No SimpleRouterRule found for PrefixGroupSet: Australia
12:45:39,495 INFO SimpleRouterRuleCommand:109 - Using default FaxProvider for attempt: 3006
12:45:39,495 INFO SimpleRouterRuleCommand:126 - SimpleRouterRule results: [[provider: FaxProvider(super=Provider(id=1, name=hylafax-loop, orderNumber=1, enabled=true), numberFormat=LOCALIZED_AUSTRALIA) score: 1.0 protocol limit: null tier: 0 smartblock candidate: false]]
12:45:39,502 WARN JDBCExceptionReporter:233 - SQL Error: 0, SQLState: 42601
12:45:39,502 ERROR JDBCExceptionReporter:234 - ERROR: syntax error at or near ")"
Position: 1616
12:45:39,505 ERROR JmsErrorHandler:23 - Error in JMS listener
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
at net.utbox.service.hb.FaxFailureHistoryServiceImpl.fetchByNumberAndFaxRoutes(FaxFailureHistoryServiceImpl.java:30)
at net.utbox.router.command.OverflowRuleCommand.findHistoryOfFailedRoutesForTheNumber(OverflowRuleCommand.java:85)
at net.utbox.router.command.OverflowRuleCommand.route(OverflowRuleCommand.java:36)
at net.utbox.router.command.OverflowRuleCommand$$FastClassByCGLIB$$d314a678.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
at net.utbox.router.command.OverflowRuleCommand$$EnhancerByCGLIB$$553162e8.route(<generated>)
at net.utbox.router.RouterImpl.runStreamingCommands(RouterImpl.java:98)
at net.utbox.router.jms.StreamingRouter.process(StreamingRouter.java:61)
at net.utbox.router.jms.StreamingRouter.onMessage(StreamingRouter.java:44)
at net.utbox.router.jms.StreamingRouter$$FastClassByCGLIB$$3967ac3b.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617)
at net.utbox.router.jms.StreamingRouter$$EnhancerByCGLIB$$4f026349.onMessage(<generated>)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:535)
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:495)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
Position: 1616
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 32 more
12:47:11,981 INFO LockableJmsGrouper:88 - Initializing grouper routerGrouperLock
12:47:11,987 INFO FailoverTransport:891 - Successfully connected to nio://localhost:61616?wireFormat.maxInactivityDuration=0
12:50:00,001 INFO RouterSettingsChangeListener:48 - Checking for changes in router settings..
12:55:00,001 INFO RouterSettingsChangeListener:48 - Checking for changes in router settings..
13:00:00,000 INFO RouterSettingsChangeListener:48 - Checking for changes in router settings..
13:05:00,000 INFO RouterSettingsChangeListener:48 - Checking for changes in router settings..
13:10:00,000 INFO RouterSettingsChangeListener:48 - Checking for changes in router settings..
13:15:00,000 INFO RouterSettingsChangeListener:48 - Checking for changes in router settings..
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment