JasperServer Oracle JDBC Error: "No suitable Driver for..."

[andreas.necker]

I'm trying to install the database for JasperServer 5.6.1 on Oracle (11.2). When I check my buildomatic default_master.properties with "js-install test" I get the "No suitable Driver for jdbc..." error.

 

----------------------------------------------------------------------

Running JasperReports Server install script at 2014-10-09_15-33

----------------------------------------------------------------------

WARNING: JAVA_HOME environment variable not found

[test]

Running pre-install-test-pro Ant task

----------------------------------------------------------------------

Buildfile: C:Jaspersoftjasperreports-server-5.6.1buildomaticbuild.xml

[echo] Filtering properties (cleaning out blank spaces)

[echo] creating C:/Jaspersoft/jasperreports-server-5.6.1/buildomatic/build_conf/default

[delete] Deleting directory C:Jaspersoftjasperreports-server-5.6.1buildomaticbuild_confdefault

[mkdir] Created dir: C:Jaspersoftjasperreports-server-5.6.1buildomaticbuild_confdefault

[copy] Copying 1 file to C:Jaspersoftjasperreports-server-5.6.1buildomaticbuild_confdefault

[copy] Copying 1 file to C:Jaspersoftjasperreports-server-5.6.1buildomaticbuild_confdefault

[copy] Copying 1 file to C:Jaspersoftjasperreports-server-5.6.1buildomaticbuild_confdefault

[copy] Copying 1 file to C:Jaspersoftjasperreports-server-5.6.1buildomaticbuild_confdefault

[echo] dbSidOrServiceName = :psp1

[echo] dbSidOrServiceNameProp = SID=psp1

[copy] Copying 1 file to C:Jaspersoftjasperreports-server-5.6.1buildomaticbuild_confdefault

[echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands

[copy] Copying 32 files to C:Jaspersoftjasperreports-server-5.6.1buildomaticbuild_confdefault

[copy] Copying 1 file to C:Jaspersoftjasperreports-server-5.6.1buildomaticbuild_confdefault

[copy] Copying 1 file to C:Jaspersoftjasperreports-server-5.6.1buildomaticbuild_confdefaultwebappWEB-INF

[echo] using settings file: C:/Jaspersoft/jasperreports-server-5.6.1/buildomatic/build_conf/default/maven_settings.xml

 

test-pro-all-props:

[echo] Checking properties:

[echo] dbType=oracle

[echo] dbHost=r1edlx0012

[echo] dbUsername=jasperserver

[echo] dbPassword=**********

[echo] dbPort=1521

[echo] js.dbName=jasperserver

[echo] sugarcrm.dbName=sugarcrm

[echo] foodmart.dbName=foodmart

[echo] webAppNamePro=jasperserver-pro

[echo] appServerType=skipAppServerCheck

[echo] appServerDir=C:Jaspersoftjasperreports-server-5.6.1/apache-tomcat

[echo] sysUsername=system

[echo] sysPassword=**********

[echo] sid=psp1

 

check-dbtype-pro:

 

test-appServerType-pro:

 

do-install-upgrade-test:

[echo] Checking DBMS host and port:

[echo] About to validate host: r1edlx0012

[echo] Host r1edlx0012 is OK

[echo] Done validating host: r1edlx0012

[echo] About to validate port: r1edlx0012:1521

[echo] Port 1521 is OK

[echo] Done validating port: r1edlx0012:1521

[echo] Validating administrative database connection at jdbc:tibcosoftware:oracle://r1edlx0012:1521;SID=psp1;SysLoginRole=SYSDBA;User=sys;Password=**********. Phase: [test]

[echo] For JDBC driver the artifactId and version properties are set:

[echo] maven.jdbc.artifactId=ojdbc6

[echo] maven.jdbc.version=11.2.0

[echo] Specified JDBC driver jar exists

[select-sql] Failed to connect: No suitable Driver for jdbc:tibcosoftware:oracle://r1edlx0012:1521;SID=psp1;SysLoginRole=SYSDBA;User=sys;Password=**********

[echo] Connection failed:

[echo] SQLState: ${errorSqlStateCodePropertyadminDBtestNoCheckDB}

[echo] Vendor specific error code: 0

[echo] Message: [No suitable Driver for jdbc:tibcosoftware:oracle://r1edlx0012:1521;SID=psp1;SysLoginRole=SYSDBA;User=sys;Password=********]

 

BUILD FAILED

C:Jaspersoftjasperreports-server-5.6.1buildomaticbinvalidation.xml:494: The following error occurred while executing this line:

C:Jaspersoftjasperreports-server-5.6.1buildomaticbinvalidation.xml:375: The following error occurred while executing this line:

C:Jaspersoftjasperreports-server-5.6.1buildomaticconf_sourcedboracledb.xml:161: The following error occurred while executing this line:

C:Jaspersoftjasperreports-server-5.6.1buildomaticconf_sourcedboracledb.xml:258: The following error occurred while executing this line:

C:Jaspersoftjasperreports-server-5.6.1buildomaticbinvalidation.xml:446: The following error occurred while executing this line:

C:Jaspersoftjasperreports-server-5.6.1buildomaticbinvalidation.xml:469: Generic connection failure: [No suitable Driver for jdbc:tibcosoftware:oracle://r1edlx0012:1521;SID=psp1;SysLoginRole=SYSDBA;User=sys;Password=**********]. Treating problem with JDBC connection as unrecoverable

 

Total time: 3 seconds

Checking Ant return code: OK

----------------------------------------------------------------------

 

The JDBC drivers are the standard drivers from Oracle TechNet.

What's the problem?

 

Regards

Andreas

 

 

[hozawa]

Encountered the same problem.

The problem is that Tibco Jaspersoft decided to bundle their own jdbc driver starting with 5.6.1. You'll need to change class and url to use that.

If you want to use Oracle's jdbc, you'll need to specify the jdbc information in default_master.properties.

If you ran a script once with the wrong setting, you'll need to delete "build_conf" folder.

[andreas.necker]

Do you have an example or document which describes this configuration changes for the Tibco and/or Oracle drivers.

[andreas.necker]

OK, it's working now. Started from scratch with the Tibco JDBC drivers.

Thank You.

[hozawa]

5.6.1 Installation guide explains the new drivers. Be aware that Tibco JDBC drivers are not 100% compatible from jdbc drivers from vendors.

[elizam]

We had to remove the vendor drivers from the install for licensing reasons.  TIBCO has a single uniform license for these other drivers, so we now include them. If you are used to the vendor driver, you should stick with that. 

By default, the buildomatic files now assume you are using the TIBCO JDBC drivers with default settings. If you are updating from a previous install, you can use the vendor's driver by copying it from your previous version to new or updated install and then use your old default_master.properties with the 5.6.1 build. 

If you are installing from scratch, you need to modify the install files to work with the vendor driver. Unfortunately, at the moment, you have to modify a couple of files to revert to the vendor's driver, not just the default_master.properties file. Again this is included in the install guide, including the location to place the driver (Section 6.4 - oracle is 6.4.2.2 Oracle Example).