How to set options Ignore space after function name in MySQL JDBC Driver

Hi

I am using Powerbuilder 11.5 and Mysql 5.1.70-community on Windows 7 32 Bit, I downloaded MySQL connector "Connector/J 5.1.26"

I created a database profile with following options
// Profile dd
SQLCA.DBMS = "JDBC"
SQLCA.LogPass = <***>
SQLCA.LogId = "root"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Driver='com.mysql.jdbc.Driver',URL='jdbc:mysql://localhost:3306/MyDB'

and it works also but it is giving error on any SELECT statement where in Aggregate function is used like Count(), Sum(). The same problem arrises when i was using ODBC driver there we have option Ignore Spaces after function name if i set this option in ODBC Profile it was working fine.

But since now i want DSN less connection JDBC driver allows me to connect to MySQL but i don't know how to specify this option

I tried out following options but it fails
SQLCA.DBParm = "Driver='com.mysql.jdbc.Driver',URL='jdbc:mysql://localhost:3306/MyDB',OPTION='135168'"
//SQLCA.DBParm = "Driver='com.mysql.jdbc.Driver',URL='jdbc:mysql://localhost:3306/MyDB'"
//SQLCA.DBParm = "Driver='com.mysql.jdbc.Driver',URL='jdbc:mysql://localhost:3306/MyDB',TrimSpaces='Yes'"

0 answers