Sybase compatiblity

[marwan simaan]

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

[Dave Syer]

What type would you recommend?

[marwan simaan]

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,

[trisberg]

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

[marwan simaan]

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

[trisberg]

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?

[marwan simaan]

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?

[trisberg]

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.

[marwan simaan]

Great to hear that.
Thanks a lot.

[marwan simaan]

Hello,

Is there a JIRA issue for me to follow?

Thanks,
Marwan