Expand my Community achievements bar.

Guidelines for the Responsible Use of Generative AI in the Experience Cloud Community.

AEM integrate to Hybris with Mysql as DB

Avatar

Level 1

here is the document I am following

http://docs.adobe.com/docs/en/aem/6-0/deploy/ecommerce/hybris.html

I am using AEM 6.0 and Hybris 5.2.0

when I install Hybris, it mentioned several files:

setup.groovy

postinit.groovy

sqltool-2.2.6.jar

they are only specified to HSQL DB, what if we use Mysql, how to switch it. I can replace all HSQL data to MySql relevant data, but I can't find any replacement to "sqltool-2.2.6.jar" it seems only work for Hsql.

for example, my postinit.groovy like below

println "Initializing token store's MySqlDB"
def cmd = "java -Xbootclasspath/a:./bin/platform/lib/dbdriver/mysql-connector-java-5.1.28-bin.jar -jar sqltool-2.2.6.jar --inlineRc=url=jdbc:mysql://localhost/hybris_aem?useConfigs=maxPerformance&characterEncoding=utf8,user=hybris_aem,password=    schema.sql"
def proc = cmd.execute()
proc.waitFor()
proc.errorStream.eachLine { println it }

this doesn't work, because it couldn't find org. hsqldb.jdbc.JDBCDriver from sqltool-2.2.6.jar.

0 Replies