Apr 20th, 2009, 12:13 PM
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?
Apr 20th, 2009, 12:55 PM
What type would you recommend?
Apr 21st, 2009, 04:05 AM
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:
The Sybase data type TEXT is mapped to LONGVARCHAR.
Apr 21st, 2009, 08:01 AM
What is the error you are getting? Also, have you tried Sybase ASE 15?
Apr 21st, 2009, 09:18 AM
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.
Apr 22nd, 2009, 09:05 PM
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?
Apr 23rd, 2009, 03:39 AM
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?
Apr 27th, 2009, 12:00 PM
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.
Apr 27th, 2009, 12:04 PM
Great to hear that.
Thanks a lot.
May 4th, 2009, 09:19 AM
Is there a JIRA issue for me to follow?