3 Replies Latest reply on Mar 16, 2010 12:34 AM by kimda

    Handling clob column type

    kimda

      Hi,


      I am working jboss seam project that was initially created by jboss seam and I changed column type varchar2 to clob in order to take enough user input. Now, I changed data type Clob instead of String, but I am having trouble when I retrieve data and update data.
      Are there any references for this type of data type?


      thx,
      Daniel

        • 1. Re: Handling clob column type
          kimda
          Ok, I created a table with clob data type and execute "seam generate" command. It worked ok with around 1000 char, but if I enter more than 1000 char, I get the following error.

          ERROR [JDBCExceptionReporter] operation not allowed: streams type cannot be used in batching

          ++++++++++++++++++++++++++++++++++++++++++
          ,
               @NotEmpty
               @Lob
               private String content;


          /**
                * @return the content
                */
               public String getContent() {
                    return content;
               }

               /**
                * @param content the content to set
                */
               public void setContent(String content) {
                    this.content = content;
               }
          '

          • 2. Re: Handling clob column type
            kukeltje.ronald.jbpm.org
            http://www.google.com/search?q=ERROR+[JDBCExceptionReporter]+operation+not+allowed%3A+streams+type+cannot+be+used+in+batching&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:nl:official
            • 3. Re: Handling clob column type
              kimda

              I already googled, but couldn't find solution. someone solved by the latest oracle driver. (I am using the latest oracle driver - ojdbc14.jar)