I created two datasources... one set of reports use the first data source with data from the databse called buylist. The second datasource (mariadb on the same server) is to use data from another database titled 'data.'
The Datasouce urls are:
jdbc:mariadb://192.168.1.52/buylist
However when I try to run a report using the second datasource it seems to combine the names of the databases and tries to pull data from the first database (buylist) giving an error that the table does not exist..
(the table is CLIENTS and is in the database data, so it should be data.CLIENTS)
I don't understand what is happening here...
I created two datasources... one set of reports use the first data source with data from the databse called buylist. The second datasource (mariadb on the same server) is to use data from another database titled 'data.'
The Datasouce urls are:
jdbc:mariadb://192.168.1.52/buylist
and
jdbc:mariadb://192.168.1.52/data?allowMultiQueries=true
However when I try to run a report using the second datasource it seems to combine the names of the databases and tries to pull data from the first database (buylist) giving an error that the table does not exist..
(the table is CLIENTS and is in the database data, so it should be data.CLIENTS)
java.sql.SQLSyntaxErrorException: (conn=28222) Table 'data.BUYLIST' doesn't exist
Last edit: Gary Vassalotti 2024-06-21