Re: cmake error when using xdevapi

[Luis Silva]

Hi!

There are two different APIs for connector cpp.
JDBC, provided by this package: libmysqlcppconn9_8.0.31-1ubuntu22.04_amd64.deb
And XAPI provided by this package libmysqlcppconn8-2_8.0.31-1ubuntu22.04_amd64.deb

When you install the dev package, it will require both.

The issue is that you are linking to the wrong lib.

target_link_libraries(MySQL PUBLIC Config mysqlcppconn)

should be

target_link_libraries(MySQL PUBLIC Config mysqlcppconn8)

as you can check on the libraries dir:
/usr/lib/x86_64-linux-gnu/libmysqlcppconn.so.9.8.0.31
/usr/lib/x86_64-linux-gnu/libmysqlcppconn.so.9
/usr/lib/x86_64-linux-gnu/libmysqlcppconn8.so.2.8.0.31
/usr/lib/x86_64-linux-gnu/libmysqlcppconn8.so.2
/usr/lib/x86_64-linux-gnu/libmysqlcppconn-static.a
/usr/lib/x86_64-linux-gnu/libmysqlcppconn8-static.a
/usr/lib/x86_64-linux-gnu/libmysqlcppconn.so
/usr/lib/x86_64-linux-gnu/libmysqlcppconn8.so

So, JDBC = libmysqlcppconn.so
XAPI = libmysqlcppconn8.so

Luís