Run Hybris 6.7 on MySQL

[Former Member]

I set-up the local.config like this:

 mysql.optional.tabledefs=CHARSET\=utf8 COLLATE\=utf8_bin
 db.url=jdbc\:mysql\://localhost/6showcase?useConfigs\=maxPerformance&characterEncoding\=utf8&useSSL\=false
 db.driver=com.mysql.jdbc.Driver
 db.username=root
 db.password=root
 db.tableprefix=
 mysql.tabletype=InnoDB
 installed.tenants=

I made a new build setant - ant clean all...> works fine Build Successfull

When I start localally I receive this message:

 **ERROR [localhost-startStop-4] [DataSourceImpl] error connecting to DataSource having url jdbc:mysql://localhost/6showcase?useConfigs=maxPerformance&characterEncoding=utf8&useSSL=false: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long**

In MySQL I have a running connection and a user root with all privileges for the schema etc... Any idea what can be wrong?

[Former Member]

First question: did you put the mysql driver inside the hybris\bin\platform\lib\dbdriver folder?

Second: in the local properties, we have this configurations for the database:

db.url=jdbc\:mysql\://localhost/6schowcase?useConfigs\=maxPerformance&characterEncoding\=utf8 db.driver=com.mysql.jdbc.Driver db.username=root db.password= db.tableprefix= mysql.optional.tabledefs=CHARSET\=utf8 COLLATE\=utf8_bin mysql.tabletype=InnoDB mysql.allow.fractional.seconds=false

Is this right in your local.properties?

And, I advise you always to change your recipe to set up the local.properties. Because, if you need to run the recipe again, you don't loose your information. And, also, it is easier to share with your team the changes in the recipe.

[Former Member]

I found out now by a value comment that my mySQL version is to high. I use MySQL 8.0 and Hybris 6.7 support 5.6 / 5.7. So I have to install a lower MySQL- Import the SQL and redo the build process and test again.

[VinayKumarS]

can you try with mysql.allow.fractional.seconds=false and check

[VinayKumarS]

also which version of mysql you are using?