[
https://issues.jboss.org/browse/TEIIDDES-2933?page=com.atlassian.jira.plu...
]
Matej Kralik commented on TEIIDDES-2933:
----------------------------------------
[~van.halbert] Set pkField with all lowercase is not enough. I had to set lowercase for
all column in the BookCacheSource and BooksViewMat too.
Next, I noticed that PUBLISH_YEAR column has a problem too. When I deployed VDB, server
showed error that
{code:java}
TEIID21010 Did not find a corresponding write method on entity Book with name
PUBLISH_YEAR
{code}
When I removed underscore (_) from BookCacheSource and BooksViewMat , generate new JDG
module, deployed was successful.
Next, I noticed that when I have mat table with all lowercase (book) and I create JDG
materialization and generated JDG module, shows me error that
{code:java}
TEIID30504 BookCacheSource: TEIID21005 Registered Class not found for table book, check
table name matches a registered class
{code}
I noticed that generated JDG module contains Book.class but the table is 'book' so
that the class should be book.class . I think that this will be resolved by
https://issues.jboss.org/browse/TEIIDDES-2925
[~van.halbert] To your comment about ST_ table.
When I create my project with JDG materialization I proceeded according to JDG
materialization quick start. But I had to set staging table in the
"teiid_rel:MATVIEW_LOAD_SCRIPT" to Book because when I set ST_Book1 which the
designer generated on the server shows me error that
{code:java}
org.teiid.jdbc.TeiidSQLException: TEIID30504 BookCacheSource: TEIID21005 Registered Class
not found for table ST_Book1, check table name matches a registered class
{code}
This same error shows me when I set "teiid_rel:MATERIALIZED_STAGE_TABLE"
'BookCacheSource.ST_Book1' instead of "teiid_rel:MATVIEW_LOAD_SCRIPT"
It is an issue or I do something wrong ?
No such accessible property/method in the class after deploy vdb
----------------------------------------------------------------
Key: TEIIDDES-2933
URL:
https://issues.jboss.org/browse/TEIIDDES-2933
Project: Teiid Designer
Issue Type: Bug
Components: Dynamic VDBs
Affects Versions: 10.0.2
Reporter: Matej Kralik
Assignee: Van Halbert
Attachments: jdgTest.zip
When I want to deploy dynamic VDB with JDG materialization, the server shows me :
TEIID31111 No such accessible property/method ISBN on class org.teiid.jdg.pojo.Book.
I looked at Book.java and ISBN is there.
The class is generated in the teiid designer. In the attachment is the project with
dynamicVDB and generated JDG module.
Stacktrace:
{code:java}
12:34:07,140 WARN [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue223) Connector
worker process failed for atomic-request=e3xcwoJghvNm.0.69.131:
org.teiid.translator.TranslatorException: TEIID31111 No such accessible property/method
ISBN on class org.teiid.jdg.pojo.Book.
at
org.teiid.translator.object.ObjectUpdateExecution.evaluate(ObjectUpdateExecution.java:524)
[translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.translator.object.ObjectUpdateExecution.handleInsert(ObjectUpdateExecution.java:219)
[translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.translator.object.ObjectUpdateExecution.executeUpdate(ObjectUpdateExecution.java:150)
[translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.translator.object.ObjectUpdateExecution.execute(ObjectUpdateExecution.java:108)
[translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:402)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source) [:1.8.0_91]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_91]
at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_91]
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at com.sun.proxy.$Proxy46.execute(Unknown Source)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:142)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.query.processor.relational.ProjectIntoNode.checkExitConditions(ProjectIntoNode.java:264)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.query.processor.relational.ProjectIntoNode.nextBatchDirect(ProjectIntoNode.java:164)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:608)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:69)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.query.processor.proc.ExecDynamicSqlInstruction$1.process(ExecDynamicSqlInstruction.java:218)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:389)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:298)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:270)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[rt.jar:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[rt.jar:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_91]
Caused by: javax.script.ScriptException: TEIID31111 No such accessible property/method
ISBN on class org.teiid.jdg.pojo.Book.
at org.teiid.query.eval.TeiidScriptEngine$1.eval(TeiidScriptEngine.java:132)
[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at
org.teiid.translator.object.ObjectUpdateExecution.evaluate(ObjectUpdateExecution.java:521)
[translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8]
... 47 more
12:34:07,146 WARN [org.teiid.MATVIEWS] (Worker0_QueryProcessorQueue225)
org.teiid.jdbc.TeiidSQLException: TEIID30504 BookCacheSource: TEIID31111 No such
accessible property/method ISBN on class org.teiid.jdg.pojo.Book.
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)