New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
connection.getMetaData() called every time on executing a SELECT query on Oracle #453
Comments
Hey @wpc, what version are you using - does the same happen from master / 1.3.0.rc1 ? |
esp. caseConvertIdentifierForJdbc/Rails to accept a connection (see jruby#453)
Oracle seems to be doing some SQL on getMetaData ... this seems to improve performance singnificantly: test run times : before: 185-190s / 180 PS after: 130-150s / 125 PS
this is quite surprising but true - we can avoid |
esp. caseConvertIdentifierForJdbc/Rails to accept a connection (see jruby#453)
Thank you very much for fixing this problem. We will upgrade and have a try. |
Hi, I face the exact same problem in my java application. Do you know whether this fix is available in jdbc driver(ojdbc.jar)? If yes, which version? Thanks in advance for the help. |
HI, guys
We are working on a Rails application with Oracle 11g with JDBC adapter. In our production environment we found every time we execute a select SQL there is another SQL fire up for collecting meta data from database. This is running slow in our oracle server and occupying resources.
The SQL looks like following:
The JDBC driver we are using is the latest ojdc6.jar
Thanks
The text was updated successfully, but these errors were encountered: