[JBoss JIRA] Closed: (TEIIDDES-6) java.io.IOException when trying to execute getLibrary procedure against iTunes Music Library
by Barry LaFond (JIRA)
[ https://jira.jboss.org/jira/browse/TEIIDDES-6?page=com.atlassian.jira.plu... ]
Barry LaFond closed TEIIDDES-6.
-------------------------------
> java.io.IOException when trying to execute getLibrary procedure against iTunes Music Library
> --------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-6
> URL: https://jira.jboss.org/jira/browse/TEIIDDES-6
> Project: Teiid Designer
> Issue Type: Bug
> Components: Teiid Integration
> Affects Versions: 6.0.0
> Environment: fedora 10
> Reporter: Paul Nittel
> Assignee: Ramesh Reddy
> Priority: Critical
> Fix For: 6.0.0
>
> Attachments: FedTools54_MPS.zip, miTunes Music Library.xml
>
>
> When I executed the bare EXEC getLibrary(), I got an exception:
> Exec EXEC dbfile.getLibrary( )
> !ENTRY net.sourceforge.sqlexplorer 4 4 2008-12-19 15:59:31.747
> !MESSAGE A problem occurred working with the IResultSetProcessor "com.metamatrix.modeler.internal.dqp.ui.jdbc.XmlDocumentResultSetProcessor"
> !STACK 0
> java.lang.RuntimeException: com.metamatrix.jdbc.MMSQLException: Unable to read data from the stream: java.io.IOException: Stream closed
> at com.metamatrix.jdbc.MMSQLXML.toString(MMSQLXML.java:87)
> at java.text.MessageFormat.subformat(MessageFormat.java:1246)
> at java.text.MessageFormat.format(MessageFormat.java:836)
> at java.text.Format.format(Format.java:140)
> at java.text.MessageFormat.format(MessageFormat.java:812)
> at com.metamatrix.core.BundleUtil.getString(BundleUtil.java:319)
> at com.metamatrix.core.BundleUtil.getString(BundleUtil.java:273)
> at com.metamatrix.jdbc.DataTypeTransformer.createConversionError(DataTypeTransformer.java:76)
> at com.metamatrix.jdbc.DataTypeTransformer.transform(DataTypeTransformer.java:71)
> at com.metamatrix.jdbc.DataTypeTransformer.transform(DataTypeTransformer.java:61)
> at com.metamatrix.jdbc.MMResultSet.getString(MMResultSet.java:1024)
> at com.metamatrix.modeler.internal.dqp.ui.jdbc.XmlDocumentResultsModel.createResults(XmlDocumentResultsModel.java:91)
> at com.metamatrix.modeler.internal.dqp.ui.jdbc.XmlDocumentResultsModel.<init>(XmlDocumentResultsModel.java:72)
> at com.metamatrix.modeler.internal.dqp.ui.jdbc.XmlDocumentResultSetProcessor.process(XmlDocumentResultSetProcessor.java:68)
> at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.processQuery(SqlExecProgress.java:211)
> at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.run(SqlExecProgress.java:121)
> at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
> Caused by: com.metamatrix.jdbc.MMSQLException: Unable to read data from the stream: java.io.IOException: Stream closed
> at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:85)
> at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:66)
> at com.metamatrix.jdbc.MMSQLXML.getString(MMSQLXML.java:79)
> at com.metamatrix.jdbc.MMSQLXML.toString(MMSQLXML.java:85)
> ... 16 more
> Caused by: java.io.IOException: Unable to read data from the stream: java.io.IOException: Stream closed
> at com.metamatrix.dqp.client.impl.StreamingLobChunckProducer.getNextChunk(StreamingLobChunckProducer.java:77)
> at com.metamatrix.common.lob.LobChunkInputStream.fetchNextChunk(LobChunkInputStream.java:79)
> at com.metamatrix.common.lob.LobChunkInputStream.read(LobChunkInputStream.java:66)
> at java.io.InputStream.read(InputStream.java:154)
> at com.metamatrix.common.lob.LobChunkInputStream.read(LobChunkInputStream.java:91)
> at com.metamatrix.common.lob.LobChunkInputStream.getByteContents(LobChunkInputStream.java:110)
> at com.metamatrix.jdbc.MMSQLXML.getString(MMSQLXML.java:77)
> ... 17 more
> Caused by: java.util.concurrent.ExecutionException: java.io.IOException: Stream closed
> at com.metamatrix.dqp.client.ResultsFuture.convertResult(ResultsFuture.java:91)
> at com.metamatrix.dqp.client.ResultsFuture.get(ResultsFuture.java:86)
> at com.metamatrix.dqp.client.impl.StreamingLobChunckProducer.getNextChunk(StreamingLobChunckProducer.java:75)
> ... 23 more
> Caused by: java.io.IOException: Stream closed
> at sun.nio.cs.StreamDecoder.ensureOpen(StreamDecoder.java:27)
> at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:128)
> at java.io.InputStreamReader.read(InputStreamReader.java:167)
> at java.io.Reader.read(Reader.java:123)
> at com.metamatrix.common.lob.ReaderInputStream.read(ReaderInputStream.java:70)
> at java.io.InputStream.read(InputStream.java:154)
> at java.io.FilterInputStream.read(FilterInputStream.java:116)
> at java.io.PushbackInputStream.read(PushbackInputStream.java:169)
> at java.io.FilterInputStream.read(FilterInputStream.java:90)
> at com.metamatrix.common.lob.ByteLobChunkStream.getNextChunk(ByteLobChunkStream.java:61)
> at com.metamatrix.dqp.internal.process.LobChunkStream.getNextChunk(LobChunkStream.java:88)
> at com.metamatrix.dqp.internal.process.LobWorkItem.run(LobWorkItem.java:81)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> Model Project Set is attached.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 5 months
[JBoss JIRA] Closed: (TEIIDDES-5) Expressions cannot be selected by XML queries - response to "select relate(..."
by Barry LaFond (JIRA)
[ https://jira.jboss.org/jira/browse/TEIIDDES-5?page=com.atlassian.jira.plu... ]
Barry LaFond closed TEIIDDES-5.
-------------------------------
> Expressions cannot be selected by XML queries - response to "select relate(..."
> -------------------------------------------------------------------------------
>
> Key: TEIIDDES-5
> URL: https://jira.jboss.org/jira/browse/TEIIDDES-5
> Project: Teiid Designer
> Issue Type: Bug
> Environment: fedora 10
> Reporter: Paul Nittel
> Assignee: Steven Hawkins
> Attachments: FedTools51_MPS.zip
>
>
> I ran the E2E XML Relate Context script and found I could not execute queries. I get the subject error when I do so. This is the query:
> select relate(rentals.rentsVehicle,rentals.company,rentals.vehicle, 'rentals.rentsVehicle.companyID=rentals.company.companyID and rentals.rentsVehicle.vehicleID=rentals.vehicle.vehicleID')
> from "VehicleRentalsVDB"."VehicleRentalsDoc.rentalsDocument"
> Here's the accompanying exception:
> Error 2008-12-18 14:08:25.526 Error processing query
> com.metamatrix.jdbc.MMSQLException: Expressions cannot be selected by XML Queries
> at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:85)
> at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:66)
> at com.metamatrix.jdbc.MMStatement.setException(MMStatement.java:364)
> at com.metamatrix.jdbc.MMStatement.processQueryMessage(MMStatement.java:441)
> at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:540)
> at com.metamatrix.jdbc.MMStatement.execute(MMStatement.java:387)
> at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.processQuery(SqlExecProgress.java:192)
> at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.run(SqlExecProgress.java:121)
> at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
> Caused by: [QueryResolverException]Expressions cannot be selected by XML Queries
> at com.metamatrix.query.resolver.command.XMLQueryResolver.resolveXMLSelect(XMLQueryResolver.java:203)
> at com.metamatrix.query.resolver.command.XMLQueryResolver.resolveCommand(XMLQueryResolver.java:88)
> at com.metamatrix.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:176)
> at com.metamatrix.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:128)
> at com.metamatrix.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:100)
> at com.metamatrix.dqp.internal.process.Request.resolveCommand(Request.java:353)
> at com.metamatrix.dqp.internal.process.Request.prepareCommand(Request.java:314)
> at com.metamatrix.dqp.internal.process.Request.generatePlan(Request.java:506)
> at com.metamatrix.dqp.internal.process.Request.processRequest(Request.java:619)
> at com.metamatrix.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:365)
> at com.metamatrix.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:210)
> at com.metamatrix.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:46)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> Model Project Set attached.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 5 months