Peter Ruzicka - 2018-06-07

Hi,

I have MS SQL DB 2012 with huge select query from hibernate (took from server log). If I call this query from e.g. Squirel client (the same jdbc) or MS Studio - I am getting results OK.

When I call it from application on JBOSS EAP 6 with the same jtds 1.2.7 driver - I get error:

java.sql.SQLException: Cannot create a row of size 8243 which is greater than the allowable maximum row size of 8060.

But this error should not exist on SQL Server 2012 anymore as I understood.

Could you help me please?

                <datasource jta="true" jndi-name="java:jboss/datasources/test" pool-name="test_t" enabled="true" use-ccm="false">
                    <connection-url>jdbc:jtds:sqlserver://IP/xxx_production</connection-url>
                    <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
                    <driver>jtds-1.2.7.jar</driver>
                    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                    <security>
                        <user-name>xxx_production</user-name>
                        <password>pass</password>
                    </security>
                    <validation>
                        <validate-on-match>false</validate-on-match>
                        <background-validation>false</background-validation>
                    </validation>
                    <statement>
                        <share-prepared-statements>false</share-prepared-statements>
                    </statement>
                </datasource>