I am trying to connect to a Sybase IQ database using JPA with Spring Boot. The connection is successful, but when tried to synchronize the database, the following error is appearing.
[42W33][2706] SQL Anywhere Error -141: Table 'sysdatabases' not found. SQL Anywhere Error -141: Table 'sysdatabases' not found.
Please not: I am using JConnect4 driver. Also, I am able to read the data using select queries from the IDE db console, but the schemas and all are not recognized by the JPA tool.
I got the fix.
Data source Properties-> {click on your Database}->Options->Check the checkbox saying "Introspect using JDBC Metadata".