ERROR2008-01-16 02:07:42,485 CommDSP:[elos.communicator.dsp.itunes.dao.hibernate.ITunesDAOHibernate.saveAlbumsCollection:481] - :A:Hibernate operation: could not load: [elos.communicator.dsp.itunes.model.Album#179956425]; uncategorized SQLException for SQL []; SQL state [null]; error code [17059]; Fallo al convertir a representación interna; nested exception is java.sql.SQLException: Fallo al convertir a representación interna: 5033197406527|179956425|Comu passione|13||ITA490600164|La storia è toa|179959703|11|1|S
WARN 2008-01-16 02:07:42,499 CommDSP:[net.sf.hibernate.util.JDBCExceptionReporter.logExceptions:57] - SQL Error: 17059, SQLState: null
ERROR2008-01-16 02:07:42,500 CommDSP:[net.sf.hibernate.util.JDBCExceptionReporter.logExceptions:58] - Fallo al convertir a representación interna

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
  <class name="elos.communicator.dsp.itunes.model.Album" table="dsr_albums" dynamic-update="false" dynamic-insert="false" mutable="true" polymorphism="implicit" batch-size="1" select-before-update="false" optimistic-lock="version">
    <id name="codAlbum" column="COD_ALBUM" type="java.lang.String" unsaved-value="null">
      <generator class="assigned"/>
    </id>
    <property name="albumName" type="java.lang.String" update="true" insert="true" column="ALBUM_NAME" not-null="false" unique="false"/>
    <property name="albumYear" type="int" update="true" insert="true" column="ALBUM_YEAR" not-null="false" unique="false"/>
    <property name="songNumb" type="int" update="true" insert="true" column="SONG_NUMB" not-null="false" unique="false"/>
    <property name="upc" type="java.lang.String" update="true" insert="true" column="UPC" not-null="false" unique="false"/>
    <set name="songs" table="dsr_album_songs" lazy="true" inverse="false" cascade="none" sort="unsorted" order-by="cod_Song" batch-size="1" outer-join="auto">
      <key column="cod_Album"/>
      <many-to-many class="elos.communicator.dsp.itunes.model.Song" column="cod_Song" outer-join="true"/>
    </set>
    <!--
            To add non XDoclet property mappings, create a file named
                hibernate-properties-Album.xml
            containing the additional properties and place it in your merge dir.
        -->
  </class>
  <class name="elos.communicator.dsp.itunes.model.ItunesMasterInfo" table="master_itunes_info" dynamic-update="false" dynamic-insert="false" mutable="true" polymorphism="implicit" batch-size="1" select-before-update="false" optimistic-lock="version">
    <id name="masterId" column="masterId" type="java.lang.Long" unsaved-value="null">
      <generator class="native">
        <param name="sequence">SEQ_MASTER_ITUNES</param>
      </generator>
    </id>
    <property name="masterName" type="java.lang.String" update="true" insert="true" column="masterName" not-null="false" unique="false"/>
    <property name="started" type="java.util.Date" update="true" insert="true" column="started" not-null="false" unique="false"/>
    <property name="finished" type="java.util.Date" update="true" insert="true" column="finished" not-null="false" unique="false"/>
    <property name="error" type="java.lang.String" update="true" insert="true" column="error" not-null="false" unique="false"/>
    <property name="songs" type="java.lang.Long" update="true" insert="true" column="songs" not-null="false" unique="false"/>
    <property name="albums" type="java.lang.Long" update="true" insert="true" column="albums" not-null="false" unique="false"/>
    <!--
            To add non XDoclet property mappings, create a file named
                hibernate-properties-ItunesMasterInfo.xml
            containing the additional properties and place it in your merge dir.
        -->
  </class>
  <class name="elos.communicator.dsp.itunes.model.Song" table="dsr_songs" dynamic-update="false" dynamic-insert="false" mutable="true" polymorphism="implicit" batch-size="1" select-before-update="false" optimistic-lock="version">
    <id name="codSong" column="COD_SONG" type="java.lang.String" unsaved-value="null">
      <generator class="assigned"/>
    </id>
    <property name="artistName" type="java.lang.String" update="true" insert="true" column="ARTIST_NAME" not-null="false" unique="false"/>
    <property name="duration" type="int" update="true" insert="true" column="DURATION" not-null="false" unique="false"/>
    <property name="grid" type="java.lang.String" update="true" insert="true" column="GRID_ID" not-null="false" unique="false"/>
    <property name="isrc" type="java.lang.String" update="true" insert="true" column="ISRC" not-null="false" unique="false"/>
    <property name="recordCompany" type="java.lang.String" update="true" insert="true" column="RECORD_COMPANY" not-null="false" unique="false"/>
    <property name="title" type="java.lang.String" update="true" insert="true" column="TITLE" not-null="false" unique="false"/>
    <property name="vendorId" type="java.lang.String" update="true" insert="true" column="VENDOR_ID" not-null="false" unique="false"/>
    <!--
            To add non XDoclet property mappings, create a file named
                hibernate-properties-Song.xml
            containing the additional properties and place it in your merge dir.
        -->
  </class>
  <class name="elos.communicator.dsp.listener.model.DsrQueue" table="dsr_queue" dynamic-update="false" dynamic-insert="false" mutable="true" polymorphism="implicit" batch-size="1" select-before-update="false" optimistic-lock="version">
    <id name="idQueue" column="idQueue" type="java.lang.Long" unsaved-value="null">
      <generator class="native">
        <param name="sequence">SEQ_DSR_QUEUE</param>
      </generator>
    </id>
    <property name="path" type="java.lang.String" update="true" insert="true" column="path" not-null="false" unique="false"/>
    <property name="name" type="java.lang.String" update="true" insert="true" column="name" not-null="false" unique="false"/>
    <property name="source" type="java.lang.String" update="true" insert="true" column="source" not-null="false" unique="false"/>
    <property name="priority" type="java.lang.String" update="true" insert="true" column="prioriry" not-null="false" unique="false"/>
    <!--
            To add non XDoclet property mappings, create a file named
                hibernate-properties-DsrQueue.xml
            containing the additional properties and place it in your merge dir.
        -->
  </class>
  <class name="elos.communicator.dsp.listener.model.MessageCounter" table="message_counter" dynamic-update="false" dynamic-insert="false" mutable="true" polymorphism="implicit" batch-size="1" select-before-update="false" optimistic-lock="version">
    <id name="idCounter" column="idCounter" type="java.lang.Long" unsaved-value="null">
      <generator class="native">
        <param name="sequence">SEQ_MESSAGE_COUNTER</param>
      </generator>
    </id>
    <property name="numReleaseAvailabilityMessages" type="java.lang.Long" update="true" insert="true" column="num_messages" not-null="false" unique="false"/>
    <property name="idMessage" type="java.lang.Long" update="true" insert="true" column="id_message" not-null="false" unique="false"/>
    <property name="releaseAvailability" type="java.lang.Long" update="true" insert="true" column="release_availability" not-null="false" unique="false"/>
    <!--
            To add non XDoclet property mappings, create a file named
                hibernate-properties-MessageCounter.xml
            containing the additional properties and place it in your merge dir.
        -->
  </class>
</hibernate-mapping>