[JBoss JIRA] (TEIID-2525) Prefetch doesn't work when clause contains LIMIT keyword
by Filip Nguyen (JIRA)
Filip Nguyen created TEIID-2525:
-----------------------------------
Summary: Prefetch doesn't work when clause contains LIMIT keyword
Key: TEIID-2525
URL: https://issues.jboss.org/browse/TEIID-2525
Project: Teiid
Issue Type: Bug
Affects Versions: 8.4, 7.7.7
Reporter: Filip Nguyen
Assignee: Steven Hawkins
Priority: Critical
Doesn't work both in the newest Teiid and the 7.x version.
Not sure how critical this is. When setting the prefetch via JDBC and using FORWARD_ONLY result set [1] I am getting exceptions [2] when using LIMIT clause in the SQL.
{code:java}
TeiidDataSource ds = new TeiidDataSource();
ds.setDatabaseName(vdb);
ds.setUser("user");
ds.setPassword("user");
ds.setServerName(host);
ds.setPortNumber(Integer.valueOf(port));
ds.setFetchSize(10);
....
Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
{code}
[2]
{code:java}
Eorg.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
at org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402)
at org.teiid.jdbc.ResultSetImpl.requestBatch(ResultSetImpl.java:375)
at org.teiid.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:226)
at org.teiid.jdbc.BatchResults.requestNextBatch(BatchResults.java:141)
at org.teiid.jdbc.BatchResults.hasNext(BatchResults.java:252)
at org.teiid.jdbc.ResultSetImpl.hasNext(ResultSetImpl.java:439)
at org.teiid.jdbc.ResultSetImpl.next(ResultSetImpl.java:251)
at JDBCClient.execute(JDBCClient.java:90)
at JDBCClient.main(JDBCClient.java:45)
Caused by: org.teiid.core.TeiidException: ASSERTION FAILED: expected reference to be not null
at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:202)
at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:955)
at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:543)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:346)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:305)
at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:782)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 6 months
[JBoss JIRA] (TEIID-2519) Odata Table Query Not Workng
by devin pinkston (JIRA)
[ https://issues.jboss.org/browse/TEIID-2519?page=com.atlassian.jira.plugin... ]
devin pinkston commented on TEIID-2519:
---------------------------------------
Thank you Ramesh!
> Odata Table Query Not Workng
> ----------------------------
>
> Key: TEIID-2519
> URL: https://issues.jboss.org/browse/TEIID-2519
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.3
> Environment: CentOS, JBOSS AS 7.1.1, Teiid 8.3.
> Reporter: devin pinkston
> Assignee: Ramesh Reddy
> Priority: Minor
> Labels: odata,, service,, web
> Fix For: 8.4
>
> Attachments: metadata.txt, portfolio-vdb.xml, portfolio-vdb.xml
>
>
> When trying to query a table through Odata, a error is diplayed: EdmEntitySet refinedSalariesModel.refinedSalaries is not found
> When issuing the query:
> http://localhost:8080/odata/Portfolio.1/refinedSalariesModel.refinedSalaries
> We have also tried using:
> http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries
> When issuing the second query, this error is thrown:
> <error><code/><message lang="en-US">Could not find resource for relative : /refinedSalariesModel/refinedSalaries of full path: http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries</message></error>
> We can successfully display the metadata and see the details of the VDB by using:
> http://localhost:8080/odata/Portfolio.1/$metadata
> Please let me know if you need any more information
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 6 months
[JBoss JIRA] (TEIID-2524) Hive metadata import leaves white characters in table name
by Filip Nguyen (JIRA)
Filip Nguyen created TEIID-2524:
-----------------------------------
Summary: Hive metadata import leaves white characters in table name
Key: TEIID-2524
URL: https://issues.jboss.org/browse/TEIID-2524
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.4
Reporter: Filip Nguyen
Assignee: Steven Hawkins
When hive translator starts with the newest Hive it runs "describe" command which returns Hive table names with white spaces.
Maybe just use trim() in HiveMetadataProcessor.java?
String name = rs.getString(1).trim();
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 6 months
[JBoss JIRA] (TEIID-2523) How to configure ssl with mod_cluster and JBoss 7.1.1
by Jose Giner (JIRA)
Jose Giner created TEIID-2523:
---------------------------------
Summary: How to configure ssl with mod_cluster and JBoss 7.1.1
Key: TEIID-2523
URL: https://issues.jboss.org/browse/TEIID-2523
Project: Teiid
Issue Type: Feature Request
Affects Versions: 7.1.1
Environment: - One LPAR with AIX 7.1, mod_cluster 1.1.3, http 2.2.14
- Two LPAR with AIX 7.1, JBoss 7.1.1. Final
Reporter: Jose Giner
Assignee: Steven Hawkins
Hi,
We configure three LPAR with AIX7.1:
- One LPAR for Web with mod_cluster 1.1.3 and http 2.2.14
- Two LPAR for JBoss 7.1.1 Final.
Now we want to securize the Web LPAR.
1.- We create a local certificate on Web LPAR:
openssl genrsa -des3 -out server.key 1024
openssl req -new -key server.key -out server.csr
openssl req -new -key server.key -out server.csr
openssl x509 -req -days 730 -in server.csr -signkey server.key -out server.crt
2.- We comment the line "Include conf/extra/httpd-vhosts.conf" on httpd.conf
3.- We uncommnet the line "Include conf/extra/httpd-ssl.conf" on httpd.conf
4.- We copy the content of conf/extra/httpd-vhosts.conf at the bottom of conf/extra/httpd-ssl.conf and change the port 10001 by 443 and add SSL configuration:
</VirtualHost>
Listen 192.168.34.19:443
MemManagerFile /var/cache/httpd
<VirtualHost 192.168.34.19:443>
SSLEngine on
SSLCipherSuite AES128-SHA:ALL:!ADH:!LOW:!MD5:!SSLV2:!NULL
SSLCertificateFile pki/server.crt
SSLCertificateKeyFile pki/server.key
SSLVerifyClient require
SSLVerifyDepth 10
<Directory />
Order deny,allow
Allow from all
</Directory>
KeepAliveTimeout 60
MaxKeepAliveRequests 0
ManagerBalancerName other-server-group
AdvertiseFrequency 5
#This directive allows you to view mod_cluster status at URL http://192.168.34.19:10001/mod_cluster-manager
<Location /mod_cluster-manager>
SetHandler mod_cluster-manager
Order deny,allow
Allow from all
</Location>
</VirtualHost>
but we cannot connect using https://.....
Anything wrong? We must configure something in JBoss?
Regards,
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 6 months
[JBoss JIRA] (TEIID-2521) Create a Security Guide
by B Long (JIRA)
[ https://issues.jboss.org/browse/TEIID-2521?page=com.atlassian.jira.plugin... ]
B Long edited comment on TEIID-2521 at 6/2/13 9:43 PM:
-------------------------------------------------------
Is "and applying the standard security-constraint and security-role settings to your web.xml" still valid? Should this be something else instead? (At bottom of https://community.jboss.org/wiki/CreatingACustomLoginModule)
was (Author: belong):
Is "and applying the standard security-constraint and security-role settings to your web.xml" still valid? Should this be something else instead?
> Create a Security Guide
> -----------------------
>
> Key: TEIID-2521
> URL: https://issues.jboss.org/browse/TEIID-2521
> Project: Teiid
> Issue Type: Enhancement
> Components: Documentation
> Affects Versions: 8.4
> Reporter: B Long
> Assignee: Steven Hawkins
> Priority: Trivial
> Fix For: 8.4
>
> Original Estimate: 0 minutes
> Remaining Estimate: 0 minutes
>
> Create a Security Guide incorporating security sections from the Administrator's Guide and Developer's Guide.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 7 months
[JBoss JIRA] (TEIID-2521) Create a Security Guide
by B Long (JIRA)
[ https://issues.jboss.org/browse/TEIID-2521?page=com.atlassian.jira.plugin... ]
B Long commented on TEIID-2521:
-------------------------------
Is "and applying the standard security-constraint and security-role settings to your web.xml" still valid? Should this be something else instead?
> Create a Security Guide
> -----------------------
>
> Key: TEIID-2521
> URL: https://issues.jboss.org/browse/TEIID-2521
> Project: Teiid
> Issue Type: Enhancement
> Components: Documentation
> Affects Versions: 8.4
> Reporter: B Long
> Assignee: Steven Hawkins
> Priority: Trivial
> Fix For: 8.4
>
> Original Estimate: 0 minutes
> Remaining Estimate: 0 minutes
>
> Create a Security Guide incorporating security sections from the Administrator's Guide and Developer's Guide.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 7 months