msxisalive - 2007-10-16

Hello.

First of all: thank you very much for this program. It has been helpfull to me. :-)

Now, I have a problem with it:

I'm trying to migrate some dbf (clipper) databases to access, but some rows doesn't gets inserted. Logs are in FINER mode and I see this in the logs:

Error:[Microsoft][Controlador ODBC Microsoft Access]Tipo de datos SQL no válido    INSERT INTO tmp_familia (CODFAM,DESCRIFAM) VALUES (90,null)
Error:[Microsoft][Controlador ODBC Microsoft Access]Tipo de datos SQL no válido    INSERT INTO tmp_familia (CODFAM,DESCRIFAM) VALUES (77,null)
Error:[Microsoft][Controlador ODBC Microsoft Access]Tipo de datos SQL no válido    INSERT INTO tmp_familia (CODFAM,DESCRIFAM) VALUES (71,null)
Error:[Microsoft][Controlador ODBC Microsoft Access]Tipo de datos SQL no válido    INSERT INTO tmp_familia (CODFAM,DESCRIFAM) VALUES (76,null)
Error:[Microsoft][Controlador ODBC Microsoft Access]Tipo de datos SQL no válido    INSERT INTO tmp_familia (CODFAM,DESCRIFAM) VALUES (91,null)
Error:[Microsoft][Controlador ODBC Microsoft Access]Tipo de datos SQL no válido    INSERT INTO tmp_familia (CODFAM,DESCRIFAM) VALUES (53,null)

I think that the problem is with nulls, but tables accepts it. In fact, if I make a copy & paste of the SQL sentence, access insert the row by itself.

This is my migration file:

<migration>

  <databank>
    <source
      driverType="org.javahispano.dbmt.migrations.MigrationDBFSource"
      url="E:\\Pedidos\\"
    />
    <target
           driver="sun.jdbc.odbc.JdbcOdbcDriver"
               driverType="org.javahispano.dbmt.migrations.MigrationJDBC"
           quoted-names="false"
           url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=E:\Seguridad\N5\pedidos3_traspaso.mdb"
    />
  </databank>
  <!--
  'org.javahispano.dbmt' JDK14 logger. Contains information about log process.
  -->
  <log level="FINER"/>

  <steps>
 
   <step name="familia"
          skip='false'
          source_table="familia.dbf"
          target_table="tmp_familia"
          clear_target="true"    
          log_level="FINER"
          slice_size="1000"
          stop_on_error="false"
     >
     <field from="CODFAM"/>
     <field from="DESCRIFAM"/>
   </step>
  
  </steps>
</migration>

I forgot to mention that I previously migrated this same tables to MySQL successfully.

Thank you very much in advance.