Set property "net.sf.jasperreports.query.executer.factory.plsql" for the jasper report compiled JRAntCompileTask

[4epenaxep]

Hi.

I use JRAntCompileTask for compiling reports. To use plsql query language must be set property net.sf.jasperreports.query.executer.factory.plsql=com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory. I tryed to set this property in file srcmainresourcesjasperreports.properties but error has occurred:

 

Caused by: net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the 'plsql' language.

at net.sf.jasperreports.engine.util.JRQueryExecuterUtils.getExecuterFactory(JRQueryExecuterUtils.java:114)

at net.sf.jasperreports.engine.design.JRDesignDataset.queryLanguageChanged(JRDesignDataset.java:1180)

at net.sf.jasperreports.engine.design.JRDesignDataset.setQuery(JRDesignDataset.java:647)

 

What could be the problem?

 

Settings for JRAntCompileTask:

<plugin>

                <artifactId>maven-antrun-plugin</artifactId>

                <version>1.6</version>

                <executions>

                    <execution>

                        <phase>compile</phase>

                        <configuration>

                            <target>

                                <taskdef name="jrc" classname="net.sf.jasperreports.ant.JRAntCompileTask">

                                    <classpath refid="maven.compile.classpath" />

                                </taskdef>

 

                                <mkdir dir="${project.build.outputDirectory}" />

                                <mkdir dir="${project.basedir}/src/main/jasperreports" />

 

                                <jrc srcdir="${project.basedir}/src/main/jasperreports" destdir="${project.build.outputDirectory}" tempdir="${project.build.outputDirectory}" keepjava="false" xmlvalidation="true">

                                    <classpath refid="maven.compile.classpath" />

                                    <include name="**/*.jrxml" />

                                </jrc>

                            </target>

                        </configuration>

                        <goals>

                            <goal>run</goal>

                        </goals>

                    </execution>

                </executions>

                <dependencies>

                    <dependency>

                        <groupId>com.jaspersoft.jrx</groupId>

                        <artifactId>jasperreports-extensions</artifactId>

                        <version>3.5.3</version>

                        <scope>runtime</scope>

                    </dependency>

                    <dependency>

                        <groupId>javax.servlet</groupId>

                        <artifactId>servlet-api</artifactId>

                        <version>2.5</version>

                    </dependency>

                    <dependency>

                        <groupId>net.sf.jasperreports</groupId>

                        <artifactId>jasperreports</artifactId>

                        <version>${jasperreports.version}</version>

                    </dependency>

             </plugin>

 

[ghudson_1]

Is jasperreports-extensions-x.x.x.jar on the classpath?    If not, you can get it from <ireport>ireportmodulesext

[4epenaxep]

 jasperreports-extensions-3.5.3.jar located in the repository and added to dependencies

[amitgupta.mailto]

I am having the same problem. But looks like this thread is not closed with an answer.

Can someone help on this please.