[JBoss JIRA] (TEIID-5615) Error when binding NULL to nullable parameter in a prepared statement with PDO PostgreSQL ODBC client
by George Ushakov (Jira)
George Ushakov created TEIID-5615:
-------------------------------------
Summary: Error when binding NULL to nullable parameter in a prepared statement with PDO PostgreSQL ODBC client
Key: TEIID-5615
URL: https://issues.jboss.org/browse/TEIID-5615
Project: Teiid
Issue Type: Bug
Components: ODBC
Affects Versions: 11.2, 11.0
Environment: All infrastructure is Dockerized on Windows 64bit (see below)
WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
Teiid Engine 11.2.0
DatabaseProductVersion=11.1 (Debian 11.1-1.pgdg90+1)
PostgreSQL JDBC Driver=42.2.5
PDO Driver for PostgreSQL (from phpinfo())
PostgreSQL(libpq) Version: 9.6.10
Module version: 7.1.26
Reporter: George Ushakov
Assignee: Steven Hawkins
On Teiid 11.0 (and probably later versions, as well) running in a WildFly there is a problem when binding to a NULLABLE parameter in a prepared statement with NULL value when running against a PostgreSQL source from a PDO (PHP) ODBC client.
PDO calls causing the error are related to [PDOStatement::bindValue|https://secure.php.net/manual/en/pdostatement.bin...]
and [PDOStatement::bindParam|https://secure.php.net/manual/en/pdostatement.bin...].
It occurs exclusively when the client is trying to bind a NULL value (corresponding to a NULLABLE column in a table) to the prepared statement using PDO::PARAM_NULL type.
Example PHP code
{code:php}
$dbh = new PDO('pgsql:host=<teiid_host>;port=35432;dbname=<vdb_name>;user=<teiid_user>;password=<teiid_password>');
$stmt = $dbh->prepare("INSERT INTO foobar (id, optional) VALUES(?, ?)");
$stmt->bindValue(1, 1);
$stmt->bindValue(2, null, PDO::PARAM_NULL);
$stmt->execute();
{code}
Exception thrown is
Caused by: java.lang.NegativeArraySizeException
at org.teiid.transport.PgFrontendProtocol.createByteArray(PgFrontendProtocol.java:328)
at org.teiid.transport.PgFrontendProtocol.buildBind(PgFrontendProtocol.java:266)
at org.teiid.transport.PgFrontendProtocol.createRequestMessage(PgFrontendProtocol.java:153)
at org.teiid.transport.PgFrontendProtocol.decode(PgFrontendProtocol.java:133)
at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:411)
... 15 more
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
7 years, 2 months
[JBoss JIRA] (TEIID-5594) Use generic rather than jboss javax dependencies for teiid core
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5594?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5594.
-----------------------------------
Resolution: Done
Thanks Van. Merged the PR with a minor change to use the non jboss slf4j - if that's needed we can switch back.
> Use generic rather than jboss javax dependencies for teiid core
> ---------------------------------------------------------------
>
> Key: TEIID-5594
> URL: https://issues.jboss.org/browse/TEIID-5594
> Project: Teiid
> Issue Type: Sub-task
> Components: Build/Kits
> Reporter: Steven Hawkins
> Assignee: Van Halbert
> Priority: Minor
> Fix For: 12.1
>
>
> The following dependencies are aligned to Wildfly, but that is unnecessary for embedded/springboot. They should be replaced with more generic versions.
> {code}
> <dependency>
> <groupId>org.jboss.spec.javax.ws.rs</groupId>
> <artifactId>jboss-jaxrs-api_2.1_spec</artifactId>
> <version>1.0.1.Final</version>
> </dependency>
> <dependency>
> <groupId>org.jboss.spec.javax.xml.ws</groupId>
> <artifactId>jboss-jaxws-api_2.3_spec</artifactId>
> <version>1.0.0.Final</version>
> </dependency>
> <dependency>
> <groupId>org.jboss.spec.javax.servlet</groupId>
> <artifactId>jboss-servlet-api_3.1_spec</artifactId>
> <version>1.0.2.Final</version>
> </dependency>
> <dependency>
> <groupId>org.jboss.spec.javax.transaction</groupId>
> <artifactId>jboss-transaction-api_1.2_spec</artifactId>
> <version>1.1.1.Final</version>
> </dependency>
> <dependency>
> <groupId>org.jboss.spec.javax.xml.bind</groupId>
> <artifactId>jboss-jaxb-api_2.3_spec</artifactId>
> <version>1.0.1.Final</version>
> </dependency>
> <dependency>
> <groupId>org.slf4j</groupId>
> <artifactId>slf4j-api</artifactId>
> <version>1.7.22.jbossorg-1</version>
> </dependency>
> {code}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
7 years, 2 months
[JBoss JIRA] (TEIID-5613) upgrade to thorntail 2.3
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5613?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5613:
---------------------------------------
The last WildFly .Y release was 10.1 in 2016. They've only done a couple of ..Z minor releases, but otherwise a 3-4 month cadence for a major release after WildFly 11.
> upgrade to thorntail 2.3
> ------------------------
>
> Key: TEIID-5613
> URL: https://issues.jboss.org/browse/TEIID-5613
> Project: Teiid
> Issue Type: Task
> Components: thorntail
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.0
>
>
> Thorntail with THORN-2126 has intermediate versions, such as the 1.5.3 config-api, on wildfly 14 - but moved to WildFly 15 for the release. I'll experiment a little if Teiid 12 is compatible enough to build Thorntail 2.3 support directly. More than likely though we'll need to wait until Teiid 13 to sync back up.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
7 years, 2 months
[JBoss JIRA] (TEIID-5613) upgrade to thorntail 2.3
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIID-5613?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5613:
-------------------------------------
Maybe I am misreading 6 months to 3 months, that means they have no dot releases at all
> upgrade to thorntail 2.3
> ------------------------
>
> Key: TEIID-5613
> URL: https://issues.jboss.org/browse/TEIID-5613
> Project: Teiid
> Issue Type: Task
> Components: thorntail
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.0
>
>
> Thorntail with THORN-2126 has intermediate versions, such as the 1.5.3 config-api, on wildfly 14 - but moved to WildFly 15 for the release. I'll experiment a little if Teiid 12 is compatible enough to build Thorntail 2.3 support directly. More than likely though we'll need to wait until Teiid 13 to sync back up.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
7 years, 2 months
[JBoss JIRA] (TEIID-5613) upgrade to thorntail 2.3
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5613?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5613:
---------------------------------------
We are at about 6 months for major releases. In this case I didn't push further to WF 15 toward the end of the 12 cycle - Thorntail did. Also from 14 to 15 was only 3 months for WildFly.
> upgrade to thorntail 2.3
> ------------------------
>
> Key: TEIID-5613
> URL: https://issues.jboss.org/browse/TEIID-5613
> Project: Teiid
> Issue Type: Task
> Components: thorntail
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.0
>
>
> Thorntail with THORN-2126 has intermediate versions, such as the 1.5.3 config-api, on wildfly 14 - but moved to WildFly 15 for the release. I'll experiment a little if Teiid 12 is compatible enough to build Thorntail 2.3 support directly. More than likely though we'll need to wait until Teiid 13 to sync back up.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
7 years, 2 months
[JBoss JIRA] (TEIID-5613) upgrade to thorntail 2.3
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIID-5613?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5613:
-------------------------------------
WildFly has adjusted their rate of release of each major version to I believe every 6 months. We need to think of this release cadence and come up some strategy for Teiid.
> upgrade to thorntail 2.3
> ------------------------
>
> Key: TEIID-5613
> URL: https://issues.jboss.org/browse/TEIID-5613
> Project: Teiid
> Issue Type: Task
> Components: thorntail
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.0
>
>
> Thorntail with THORN-2126 has intermediate versions, such as the 1.5.3 config-api, on wildfly 14 - but moved to WildFly 15 for the release. I'll experiment a little if Teiid 12 is compatible enough to build Thorntail 2.3 support directly. More than likely though we'll need to wait until Teiid 13 to sync back up.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
7 years, 2 months
[JBoss JIRA] (TEIID-5614) Teiid Spring Boot - Enable Spring Actuator and non OData requests
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIID-5614?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-5614:
--------------------------------
Description:
While working with Teiid spring boot starter in my spring boot app I encountered an issue when trying to access spring actuator endpoints.
I have "server.context-path: /api/odata" in my bootstrap.yml configuration.
Then, accessing <my-server-url>/api/odata/health returns an error since I don't have a table named "health":
{code}
<error xmlns="http://docs.oasis-open.org/odata/ns/metadata">
<code>null</code>
<message>
Cannot find EntitySet, Singleton, ActionImport or FunctionImport with name 'health'.
</message>
</error>
{code}
I need to "split" the context for OData endpoints and for the rest endpoints which are not OData endpoints.
I saw that Olingo has a support for that ("org.apache.olingo.odata2.path.split" property).
(didn't find any documentation for that "split" for OData version 4)
https://olingo.apache.org/doc/odata2/tutorials/Olingo_Tutorial_Advanced_S...
Maybe this feature is useful also for requests which are not OData Protocol requests(and not only for Spring actuator endpoints..)
was:
While working with Teiid spring boot starter in my spring boot app I encountered an issue when trying to access spring actuator endpoints.
I have "server.context-path: /api/odata" in my bootstrap.yml configuration.
Then, accessing <my-server-url>/api/odata/health returns an error since I don't have a table named "health":
<error xmlns="http://docs.oasis-open.org/odata/ns/metadata">
<code>null</code>
<message>
Cannot find EntitySet, Singleton, ActionImport or FunctionImport with name 'health'.
</message>
</error>
I need to "split" the context for OData endpoints and for the rest endpoints which are not OData endpoints.
I saw that Olingo has a support for that ("org.apache.olingo.odata2.path.split" property).
(didn't find any documentation for that "split" for OData version 4)
https://olingo.apache.org/doc/odata2/tutorials/Olingo_Tutorial_Advanced_S...
Maybe this feature is useful also for requests which are not OData Protocol requests(and not only for Spring actuator endpoints..)
> Teiid Spring Boot - Enable Spring Actuator and non OData requests
> -----------------------------------------------------------------
>
> Key: TEIID-5614
> URL: https://issues.jboss.org/browse/TEIID-5614
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Tamar Meron
> Assignee: Ramesh Reddy
> Priority: Major
>
> While working with Teiid spring boot starter in my spring boot app I encountered an issue when trying to access spring actuator endpoints.
> I have "server.context-path: /api/odata" in my bootstrap.yml configuration.
> Then, accessing <my-server-url>/api/odata/health returns an error since I don't have a table named "health":
> {code}
> <error xmlns="http://docs.oasis-open.org/odata/ns/metadata">
> <code>null</code>
> <message>
> Cannot find EntitySet, Singleton, ActionImport or FunctionImport with name 'health'.
> </message>
> </error>
> {code}
> I need to "split" the context for OData endpoints and for the rest endpoints which are not OData endpoints.
> I saw that Olingo has a support for that ("org.apache.olingo.odata2.path.split" property).
> (didn't find any documentation for that "split" for OData version 4)
> https://olingo.apache.org/doc/odata2/tutorials/Olingo_Tutorial_Advanced_S...
> Maybe this feature is useful also for requests which are not OData Protocol requests(and not only for Spring actuator endpoints..)
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
7 years, 2 months
[JBoss JIRA] (TEIID-5614) Teiid Spring Boot - Enable Spring Actuator and non OData requests
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIID-5614?page=com.atlassian.jira.plugin... ]
Ramesh Reddy reassigned TEIID-5614:
-----------------------------------
Assignee: Ramesh Reddy (was: Steven Hawkins)
> Teiid Spring Boot - Enable Spring Actuator and non OData requests
> -----------------------------------------------------------------
>
> Key: TEIID-5614
> URL: https://issues.jboss.org/browse/TEIID-5614
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Tamar Meron
> Assignee: Ramesh Reddy
> Priority: Major
>
> While working with Teiid spring boot starter in my spring boot app I encountered an issue when trying to access spring actuator endpoints.
> I have "server.context-path: /api/odata" in my bootstrap.yml configuration.
> Then, accessing <my-server-url>/api/odata/health returns an error since I don't have a table named "health":
> <error xmlns="http://docs.oasis-open.org/odata/ns/metadata">
> <code>null</code>
> <message>
> Cannot find EntitySet, Singleton, ActionImport or FunctionImport with name 'health'.
> </message>
> </error>
> I need to "split" the context for OData endpoints and for the rest endpoints which are not OData endpoints.
> I saw that Olingo has a support for that ("org.apache.olingo.odata2.path.split" property).
> (didn't find any documentation for that "split" for OData version 4)
> https://olingo.apache.org/doc/odata2/tutorials/Olingo_Tutorial_Advanced_S...
> Maybe this feature is useful also for requests which are not OData Protocol requests(and not only for Spring actuator endpoints..)
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
7 years, 2 months