[
https://issues.apache.org/jira/browse/DBUTILS-125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14519564#comment-14519564
]
EMR commented on DBUTILS-125:
-----------------------------
So I ran a test. It seems to be something wrong with the 12.x driver. Since I
got no where putting the query into the application, I created the complex
query as a view on the server. I figured that this would at least work around
the problem. However, it seems like there are still problems with the 12.x
instant client... The driver version is in the paragraph/snippets. See my
testing below:
ojdbc6.jar:
DEBUG (JavaApplication33.java:91) - Got query runner:
org.apache.commons.dbutils.QueryRunner@114b6c2
JDBC driver version is >>>>> 11.2.0.2.0 <<<<<
DEBUG (JavaApplication33.java:104) - Exec Query
ERROR (JavaApplication33.java:110) - ORA-00904: "barcode": invalid identifier
Query: SELECT DISTINCT * FROM schema1.reader_vw WHERE user_id = ? OR barcode
= ? Parameters: [xx1, xx1]
DEBUG (JavaApplication33.java:91) - Got query runner:
org.apache.commons.dbutils.QueryRunner@1d016c9
JDBC driver version is >>>>> 12.1.0.2.0 <<<<<
DEBUG (JavaApplication33.java:104) - Exec Query
ERROR (JavaApplication33.java:110) - ORA-00942: table or view does not exist
Query: SELECT DISTINCT * FROM schema1.reader_vw WHERE user_id = ? OR barcode
= ? Parameters: [xx1, xx1]
##############################
ojdbc7.jar (7 not available for v11.x):
DEBUG (JavaApplication33.java:91) - Got query runner:
org.apache.commons.dbutils.QueryRunner@d1993a
JDBC driver version is >>>>> 12.1.0.2.0 <<<<<
DEBUG (JavaApplication33.java:104) - Exec Query
ERROR (JavaApplication33.java:110) - ORA-00942: table or view does not exist
Query: SELECT DISTINCT * FROM schema1.reader_vw WHERE user_id = ? OR barcode
= ? Parameters: [xx1, xx1]
##############################
After correcting the query, with ojdbc6:
DEBUG (JavaApplication33.java:89) - Got query runner:
org.apache.commons.dbutils.QueryRunner@114b6c2
JDBC driver version is >>>>> 11.2.0.2.0 <<<<<
DEBUG (JavaApplication33.java:102) - Exec Query
DEBUG (EPerson.java:47) - EPerson()
DEBUG (JavaApplication33.java:106) - xx1|IF88RAN|John
Smith|null|Medical|D1381072|Infrastructure|D138108F
DEBUG (JavaApplication33.java:89) - Got query runner:
org.apache.commons.dbutils.QueryRunner@1d016c9
JDBC driver version is >>>>> 12.1.0.2.0 <<<<<
DEBUG (JavaApplication33.java:102) - Exec Query
ERROR (JavaApplication33.java:108) - ORA-00942: table or view does not exist
Query: SELECT DISTINCT * FROM schema1.reader_vw WHERE user_id = ? OR
barcode_id = ? Parameters: [xx1, xx1]
> Using Oracle OJDBC7 gives ORA-00933
> -----------------------------------
>
> Key: DBUTILS-125
> URL: https://issues.apache.org/jira/browse/DBUTILS-125
> Project: Commons DbUtils
> Issue Type: Bug
> Affects Versions: 1.6
> Environment: JDBC driver version is 12.1.0.1.0
> Reporter: EMR
> Priority: Minor
>
> Attempting to run an sql query with the latest version of the drivers, it
> fails with ERROR (JavaApplication33.java:107) - ORA-00933: SQL command not
> properly ended.
> However, if I revert to the 11 version of the driver, the query works fine.
> Is there a setting that I am missing between the two versions?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
