View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0002328 | SymmetricDS | Bug | public | 2015-06-23 07:47 | 2022-09-12 14:18 |
Reporter | ondrejhala | Assigned To | chenson | ||
Priority | high | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.7.19 | ||||
Target Version | 3.7.28 | Fixed in Version | 3.7.28 | ||
Summary | 0002328: Error during use of dbexport feature on PostgreSQL database | ||||
Description | Illegal 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. This issue has been already committed with previous version of SymmetricDS and PostgreSQL (http://www.symmetricds.org/issues/view.php?id=2215). The issue is confirmed in last version of SymmetricDS. | ||||
Steps To Reproduce | Call dbexport on PosgreSQL database v9.3.1 on table that contains column with type lo. .\dbexport --engine SymmetricDsPSRV --format=csv --dir=C:\DBExport attachment Structure of table: CREATE TABLE attachment ( id integer NOT NULL, packed_len bigint NOT NULL, packed_len_id integer NOT NULL, buffer lo ) | ||||
Additional Information | 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) SW versions: PostgreSQL 9.3.1, compiled by Visual C++ build 1600, 32-bit Java version: 1.8.0_25 | ||||
Tags | No tags attached. | ||||
has duplicate | 0002215 | closed | Error during use of dbexport feature on PostgreSQL database |
SymmetricDS: 3.7 8e53aad2 2015-12-08 13:42:09 Details Diff |
0002328: Error during use of dbexport feature on PostgreSQL database |
Affected Issues 0002328 |
|
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/PostgresLobHandler.java | Diff File | ||
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/sql/JdbcSqlTemplate.java | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2015-06-23 07:47 | ondrejhala | New Issue | |
2015-12-08 18:42 | chenson | Fixed in Version | => 3.7.28 |
2015-12-08 18:42 | chenson | Target Version | => 3.7.28 |
2015-12-08 18:43 | chenson | Status | new => resolved |
2015-12-08 18:43 | chenson | Resolution | open => fixed |
2015-12-08 18:43 | chenson | Assigned To | => chenson |
2015-12-08 19:00 | chenson | Changeset attached | => SymmetricDS 3.7 8e53aad2 |
2016-01-03 21:44 | chenson | Status | resolved => closed |
2022-09-12 14:18 | emiller | Relationship added | has duplicate 0002215 |