Sybase SQL Scanning: Failed to Read error

Products

• Data Loss Prevention Network Discover

Issue/Introduction

Performing SQL Discover scan results in the error

Failed to read
sybase://TARGET:41/sb_error_db|sb_monitor_disburse_work; error: Unable
to extract the data from table: sb_monitor_disburse_work:
java.sql.SQLException: Incorrect syntax near ';'.

Resolution

Replacing the Sybase default setting for driver_row_selector with the SQL SERVER default within sqldatabasecrawler.properties resolves this issue:

# Sybase
driver_class.sybase =  net.sourceforge.jtds.jdbc.Driver
driver_subprotocol.sybase = jtds:sybase
driver_table_query.sybase = SELECT * FROM sysobjects WHERE type='U'
# driver_row_selector.sybase = set rowcount {2.EN_US};select {1.EN_US} from {0.EN_US};set
rowcount 0
driver_row_selector.sybase = SELECT TOP {2.EN_US} {1.EN_US}  FROM {0.EN_US}
driver_jar.sybase = jtds-1.2.2.jar
quote_table_names.sybase = true