#30 Can't import Atari Lynx DB

[ablaszczyk]

This time no stacktrace :(

  Switching to alternate import method because of the following exception: org.hibernate.exception.GenericJDBCException: error executing work
  Importing data from csv file .jgamebase/GB_Lynx/Export/Games.csv' into table 'GAMES' line by line.
Access import failed!

[ablaszczyk]

Got stacktrace:

Caused by: ERROR XIE0R: Import error on line 1 of file .jgamebase/GB_Lynx/Export/Games.csv.sle: Invalid character string format for type INTEGER. 
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
    ... 26 more
Caused by: java.sql.SQLDataException: Invalid character string format for type INTEGER.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
    at org.apache.derby.impl.load.Import.performImport(Unknown Source)
    at org.apache.derby.impl.load.Import.importTable(Unknown Source)
    at org.apache.derby.catalog.SystemProcedures.SYSCS_IMPORT_TABLE(Unknown Source)
    at org.apache.derby.exe.ac560740aax0168x6c1fx73cax00001944937f4.g0(Unknown Source)
    at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown Source)
    at org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown Source)
    at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
    at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
    ... 19 more
Caused by: ERROR 22018: Invalid character string format for type INTEGER.
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.iapi.types.DataType.invalidFormat(Unknown Source)
    at org.apache.derby.iapi.types.DataType.setValue(Unknown Source)
    at org.apache.derby.exe.ac560740aax0168x6c1fx73cax00001944937f35.e0(Unknown Source)
    at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)
    at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.doProjection(Unknown Source)
    at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source)
    at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
    at org.apache.derby.impl.sql.execute.NoPutResultSetImpl.getNextRowFromRowSource(Unknown Source)
    at org.apache.derby.impl.store.access.heap.HeapController.load(Unknown Source)
    at org.apache.derby.impl.store.access.heap.Heap.load(Unknown Source)
    at org.apache.derby.impl.store.access.RAMTransaction.loadConglomerate(Unknown Source)
    at org.apache.derby.impl.store.access.RAMTransaction.recreateAndLoadConglomerate(Unknown Source)
    at org.apache.derby.impl.sql.execute.InsertResultSet.bulkInsertCore(Unknown Source)
    at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
    at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
    at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
    ... 34 more

[F. Gerbig]

Hi ablaszczyk,

I'll have to investigate.

Best regards,
Frank

[ablaszczyk]

Adding DB - maybe this will help

[F. Gerbig]

Hi ablaszczyk,

The Lynx database does not adhere to the assumptions jGB makes about valid databases:
that the db columns have a fixed order.

Normally that is a valid assumtion as GB does not create new databases; it copies an "empty" db and fills it with data, so the order of columns stays fixed.

I don't know if I can/will fix this, I will have to investigate further.

Kind regards,
Frank

[F. Gerbig]

Hi ablaszczyk,

The Access database "GB Lynx" can not be imported to jGB automatically, but I revived the jToolBox (start "jgamebase toolbox").

With the toolbox you can import data step-by-step:
I exported the Access database to csv files, corrected the order of the columns in the file "Games.csv" (using LibreOffice), updated the db version, and imported the data.

Please find the imported db attached.

Kind regards,
Frank