Jump to: navigation, search

Java_Database_Connectivity

Also known as JDBC. A Java Application Programming Interface (API) that enables Java programs to execute SQL statements.



Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

If you use a Genesys computer-telephony integration (CTI) installation, you must install Advisors Genesys Adapter with CCAdv and WA applications. For Cisco installations, no adapter is required.

Deploying Advisors Cisco Adapter

You run a .jar installation file to deploy Advisors Cisco Adapter (ACA).

You can deploy ACA on a Red Hat Linux or a Windows platform, and with Oracle or MS SQL databases.

All database passwords used by the Cisco Adapter application are encrypted and saved in the ..GCTI\Advisors\CiscoConnector\conf\ cisco_adapter.properties file.

To change the password, see Change Encrypted Passwords.

Deployment Roadmap


  1. [+] Install the databases that correspond to the Advisors products you will deploy.
  2. Create the Advisors User and the Object Configuration User in Configuration Server. (Note that ACA itself does not require these users.)
  3. [+] Install the Platform service (Geronimo) on servers where it is required for Advisors components. (Note that ACA itself does not require Advisors Platform, but components that ACA serves require it.)
  4. Pma you-are-here-arrow.png Install each adapter you will use (AGA and ACA). See additional information for CCAdv/WA installations.
  5. Register the Stat Servers that you plan to use with Advisors.
  6. [+] Install the Advisors components for your enterprise.
  7. Make any required configuration changes.

<tabber>

Procedure=

Procedure: Deploying ACA


Steps

  1. Review the General Prerequisites and prerequisites specific to Advisors Cisco Adapter deployment before beginning deployment.
  2. Launch the installation file.
    [+] Show Step for Linux
    [+] Show Step for Windows
  3. Use the Next and Back buttons on the installer to navigate through the installation screens. Enter your information on each screen; see the Installer Screens tab on this page for additional information. Ensure you provide complete information on each screen.
  4. After installation is complete, click Show Details. Verify that there were no errors reported during installation.

|-| Installer Screens=

[+] Advisors Cisco Adapter Database Configuration
[+] Advisors Cisco Adapter Database Configuration - Advanced
[+] Cisco AWDB Database Configuration
[+] Cisco HDS Database Configuration
[+] Genesys Data Source - Configuration Server
[+] Genesys Data Source - Backup Configuration Server
[+] Installation details
[+] Java Development Kit
[+] Oracle JDBC Driver
[+] Platform Database Configuration
[+] Platform Database Configuration - Advanced
[+] RDBMS Type and JDBC Connectivity
[+] Register Adapter
[+] SCS Integration Configuration

|-| Multiple instances on a server=

It is possible to deploy multiple instances of Advisors Cisco Adapter on a single server. Multiple Cisco Adapters can be installed to provide metrics from separate HDS/AWDB source environments.

For each installation, you must create the database.

Deploy the second, and subsequent ACA instances, using the same procedure you use to deploy a single instance, and follow these rules:

  • You must install each Cisco Adapter instance in a different directory. For example, the first instance could use the following location:
    C:\Program Files\GCTI\Advisors\CiscoAdapter
    and the second instance could be located at:
    C:\Program Files\GCTI\Advisors\CiscoAdapter2.
  • You must specify a unique log directory and a unique data directory for each Cisco Adapter instance.
  • You must specify a unique port number for each Cisco Adapter instance.

|-| Troubleshooting=

The following Table shows parameter validation errors that you may encounter at the end of installation.

Installation Error Message Cause
[java] Failed to connect to the database using connection URL:

[java]
jdbc:sqlserver://192.168.xx.yy:nnn;DatabaseName=ys_cadb;user=sa;password=very_secure_pwd; selectMethod=cursor
[java] The following exception was thrown:
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 192.168.xx.yy, port nnn has failed. Error: "Connection refused. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.

Wrong database server name / IP address or port number
[java] Failed to connect to the database using connection URL:

[java]
jdbc:sqlserver://192.168.xx.yy:nnnn;DatabaseName=NotAPlatformDB;selectMethod=cursor;user=sa; password=very_secure_pwd
[java] The following exception was thrown:
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 192.168.xx.yy, port nnnn has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port."

Wrong database name
[java] Exception while connecting: Login failed for user 'badUserId'.

[java] url used:
jdbc:sqlserver://192.168.xx.yy:nnnn;DatabaseName=ys_cadb;selectMethod=cursor;user=badUserId; password=very_secure_password

Wrong database user name or password
[java] Exception in thread "main" java.security.InvalidParameterException: ERROR: Failed to verify validity of the JDK 1.6 located at /home/yevgeny/dev/java/j2sdk1.4.2_08.

[java] ERROR: Invalid JDK version found at /home/yevgeny/dev/java/j2sdk1.4.2_08, the version must be at least 1.6, but was 1.4
[java] at com.informiam.installer.jdk.JdkVersionChecker.checkJdk
(JdkVersionChecker.java:66)
[java] ERROR: Failed to verify validity of the JDK 1.6 located at /home/yevgeny/dev/java/j2sdk1.4.2_08.
[java] at com.informiam.installer.jdk.JdkVersionChecker.main
(JdkVersionChecker.java:81)

Wrong path to JDK or wrong version of the JDK specified.
Apr 11, 2011 3:53:46 PM oracle.jdbc.driver.OracleDriver registerMBeans

WARNING: Error while registering Oracle JDBC Diagnosability MBean.
java.security.AccessControlException: access denied (javax.management.MBeanTrustPermission register)
at java.security.AccessControlContext.checkPermission(Unknown Source)
at java.lang.SecurityManager.checkPermission(Unknown Source)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.checkMBeanTrustPermission(Unknown Source)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(Unknown Source)
at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(Unknown Source)
at oracle.jdbc.driver.OracleDriver.registerMBeans(OracleDriver.java:360)
at oracle.jdbc.driver.OracleDriver$1.run(OracleDriver.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.jdbc.driver.OracleDriver.<clinit>(OracleDriver.java:195)

Produced in error and can be ignored.

Displays in the Errors tab when installing Cisco Adapter with Oracle JDBC driver ojdbc6-11.2.0.2.0, and accurately reports that installation was successful.

Exception in thread "AWT-EventQueue-0" java.lang.ArrayIndexOutOfBoundsException: 32

at sun.font.FontDesignMetrics.charsWidth(Unknown Source)
at javax.swing.text.Utilities.getTabbedTextOffset(Unknown Source)
at javax.swing.text.Utilities.getTabbedTextOffset(Unknown Source)
at javax.swing.text.Utilities.getTabbedTextOffset(Unknown Source)
at javax.swing.text.PlainView.viewToModel(Unknown Source)
at javax.swing.text.FieldView.viewToModel(Unknown Source)
at javax.swing.plaf.basic.BasicTextUI$RootView.viewToModel(Unknown Source)
at javax.swing.plaf.basic.BasicTextUI.viewToModel(Unknown Source)

Produced in error and can be ignored.
[loadfile] Unable to load file: java.io.FileNotFoundException: C:\ (The system cannot find the path specified) Produced in error and can be ignored.
This page was last edited on August 24, 2018, at 13:48.
Comments or questions about this documentation? Contact us for support!