[JBoss JIRA] (TEIID-3989) PartialResultsWarning not being returned
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3989?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3989.
-----------------------------------
Fix Version/s: 9.0
8.12.5
8.13.2
Resolution: Done
The fix adds handling into the ExceptionHolder so that SourceWarnings can be reconstructed. A patched server and client are required for this to work properly otherwise the previous behavior of just the TeiidSQLWarning will be seen.
> PartialResultsWarning not being returned
> ----------------------------------------
>
> Key: TEIID-3989
> URL: https://issues.jboss.org/browse/TEIID-3989
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver
> Affects Versions: 8.11.3, 9.0
> Reporter: Tom Arnold
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.2
>
> Attachments: TeiidTest.zip, TeiidTest2.zip, Test-vdb.xml, translator-test.zip
>
>
> I'm trying to follow the example [here|https://docs.jboss.org/author/display/TEIID/Partial+Results+Mode] to return source failure information to my app. Partial results mode does work, but I'm getting {{TeiidSQLWarning}} instead of the expected {{PartialResultsWarning}}.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIID-3995) SAP HANA materialization:function loadMatView with argument invalidate set to true problem
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3995?page=com.atlassian.jira.plugin... ]
Steven Hawkins edited comment on TEIID-3995 at 2/24/16 1:20 PM:
----------------------------------------------------------------
I'm not able to reproduce this. Can you provide your source model for Source? And the full stacktrace if possible.
was (Author: shawkins):
I'm not able to reproduce this. Can you provide your source model for Source?
> SAP HANA materialization:function loadMatView with argument invalidate set to true problem
> ------------------------------------------------------------------------------------------
>
> Key: TEIID-3995
> URL: https://issues.jboss.org/browse/TEIID-3995
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.x
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
>
> There appears to be an issue with loadMatView function.
> Specifically when the function is invoked with invalidate=>'true' argument, when it is expected, that invocation of this function invalidates the current contents of the materialized view until the initiated load is completed and new data are populated.
> But when calling this function as described, an error occurs:
> {code:plain}
> TEIID20001 The modeled datatype integer for column 0 doesn't match the runtime type "org.teiid.core.types.ArrayImpl". Please ensure that the column's modeled datatype matches the expected data.
> {code}
> Please note, that there is no column of type array in my schema.
> There is declaration of the view:
> {code:sql}
> CREATE VIEW external_long_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> )
> {code}
> and the query used to load the view:
> {code:sql}
> "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO dv_matviews_mat_view_stage(customer_id,total_amount) SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;',
> {code}
> Complete definition of the view is:
> {code:sql}
> CREATE VIEW external_long_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> ) OPTIONS (
> MATERIALIZED 'TRUE',
> UPDATABLE 'FALSE',
> MATERIALIZED_TABLE 'Source.JSTASTNY.dv_matviews_mat_view',
> "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true',
> "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.JSTASTNY.dv_matviews_statustable',
> "teiid_rel:ON_VDB_START_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_create) SELECT id, vdb_create+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:ON_VDB_DROP_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_drop) SELECT id, vdb_drop+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO dv_matviews_mat_view_stage(customer_id,total_amount) SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;',
> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'exec Source.native(''truncate table dv_matviews_mat_view_stage'');MERGE INTO dv_matviews_check_table(id,before_load) SELECT id, before_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''RENAME TABLE dv_matviews_mat_view_stage TO dv_matviews_mat_view_temp'');exec Source.native(''RENAME TABLE dv_matviews_mat_view TO dv_matviews_mat_view_stage'');exec Source.native(''RENAME TABLE dv_matviews_mat_view_temp TO dv_matviews_mat_view'');MERGE INTO dv_matviews_check_table(id,after_load) SELECT id, after_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT',
> "teiid_rel:MATVIEW_TTL" 20000
> ) AS SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIID-3999) more aspects of materialization metadata should be validated
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3999:
-------------------------------------
Summary: more aspects of materialization metadata should be validated
Key: TEIID-3999
URL: https://issues.jboss.org/browse/TEIID-3999
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Reporter: Steven Hawkins
Priority: Minor
During metadata load we should check if the status table and the materialization scripts are valid, so there is at least a log of the issue rather than waiting for the exception to occur once the vdb is active.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIID-3998) EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3998?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3998.
-----------------------------------
Resolution: Duplicate Issue
Addressed by TEIID-2300 which was a client side change.
> EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3
> ------------------------------------------------------------
>
> Key: TEIID-3998
> URL: https://issues.jboss.org/browse/TEIID-3998
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12
> Environment: eds-5.3.1_1_2015-jdbc
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server1.log
>
>
> We identified an issue when trying to connect with EDS 5.3 jdbc driver to JDV 6.2.3 instance.
> The problem is caused by virtual procedure execution.
> Query performed:
> EXEC View.hiddenUpdate(456,'changed')
> View definition:
> {code}
> <model name="View" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> CREATE VIRTUAL PROCEDURE hiddenUpdate(ID integer,CUSTOMERNAME string) AS BEGIN
> MERGE INTO Customers(id,customername) VALUES(ID,CUSTOMERNAME);
> END
> ]]> </metadata>
> </model>
> {code}
> NPE excepton:
> {code}
> Exception in thread "main" java.lang.NullPointerException
> at org.teiid.jdbc.StatementImpl.executeUpdate(StatementImpl.java:342)
> at jdbcdriver.JDBCClient.executeUpdate(JDBCClient.java:59)
> at jdbcdriver.JDBCClient.main(JDBCClient.java:52)
> {code}
> Client code:
> {code}
> @Test
> public void procedureInvalidateCacheTest(){
> String sqlSelectAll = "/*+ cache */SELECT * FROM Customers;";
> try{
>
> Utils.executeUpdate(con,"INSERT INTO Customers(id,customername) VALUES (456, 'Testing 1');");
>
> ResultSet empty = Utils.executeQuery(con, sqlSelectAll);
> Assert.assertTrue(empty.next(), "ResultSet should be empty");
>
> try{
> Thread.sleep(3000);
> }catch(InterruptedException ie){
>
> }
>
> Utils.executeUpdate(con,"EXEC View.hiddenUpdate(456,'changed')");
>
> ResultSet full = Utils.executeQuery(con, sqlSelectAll);
> Assert.assertTrue(full.next(), "ResultSet shouldn't be empty");
>
> int custId = full.getInt(1);
> String custName = full.getString(2);
> Assert.assertEquals(custId, 456,"Returned row with wrong customer id");
> Assert.assertEquals(custName,"changed","PROCEDURE with UPDATE query didn't invalidate the cache:returned row with wrong customer name");
>
>
> }catch(SQLException se){
> LOG.error("Error during performing sql query on teiid",se);
> Assert.fail("Error during performing sql query on teiid", se);
> }
> }
> static Connection getTeiidConnectionUser1() throws SQLException {
> LOG.info("Getting Teiid connection for user1.");
> return TeiidDriver.getInstance().connect(TEIID_URL_USER1, null);
> }
> static int executeUpdate(Connection con, String sql) throws SQLException{
> LOG.info("Executing update [connection: " + con + "]: " + sql + ".");
> Statement s = con.createStatement();
> return s.executeUpdate(sql);
> }
> {code}
> Server log is in the attachment.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIID-3995) SAP HANA materialization:function loadMatView with argument invalidate set to true problem
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3995?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3995:
---------------------------------------
I'm not able to reproduce this. Can you provide your source model for Source?
> SAP HANA materialization:function loadMatView with argument invalidate set to true problem
> ------------------------------------------------------------------------------------------
>
> Key: TEIID-3995
> URL: https://issues.jboss.org/browse/TEIID-3995
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.x
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
>
> There appears to be an issue with loadMatView function.
> Specifically when the function is invoked with invalidate=>'true' argument, when it is expected, that invocation of this function invalidates the current contents of the materialized view until the initiated load is completed and new data are populated.
> But when calling this function as described, an error occurs:
> {code:plain}
> TEIID20001 The modeled datatype integer for column 0 doesn't match the runtime type "org.teiid.core.types.ArrayImpl". Please ensure that the column's modeled datatype matches the expected data.
> {code}
> Please note, that there is no column of type array in my schema.
> There is declaration of the view:
> {code:sql}
> CREATE VIEW external_long_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> )
> {code}
> and the query used to load the view:
> {code:sql}
> "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO dv_matviews_mat_view_stage(customer_id,total_amount) SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;',
> {code}
> Complete definition of the view is:
> {code:sql}
> CREATE VIEW external_long_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> ) OPTIONS (
> MATERIALIZED 'TRUE',
> UPDATABLE 'FALSE',
> MATERIALIZED_TABLE 'Source.JSTASTNY.dv_matviews_mat_view',
> "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true',
> "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.JSTASTNY.dv_matviews_statustable',
> "teiid_rel:ON_VDB_START_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_create) SELECT id, vdb_create+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:ON_VDB_DROP_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_drop) SELECT id, vdb_drop+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO dv_matviews_mat_view_stage(customer_id,total_amount) SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;',
> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'exec Source.native(''truncate table dv_matviews_mat_view_stage'');MERGE INTO dv_matviews_check_table(id,before_load) SELECT id, before_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''RENAME TABLE dv_matviews_mat_view_stage TO dv_matviews_mat_view_temp'');exec Source.native(''RENAME TABLE dv_matviews_mat_view TO dv_matviews_mat_view_stage'');exec Source.native(''RENAME TABLE dv_matviews_mat_view_temp TO dv_matviews_mat_view'');MERGE INTO dv_matviews_check_table(id,after_load) SELECT id, after_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT',
> "teiid_rel:MATVIEW_TTL" 20000
> ) AS SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIID-3998) EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3
by Filip Elias (JIRA)
[ https://issues.jboss.org/browse/TEIID-3998?page=com.atlassian.jira.plugin... ]
Filip Elias updated TEIID-3998:
-------------------------------
Attachment: server1.log
> EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3
> ------------------------------------------------------------
>
> Key: TEIID-3998
> URL: https://issues.jboss.org/browse/TEIID-3998
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12
> Environment: eds-5.3.1_1_2015-jdbc
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server1.log
>
>
> We identified an issue when trying to connect with EDS 5.3 jdbc driver to JDV 6.2.3 instance.
> The problem is caused by virtual procedure execution.
> Query performed:
> EXEC View.hiddenUpdate(456,'changed')
> View definition:
> {code}
> <model name="View" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> CREATE VIRTUAL PROCEDURE hiddenUpdate(ID integer,CUSTOMERNAME string) AS BEGIN
> MERGE INTO Customers(id,customername) VALUES(ID,CUSTOMERNAME);
> END
> ]]> </metadata>
> </model>
> {code}
> NPE excepton:
> {code}
> Exception in thread "main" java.lang.NullPointerException
> at org.teiid.jdbc.StatementImpl.executeUpdate(StatementImpl.java:342)
> at jdbcdriver.JDBCClient.executeUpdate(JDBCClient.java:59)
> at jdbcdriver.JDBCClient.main(JDBCClient.java:52)
> {code}
> Client code:
> {code}
> @Test
> public void procedureInvalidateCacheTest(){
> String sqlSelectAll = "/*+ cache */SELECT * FROM Customers;";
> try{
>
> Utils.executeUpdate(con,"INSERT INTO Customers(id,customername) VALUES (456, 'Testing 1');");
>
> ResultSet empty = Utils.executeQuery(con, sqlSelectAll);
> Assert.assertTrue(empty.next(), "ResultSet should be empty");
>
> try{
> Thread.sleep(3000);
> }catch(InterruptedException ie){
>
> }
>
> Utils.executeUpdate(con,"EXEC View.hiddenUpdate(456,'changed')");
>
> ResultSet full = Utils.executeQuery(con, sqlSelectAll);
> Assert.assertTrue(full.next(), "ResultSet shouldn't be empty");
>
> int custId = full.getInt(1);
> String custName = full.getString(2);
> Assert.assertEquals(custId, 456,"Returned row with wrong customer id");
> Assert.assertEquals(custName,"changed","PROCEDURE with UPDATE query didn't invalidate the cache:returned row with wrong customer name");
>
>
> }catch(SQLException se){
> LOG.error("Error during performing sql query on teiid",se);
> Assert.fail("Error during performing sql query on teiid", se);
> }
> }
> static Connection getTeiidConnectionUser1() throws SQLException {
> LOG.info("Getting Teiid connection for user1.");
> return TeiidDriver.getInstance().connect(TEIID_URL_USER1, null);
> }
> static int executeUpdate(Connection con, String sql) throws SQLException{
> LOG.info("Executing update [connection: " + con + "]: " + sql + ".");
> Statement s = con.createStatement();
> return s.executeUpdate(sql);
> }
> {code}
> Server log is in the attachment.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIID-3998) EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3998?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-3998:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1311213
Bugzilla Update: Perform
> EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3
> ------------------------------------------------------------
>
> Key: TEIID-3998
> URL: https://issues.jboss.org/browse/TEIID-3998
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12
> Environment: eds-5.3.1_1_2015-jdbc
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server1.log
>
>
> We identified an issue when trying to connect with EDS 5.3 jdbc driver to JDV 6.2.3 instance.
> The problem is caused by virtual procedure execution.
> Query performed:
> EXEC View.hiddenUpdate(456,'changed')
> View definition:
> {code}
> <model name="View" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> CREATE VIRTUAL PROCEDURE hiddenUpdate(ID integer,CUSTOMERNAME string) AS BEGIN
> MERGE INTO Customers(id,customername) VALUES(ID,CUSTOMERNAME);
> END
> ]]> </metadata>
> </model>
> {code}
> NPE excepton:
> {code}
> Exception in thread "main" java.lang.NullPointerException
> at org.teiid.jdbc.StatementImpl.executeUpdate(StatementImpl.java:342)
> at jdbcdriver.JDBCClient.executeUpdate(JDBCClient.java:59)
> at jdbcdriver.JDBCClient.main(JDBCClient.java:52)
> {code}
> Client code:
> {code}
> @Test
> public void procedureInvalidateCacheTest(){
> String sqlSelectAll = "/*+ cache */SELECT * FROM Customers;";
> try{
>
> Utils.executeUpdate(con,"INSERT INTO Customers(id,customername) VALUES (456, 'Testing 1');");
>
> ResultSet empty = Utils.executeQuery(con, sqlSelectAll);
> Assert.assertTrue(empty.next(), "ResultSet should be empty");
>
> try{
> Thread.sleep(3000);
> }catch(InterruptedException ie){
>
> }
>
> Utils.executeUpdate(con,"EXEC View.hiddenUpdate(456,'changed')");
>
> ResultSet full = Utils.executeQuery(con, sqlSelectAll);
> Assert.assertTrue(full.next(), "ResultSet shouldn't be empty");
>
> int custId = full.getInt(1);
> String custName = full.getString(2);
> Assert.assertEquals(custId, 456,"Returned row with wrong customer id");
> Assert.assertEquals(custName,"changed","PROCEDURE with UPDATE query didn't invalidate the cache:returned row with wrong customer name");
>
>
> }catch(SQLException se){
> LOG.error("Error during performing sql query on teiid",se);
> Assert.fail("Error during performing sql query on teiid", se);
> }
> }
> static Connection getTeiidConnectionUser1() throws SQLException {
> LOG.info("Getting Teiid connection for user1.");
> return TeiidDriver.getInstance().connect(TEIID_URL_USER1, null);
> }
> static int executeUpdate(Connection con, String sql) throws SQLException{
> LOG.info("Executing update [connection: " + con + "]: " + sql + ".");
> Statement s = con.createStatement();
> return s.executeUpdate(sql);
> }
> {code}
> Server log is in the attachment.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIID-3998) EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3
by Filip Elias (JIRA)
Filip Elias created TEIID-3998:
----------------------------------
Summary: EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3
Key: TEIID-3998
URL: https://issues.jboss.org/browse/TEIID-3998
Project: Teiid
Issue Type: Bug
Affects Versions: 8.12
Environment: eds-5.3.1_1_2015-jdbc
Reporter: Filip Elias
Assignee: Steven Hawkins
We identified an issue when trying to connect with EDS 5.3 jdbc driver to JDV 6.2.3 instance.
The problem is caused by virtual procedure execution.
Query performed:
EXEC View.hiddenUpdate(456,'changed')
View definition:
{code}
<model name="View" type="VIRTUAL">
<metadata type="DDL"><![CDATA[
CREATE VIRTUAL PROCEDURE hiddenUpdate(ID integer,CUSTOMERNAME string) AS BEGIN
MERGE INTO Customers(id,customername) VALUES(ID,CUSTOMERNAME);
END
]]> </metadata>
</model>
{code}
NPE excepton:
{code}
Exception in thread "main" java.lang.NullPointerException
at org.teiid.jdbc.StatementImpl.executeUpdate(StatementImpl.java:342)
at jdbcdriver.JDBCClient.executeUpdate(JDBCClient.java:59)
at jdbcdriver.JDBCClient.main(JDBCClient.java:52)
{code}
Client code:
{code}
@Test
public void procedureInvalidateCacheTest(){
String sqlSelectAll = "/*+ cache */SELECT * FROM Customers;";
try{
Utils.executeUpdate(con,"INSERT INTO Customers(id,customername) VALUES (456, 'Testing 1');");
ResultSet empty = Utils.executeQuery(con, sqlSelectAll);
Assert.assertTrue(empty.next(), "ResultSet should be empty");
try{
Thread.sleep(3000);
}catch(InterruptedException ie){
}
Utils.executeUpdate(con,"EXEC View.hiddenUpdate(456,'changed')");
ResultSet full = Utils.executeQuery(con, sqlSelectAll);
Assert.assertTrue(full.next(), "ResultSet shouldn't be empty");
int custId = full.getInt(1);
String custName = full.getString(2);
Assert.assertEquals(custId, 456,"Returned row with wrong customer id");
Assert.assertEquals(custName,"changed","PROCEDURE with UPDATE query didn't invalidate the cache:returned row with wrong customer name");
}catch(SQLException se){
LOG.error("Error during performing sql query on teiid",se);
Assert.fail("Error during performing sql query on teiid", se);
}
}
static Connection getTeiidConnectionUser1() throws SQLException {
LOG.info("Getting Teiid connection for user1.");
return TeiidDriver.getInstance().connect(TEIID_URL_USER1, null);
}
static int executeUpdate(Connection con, String sql) throws SQLException{
LOG.info("Executing update [connection: " + con + "]: " + sql + ".");
Statement s = con.createStatement();
return s.executeUpdate(sql);
}
{code}
Server log is in the attachment.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIID-3997) "Unknown attribute ssl-enable" error in DV Management Console when configuring a transport for SSL
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3997?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-3997:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1311630
Bugzilla Update: Perform
> "Unknown attribute ssl-enable" error in DV Management Console when configuring a transport for SSL
> ---------------------------------------------------------------------------------------------------
>
> Key: TEIID-3997
> URL: https://issues.jboss.org/browse/TEIID-3997
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.2.6_2
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
>
> clicking the SSL Enabled checkbox on a Teiid Transport in the Management Console gives below error upon saving:
> Unexpected HTTP response: 500
> Request
> {
> "operation" => "composite",
> "address" => [],
> "steps" => [{
> "address" => [
> ("profile" => "ha"),
> ("subsystem" => "teiid"),
> ("transport" => "jdbc")
> ],
> "operation" => "write-attribute",
> "name" => "ssl-enable",
> "value" => true
> }]
> }
> Response
> Internal Server Error
> {
> "outcome" => "failed",
> "result" => {"step-1" => {
> "outcome" => "failed",
> "failure-description" => "JBAS014792: Unknown attribute ssl-enable",
> "rolled-back" => true
> }},
> "failure-description" => {"domain-failure-description" => {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-1" => "JBAS014792: Unknown attribute ssl-enable"}}},
> "rolled-back" => true
> }
> The correct attribute is ssl-mode=enabled, which is what setting the Mode Field to enabled does. Either remove the checkbox for "SSL Enabled" or have it send the correct operation:
> Request
> {
> "operation" => "composite",
> "address" => [],
> "steps" => [{
> "address" => [
> ("profile" => "ha"),
> ("subsystem" => "teiid"),
> ("transport" => "jdbc")
> ],
> "operation" => "write-attribute",
> "name" => "ssl-mode",
> "value" => enabled
> }]
> }
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIID-3997) "Unknown attribute ssl-enable" error in DV Management Console when configuring a transport for SSL
by Debbie Steigner (JIRA)
Debbie Steigner created TEIID-3997:
--------------------------------------
Summary: "Unknown attribute ssl-enable" error in DV Management Console when configuring a transport for SSL
Key: TEIID-3997
URL: https://issues.jboss.org/browse/TEIID-3997
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.2.6_2
Reporter: Debbie Steigner
Assignee: Steven Hawkins
clicking the SSL Enabled checkbox on a Teiid Transport in the Management Console gives below error upon saving:
Unexpected HTTP response: 500
Request
{
"operation" => "composite",
"address" => [],
"steps" => [{
"address" => [
("profile" => "ha"),
("subsystem" => "teiid"),
("transport" => "jdbc")
],
"operation" => "write-attribute",
"name" => "ssl-enable",
"value" => true
}]
}
Response
Internal Server Error
{
"outcome" => "failed",
"result" => {"step-1" => {
"outcome" => "failed",
"failure-description" => "JBAS014792: Unknown attribute ssl-enable",
"rolled-back" => true
}},
"failure-description" => {"domain-failure-description" => {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-1" => "JBAS014792: Unknown attribute ssl-enable"}}},
"rolled-back" => true
}
The correct attribute is ssl-mode=enabled, which is what setting the Mode Field to enabled does. Either remove the checkbox for "SSL Enabled" or have it send the correct operation:
Request
{
"operation" => "composite",
"address" => [],
"steps" => [{
"address" => [
("profile" => "ha"),
("subsystem" => "teiid"),
("transport" => "jdbc")
],
"operation" => "write-attribute",
"name" => "ssl-mode",
"value" => enabled
}]
}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months