andreas.necker

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

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

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