All Products
Search

This Product

    AnalyticDB:FineReport 10.0

    Document Center

    AnalyticDB:FineReport 10.0

    Last Updated:Jun 21, 2026

    This document presents the compatibility test results for FineReport 10.0 with AnalyticDB for MySQL, covering connectivity, table listing, and table data query.

    Test environment

    The official website for FineReport 10.0 is FineReport 10.0.

    Test scope

    • Connecting to FineReport 10.0: In FineReport Designer, open the define data connection dialog box and create a new connection named JDBC2. Select MySQL as the database, set the driver to com.mysql.jdbc.Driver, and the URL to jdbc:mysql://localhost:3303. Click test connection. A message confirms a successful connection.
    • Listing databases: The preview shows the current instance contains three databases: MYSQL, INFORMATION_SCHEMA, and test4dmp.
    • Listing tables: The Preview dialog box lists all 17 tables in the current database.
    • Viewing table schema: The Preview dialog box shows the CREATE TABLE statement (the result of the SHOW CREATE TABLE command) for the student table. This table has three columns: id (bigint), name (varchar), and unit (int).
    • Viewing table data: The Preview dialog box shows a table with three columns: id (bigint), name (varchar), and unit (int). It contains one record (id=1, name=sa, unit=1). The preview is limited to a maximum of 200 rows.
    • Viewing views: The Preview dialog box shows details for the student_view view, including its creation statement (CREATE VIEW test4dmp.student_view AS S...), character set (utf8), and collation (utf8_general_ci). A preview of the view's data shows 1 row, with a maximum limit of 200 rows.