GraniteDS Hello sample project using Mysql instead of HSQLDB

Asked Mar 14 '13 at 19:49

Active Mar 12 '16 at 14:58

Viewed 164 times

I am new to JPA. Do anyone have any idea what else needs to be change in the sample to get it working with Mysql?

I was thinking the only changes that need to be done is the (jpa-config.xml)

I changed the data source to work with mysql.. I tested it out and its working. I create a table called Welcome on Mysql and have the columns name and message on it.

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName">
        <value>com.mysql.jdbc.Driver</value>
    </property>
    <property name="url">
        <value>jdbc:mysql://localhost:3306/testdata</value>
    </property>
    <property name="username">
        <value>sa</value>
    </property>
    <property name="password">
        <value>sa</value>
    </property>
</bean>

I am geting an error "org.hibernate.exception.SQLGrammarEXception: could not execute query" whenever I try to insert an entry through the sample.

edited Mar 12 '16 at 14:58

Roman C

49,761
33
66
176

asked Mar 14 '13 at 19:49

user2171396

Change driver info to MySQL!! it seems your using org.hsqldb.jdbcDriver – devBinnooh Mar 14 '13 at 20:11
"I changed the data source to work with mysql" ... post above.. I know the mysql setup is working because for the login system, I tied it with that datasource – user2171396 Mar 14 '13 at 20:13
Which Hibernate grammar have you configured? – Mar 14 '13 at 21:02
I assume this is the grammar "org.hibernate.dialect.HSQLDialect". I will try the mysql grammar – user2171396 Mar 14 '13 at 21:16

GraniteDS Hello sample project using Mysql instead of HSQLDB

0 Answers0