数据库版本: sql Server2012
已成功并建立数据源.
问题:
建立数据集过程中, 如果引用有字段类型为bigint的任何表, 点击刷新数据会报错(貌似转换为numeric后溢出), 我尝试把该int类型更换为字符后依然无效:
SQL执行失败，请检查表、字段、关联关系等信息是否正确并重新编辑。exception while executing query: com.microsoft.sqlserver.jdbc.SQLServerException: An error occurred during the current command (Done status 0). Arithmetic overflow error converting bigint to data type numeric. [An error occurred during the current command (Done status 0). Arithmetic overflow error converting bigint to data type numeric.]
而添加其他表(主键中给不含bigint类型)的表则能成功读取.求各路大佬指点.