How to connect xMII 11.5 and MaxDB?

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

Poul, thanks for your help.

I implemented your suggestion, but the status is red. Follow my summary:

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/xmii?timeout=0

Timeout 15

UseCount 256

UserName admin

ValidationQuery SELECT count(*) from XMII_LANGUAGES

WaitTime 30

Do you have any light?

Vinicius

[salvatore_castro]

Vinicius,

If the database is unicode then you have to add the following parameter to the ServerURL:

Unicode=true

Hope this helps.

Sam

[Former Member]

If you look in the xMII log, you'll get a detailed error as to why xMII is unable to connect to the database.

[Former Member]

Hi Rick,

I read my log and found nothing about the SAP DP connection problem, only a reference about the JCO server error:

2008-05-26 13:54:31,617 [JCO.ServerThread-1] ERROR  SERVER-EXCEPTION - [null,null,null,] com.sap.mw.jco.JCO$Exception: (129) JCO_ERROR_SERVER_STARTUP: Server startup failed at Mon May 26 13:54:31 BRT 2008.
This is caused by either a) erroneous server settings, b) the backend system has been shutdown, c) network problems. Will try next startup in 512 seconds.
Missing -a<Program ID>
2008-05-26 13:58:42,999 [ServletExec: request: time=1211821122929, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM Connector - Disabling server MaxDB
2008-05-26 13:58:42,999 [ServletExec: request: time=1211821122929, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM ConnectionPool - Destroy Connection pool [jdbc:sapdb://localhost/xmii?timeout=0]:

2008-05-26 13:58:42,999 [ServletExec: request: time=1211821122929, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM Connector - Enabling server MaxDB
2008-05-26 13:58:43,089 [ServletExec: request: time=1211821122929, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM ConnectionPool - Created Connection pool [jdbc:sapdb://localhost/xmii?timeout=0]:

2008-05-26 13:58:43,089 [ServletExec: request: time=1211821122929, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM Connector - Create Server [name=MaxDB,className=com.lighthammer.Illuminator.connectors.IDBC.IDBC,description=SAP MaxDB 7.6,enabled=true,connected=true,holder=com.lighthammer.Illuminator.tools.database.ConnectionHolder@171194d]
2008-05-26 13:59:59,509 [ServletExec: request: time=1211821199509, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM Connector - Disabling server MaxDB
2008-05-26 13:59:59,509 [ServletExec: request: time=1211821199509, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM ConnectionPool - Destroy Connection pool [jdbc:sapdb://localhost/xmii?timeout=0]:

2008-05-26 13:59:59,509 [ServletExec: request: time=1211821199509, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM Connector - Enabling server MaxDB
2008-05-26 13:59:59,559 [ServletExec: request: time=1211821199509, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM ConnectionPool - Created Connection pool [jdbc:sapdb://localhost/xmii?timeout=0]:

2008-05-26 13:59:59,559 [ServletExec: request: time=1211821199509, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM Connector - Create Server [name=MaxDB,className=com.lighthammer.Illuminator.connectors.IDBC.IDBC,description=SAP MaxDB 7.6,enabled=true,connected=true,holder=com.lighthammer.Illuminator.tools.database.ConnectionHolder@a826da]
2008-05-26 14:03:03,653 [JCO.ServerThread-1] ERROR  SERVER-EXCEPTION - [null,null,null,] com.sap.mw.jco.JCO$Exception: (129) JCO_ERROR_SERVER_STARTUP: Server startup failed at Mon May 26 14:03:03 BRT 2008.
This is caused by either a) erroneous server settings, b) the backend system has been shutdown, c) network problems. Will try next startup in 1024 seconds.
Missing -a<Program ID>
2008-05-26 14:03:12,015 [ServletExec: request: time=1211821391815, uri=/Lighthammer/Illuminator] ERROR  ErrorHandler - Server is currently disabled (IDBC).
com.lighthammer.Illuminator.logging.LHException: Server is currently disabled (IDBC).
	at com.lighthammer.Illuminator.services.handlers.IlluminatorService.getServer(Unknown Source)
	at com.lighthammer.Illuminator.services.handlers.IlluminatorService.processRequest(Unknown Source)
	at com.lighthammer.Illuminator.services.ServiceManager.runQuery(Unknown Source)
	at com.lighthammer.Illuminator.servlet.Illuminator.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	at com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:638)
	at com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:236)
	at com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequestDispatcher.java:283)
	at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:96)
	at com.lighthammer.cms.system.CMSFilter.doFilter(Unknown Source)
	at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:60)
	at com.newatlanta.servletexec.ApplicationInfo.filterApplRequest(ApplicationInfo.java:2159)
	at com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1823)
	at com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:937)
	at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1091)
	at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:973)
	at com.newatlanta.servletexec.ServletExecService.processServletRequest(ServletExecService.java:167)
	at com.newatlanta.servletexec.ServletExecService.Run(ServletExecService.java:204)
	at com.newatlanta.servletexec.HttpServerRequest.run(HttpServerRequest.java:487)
2008-05-26 14:03:13,918 [ServletExec: request: time=1211821393738, uri=/Lighthammer/Illuminator] ERROR  ConnectionHolder - Unable to get a connection from the pool
com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 22): Unknown table name:XMII_LANGUAGES
	at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:64)
	at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:984)
	at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:622)
	at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:489)
	at com.sap.dbtech.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:859)
	at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:923)
	at com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:266)
	at com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:234)
	at com.sap.dbtech.jdbc.trace.Statement.execute(Statement.java:368)
	at com.lighthammer.Illuminator.tools.database.ConnectionPool.validateConnection(Unknown Source)
	at com.lighthammer.Illuminator.tools.database.ConnectionPool.createConnectionObject(Unknown Source)
	at com.lighthammer.Illuminator.tools.database.ConnectionPool.getConnectionObject(Unknown Source)
	at com.lighthammer.Illuminator.tools.database.ConnectionHolder.getConnection(Unknown Source)
	at com.lighthammer.Illuminator.connectors.IDBC.IDBC.processRequest(Unknown Source)
	at com.lighthammer.Illuminator.services.handlers.IlluminatorService.processRequest(Unknown Source)
	at com.lighthammer.Illuminator.services.ServiceManager.runQuery(Unknown Source)
	at com.lighthammer.Illuminator.servlet.Illuminator.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	at com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:638)
	at com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:236)
	at com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequestDispatcher.java:283)
	at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:96)
	at com.lighthammer.cms.system.CMSFilter.doFilter(Unknown Source)
	at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:60)
	at com.newatlanta.servletexec.ApplicationInfo.filterApplRequest(ApplicationInfo.java:2159)
	at com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1823)
	at com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:937)
	at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1091)
	at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:973)
	at com.newatlanta.servletexec.ServletExecService.processServletRequest(ServletExecService.java:167)
	at com.newatlanta.servletexec.ServletExecService.Run(ServletExecService.java:204)
	at com.newatlanta.servletexec.HttpServerRequest.run(HttpServerRequest.java:487)
