Step 7: Checking EBICS Server database parameters (JBoss)

The database configuration parameters were set during installation. Review and change these parameters if necessary.

MySQL

  1. Using a text editor, open the file:
  2. <EBICS Server installation directory>/JBossServer/server/bankrechner/deploy/bankrechner-ds.xml
  3. By default, the database access configuration in this file is:
  4. <connection-url>jdbc:mysql://localhost/bankingserver</connection-url>

    <driver-class>com.mysql.jdbc.Driver</driver-class>
  5. This default configuration uses port 3306.
  6. You can reset the host and port values using a syntax similar to the following example:
  7. <connection-url>jdbc:mysql://MyRemoteHost:65000/bankingserver</connection-url><driver-class>com.mysql.jdbc.Driver</driver-class>
  8. You can change the Database User and related password inside this file by modifying the tags <user-name>bankrechner</user-name> <password>bankrechner</password>
  9. <user-name>bankrechner</user-name> <password>bankrechner</password>

Oracle

  1. Using a text editor, open the file:
  2. <EBICS Server installation directory>/JBossServer/server/bankrechner/deploy/bankrechner-ds.xml
  3. By default, the database access configuration in this file is:
  4. <connection-url>jdbc:oracle:thin:@localhost:1521:BANKINGSERVER</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  5. This default configuration uses port 3306.
  6. The Oracle URL is:
  7. <connection-url>jdbc:oracle:thin:@localhost:1521:BASE</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  8. You can change the Database User and related password inside this file by modifying the tags <user-name>bankrechner</user-name> <password>bankrechner</password>
  9. <user-name>bankrechner</user-name> <password>bankrechner</password>
  10. Open the file bankrechner.ear!bankrechner.jar!META-INF/persistence.xml, locate the hibernate.dialect tag. It contains the value:
    de.businesslogics.persistence.hibernate.MyOracle10gDialect

Related topics

Installing EBICS Server on JBoss: general implementation procedure