Skip to Content
avatar image
Former Member

How to connect xMII 11.5 and MaxDB?

Hi All,

Someone know how to connect xMII 11.5 and MaxDB (7.6 or 7.7)?

Thanks in advance,

Vinicius Martins

Axia Consulting

São Paulo - Brasil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Apr 11, 2008 at 02:25 PM

    Hi.

    I have tried it with xMII version 12, and the only difference should be the way to install the jar file,

    I guess the file should be located at C:\ServletExecAS\<Instance Name>\webapps\default\Lighthammer\WEB-INF\lib, and the servlet should be restarted.

    First I found this file, sapdbc.jar, within the MaxDB directories, install this as described above.

    The connection should be as follows.

    Connector IDBC

    ConnectorID

    ConnectorType SQL

    DatePrefix '

    DateSuffix '

    DaysRetention 7

    Description ---

    Enabled T

    InitCommand

    InternalDateFormat yyyy-MM-dd HH:mm:ss

    JDBCDriver com.sap.dbtech.jdbc.DriverSapDB

    MaxRetryCount 5

    Name PS_MaxDB

    PoolMax 100

    PoolSize 1

    RetryInterval 60000

    ServerPackage com.sap.xmii.Illuminator.connectors.IDBC

    ServerURL jdbc:sapdb://localhost/DI1?timeout=0

    Timeout 15

    UseCount 256

    UserName SAPDI1DB

    ValidationQuery SELECT count(*) from XMII_LANGUAGES

    WaitTime 30

    BR.

    Poul.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2008 at 07:01 PM

    Please validate this and alter if necessary

    ValidationQuery SELECT count(*) from XMII_LANGUAGES

    The query needs to be correct, this might only work for xMII version 12.

    BR

    Poul.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 08:14 PM

    Hi,

    I have success with this connection:

    Name Value

    Connector IDBC

    ConnectorType SQL

    DatePrefix '

    DateSuffix '

    Description SAP MaxDB 7.6

    Enabled true

    InitCommand

    InternalDateFormat yyyy-MM-dd HH:mm:ss

    JDBCDriver com.sap.dbtech.jdbc.DriverSapDB

    Name MaxDB

    PoolMax 100

    PoolSize 1

    ServerPackage com.lighthammer.Illuminator.connectors.IDBC

    ServerURL jdbc:sapdb://localhost/MAXDB1?timeout=0

    Timeout 15

    UseCount 256

    UserName dbadmin

    ValidationQuery

    WaitTime 30

    Bye!

    Vinicius

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 08:15 PM

    I found some information in the MySQL website to guide me!

    Add comment
    10|10000 characters needed characters exceeded