[teiid-issues] [JBoss JIRA] (TEIID-2906) bind variables and sql appear when exception thrown
Hisanobu Okuda (JIRA)
issues at jboss.org
Thu Mar 27 08:28:12 EDT 2014
[ https://issues.jboss.org/browse/TEIID-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12956975#comment-12956975 ]
Hisanobu Okuda commented on TEIID-2906:
---------------------------------------
The customers are upset and displaying anger to us. We in Japan need to keep it as a bug to calm down them. Also they believe that the issue will be fixed sooner if it is filed as a bug than an enhancement. I'm asking you not in the point of view of technical aspect, but business matter. At least, for the customer, the current behavior is unexpected.
I will attach the customer comment (originally in Japanese, translated in English)
------------------------------------------------------------------------------------------
1 . For specific details of the business impact will get back to you .
As long as it is not subjected to this modification , we will not be able to release the system.
Detailed number, such as the construction period and corresponding content in the application is unknown at this time .
I am sorry.
However , you have to tell that there is a risk of cutover postponed ,
For projects that are built into the medium-term plan of the customer , there is no option of release postponed.
( Cutover is September 2014 )
That is, for us , it is an issue that must be resolved within six months at the latest, no matter what .
If you can not resolve the issue, you RH and we need to describe the situation to the customer, even those that return forced to contract money ,
It is neither exaggerated nor a joke .
Thank you for your understanding .
2 . Support will be available for you are expecting
We will request a resolution of up to 2014 the end of June .
To enter into a process that is for release since August 2014 ,
By the end of July , you need to solve this problem , and to implement the no-effect confirmation .
Therefore there is the need to have you presented by RH 's a solution in June .
------------------------------------------------------------------------------------------
Now the customers are objecting to the values only, however, I think potentially SQL would be also what they will be objecting.
> bind variables and sql appear when exception thrown
> ---------------------------------------------------
>
> Key: TEIID-2906
> URL: https://issues.jboss.org/browse/TEIID-2906
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.4
> Environment: - JDV 6.0.0
> Reporter: Hisanobu Okuda
> Assignee: Steven Hawkins
> Attachments: PreparedStatementTest.java, test.vdb
>
>
> When a query causes an exception, bind variables and sql are written in teiid-command.log and are sent to a client.
> teiid-command.log:-
> {code}
> 19:36:19,942 WARN [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue29) TEIID30020 Processing exception for request 6jFRdyvDG5bU.0
> 'TEIID30504 New_MySQL: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAM
> E`, g_0.`PASSWORD`, g_0.`USERROLE` FROM `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]'. Originally TeiidProcessingException 'Can
> not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.' MysqlIO.java:3039.
> Enable more detailed logging to see the entire stacktrace.
> {code}
> printStackTrace() at client side:-
> {code}
> org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 New_MySQL: 0 TEIID11008:TEI
> ID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAME`, g_0.`PASSWORD`, g_0.`USERROLE` FROM
> `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
> {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
More information about the teiid-issues
mailing list