Connecting to mySQL

[Former Member]

Hi,

Can you send me the receiver JDBC database connection parameters for connecting to mySQL.

JDBC Driver:

Connection:

Best Regards

Suresh Kasu

[Former Member]

Hi,

JDBC driver: com.microsoft.jdbc.sqlserver.sqlserverdriver

connection: jdbc:microsoft:sqlserver://ip:port;databasename=

here ip and port are sqlserver ip and port.

Regards,

S.RamNarender

[Former Member]

Hi suresh

please fallow the steps to connect mySQL server

1)download the jdbc driver from url http://download.softagency.net/MySQL/Downloads/Connector-J/

(mysql-connector-java-3.1.14-bin.jar if you are using mysql 4.0)

2)copy the mysql-connector-java-3.1.14-bin.jar file into

C:\ServletExec AS\se-xMII\webapps\default\Lighthammer\WEB-INF\lib folder

3) place the same jar into java folder C:\j2sdk1.4.2_14\lib

4) Access the xMII server url in the browser

http://localhost/Lighthammer/Menu.jsp

5)Select the DataServices>DataServers> uncheck the check box (show only Enabled servers)

This is the summary of the data server configuration

Name Value

Connector IDBC

ConnectorType SQL

Enabled True(select the check box)

DatePrefix '

DateSuffix '

Description Default IDBC Server

InitCommand

InternalDateFormat yyyy-MM-dd HH:mm:ss

JDBCDriver com.mysql.jdbc.Driver

PoolMax 100

PoolSize 1

ServerPackage com.lighthammer.Illuminator.connectors.IDBC

ServerURL jdbc:mysql://<hostname>/<databasename>

Timeout 15

UseCount 256

UserName root

ValidationQuery select now()

WaitTime 30

After entering all the parameters save and check the Status

Regards

Srikanth

[prateek]

Have a look here

<i>[Reward if helpful]</i>

Regards,

Prateek

[Former Member]

How to perform external DBLook-ups from XI utilizing J2EE JDBC Connector Service

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9aedca11-0d01-0010-3b90-9ea04182...