I changed this to use Sybase’s specific unitext type, which is their renaming of the T-SQL ntext type.

Unfortunately this test still fails because we try to create a NClob from the Connection for the s.getLobHelper().createNClob( ... ) call. jConnect does not implement that method (or maybe only in case of ENABLE_LOB_LOCATORS, not really sure).

That comes about because we assume that if the driver implements one, it implements them all - makes sense, right? Well unfortunately, the jConnect driver does implement Connection#createBlob and Connection#createClob; it just does not implement Connection#createNClob oddly.

I’m just going to skip this test for Sybase. The use case here would be someone mapping a long (n)varchar as a (N)Clob in their Java model. No one is doing that. And if they are doing that on Sybase, I think we just say that is not supported (though it would be interesting to try with ENABLE_LOB_LOCATORS enabled).