-
Bug
-
Resolution: Done
-
Major
-
1.2.0.Final
-
None
Attempting to execute this JCR-SQL query:
SELECT drools:title, drools:description, drools:archive FROM drools:assetNodeType WHERE jcr:path LIKE '/drools:repository/drools:package_area/%' AND (drools:subject LIKE 'testQueryXXX42' OR drools:subject LIKE 'wankle') AND (drools:source LIKE 'database' OR drools:source LIKE 'wankle') AND drools:archive = 'false' AND jcr:created > TIMESTAMP '1974-07-10T00:00:00.000-05:00' AND jcr:created < TIMESTAMP '3074-07-10T00:00:00.000-05:00'
Leads to this stack trace:
org.drools.repository.RulesRepositoryException: javax.jcr.RepositoryException: Error while performing the query "Access [__ALLNODES__]
Project [__ALLNODES__] <PROJECT_COLUMNS=[__ALLNODES__.drools:title, __ALLNODES__.drools:description, __ALLNODES__.drools:archive]>
Select [__ALLNODES__] <SELECT_CRITERIA=_ALLNODES_.jcr:created BETWEEN '1974-07-10T05:00:00.000Z' EXCLUSIVE AND '3074-07-10T05:00:00.000Z' EXCLUSIVE>
Select [__ALLNODES__] <SELECT_CRITERIA=PATH(_ALLNODES_) LIKE '/drools:repository/drools:package_area/%'>
Select [__ALLNODES__] <SELECT_CRITERIA=(_ALLNODES.drools:subject LIKE 'testQueryXXX42' OR __ALLNODES_.drools:subject LIKE 'wankle')>
Select [__ALLNODES__] <SELECT_CRITERIA=(_ALLNODES.drools:source LIKE 'database' OR __ALLNODES_.drools:source LIKE 'wankle')>
Select [__ALLNODES__] <SELECT_CRITERIA=_ALLNODES_.drools:archive = 'false'>
Select [__ALLNODES__] <SELECT_CRITERIA=_ALLNODES_.jcr:primaryType = 'drools:assetNodeType'>
Source [__ALLNODES__] <SOURCE_COLUMNS=[drools:rights(STRING), jcr:isCheckedOut(BOOLEAN), drools:categoryReference(REFERENCE), jcr:autoCreated(BOOLEAN), drools:checkinComment(STRING), jcr:root(REFERENCE), mode:lockingSession(STRING), jcr:name(STRING), jcr:baseVersion(REFERENCE), jcr:isFullTextSearchable(BOOLEAN), jcr:protocol(STRING), jcr:successors(REFERENCE), drools:attachmentFileName(STRING), drools:archive(BOOLEAN), jcr:activity(REFERENCE), jcr:requiredType(STRING), jcr:isDeep(BOOLEAN), drools:relation(STRING), drools:publisher(STRING), jcr:copiedFrom(REFERENCE), jcr:retentionPolicy(REFERENCE), mode:expirationDate(DATE), drools:type(STRING), jcr:defaultValues(STRING), jcr:isQueryOrderable(BOOLEAN), jcr:frozenUuid(STRING), drools:compiledPackage(BINARY), jcr:onParentVersion(STRING), mode:isHeldBySession(BOOLEAN), drools:dateEffective(DATE), jcr:lockOwner(STRING), drools:header(STRING), mode:uri(STRING), jcr:mandatory(BOOLEAN), jcr:encoding(STRING), jcr:childVersionHistory(REFERENCE), mode:workspace(STRING), jcr:created(DATE), jcr:lockIsDeep(BOOLEAN), jcr:versionableUuid(STRING), jcr:createdBy(STRING), drools:externalURI(STRING), jcr:id(REFERENCE), jcr:primaryItemName(STRING), jcr:language(STRING), jcr:nodeTypeName(STRING), drools:title(STRING), jcr:workspace(STRING), jcr:mergeFailed(REFERENCE), mode:lockedUuid(STRING), jcr:defaultPrimaryType(STRING), jcr:data(BINARY), jcr:text(STRING), drools:creator(STRING), jcr:mimeType(STRING), jcr:versionHistory(REFERENCE), drools:binaryContent(BINARY), jcr:title(STRING), jcr:protected(BOOLEAN), jcr:currentLifecycleState(STRING), jcr:sameNameSiblings(BOOLEAN), jcr:configuration(REFERENCE), drools:coverage(STRING), jcr:port(STRING), drools:source(STRING), jcr:activityTitle(STRING), jcr:primaryType(STRING), drools:packageName(STRING), drools:dateExpired(DATE), drools:content(STRING), jcr:multiple(BOOLEAN), jcr:isQueryable(BOOLEAN), jcr:lastModified(DATE), jcr:isAbstract(BOOLEAN), jcr:statement(STRING), jcr:description(STRING), jcr:messageId(STRING), mode:sessionScope(BOOLEAN), jcr:supertypes(STRING), drools:lastModified(DATE), jcr:repository(STRING), drools:lastContributor(STRING), jcr:requiredPrimaryTypes(STRING), jcr:hold(STRING), drools:format(STRING), drools:stateReference(REFERENCE), jcr:uuid(STRING), jcr:content(REFERENCE), jcr:path(PATH), jcr:predecessors(REFERENCE), jcr:lifecyclePolicy(REFERENCE), drools:versionNumber(LONG), drools:subject(STRING), jcr:frozenMixinTypes(STRING), jcr:hasOrderableChildNodes(BOOLEAN), drools:description(STRING), jcr:frozenPrimaryType(STRING), jcr:availableQueryOperators(STRING), jcr:isMixin(BOOLEAN), jcr:mixinTypes(STRING), drools:createdDate(DATE), jcr:valueConstraints(STRING), jcr:lastModifiedBy(STRING), jcr:host(STRING)], SOURCE_NAME=_ALLNODES_>
" against the content in the "" workspace of the "_ALLNODES_" source: Error converting String to a Long: 1974-07-10T05:00:00.000Z
at org.drools.repository.RulesRepository.query(RulesRepository.java:1444)
at org.drools.repository.RulesRepositoryTest.testQuery(RulesRepositoryTest.java:336)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at junit.framework.TestCase.runTest(TestCase.java:168)
at junit.framework.TestCase.runBare(TestCase.java:134)
at junit.framework.TestResult$1.protect(TestResult.java:110)
at junit.framework.TestResult.runProtected(TestResult.java:128)
at junit.framework.TestResult.run(TestResult.java:113)
at junit.framework.TestCase.run(TestCase.java:124)
at junit.framework.TestSuite.runTest(TestSuite.java:232)
at junit.framework.TestSuite.run(TestSuite.java:227)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:83)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: javax.jcr.RepositoryException: Error while performing the query "Access [__ALLNODES__]
Project [__ALLNODES__] <PROJECT_COLUMNS=[__ALLNODES__.drools:title, __ALLNODES__.drools:description, __ALLNODES__.drools:archive]>
Select [__ALLNODES__] <SELECT_CRITERIA=_ALLNODES_.jcr:created BETWEEN '1974-07-10T05:00:00.000Z' EXCLUSIVE AND '3074-07-10T05:00:00.000Z' EXCLUSIVE>
Select [__ALLNODES__] <SELECT_CRITERIA=PATH(_ALLNODES_) LIKE '/drools:repository/drools:package_area/%'>
Select [__ALLNODES__] <SELECT_CRITERIA=(_ALLNODES.drools:subject LIKE 'testQueryXXX42' OR __ALLNODES_.drools:subject LIKE 'wankle')>
Select [__ALLNODES__] <SELECT_CRITERIA=(_ALLNODES.drools:source LIKE 'database' OR __ALLNODES_.drools:source LIKE 'wankle')>
Select [__ALLNODES__] <SELECT_CRITERIA=_ALLNODES_.drools:archive = 'false'>
Select [__ALLNODES__] <SELECT_CRITERIA=_ALLNODES_.jcr:primaryType = 'drools:assetNodeType'>
Source [__ALLNODES__] <SOURCE_COLUMNS=[drools:rights(STRING), jcr:isCheckedOut(BOOLEAN), drools:categoryReference(REFERENCE), jcr:autoCreated(BOOLEAN), drools:checkinComment(STRING), jcr:root(REFERENCE), mode:lockingSession(STRING), jcr:name(STRING), jcr:baseVersion(REFERENCE), jcr:isFullTextSearchable(BOOLEAN), jcr:protocol(STRING), jcr:successors(REFERENCE), drools:attachmentFileName(STRING), drools:archive(BOOLEAN), jcr:activity(REFERENCE), jcr:requiredType(STRING), jcr:isDeep(BOOLEAN), drools:relation(STRING), drools:publisher(STRING), jcr:copiedFrom(REFERENCE), jcr:retentionPolicy(REFERENCE), mode:expirationDate(DATE), drools:type(STRING), jcr:defaultValues(STRING), jcr:isQueryOrderable(BOOLEAN), jcr:frozenUuid(STRING), drools:compiledPackage(BINARY), jcr:onParentVersion(STRING), mode:isHeldBySession(BOOLEAN), drools:dateEffective(DATE), jcr:lockOwner(STRING), drools:header(STRING), mode:uri(STRING), jcr:mandatory(BOOLEAN), jcr:encoding(STRING), jcr:childVersionHistory(REFERENCE), mode:workspace(STRING), jcr:created(DATE), jcr:lockIsDeep(BOOLEAN), jcr:versionableUuid(STRING), jcr:createdBy(STRING), drools:externalURI(STRING), jcr:id(REFERENCE), jcr:primaryItemName(STRING), jcr:language(STRING), jcr:nodeTypeName(STRING), drools:title(STRING), jcr:workspace(STRING), jcr:mergeFailed(REFERENCE), mode:lockedUuid(STRING), jcr:defaultPrimaryType(STRING), jcr:data(BINARY), jcr:text(STRING), drools:creator(STRING), jcr:mimeType(STRING), jcr:versionHistory(REFERENCE), drools:binaryContent(BINARY), jcr:title(STRING), jcr:protected(BOOLEAN), jcr:currentLifecycleState(STRING), jcr:sameNameSiblings(BOOLEAN), jcr:configuration(REFERENCE), drools:coverage(STRING), jcr:port(STRING), drools:source(STRING), jcr:activityTitle(STRING), jcr:primaryType(STRING), drools:packageName(STRING), drools:dateExpired(DATE), drools:content(STRING), jcr:multiple(BOOLEAN), jcr:isQueryable(BOOLEAN), jcr:lastModified(DATE), jcr:isAbstract(BOOLEAN), jcr:statement(STRING), jcr:description(STRING), jcr:messageId(STRING), mode:sessionScope(BOOLEAN), jcr:supertypes(STRING), drools:lastModified(DATE), jcr:repository(STRING), drools:lastContributor(STRING), jcr:requiredPrimaryTypes(STRING), jcr:hold(STRING), drools:format(STRING), drools:stateReference(REFERENCE), jcr:uuid(STRING), jcr:content(REFERENCE), jcr:path(PATH), jcr:predecessors(REFERENCE), jcr:lifecyclePolicy(REFERENCE), drools:versionNumber(LONG), drools:subject(STRING), jcr:frozenMixinTypes(STRING), jcr:hasOrderableChildNodes(BOOLEAN), drools:description(STRING), jcr:frozenPrimaryType(STRING), jcr:availableQueryOperators(STRING), jcr:isMixin(BOOLEAN), jcr:mixinTypes(STRING), drools:createdDate(DATE), jcr:valueConstraints(STRING), jcr:lastModifiedBy(STRING), jcr:host(STRING)], SOURCE_NAME=_ALLNODES_>
" against the content in the "" workspace of the "_ALLNODES_" source: Error converting String to a Long: 1974-07-10T05:00:00.000Z
at org.modeshape.jcr.query.qom.JcrAbstractQuery.checkForProblems(JcrAbstractQuery.java:133)
at org.modeshape.jcr.query.JcrQuery.execute(JcrQuery.java:103)
at org.drools.repository.RulesRepository.query(RulesRepository.java:1439)
... 20 more