Skip to Content
0

SQL Anywhere Error -141: Table 'sysdatabases' not found

Apr 12 at 09:18 AM

13

avatar image
ANKITA SINHA

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.

SAP SQL Anywhere
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
Best Answer
avatar image
ANKITA SINHA Answered Apr 12 at 11:06 AM
0

I got the fix.

Data source Properties-> {click on your Database}->Options->Check the checkbox saying "Introspect using JDBC Metadata".

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users