View Issue Details

IDProjectCategoryView StatusLast Update
0002215SymmetricDSBugpublic2019-04-12 08:48
Reporterondrejhala Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.7.6 
Summary0002215: Error during use of dbexport feature on PostgreSQL database
DescriptionIllegal State Exception is fired during export of table from PosgreSQL database v8.4.2 with dbexport tool.

Exception message: Cannot translate a java.lang.Long into a byte[].

This happens only on tables with large object column.
Steps To ReproduceCall dbexport on PosgreSQL database v8.4.2 on table that contains column with type lo.

.\dbexport --engine SymmetricDsPSRV --format=csv --dir=C:\DBExport attachment
Additional InformationStructure of table:
CREATE TABLE attachment
(
  id integer NOT NULL,
  packed_len bigint NOT NULL,
  packed_len_id integer NOT NULL,
  buffer lo
)

Log OUTPUT:

Log output will be written to C:\SymmetricDS\symmetric-psrv-export/logs/symmetric.log
[] - AbstractCommandLauncher - Option: name=engine, value={SymmetricDsPSRV}
[] - AbstractCommandLauncher - Option: name=format, value={csv}
[] - AbstractCommandLauncher - Option: name=dir, value={C:\DBExport}
[] - JdbcDatabasePlatformFactory - Detected database 'PostgreSQL', version '8', protocol 'postgresql'
[] - JdbcDatabasePlatformFactory - The IDatabasePlatform being used is org.jumpmind.db.platform.postgresql.PostgreSqlDat
abasePlatform
-------------------------------------------------------------------------------
An exception occurred. Please see the following for details:
-------------------------------------------------------------------------------
java.lang.IllegalStateException: Cannot translate a java.lang.Long into a byte[]
        at org.jumpmind.db.sql.Row.toBytes(Row.java:72)
        at org.jumpmind.db.sql.Row.getBytes(Row.java:131)
        at org.jumpmind.db.platform.AbstractDatabasePlatform.getStringValues(AbstractDatabasePlatform.java:487)
        at org.jumpmind.symmetric.io.data.DbExport$WriterWrapper.writeRow(DbExport.java:510)
        at org.jumpmind.symmetric.io.data.DbExport$1.mapRow(DbExport.java:222)
        at org.jumpmind.db.sql.JdbcSqlReadCursor.next(JdbcSqlReadCursor.java:115)
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:193)
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:182)
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:123)
        at org.jumpmind.symmetric.io.data.DbExport.writeTable(DbExport.java:220)
        at org.jumpmind.symmetric.io.data.DbExport.exportTables(DbExport.java:181)
        at org.jumpmind.symmetric.io.data.DbExport.exportTables(DbExport.java:159)
        at org.jumpmind.symmetric.io.data.DbExport.exportTables(DbExport.java:149)
        at org.jumpmind.symmetric.DbExportCommand.executeWithOptions(DbExportCommand.java:192)
        at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:190)
        at org.jumpmind.symmetric.DbExportCommand.main(DbExportCommand.java:75)
-------------------------------------------------------------------------------
Tagsdbimport/dbexport, dialect: postgresql, large objects

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2015-02-24 10:03 ondrejhala New Issue
2015-02-24 10:04 ondrejhala Tag Attached: dbexport
2015-02-24 10:04 ondrejhala Tag Attached: large objects
2015-02-24 10:04 ondrejhala Tag Attached: lo
2015-02-24 10:04 ondrejhala Tag Attached: postgres
2015-02-24 10:04 ondrejhala Tag Attached: postgresql
2019-04-12 08:48 admin Tag Detached: lo
2019-04-12 08:48 admin Tag Detached: postgres
2019-04-12 12:40 admin Tag Renamed dbexport => dbimport/dbexport
2019-04-23 16:50 admin Tag Renamed postgresql => dialect: postgresql