[teiid-issues] [JBoss JIRA] (TEIID-4173) Using PI JDBC Adapter, server does not start up using simple queries

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 Labels: JDBC, PI 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