Jump to content
Changes to the Jaspersoft community edition download ×

ERROR No suitable driver found for java.sql.DriverManager.getConnection (Oracle)


julia.bustos

Recommended Posts

Hi all!

I'm doing a report with two connections. In the main, I use a JSON, for the subreport the following parameter:

<parameter name="SUBREPORT_CONNECTION" class="java.sql.Connection" isForPrompting="false">

        <defaultValueExpression><![CDATA[java.sql.DriverManager.getConnection("jdbc:oracle:thin:@IP:PORT/DB","USER","PASS")]]></defaultValueExpression>

</parameter>

<subreport>

                <reportElement x="0" y="10" width="595" height="200" uuid="693d33ec-8ad9-4e8f-bab9-0339d80b8d94"/>

                <connectionExpression><![CDATA[$P{SUBREPORT_CONNECTION}]]></connectionExpression>

                <subreportExpression><![CDATA["name.jasper"]]></subreportExpression>

</subreport>

The problem is that I get the error  Error evaluating expression for java.sql.DriverManager.getConnection("jdbc:oracle:thin.....)

Caused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@10.120.34.140:1521/TESTEKIP

The classpath is declared (tested with the ojdbc8 and ojdbc6 drivers in the plugins folder)

HELP!

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...