[jira] Closed: (JUDDI-146) Hitting Oracle In Clause Limit Error during Find request

["Kurt T Stam (JIRA)" <ju...@ws.apache.org>]

     [ https://issues.apache.org/jira/browse/JUDDI-146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kurt T Stam closed JUDDI-146.
-----------------------------

    Resolution: Duplicate

Should get fixed as part of JUDDI-89

> Hitting Oracle In Clause Limit Error during Find request
> --------------------------------------------------------
>
>                 Key: JUDDI-146
>                 URL: https://issues.apache.org/jira/browse/JUDDI-146
>             Project: jUDDI
>          Issue Type: Bug
>    Affects Versions: 2.0rc5
>         Environment: Glassfish application server on JDK 1.5. Oracle 10g backend.
>            Reporter: Michael Pilone
>            Assignee: Kurt T Stam
>             Fix For: 2.0
>
>
> I'm using JUDDI in a project where we publish our application's internal taxonomies as TModels. I'm hitting a problem when I try to get some of our TModels back out of JUDDI using a find TModel operation. I've looked at the code and the problem is in the implementation of the FindTModelByNameQuery around line 76. The IN clause generated in this case has more than 1000 entries which is more than is allowed by Oracle. I've attached a stacktrace below.
> I'm using an maxRows value of 100 on my find request, but JUDDI doesn't apply this limit until after all the items have been found and loaded internally. I have the feeling from looking through the other Find functions that this is going to be a limit on everything in JUDDI, not just TModels.
> I would suggest that the in clause be broken down into reasonable chunks (100 - 500?) and then ORed together to avoid this problem in Oracle and other DBs. The other option would be to execute multiple independent queries with chunks of keys in the single IN clause.
> Logs:
> ERROR - java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
> ERROR - java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
> WARN - An Exception was encountered while attempting to close the Find TModel ResultSet: null
> java.lang.NullPointerException
> at org.apache.juddi.datastore.jdbc.FindTModelByNameQuery.select(FindTModelByNameQuery.java:94)
> at org.apache.juddi.datastore.jdbc.JDBCDataStore.findTModel(JDBCDataStore.java:1610)
> at org.apache.juddi.function.FindTModelFunction.execute(FindTModelFunction.java:165)
> at org.apache.juddi.registry.RegistryEngine.execute(RegistryEngine.java:234)
> at org.apache.juddi.registry.AbstractService.doPost(AbstractService.java:168)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
> at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:290)
> at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
> at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
> at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
> at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
> at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
> at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
> at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
> at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
> at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272)
> at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
> at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568)
> at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813)
> at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
> at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
> at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
> at com.sun.enterprise.web.portunif.PortUnificationPipeline$PUTask.doTask(PortUnificationPipeline.java:380)
> at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
> at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.