I am having problems with returning results of SMALLINT from a Sybase ASE 12.5.1 server. The test simply called sp_who which displays a table of users on the system. This table contains several SMALLINT columns which aren't binding correctly and cause an exception being thrown.
Apparently the types.properties override bindings for SMALLINT and NUMERIC are incorrect when using JConnect 5.5 or TDS 0.9 as the JDBC driver to a Sybase ASE 12.5.1 system.
After further investigation, I discovered that JConnect 5.5 uses a server name of sybase_sql_server and jTDS 0.9 uses sql_server.
It would be great if the types.properties file overrides for sybase_sql_server and sql_server where added along with the usual adaptive_server_enterprise overrides.
I am having problems with returning results of SMALLINT from a Sybase ASE 12.5.1 server. The test simply called sp_who which displays a table of users on the system. This table contains several SMALLINT columns which aren't binding correctly and cause an exception being thrown.
Apparently the types.properties override bindings for SMALLINT and NUMERIC are incorrect when using JConnect 5.5 or TDS 0.9 as the JDBC driver to a Sybase ASE 12.5.1 system.
After further investigation, I discovered that JConnect 5.5 uses a server name of sybase_sql_server and jTDS 0.9 uses sql_server.
It would be great if the types.properties file overrides for sybase_sql_server and sql_server where added along with the usual adaptive_server_enterprise overrides.
Something like the following:
##############################################################################
# Sybase ASE (sybase_sql_server - JConnect 5.5)
##############################################################################
sybase_sql_server.NUMERIC.class = net.sourceforge.sqlunit.types.BigDecimalType
sybase_sql_server.NUMERIC.type = 2
sybase_sql_server.SMALLINT.class = net.sourceforge.sqlunit.types.IntegerType
sybase_sql_server.SMALLINT.type = 5
##############################################################################
# Sybase ASE (sql_server - jTDS 0.9)
##############################################################################
sql_server.NUMERIC.class = net.sourceforge.sqlunit.types.BigDecimalType
sql_server.NUMERIC.type = 2
sql_server.SMALLINT.class = net.sourceforge.sqlunit.types.IntegerType
sql_server.SMALLINT.type = 5
Hi Mark,
Thanks for the update. I just checked in the types.properties to CVS for jTDS 0.9 and JConnect 5.5.
-sujit