[JBoss JIRA] (TEIIDSB-203) A .vdb file nested inside the Spring Repackage jar can not be read
by Ramesh Reddy (Jira)
[ https://issues.redhat.com/browse/TEIIDSB-203?page=com.atlassian.jira.plug... ]
Ramesh Reddy updated TEIIDSB-203:
---------------------------------
Original Estimate: 4 hours
> A .vdb file nested inside the Spring Repackage jar can not be read
> ------------------------------------------------------------------
>
> Key: TEIIDSB-203
> URL: https://issues.redhat.com/browse/TEIIDSB-203
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: core
> Affects Versions: 1.4.0
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Major
> Fix For: 1.5.0
>
> Original Estimate: 4 hours
> Time Spent: 3 hours
> Remaining Estimate: 0 minutes
>
> When user is using a .VDB file as VDB and builds a spring repackage based application, at runtime the loading of the VDB is failed as it is being read as classpath resource. The exception you see is
> {code}
> Caused by: java.lang.IllegalArgumentException: URI: jar:file:/home/rareddy/development/teiid-spring-boot/samples/vdb/target/spring-vdb-example-1.5.0-SNAPSHOT.jar does not contain path info ex. jar:file:/c:/foo.zip!/BAR
> at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.getPath(ZipFileSystemProvider.java:155) ~[jdk.zipfs:na]
> at java.base/java.nio.file.Path.of(Path.java:208) ~[na:na]
> at java.base/java.nio.file.Paths.get(Paths.java:98) ~[na:na]
> at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.uriToPath(ZipFileSystemProvider.java:77) ~[jdk.zipfs:na]
> at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.getFileSystem(ZipFileSystemProvider.java:167) ~[jdk.zipfs:na]
> at java.base/java.nio.file.FileSystems.getFileSystem(FileSystems.java:231) ~[na:na]
> at org.teiid.query.metadata.NioZipFileSystem.mount(NioZipFileSystem.java:67) ~[teiid-engine-14.0.0-SNAPSHOT.jar!/:14.0.0-SNAPSHOT]
> at org.teiid.query.metadata.NioZipFileSystem.mount(NioZipFileSystem.java:51) ~[teiid-engine-14.0.0-SNAPSHOT.jar!/:14.0.0-SNAPSHOT]
> at org.teiid.spring.autoconfigure.TeiidAutoConfiguration.loadVDB(TeiidAutoConfiguration.java:214) ~[teiid-spring-boot-starter-1.5.0-SNAPSHOT.jar!/:1.5.0-SNAPSHOT]
> {code}
> basically one cannot read a nested jar files. The issue also explained here https://stackoverflow.com/questions/37634452/urlclassloader-cant-handle-j...
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
3 years, 11 months
[JBoss JIRA] (TEIIDSB-203) A .vdb file nested inside the Spring Repackage jar can not be read
by Ramesh Reddy (Jira)
[ https://issues.redhat.com/browse/TEIIDSB-203?page=com.atlassian.jira.plug... ]
Ramesh Reddy resolved TEIIDSB-203.
----------------------------------
Resolution: Done
This was issue with nested jar inside another jar and trying to load that in, the resolution was to to read the nested jar as a input-stream and then create a temp file with it then passing it to create a virtual file.
> A .vdb file nested inside the Spring Repackage jar can not be read
> ------------------------------------------------------------------
>
> Key: TEIIDSB-203
> URL: https://issues.redhat.com/browse/TEIIDSB-203
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: core
> Affects Versions: 1.4.0
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Major
> Fix For: 1.5.0
>
>
> When user is using a .VDB file as VDB and builds a spring repackage based application, at runtime the loading of the VDB is failed as it is being read as classpath resource. The exception you see is
> {code}
> Caused by: java.lang.IllegalArgumentException: URI: jar:file:/home/rareddy/development/teiid-spring-boot/samples/vdb/target/spring-vdb-example-1.5.0-SNAPSHOT.jar does not contain path info ex. jar:file:/c:/foo.zip!/BAR
> at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.getPath(ZipFileSystemProvider.java:155) ~[jdk.zipfs:na]
> at java.base/java.nio.file.Path.of(Path.java:208) ~[na:na]
> at java.base/java.nio.file.Paths.get(Paths.java:98) ~[na:na]
> at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.uriToPath(ZipFileSystemProvider.java:77) ~[jdk.zipfs:na]
> at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.getFileSystem(ZipFileSystemProvider.java:167) ~[jdk.zipfs:na]
> at java.base/java.nio.file.FileSystems.getFileSystem(FileSystems.java:231) ~[na:na]
> at org.teiid.query.metadata.NioZipFileSystem.mount(NioZipFileSystem.java:67) ~[teiid-engine-14.0.0-SNAPSHOT.jar!/:14.0.0-SNAPSHOT]
> at org.teiid.query.metadata.NioZipFileSystem.mount(NioZipFileSystem.java:51) ~[teiid-engine-14.0.0-SNAPSHOT.jar!/:14.0.0-SNAPSHOT]
> at org.teiid.spring.autoconfigure.TeiidAutoConfiguration.loadVDB(TeiidAutoConfiguration.java:214) ~[teiid-spring-boot-starter-1.5.0-SNAPSHOT.jar!/:1.5.0-SNAPSHOT]
> {code}
> basically one cannot read a nested jar files. The issue also explained here https://stackoverflow.com/questions/37634452/urlclassloader-cant-handle-j...
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
3 years, 11 months
[JBoss JIRA] (TEIIDSB-203) A .vdb file nested inside the Spring Repackage jar can not be read
by Ramesh Reddy (Jira)
[ https://issues.redhat.com/browse/TEIIDSB-203?focusedWorklogId=12451143&pa... ]
Ramesh Reddy logged work on TEIIDSB-203:
----------------------------------------
Author: Ramesh Reddy
Created on: 22/May/20 1:06 PM
Start Date: 22/May/20 1:06 PM
Worklog Time Spent: 3 hours
Issue Time Tracking
-------------------
Remaining Estimate: 0 minutes
Time Spent: 3 hours
Worklog Id: (was: 12451143)
> A .vdb file nested inside the Spring Repackage jar can not be read
> ------------------------------------------------------------------
>
> Key: TEIIDSB-203
> URL: https://issues.redhat.com/browse/TEIIDSB-203
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: core
> Affects Versions: 1.4.0
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Major
> Fix For: 1.5.0
>
> Time Spent: 3 hours
> Remaining Estimate: 0 minutes
>
> When user is using a .VDB file as VDB and builds a spring repackage based application, at runtime the loading of the VDB is failed as it is being read as classpath resource. The exception you see is
> {code}
> Caused by: java.lang.IllegalArgumentException: URI: jar:file:/home/rareddy/development/teiid-spring-boot/samples/vdb/target/spring-vdb-example-1.5.0-SNAPSHOT.jar does not contain path info ex. jar:file:/c:/foo.zip!/BAR
> at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.getPath(ZipFileSystemProvider.java:155) ~[jdk.zipfs:na]
> at java.base/java.nio.file.Path.of(Path.java:208) ~[na:na]
> at java.base/java.nio.file.Paths.get(Paths.java:98) ~[na:na]
> at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.uriToPath(ZipFileSystemProvider.java:77) ~[jdk.zipfs:na]
> at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.getFileSystem(ZipFileSystemProvider.java:167) ~[jdk.zipfs:na]
> at java.base/java.nio.file.FileSystems.getFileSystem(FileSystems.java:231) ~[na:na]
> at org.teiid.query.metadata.NioZipFileSystem.mount(NioZipFileSystem.java:67) ~[teiid-engine-14.0.0-SNAPSHOT.jar!/:14.0.0-SNAPSHOT]
> at org.teiid.query.metadata.NioZipFileSystem.mount(NioZipFileSystem.java:51) ~[teiid-engine-14.0.0-SNAPSHOT.jar!/:14.0.0-SNAPSHOT]
> at org.teiid.spring.autoconfigure.TeiidAutoConfiguration.loadVDB(TeiidAutoConfiguration.java:214) ~[teiid-spring-boot-starter-1.5.0-SNAPSHOT.jar!/:1.5.0-SNAPSHOT]
> {code}
> basically one cannot read a nested jar files. The issue also explained here https://stackoverflow.com/questions/37634452/urlclassloader-cant-handle-j...
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
3 years, 11 months
[JBoss JIRA] (TEIIDSB-57) Provide Cassandra data source support
by Ramesh Reddy (Jira)
[ https://issues.redhat.com/browse/TEIIDSB-57?focusedWorklogId=12451142&pag... ]
Ramesh Reddy logged work on TEIIDSB-57:
---------------------------------------
Author: Ramesh Reddy
Created on: 22/May/20 1:04 PM
Start Date: 22/May/20 1:03 PM
Worklog Time Spent: 3 hours
Work Description: mustache file some other cleanup
Issue Time Tracking
-------------------
Remaining Estimate: 0 minutes
Time Spent: 3 hours
Worklog Id: (was: 12451142)
> Provide Cassandra data source support
> -------------------------------------
>
> Key: TEIIDSB-57
> URL: https://issues.redhat.com/browse/TEIIDSB-57
> Project: Teiid Spring Boot
> Issue Type: Feature Request
> Components: datasource
> Reporter: Ramesh Reddy
> Assignee: Aditya Manglam Sharma
> Priority: Major
> Fix For: 1.5.0
>
> Time Spent: 3 hours
> Remaining Estimate: 0 minutes
>
> Provide data source support for Cassandra
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
3 years, 11 months
[JBoss JIRA] (TEIIDSB-57) Provide Cassandra data source support
by Ramesh Reddy (Jira)
[ https://issues.redhat.com/browse/TEIIDSB-57?page=com.atlassian.jira.plugi... ]
Ramesh Reddy commented on TEIIDSB-57:
-------------------------------------
Looking at the cassandra driver it is at `19.0` version, but up versioned to overwrite with other modules in Teiid Core to `27.0.1-jre`, now Spring Boot looks like wanting to be at `20.0`. I will try to down version to `20.0` in Spring Boot to match with rest of the modules.
> Provide Cassandra data source support
> -------------------------------------
>
> Key: TEIIDSB-57
> URL: https://issues.redhat.com/browse/TEIIDSB-57
> Project: Teiid Spring Boot
> Issue Type: Feature Request
> Components: datasource
> Reporter: Ramesh Reddy
> Assignee: Aditya Manglam Sharma
> Priority: Major
> Fix For: 1.5.0
>
>
> Provide data source support for Cassandra
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
3 years, 11 months
[JBoss JIRA] (TEIID-5861) Salesforce translator should support nested joins
by Van Halbert (Jira)
[ https://issues.redhat.com/browse/TEIID-5861?page=com.atlassian.jira.plugi... ]
Van Halbert commented on TEIID-5861:
------------------------------------
Contributions are a great way to help move features forward.
> Salesforce translator should support nested joins
> -------------------------------------------------
>
> Key: TEIID-5861
> URL: https://issues.redhat.com/browse/TEIID-5861
> Project: Teiid
> Issue Type: Enhancement
> Components: Salesforce Connector
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: Backlog
>
> Original Estimate: 2 days
> Remaining Estimate: 2 days
>
> For this SQL we have wrong generated SOQL
> {code}
> select
> price.Id,
> price.IsActive__c,
> price.name,
> price.PriceBook__c,
> book.DefaultCurrency__c,
> price.Price__c,
> price.ProductCode__c,
> price.ProductName__c,
> price.Product__c,
> product.Id,
> product.Name,
> product.Description
> from
> MSRP__c as price
> left outer join /*+ MAKEDEP */ Product2 as product on
> price.Product__c = product.id
> left outer join /*+ MAKEDEP */ Pricebook2 as book on
> price.PriceBook__c = book.id
> where
> price.PriceBook__c =:priceBookId
> and ProductCode__c in(
> :productCodes
> )
> and IsActive__c = true"
> {code}
> {code}
> START DATA SRC COMMAND: startTime=2019-12-02 12:43:54.368 requestID=9MPiB/GOwB5f.0 sourceCommandID=3 executionID=2 txID=null modelName=sf translatorName=salesforce sessionID=9MPiB/GOwB5f principal=anonymous sql=SELECT sf.Pricebook2.DefaultCurrency__c FROM sf.Pricebook2 WHERE sf.Pricebook2.Id = 'xxxxx'
> [2019-12-02 12:43:54,368 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.COMMAND_LOG.SOURCE [Worker0_QueryProcessorQueue1]: SOURCE SRC COMMAND: endTime=2019-12-02 12:43:54.368 requestID=9MPiB/GOwB5f.0 sourceCommandID=2 executionID=1 txID=null modelName=sf translatorName=salesforce sessionID=9MPiB/GOwB5f principal=anonymous sourceCommand=[SELECT MSRP__c.Id, MSRP__c.IsActive__c, MSRP__c.Name, MSRP__c.PriceBook__c, MSRP__c.Price__c, MSRP__c.ProductCode__c, MSRP__c.ProductName__c, MSRP__c.Product__c, Product__r.Id, Product__r.Name, Product__r.Description FROM MSRP__c WHERE (MSRP__c.PriceBook__c = 'xxxx') AND ((MSRP__c.ProductCode__c IN(xxxxx)) AND (MSRP__c.IsActive__c = true))]
> [2019-12-02 12:43:54,368 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.CONNECTOR [Worker1_QueryProcessorQueue2]: salesforce.9MPiB/GOwB5f.9MPiB/GOwB5f.0.3: Incoming Query: SELECT Pricebook2.DefaultCurrency__c FROM Pricebook2 WHERE Pricebook2.Id = 'xxxx'
> [2019-12-02 12:43:54,368 MSK] DEBUG [salesforce-failover-facade,,,] org.teiid.COMMAND_LOG.SOURCE [Worker1_QueryProcessorQueue2]: SOURCE SRC COMMAND: endTime=2019-12-02 12:43:54.368 requestID=9MPiB/GOwB5f.0 sourceCommandID=3 executionID=2 txID=null modelName=sf translatorName=salesforce sessionID=9MPiB/GOwB5f principal=anonymous sourceCommand=[Using retrieve: Pricebook2.DefaultCurrency__c Pricebook2 [xxxx]]
> {code}
> But need to generate one. Because we have two relations in MSRP__c
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
3 years, 11 months