View Issue Details

IDProjectCategoryView StatusLast Update
0006552SymmetricDSBugpublic2024-08-14 12:00
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.7 
Target Version3.15.8Fixed in Version3.15.8 
Summary0006552: SQL Anywhere fails to call DatabaseMetaData.getSchemas()
DescriptionSQL Anywhere fails to call DatabaseMetaData.getSchemas(), which returns a result set, and the resultset.next() throws an exception with the following error message:

com.sybase.jdbc4.jdbc.SybSQLException: SQL Anywhere Error -1119: The 'FileVersion' property is no longer supported

This occurs for version 11 of SQL Anywhere, without a patch called EBF:

    ================(Build 0002528 - Engineering Case #649475)================

    If a JDBC application connected via jConnect called the method DatabaseMetaData.getSchemas(),
    then the server would have failed the request with the error "the 'FileVersion'
    property is no longer supported". This problem has now been fixed and
    the proper list of userids is now returned to the application.

https://sqlanywhere-forum.sap.com/upfiles/SQL_Anywhere_Bug_Fix_Readme_for_Version_11.0.1,_build_3158.htm
Steps To ReproduceStart up SymmetricDS against a SQL Anywhere version 11 without EBF with case # 649475
Additional InformationWorkaround is to use sp_tables:

select distinct table_owner as TABLE_SCHEM, table_qualifier as TABLE_CATALOG from sp_tables();
Tagsdialect: sql anywhere

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 381b4d87

2024-08-14 11:49:06

pmarzullo

Details Diff
0006552: SQL Anywhere fails to call DatabaseMetaData.getSchemas() Affected Issues
0006552
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/sqlanywhere/SqlAnywhereDdlReader.java Diff File

Issue History

Date Modified Username Field Change
2024-08-09 19:19 pmarzullo New Issue
2024-08-09 19:19 pmarzullo Status new => assigned
2024-08-09 19:19 pmarzullo Assigned To => pmarzullo
2024-08-09 19:19 pmarzullo Tag Attached: dialect: sql anywhere
2024-08-14 11:48 pmarzullo Project SymmetricDS Pro => SymmetricDS
2024-08-14 11:49 pmarzullo Status assigned => resolved
2024-08-14 11:49 pmarzullo Resolution open => fixed
2024-08-14 11:49 pmarzullo Fixed in Version => 3.15.8
2024-08-14 12:00 pmarzullo Changeset attached => SymmetricDS 3.15 381b4d87
2024-08-16 17:45 admin Status resolved => closed