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

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

Thank You.

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

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

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

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