[jira] [Commented] (DBUTILS-117) Error in control the use of ParameterMetaData

["Christoph Brücke (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DBUTILS-117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14063563#comment-14063563 ] 

Christoph Brücke commented on DBUTILS-117:
------------------------------------------

I've had the same issue, when using Oracle DB 12 and DbUtils 1.5/1.6-SNAPSHOT (see attached stacktrace).

{noformat}
java.sql.SQLSyntaxErrorException: ORA-00904: "A"."TABLE_NAME": invalid identifier

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:461)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:394)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:386)
	at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1039)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:681)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:256)
	at oracle.jdbc.driver.T4C8Odscrarr.doODNY(T4C8Odscrarr.java:93)
	at oracle.jdbc.driver.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:958)
	at oracle.jdbc.driver.OracleStatement.describe(OracleStatement.java:7290)
	at oracle.jdbc.driver.OracleResultSetMetaData.<init>(OracleResultSetMetaData.java:58)
	at oracle.jdbc.driver.OracleStatement.getResultSetMetaData(OracleStatement.java:7243)
	at oracle.jdbc.driver.OraclePreparedStatement.getMetaData(OraclePreparedStatement.java:5718)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.getMetaData(OraclePreparedStatementWrapper.java:5291)
	at oracle.jdbc.driver.OracleParameterMetaData.getParameterMetaData(OracleParameterMetaData.java:76)
	at oracle.jdbc.driver.OraclePreparedStatement.getParameterMetaData(OraclePreparedStatement.java:18509)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.getParameterMetaData(OraclePreparedStatementWrapper.java:5449)
	at org.apache.commons.dbutils.AbstractQueryRunner.fillStatement(AbstractQueryRunner.java:222)
{noformat}

As a change I have wrapped call to {{ParameterMetaData.getParameterCount()}} in a try-catch-block and set {{pmdKnownBroken}} to {{true}}.

Please let me know if anythings needs to be changed.

> Error in control the use of ParameterMetaData
> ---------------------------------------------
>
>                 Key: DBUTILS-117
>                 URL: https://issues.apache.org/jira/browse/DBUTILS-117
>             Project: Commons DbUtils
>          Issue Type: Bug
>    Affects Versions: 1.5
>            Reporter: Vadim Smirnov
>            Priority: Minor
>              Labels: easyfix, newbie
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> Error in fillStatement method of AbstractQueryRunner class.
> There is no try...catch statement near pmd = stmt.getParameterMetaData();
> So method fails instead of automaticallye turning pmdKnownBroken to true.



--
This message was sent by Atlassian JIRA
(v6.2#6252)