<?xml version="1.0" encoding='utf-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="logic.Route" table="route">
        <id column="id" name="id" type="java.lang.Integer">
            <generator class="increment"/>
        </id>
        <property column="number" name="number" type="java.lang.Integer"/>
        <property column="from" name="from" type="java.lang.String"/>
        <property column="to" name="to" type="java.lang.String"/>
        <property column ="interval" name="interval" type="java.lang.Integer"/>

        <set name="busses" lazy ="false">
            <key column="route"/>
            <one-to-many class="logic.Bus"/>
        </set>
    </class>
</hibernate-mapping>

<?xml version="1.0" encoding='utf-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="logic.Bus" table="bus">
        <id column="id" name="id" type="java.lang.Integer">
            <generator class="increment"/>
        </id>
        <property column="mark" name="mark" type="java.lang.String"/>
        <property column="model" name="model" type="java.lang.String"/>
        <property column="passnumber" name="passNum" type="java.lang.Integer"/>
        <property column="regnum" name="regNum" type="java.lang.String"/>
    </class>
</hibernate-mapping>

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <property name="connection.url">jdbc:mysql://localhost/busdata</property>
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="connection.username">root</property>
    <property name="connection.password">admin</property>
    <property name="connection.pool_size">1</property>
    <property name="show_sql">true</property>
    <property name="current_session_context_class">thread</property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
    <!-- DB schema will be updated if needed -->
    <!-- <property name="hbm2ddl.auto">update</property> -->


    <mapping resource="logic/Route.hbm.xml"/>
    <mapping resource="logic/Bus.hbm.xml"/>


  </session-factory>
</hibernate-configuration>

Ошибка

Hibernate: select max(id) from route
Hibernate: insert into route (number, from, to, interval, id) values (?, ?, ?, ?, ?)
Ошибка добавления маршрута
июл 05, 2016 11:32:57 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 1064, SQLState: 42000
июл 05, 2016 11:32:57 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from, to, interval, id) values (1, 'Novyi', 'RailWayStation', 10, 1)' at line 1

Запрос аналогично не работает и в командной строке