Error using varchar (max) column when using net.sourceforge.jtds.jdbc.Driver

Question

I have an MS SQL database (MS SQL 2005) and connect to it through net.sourceforge.jtds.jdbc.Driver.

The query works fine for all columns except one, which is varchar (max). Any ideas how to get around these problems?

I am using the jdbc driver to run the data index into the SOLR implementation.

(I do not manage the database, so the first prize decision will be that I can configure the SQL command to get the desired results)

thank

Answer 1

, . SQL- useLobs = false. , , .

<dataSource
    driver="net.sourceforge.jtds.jdbc.Driver"
        url="jdbc:jtds:sqlserver://server/database;useLOBs=false" 
    user="user" 
    password="password" />

Answer 2

MS SQL 2K3. UseLOBs = false , SELECT CAST(Name AS varchar(255))'Name' .