Announcement Announcement Module
Collapse
No announcement yet.
Sybase compatiblity Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sybase compatiblity

    Hello,

    We are implementing a batching project using spring batch. We aim at making the application independent of the database type.

    While moving to version 2.0.0, I am facing an error when persisting to the context tables (BATCH_JOB_EXECUTION_CONTEXT in specific) on the sybase version 12.5. The class JdbcExecutionContextDao shows that when the field SERIALIZED_CONTEXT is set to null, it is set with type 2005 (Types.CLOB).

    Note that it worked fine on oracle.

    Is this intended or is it a misconfiguration?

    Thanks,
    Marwan

  • #2
    What type would you recommend?

    Comment


    • #3
      I am not a Sybase expert so I am not hundred percent sure, but there looks to be some kind of mapping that I found:
      http://java.sun.com/j2se/1.4.2/docs/...g.html#1053867

      The Sybase data type TEXT is mapped to LONGVARCHAR.

      Thanks,

      Comment


      • #4
        What is the error you are getting? Also, have you tried Sybase ASE 15?

        Comment


        • #5
          I am getting the following error:
          JZ006: IOException detected : java.io.IOException: JZ0SL: Type SQL Not Supported : 2005.
          We are obliged to be compatible with Sybase 12.5 as many clients use it. I am not sure that Sybase ASE 15 supports CLOB's.

          Thanks,
          Marwan

          Comment


          • #6
            I don't have Sybase 12.5 so it's hard to test against it. Do you know if this version is available for download anywhere?

            Comment


            • #7
              Sorry I don't think there is a free downloadable version for Sybase.
              I can help in testing if you think it is appropriate.
              Just one question, I understand from you that this Types.CLOB worked for Sybase 15?

              Comment


              • #8
                I found a link to a 12.5.1 download (http://download.sybase.com/eval/ase_...1dev_linux.tar), thanks to Google.

                I'm pretty sure I tested that code against Sybase 15, but I will verify this and will look for a solution for 12.5 once I get that version up and running.

                Comment


                • #9
                  Great to hear that.
                  Thanks a lot.

                  Comment


                  • #10
                    Hello,

                    Is there a JIRA issue for me to follow?

                    Thanks,
                    Marwan

                    Comment


                    • #11
                      Not that I know of. Feel free to create one.

                      Comment


                      • #12
                        Issue created: BATCH-1232

                        Thanks a lot,
                        Marwan

                        Comment

                        Working...
                        X