MySQL database connection issue

[former_member638331]

Dear Experts, Good day.

I am using Hybris6.7 Suit.

I am trying to connect to CRM database with below properties.

mysql.allow.fractional.seconds=true

crm.system_type=MySQL

crm.database_hostname=XXXXXHOSTNAMEXXXXXXXX crm.database=DBNAME?useConfigs=maxPerformance&characterEncoding=utf8&useSSL=false

crm.database_port=3306

crm.database_user=XXXXXX

crm.database_password=XXXXXXXXXXXX

crm.ssc_jndi_usage=false

crm.ssc_jndi_datasource=

After build and server start when i am trying to access the CRM DB . I am getting below exception

[connection_factory] The connection property 'useSSL' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'false?socketTimeout=201600' is not in this set. jdbc:mysql://XXXXXHOSTNAMEXXXXXXX:3306/DBNAME?useConfigs=maxPerformance&characterEncoding=utf8&useSSL=false?socketTimeout=201600 INFO | [mMay 13, 2020 12:45:59 PM org.apache.catalina.core.StandardWrapperValve invoke INFO | SEVERE: Servlet.service() for servlet [DispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is com.sap.sxe.sys.exc.databaseConnectionError: The connection property 'useSSL' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'false?socketTimeout=201600' is not in this set.] with root cause INFO | java.sql.SQLException: The connection property 'useSSL' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'false?socketTimeout=201600' is not in this set. INFO | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) INFO | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) INFO | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) INFO | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) INFO | at com.mysql.jdbc.ConnectionPropertiesImpl$ConnectionProperty.validateStringValues(ConnectionPropertiesImpl.java:314) INFO | at com.mysql.jdbc.ConnectionPropertiesImpl$BooleanConnectionProperty.initializeFrom(ConnectionPropertiesImpl.java:91) INFO | at com.mysql.jdbc.ConnectionPropertiesImpl$ConnectionProperty.initializeFrom(ConnectionPropertiesImpl.java:216) INFO | at com.mysql.jdbc.ConnectionPropertiesImpl.initializeProperties(ConnectionPropertiesImpl.java:2538) INFO | at com.mysql.jdbc.ConnectionImpl.initializeDriverProperties(ConnectionImpl.java:3109)

Can you please let me know what change i have to make to fix the above issue.

Thanks in Advance

Thanks & Regards

Priya

[pgundoju]

Hi Priya,

Looks like ?socketTimeout=201600 parameter is being incorrectly injected into the connection URL. I don't see it in your connection properties configuration. So, there must be a bug in DB connection url generation logic. Please inspect that specific component.

Regards,

Pavan