commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "EMR (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DBUTILS-125) Using Oracle OJDBC7 gives ORA-00933
Date Wed, 29 Apr 2015 15:33:06 GMT

    [ 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)

Mime
View raw message