[JBoss JIRA] (TEIID-4587) JDBC/ODBC transports not set up in Teiid 9.1.1
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4587?page=com.atlassian.jira.plugin... ]
Steve Tran commented on TEIID-4587:
-----------------------------------
Ah, I see. I am trying to use domain.xml though.
> JDBC/ODBC transports not set up in Teiid 9.1.1
> ----------------------------------------------
>
> Key: TEIID-4587
> URL: https://issues.jboss.org/browse/TEIID-4587
> Project: Teiid
> Issue Type: Bug
> Components: Common
> Affects Versions: 9.1.1
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> Working with the latest Teiid 9.1.1 on Wildfly 10. None of the Teiid components are displayed in the web console. Also, none of the Teiid specific transports are there. I am able to deploy a VDB with no errors in the logs, but without the transports for port 31000 and 35432, I am unable to connect to my VDB.
> I was expecting 31000 and 35432 to be configured out-of-the-box, but perhaps that's not how the community version works.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4587) JDBC/ODBC transports not set up in Teiid 9.1.1
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4587?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-4587:
-------------------------------------
I suspect he did not start using
{code}
./standalone.sh -c standalone-teiid.xml
{code}
> JDBC/ODBC transports not set up in Teiid 9.1.1
> ----------------------------------------------
>
> Key: TEIID-4587
> URL: https://issues.jboss.org/browse/TEIID-4587
> Project: Teiid
> Issue Type: Bug
> Components: Common
> Affects Versions: 9.1.1
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> Working with the latest Teiid 9.1.1 on Wildfly 10. None of the Teiid components are displayed in the web console. Also, none of the Teiid specific transports are there. I am able to deploy a VDB with no errors in the logs, but without the transports for port 31000 and 35432, I am unable to connect to my VDB.
> I was expecting 31000 and 35432 to be configured out-of-the-box, but perhaps that's not how the community version works.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4587) JDBC/ODBC transports not set up in Teiid 9.1.1
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4587?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4587:
---------------------------------------
Both transports are enabled. Can you provide more detail about your installation? And the specific error that you are seeing when attempting to connect?
> JDBC/ODBC transports not set up in Teiid 9.1.1
> ----------------------------------------------
>
> Key: TEIID-4587
> URL: https://issues.jboss.org/browse/TEIID-4587
> Project: Teiid
> Issue Type: Bug
> Components: Common
> Affects Versions: 9.1.1
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> Working with the latest Teiid 9.1.1 on Wildfly 10. None of the Teiid components are displayed in the web console. Also, none of the Teiid specific transports are there. I am able to deploy a VDB with no errors in the logs, but without the transports for port 31000 and 35432, I am unable to connect to my VDB.
> I was expecting 31000 and 35432 to be configured out-of-the-box, but perhaps that's not how the community version works.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4587) JDBC/ODBC transports not set up in Teiid 9.1.1
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4587?page=com.atlassian.jira.plugin... ]
Steve Tran updated TEIID-4587:
------------------------------
Issue Type: Bug (was: Feature Request)
> JDBC/ODBC transports not set up in Teiid 9.1.1
> ----------------------------------------------
>
> Key: TEIID-4587
> URL: https://issues.jboss.org/browse/TEIID-4587
> Project: Teiid
> Issue Type: Bug
> Components: Common
> Affects Versions: 9.1.1
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> Working with the latest Teiid 9.1.1 on Wildfly 10. None of the Teiid components are displayed in the web console. Also, none of the Teiid specific transports are there. I am able to deploy a VDB with no errors in the logs, but without the transports for port 31000 and 35432, I am unable to connect to my VDB.
> I was expecting 31000 and 35432 to be configured out-of-the-box, but perhaps that's not how the community version works.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4587) JDBC/ODBC transports not set up in Teiid 9.1.1
by Steve Tran (JIRA)
Steve Tran created TEIID-4587:
---------------------------------
Summary: JDBC/ODBC transports not set up in Teiid 9.1.1
Key: TEIID-4587
URL: https://issues.jboss.org/browse/TEIID-4587
Project: Teiid
Issue Type: Feature Request
Components: Common
Affects Versions: 9.1.1
Reporter: Steve Tran
Assignee: Steven Hawkins
Working with the latest Teiid 9.1.1 on Wildfly 10. None of the Teiid components are displayed in the web console. Also, none of the Teiid specific transports are there. I am able to deploy a VDB with no errors in the logs, but without the transports for port 31000 and 35432, I am unable to connect to my VDB.
I was expecting 31000 and 35432 to be configured out-of-the-box, but perhaps that's not how the community version works.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4532) Provide one-way or cryptographic hash functions
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4532?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4532.
-----------------------------------
Resolution: Done
Marking as initially resolved. There are four functions added. Each can take a string or a varbinary - md5, sha1, sha2_256, and sha2_512. These were added as separate functions to keep the pushdown logic straight-forward - so that we aren't introducing special constants for the algorithm or bit length. Pushdown support was added for both Teiid and SQL Server. Pushdown support is possible for mysql (although we have to convert from the hex string to bytes), oracle (relying on the crypto package), postgres (relying on pgcrypto), and others but require more effort or that we need to detect that the extension is available. I propose that we address that on an add needed basis.
The md5 function also overlaps with the osDQ hash function, so we'll likely end up removing the hash function.
> Provide one-way or cryptographic hash functions
> -----------------------------------------------
>
> Key: TEIID-4532
> URL: https://issues.jboss.org/browse/TEIID-4532
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 9.2
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 9.2
>
>
> Provide one-way or [cryptographic hash functions|https://en.wikipedia.org/wiki/SHA-3#Comparison_of_SHA_functions], such as any of the MD5, SHA-1, SHA-2, or SHA-3 functions, so that views can define columns that are hashes of other columns.
> The goal is to allow views to hide some columns (e.g., personally identifying information), but to expose a new "primary key" that is a hash of other existing columns. So, given this source table:
> {code:sql}
> CREATE TABLE person (
> id INT PRIMARY KEY,
> name VARCHAR(256) NOT NULL,
> age INT,
> height INT,
> weight DOUBLE
> );
> {code}
> a view could be created to hide the personally identifying information:
> {code:sql}
> CREATE VIEW anonymousPerson ()
> id VARCHAR(64) PRIMARY KEY,
> age INT,
> height INT,
> weight DOUBLE
> ) AS
> SELECT sha256(p.id, p.name) AS id,
> p.age AS age,
> p.height AS height,
> p.weight AS weight
> FROM person AS p;
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4584) SimpleDB doesn' work
by Glen Wilcox (JIRA)
[ https://issues.jboss.org/browse/TEIID-4584?page=com.atlassian.jira.plugin... ]
Glen Wilcox commented on TEIID-4584:
------------------------------------
I did add the full jar. It allows the creation of the Teiid Connection >> Source Model to go almost to creation before failing. The new error is:java.lang.NoClassDefFoundError: com/fasterxml/jackson/databind/ObjectMapper
These files are included in the aws-sdk-xxx/third-party/lib area. If you try adding them like so: <resources>
<resource-root path="simpledb-api-8.12.5.redhat-8.jar" />
<resource-root path="aws-java-sdk-1.11.52.jar" />
<!-- <resource-root path="aws-java-sdk-simpledb-1.10.77.jar" /> -->
<!-- Insert resources here -->
</resources>
You can add the jackson libs which are included in the sdk download /third-party/libs. That works but you have problems with the httpclient, httpcore libs when I add those.
[^SimpleDB_ERROR_HTTP.txt] [^SimpleDB_ERROR_Jackson.txt]
> 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: Steven Hawkins
> 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)
9 years, 4 months
[JBoss JIRA] (TEIID-4584) SimpleDB doesn' work
by Glen Wilcox (JIRA)
[ https://issues.jboss.org/browse/TEIID-4584?page=com.atlassian.jira.plugin... ]
Glen Wilcox updated TEIID-4584:
-------------------------------
Attachment: SimpleDB_ERROR_HTTP.txt
SimpleDB_ERROR_Jackson.txt
> 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: Steven Hawkins
> 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)
9 years, 4 months