about jdbc connector service

[Former Member]

Hi expertise,

i try to connect mysql database using netweaver jdbc connector service. everything is OK at the beginning , but some hours later, an exception occurs " error occurred while executing init statements".

my datasource xml is below:

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE data-sources SYSTEM 'data-sources.dtd'>

<data-sources>

<application-name>sap.com/ASE</application-name>

<data-source>

<data-source-name>ASE_DATA_SOURCE</data-source-name>

<driver-name>MysqlDriver</driver-name>

<init-connections>2</init-connections>

<max-connections>10</max-connections>

<max-time-to-wait-connection>60</max-time-to-wait-connection>

<sql-engine>vendor_sql</sql-engine>

<jdbc-1.x>

<driver-class-name>org.gjt.mm.mysql.Driver</driver-class-name>

<url>jdbc:mysql://localhost:3306/ase?characterEncoding=UTF-8</url>

<user-name>root</user-name>

<password>**********</password>

</jdbc-1.x>

</data-source>

</data-sources>

and my sqlserver version is 5.1.19-beta-community-nt-debug, driver version is mysql-connector-java-5.1.6-bin.java.

i appriciate your response. thanks

[Former Member]

Hai,

Check the user password are changed or not in the mysql side which mentioned in the jdbc connector configuration.

Thanks and Regards,