[teiid-issues] [JBoss JIRA] (TEIID-4173) Using PI JDBC Adapter, server does not start up using simple queries
Al S (JIRA)
issues at jboss.org
Tue Apr 26 08:52:00 EDT 2016
Al S created TEIID-4173:
---------------------------
Summary: Using PI JDBC Adapter, server does not start up using simple queries
Key: TEIID-4173
URL: https://issues.jboss.org/browse/TEIID-4173
Project: Teiid
Issue Type: Feature Request
Components: JDBC Driver
Affects Versions: 8.13.3
Environment: Issue was discovered using Windows Server 2012 OS and Teiid 8.13.3
Reporter: Al S
Assignee: Steven Hawkins
Using the following model along with the PI JDBC 2015 adapter, the error below was seen at startup of Wildfly.
<vdb name="PIAF2" version="1">
<description>OSIsoft PI AF</description>
<model name="PIAF-Physical" type="PHYSICAL">
<property name="importer.useFullSchemaName" value="false"/>
<property name="importer.tableTypes" value="TABLE,VIEW"/>
<source name="piaf-connector" translator-name="osisoft-pi" connection-jndi-name="java:/pi-ds"/>
</model>
<model name="PIAF-Virtual" type="VIRTUAL">
<metadata type="DDL"><![CDATA[
CREATE VIEW IceDataTwo (
tag varchar(max)
) AS
select tag from pipoint.pipoint where tag='sinusoid'
]]> </metadata>
</model>
</vdb>
Error:
21:26:59,420 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
ol -- 61) WFLYCLINF0002: Started resultset cache from teiid container
21:26:59,514 WARN [org.teiid.RUNTIME] (Worker1_async-teiid-threads1) TEIID5003
6 VDB PIAF2.1 model "PIAF-Virtual" metadata failed to load. Reason:TEIID30386 or
g.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Enco
untered "tag varchar([*]max[*]) )" at line 3, column 25.
Was expecting: <UNSIGNEDINTEGER>: org.teiid.metadata.ParseException: TEIID30386
org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: En
countered "tag varchar([*]max[*]) )" at line 3, column 25.
Was expecting: <UNSIGNEDINTEGER>
at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:768)
at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetada
taRepository.java:40)
at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadM
etadata(AbstractVDBDeployer.java:84)
at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(Chai
ningMetadataRepository.java:55)
at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkCon
text.java:276)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.ru
n(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseE
xecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsin
g error: Encountered "tag varchar([*]max[*]) )" at line 3, column 25.
Was expecting: <UNSIGNEDINTEGER>
at org.teiid.query.parser.QueryParser.convertParserException(QueryParser
.java:214)
... 13 more
21:26:59,514 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
ol -- 60) WFLYCLINF0002: Started resultset-repl cache from teiid container
21:26:59,529 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
ol -- 62) WFLYCLINF0002: Started preparedplan cache from teiid container
21:27:00,732 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50001 Teii
d Engine 8.13.3 Started = Mon Apr 25 21:27:00 PDT 2016
21:27:00,951 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50038 Teii
d Embedded transport enabled. Bound to: teiid/queryengine/odata
21:27:00,998 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50038 Teii
d Embedded transport enabled. Bound to: teiid/queryengine/embedded
21:27:01,748 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
read Pool -- 65) Deploying javax.ws.rs.core.Application: class org.teiid.odata.
TeiidODataApplication
21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
read Pool -- 65) Adding class resource org.odata4j.producer.resources.MetadataR
esource from Application class org.teiid.odata.TeiidODataApplication
21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
read Pool -- 65) Adding provider class org.odata4j.producer.resources.ODataBatc
hProvider from Application class org.teiid.odata.TeiidODataApplication
21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
read Pool -- 65) Adding provider class org.teiid.odata.TeiidProducerProvider fr
om Application class org.teiid.odata.TeiidODataApplication
21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
read Pool -- 65) Adding class resource org.odata4j.producer.resources.EntityReq
uestResource from Application class org.teiid.odata.TeiidODataApplication
21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
read Pool -- 65) Adding class resource org.odata4j.producer.resources.EntitiesR
equestResource from Application class org.teiid.odata.TeiidODataApplication
21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
read Pool -- 65) Adding provider class org.teiid.odata.ODataExceptionMappingPro
vider from Application class org.teiid.odata.TeiidODataApplication
21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
read Pool -- 65) Adding class resource org.odata4j.producer.resources.ServiceDo
cumentResource from Application class org.teiid.odata.TeiidODataApplication
21:27:01,951 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50012 Teii
d JDBC - Name = jdbc, Host = 127.0.0.1, Port = 31000, SSL = OFF, security-domai
ns = teiid-security
21:27:01,967 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50037 Teii
d ODBC - Name = odbc, Host = 127.0.0.1, Port = 35432, SSL = OFF, security-domai
ns = teiid-security
21:27:02,076 INFO [org.hibernate.validator.internal.util.Version] (ServerServic
e Thread Pool -- 65) HV000001: Hibernate Validator 5.1.3.Final
21:27:02,592 INFO [org.teiid.CONNECTOR] (Worker0_async-teiid-threads0) PIExecu
tionFactory Commit=true;DatabaseProductName=PI SQL Data Access Server 1.4.1.403
using PIOLEDB;DatabaseProductVersion=PIOLEDB: 3.3.1.2;DriverMajorVersion=1;Drive
rMajorVersion=4;DriverName=com.osisoft.jdbc.Driver;DriverVersion=1.4.1.404;Isola
tionLevel=0
21:27:02,607 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -
- 65) WFLYUT0021: Registered web context: /odata
21:27:02,795 INFO [org.jboss.as.server] (ServerService Thread Pool -- 35) WFLY
SRV0010: Deployed "PIJDBCDriver.jar" (runtime-name : "PIJDBCDriver.jar")
21:27:02,811 INFO [org.jboss.as.server] (ServerService Thread Pool -- 35) WFLY
SRV0010: Deployed "PIAF-vdb.xml" (runtime-name : "PIAF-vdb.xml")
21:27:02,811 INFO [org.jboss.as.server] (ServerService Thread Pool -- 55) WFLY
SRV0010: Deployed "teiid-olingo-8.13.3-odata4.war" (runtime-name : "teiid-olingo
-8.13.3-odata4.war")
21:27:02,811 INFO [org.jboss.as.server] (ServerService Thread Pool -- 55) WFLY
SRV0010: Deployed "teiid-odata-8.13.3-odata2.war" (runtime-name : "teiid-odata-8
.13.3-odata2.war")
21:27:03,139 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http ma
nagement interface listening on http://127.0.0.1:9990/management
21:27:03,139 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0051: Admin c
onsole listening on http://127.0.0.1:9990
21:27:03,139 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0025: WildFly
Full 9.0.2.Final (WildFly Core 1.0.2.Final) started in 25094ms - Started 596 of
836 services (305 services are lazy, passive or on-demand)
21:27:03,920 WARN [org.teiid.RUNTIME] (Worker0_async-teiid-threads0) TEIID5003
6 VDB PIAF2.1 model "PIAF-Physical" metadata failed to load. Reason:TEIID11010 j
ava.sql.SQLException: java.lang.Integer cannot be cast to java.lang.Short: org.t
eiid.translator.TranslatorException: TEIID11010 java.sql.SQLException: java.lang
.Integer cannot be cast to java.lang.Short
at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut
ionFactory.java:297)
at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut
ionFactory.java:68)
at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeM
etadataRepository.java:92)
at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(Native
MetadataRepository.java:60)
at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(Chai
ningMetadataRepository.java:55)
at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkCon
text.java:276)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.ru
n(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseE
xecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: java.lang.Integer cannot be cast to java.lang.
Short
at com.osisoft.jdbc.ResultSetImpl.getShort(ResultSetImpl.java:544)
at org.teiid.translator.jdbc.JDBCMetdataProcessor.getPrimaryKeys(JDBCMet
dataProcessor.java:495)
at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(J
DBCMetdataProcessor.java:162)
at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut
ionFactory.java:295)
... 12 more
21:41:41,551 INFO [org.jboss.as.repository] (ServerService Thread Pool -- 63)
WFLYDR0009: Content C:\apps\teiid-8.13.3\standalone\data\content\14\344c87647a15
e57fe72a46b9754cd996f71dff is obsolete and will be removed
21:41:41,551 INFO [org.jboss.as.repository] (ServerService Thread Pool -- 63)
WFLYDR0002: Content removed from location C:\apps\teiid-8.13.3\standalone\data\c
ontent\14\344c87647a15e57fe72a46b9754cd996f71dff\content
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list