2008-05-26 14:03:14,048 [ServletExec: request: time=1211821393738, uri=/Lighthammer/Illuminator] ERROR  ErrorHandler - An error occurred while creating a DB connection. Connection may have been prevented due to too many waiting connections in pool.
com.lighthammer.Illuminator.logging.LHException: An error occurred while creating a DB connection. Connection may have been prevented due to too many waiting connections in pool.
	at com.lighthammer.Illuminator.tools.database.ConnectionHolder.getConnection(Unknown Source)
	at com.lighthammer.Illuminator.connectors.IDBC.IDBC.processRequest(Unknown Source)
	at com.lighthammer.Illuminator.services.handlers.IlluminatorService.processRequest(Unknown Source)
	at com.lighthammer.Illuminator.services.ServiceManager.runQuery(Unknown Source)
	at com.lighthammer.Illuminator.servlet.Illuminator.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	at com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:638)
	at com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:236)
	at com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequestDispatcher.java:283)
	at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:96)
	at com.lighthammer.cms.system.CMSFilter.doFilter(Unknown Source)
	at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:60)
	at com.newatlanta.servletexec.ApplicationInfo.filterApplRequest(ApplicationInfo.java:2159)
	at com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1823)
	at com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:937)
	at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1091)
	at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:973)
	at com.newatlanta.servletexec.ServletExecService.processServletRequest(ServletExecService.java:167)
	at com.newatlanta.servletexec.ServletExecService.Run(ServletExecService.java:204)
	at com.newatlanta.servletexec.HttpServerRequest.run(HttpServerRequest.java:487)
2008-05-26 14:03:14,048 [ServletExec: request: time=1211821393738, uri=/Lighthammer/Illuminator] ERROR  ErrorHandler - An error occurred while creating a DB connection. Connection may have been prevented due to too many waiting connections in pool.
com.lighthammer.Illuminator.logging.LHException: An error occurred while creating a DB connection. Connection may have been prevented due to too many waiting connections in pool.
	at com.lighthammer.Illuminator.tools.database.ConnectionHolder.getConnection(Unknown Source)
	at com.lighthammer.Illuminator.connectors.IDBC.IDBC.processRequest(Unknown Source)
	at com.lighthammer.Illuminator.services.handlers.IlluminatorService.processRequest(Unknown Source)
	at com.lighthammer.Illuminator.services.ServiceManager.runQuery(Unknown Source)
	at com.lighthammer.Illuminator.servlet.Illuminator.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	at com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:638)
	at com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:236)
	at com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequestDispatcher.java:283)
	at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:96)
	at com.lighthammer.cms.system.CMSFilter.doFilter(Unknown Source)
	at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:60)
	at com.newatlanta.servletexec.ApplicationInfo.filterApplRequest(ApplicationInfo.java:2159)
	at com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1823)
	at com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:937)
	at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1091)
	at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:973)
	at com.newatlanta.servletexec.ServletExecService.processServletRequest(ServletExecService.java:167)
	at com.newatlanta.servletexec.ServletExecService.Run(ServletExecService.java:204)
	at com.newatlanta.servletexec.HttpServerRequest.run(HttpServerRequest.java:487)

Thanks for any help,

Vinicius

[jcgood25]

com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 22): Unknown table name:XMII_LANGUAGES

It would appear that your ValidationQuery is invalid.

Regards,

Jeremy