[JBoss JIRA] (TEIID-4581) NPE occurs when the pkFieldName is not defined on the cacheTypeMap property
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4581?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-4581:
-------------------------------
Component/s: JDG Connector
(was: Misc. Connectors)
> NPE occurs when the pkFieldName is not defined on the cacheTypeMap property
> ---------------------------------------------------------------------------
>
> Key: TEIID-4581
> URL: https://issues.jboss.org/browse/TEIID-4581
> Project: Teiid
> Issue Type: Feature Request
> Components: JDG Connector
> Affects Versions: 9.2
> Reporter: Van Halbert
> Assignee: Van Halbert
>
> The following NPE occurs when the pkFieldName is not defined on the cacheTypeMap property:
> 19:11:34,107 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB People.1 model "People" metadata failed to load. Reason:java.lang.
> NullPointerException: java.lang.NullPointerException
> at org.teiid.translator.infinispan.dsl.metadata.ProtobufMetadataProcessor.createRootTable(ProtobufMetadataProcessor.java:186)
> at org.teiid.translator.infinispan.dsl.metadata.ProtobufMetadataProcessor.process(ProtobufMetadataProcessor.java:101)
> at org.teiid.translator.infinispan.dsl.metadata.ProtobufMetadataProcessor.process(ProtobufMetadataProcessor.java:78)
> at org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:950)
> at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96)
> at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_111]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_111]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_111]
> at org.jboss.threads.JBossThread.run(JBossThread.java:122)
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years
[JBoss JIRA] (TEIID-3925) Rename infinispan translators / resources adapters to align with running library mode versus access remote cache
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3925?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-3925:
-------------------------------
I believe this jira has been completed.
> Rename infinispan translators / resources adapters to align with running library mode versus access remote cache
> ----------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3925
> URL: https://issues.jboss.org/browse/TEIID-3925
> Project: Teiid
> Issue Type: Quality Risk
> Components: JDG Connector
> Affects Versions: 9.0
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> Currently, the infinispan translators and resource adapters are named:
> - translator-infinispan-cache (infinispan-cache) / connector-infinispan.6
> - translator-infinispan-dsl (infinispan-cache-dsl) / connector-infinispan-dsl
> Suggested rename to be done in version 9 to align with infinispan 7:
> - translator-infinispan-library-mode (infinispan-library-mode) / connector-infinispan-library-mode.7
> - translator-infinispan-remote-cache (infinispan-remote-cache / connector-infinispan-remote-cache.7
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years
[JBoss JIRA] (TEIID-3925) Rename infinispan translators / resources adapters to align with running library mode versus access remote cache
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3925?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-3925:
-------------------------------
Component/s: JDG Connector
(was: Misc. Connectors)
I believe this jira has been completed.
> Rename infinispan translators / resources adapters to align with running library mode versus access remote cache
> ----------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3925
> URL: https://issues.jboss.org/browse/TEIID-3925
> Project: Teiid
> Issue Type: Quality Risk
> Components: JDG Connector
> Affects Versions: 9.0
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> Currently, the infinispan translators and resource adapters are named:
> - translator-infinispan-cache (infinispan-cache) / connector-infinispan.6
> - translator-infinispan-dsl (infinispan-cache-dsl) / connector-infinispan-dsl
> Suggested rename to be done in version 9 to align with infinispan 7:
> - translator-infinispan-library-mode (infinispan-library-mode) / connector-infinispan-library-mode.7
> - translator-infinispan-remote-cache (infinispan-remote-cache / connector-infinispan-remote-cache.7
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years
[JBoss JIRA] (TEIID-4622) Adding new data quality functions from osDQ
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4622?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-4622:
------------------------------------
I have added a pull request, and tested it works fine, could you have a look? I checked there no name conflicts between osdq functions and teiid funtions.
Current we treat all osdq functions as category 'MISCELLANEOUS', this may mix up with teiid MiscellaneousFunctions, do we need add a new category to address osdq functions?
> Adding new data quality functions from osDQ
> -------------------------------------------
>
> Key: TEIID-4622
> URL: https://issues.jboss.org/browse/TEIID-4622
> Project: Teiid
> Issue Type: Feature Request
> Components: Common
> Affects Versions: Open To Community
> Environment: osdq-core and its dependency simmetric 3.0.0 is needed to run these functions
> maven central location
> http://search.maven.org/#search%7Cga%7C1%7Ca%3A%22osdq-core%22
> Reporter: vivek singh
> Assignee: Kylin Soong
> Fix For: Open To Community
>
> Attachments: DateUtil.java, NumberUtil.java, StringUtil.java
>
>
> Following functions have been added into osdq-core for integration with teiid.
> String functions :
> // Encrypting a string using key and AES encryption
> String encrypt ( String val, String key)
> String decrypt ( String val, String key)
> // Fuzzy distance - similarity between two strings
> float levestheindistance ( String a, String b)
> float jarowinklerdistance( String a , String b)
> float cosinedistance (String a, String b)
> // Format check for PII ( personal information)
> boolean isCreditCardFormat(String a)
> boolean isSSNFormat(String a)
> boolean isPhoneFormat(String a)
> boolean isEmailFormat(String a)
> boolean hasWhiteSpace(String a )
> Date Functions
> // converting date into universal recognized format
> long dateToEpoch(java.util.Date date)
> Date epochToDate(long epoch)
> Date epochToDate(long epoch, String TimeZone)
> long diffInSec(date a, date b)
> String convertToFormat ( Date a, String Format)
> Numerical Functions
> // Statistical functions
> double stdDev(Number[] numSeries)
> double range(Number[] numSeries)
> double median(Number[] numSeries)
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years
[JBoss JIRA] (TEIID-4616) api-docs on Swagger UI error
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4616?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-4616:
------------------------------------
I use both 63-8.12.x(https://github.com/teiid/teiid/tree/63-8.12.x) and 8.12.x(https://github.com/teiid/teiid/tree/8.12.x) branches can not reproduce the issue, [~rareddy] do you know where I can get 8.12.6.6_3? from screenshot, I think I totally got the mis-matched code, due to both branches I tested no teiid log and top green bar.
> api-docs on Swagger UI error
> ----------------------------
>
> Key: TEIID-4616
> URL: https://issues.jboss.org/browse/TEIID-4616
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.6.6_3
> Reporter: Debbie Steigner
> Assignee: Kylin Soong
> Attachments: Screenshot-RestVDB VDB - Mozilla Firefox.png
>
>
> The link on the Swagger UI for api-docs, shows Error - {"schemaValidationMessages":[{"level":"error","message":"Can't read from file http://127.0.0.1:8080/RestVDB/api-docs/Debbiev"}]}
> But I can enter the URL and go to the api-doc - http://127.0.0.1:8080/RestVDB/api-docs/Debbiev
> {"apiVersion":"2.0.0","swaggerVersion":"1.2","basePath":"/RestVDB","resourcePath":"/Debbiev","apis":[{"path":"/Debbiev/mytable","operations":[{"method":"POST","summary":"(XML) postmytable: null","notes":"","type":"java.io.InputStream","nickname":"postmytable","produces":["application/xml; charset=UTF-8"],"consumes":["application/xml"],"parameters":[{"name":"body","required":false,"type":"java.io.InputStream","paramType":"body","allowMultiple":false}]},{"method":"GET","summary":"(XML) getmytable: null","notes":"","type":"java.io.InputStream","nickname":"getmytable","produces":["application/xml; charset=UTF-8"],"parameters":[]}]},{"path":"/Debbiev/json/mytable","operations":[{"method":"GET","summary":"(JSON) getmytable: null","notes":"","type":"string","nickname":"getmytablejson","produces":["application/json; charset=UTF-8"],"parameters":[]},{"method":"POST","summary":"(JSON) postmytable: null","notes":"","type":"string","nickname":"postmytablejson","produces":["application/json; charset=UTF-8"],"consumes":["application/json"],"parameters":[{"name":"body","required":false,"type":"java.io.InputStream","paramType":"body","allowMultiple":false}]}]}]}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years
[JBoss JIRA] (TEIID-4441) Add FTP/SFTP based access to the File Resource Adapter
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4441?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-4441:
------------------------------------
DO we need Steven's weight? we may need more discussion, If we decided to use VFS, we need change the file translator interface first
{code}
public class FileExecutionFactory extends ExecutionFactory<ConnectionFactory, FileConnection>
{code}
If change 'org.teiid.translator.FileConnection' , add more methods like
{code}
void add(VirtualFile file) throws ResourceException;
VirtualFile getVFSFile(String path) throws ResourceException;
void remote(String path) throws ResourceException;
void delete(VirtualFile file) throws ResourceException;
{code}
this will bring a vfs dependency to teiid-api module, but teiid-api be used by many modules, vfs has logging dependencies, this looks can not be concise.
I suggest to create a new translator api module like mongo-api, eg, create a VFSFileConnection keep the new methods, and create a new translator
{code}
public class VFSFileExecutionFactory extends ExecutionFactory<ConnectionFactory, VFSFileConnection>
{code}
this translator can work with:
* ftp connector
* hdfs connector
* ...
I will not do any work before I totally clear how we do.
> Add FTP/SFTP based access to the File Resource Adapter
> ------------------------------------------------------
>
> Key: TEIID-4441
> URL: https://issues.jboss.org/browse/TEIID-4441
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Reporter: Ramesh Reddy
> Assignee: Kylin Soong
> Fix For: Open To Community, 9.2
>
>
> This has been requested few times in the community, it would be nice to give provide this functionality. Using http://commons.apache.org/proper/commons-net/ seems to be right decision.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years
[JBoss JIRA] (TEIID-4584) SimpleDB doesn' work
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4584?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-4584.
---------------------------------
Resolution: Done
Updated to AmazonAWS version 1.11.0, this was the closest to the "com.fasterxml" version dependency that comes along in the WildFly 10 which Teiid 9.1 and Teiid 9.2 depend upon.
Since build is different between 9.1 and 9.2 two completely separate commits were needed to fix the issue.
> SimpleDB doesn' work
> --------------------
>
> Key: TEIID-4584
> URL: https://issues.jboss.org/browse/TEIID-4584
> Project: Teiid
> Issue Type: Bug
> Components: Connector API
> Affects Versions: 8.12.6.6_3
> Environment: RHEL 7.x, JBoss 6.4, JDV 6.3,
> JBDS 9.1.0.GA, GA-v20160414-0124-B497
> Also Fedora 23
> Reporter: Glen Wilcox
> Assignee: Ramesh Reddy
> Fix For: 9.2, 9.1.2
>
> Attachments: SimpleDB_ERROR_HTTP.txt, SimpleDB_ERROR_Jackson.txt
>
>
> I was trying to set up the simpledb example:
> https://developer.jboss.org/wiki/IntegrateAmazonSimpleDBWithTeiid
> When I create the DataSource to AWS I get the following error:
> Inline image 1
> and the stack trace:
> 07:19:29,048 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (teiid-async-threads - 1) IJ000604: Throwable while attempting to get a new connection: null: java.lang.NoClassDefFoundError: com/amazonaws/AmazonServiceException
> at org.teiid.resource.adapter.simpledb.SimpleDBManagedConnectionFactory$1.getConnection(SimpleDBManagedConnectionFactory.java:46)
> at org.teiid.resource.adapter.simpledb.SimpleDBManagedConnectionFactory$1.getConnection(SimpleDBManagedConnectionFactory.java:41)
> at org.teiid.resource.spi.BasicManagedConnectionFactory.createManagedConnection(BasicManagedConnectionFactory.java:71) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:834)
> at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:379)
> at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:453)
> at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:425)
> at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:354)
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years