Gotchas with Sybase
1. Getting error 'JZ0SM: Unsupported SQL type 0'
I've not seen Sybase require this, but DB2 needs the type for null
values. In general it's a good idea for portability. MySQL is a
little loose with what it accepts, for better or worse.
2. If you are using jconn3. driver, ensure you set the sybase jdbc url with
&DYNAMIC_PREPARE=true
Without this jdbc query may silently fail even with precision errors.
More http://old.nabble.com/ibatis---Sybase-String-problem-td22554502.html
1. Getting error 'JZ0SM: Unsupported SQL type 0'
I've not seen Sybase require this, but DB2 needs the type for null
values. In general it's a good idea for portability. MySQL is a
little loose with what it accepts, for better or worse.
2. If you are using jconn3. driver, ensure you set the sybase jdbc url with
&DYNAMIC_PREPARE=true
Without this jdbc query may silently fail even with precision errors.
More http://old.nabble.com/ibatis---Sybase-String-problem-td22554502.html
