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.
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.