j.seyfriedxiiix.de

Hi, I've set up MySQL locally and created some reports running against it. Now this DB had to be migrated to a real server and became a MariaDB. Sending queries etc. works fine with other tools, but in my Jaspersoft Studio I'm not able to create a working connection to this DB. Here's what I configured: JDBC Driver: MySQL (com.mysql.jdbc.Driver)JDBC Url: jdbc:mysql://192.168.183.94/db01[/code]As driver I tried mariadb-java-client-2.5.3.jar and mysql-connector-java-8.0.16.jar What I receive as reponse: URL jdbc:mysql://192.168.183.94/db01 is invalid for driver org.hsqldb.jdbcDriverat com.jaspersoft.studio.data.DataAdapterEditorPart$1$1.runOperations(DataAdapterEditorPart.java:197) at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:51) at java.lang.Thread.run(Thread.java:748)[/code]Any help is appreciated!

Thanks Santhosh, I've tried it the way you suggested and I receive the following errors: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:1. de cannot be resolved to a variable value = de; //$JR_EXPR_ID=0$ <>2. de cannot be resolved to a variable value = de; //$JR_EXPR_ID=0$ <>3. de cannot be resolved to a variable value = de; //$JR_EXPR_ID=0$ <>3 errors. at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:206) at net.sf.jasperreports.eclipse.builder.JasperReportCompiler.compileReport(JasperReportCompiler.java:286) at com.jaspersoft.studio.editor.preview.view.control.ReportController.compileJasperDesign(ReportController.java:478) at com.jaspersoft.studio.editor.preview.view.control.ReportController.access$8(ReportController.java:463) at com.jaspersoft.studio.editor.preview.view.control.ReportController$1.run(ReportController.java:381) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:56)[/code]

Sorry, thats just a mistake in transcribing it here. I've tried it with $P{language} but instantly when adding this from the list of parameters it underlines this part red and explains when hovering over it "no viable alternative at input '$P{language}' "

I've got a datasource where the data is stored in tables with language prefixes and I'd like to let the user select the language as a parameter. I tried to handover the language prefix as a parameter in the FROM part of my SQL query, but Jasper Report won't execute that. Are there any other ways? Here's what I tried so far: SELECT * FROM $P(language) If it would be possible to join the parameter with a fix string that would be even greater: SELECT * FROM $P(language) + '_article_view_full'

I've got the same issue. Whats weird is, that the data preview works fine, but when generating the report then the error still returns.