[teiid-issues] [JBoss JIRA] (TEIID-4173) Using PI JDBC Adapter, server does not start up using simple queries
Steven Hawkins (JIRA)
issues at jboss.org
Tue Apr 26 08:57:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-4173.
-----------------------------------
Resolution: Rejected
varchar(max) is not a valid type declaration, as the error message is indicating. You can use an integer length or just use varchar/string as the type.
> 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
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list