[
https://issues.apache.org/jira/browse/DBUTILS-125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14521366#comment-14521366
]
EMR commented on DBUTILS-125:
-----------------------------
Some background on troubleshooting i've done:
I am accessing a view and/or tables as other schemas (users). My intended
account is read-only, but I have used other accounts in troubleshooting.
The url is of the format:
"jdbc:oracle:thin:@mydbserver.example.com:1521/MYTNSDB"
I am doing a ds.setUser() and ds.setPassword()
I have changed my username to the same user/schema as the table... to no avail.
I have added the username before the "@" to no avail.
I have made sure that the views and tables are accessible via SQLDeveloper
(from Oracle) from both users. Notably, they use the v11 driver for their app.
I will be testing later today with dropping in the v12 driver in the app itself
to see (confirm) dbutils issue or native java issue.
The original query used COALESCE() which gave the ORA-00933, but now, since I
created the view on the server (using the exact same query, so there's nothing
wrong with it) I am doing a "select distinct *" which is giving the ORA-00942
(table or view does not exist). Note that, as noted previously, using the
native JDBC calls work fine, and data is returned as expected.
All of this works with the v11 drivers, but not the v12 drivers.
> 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)
