• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problems with DB2XADataSource

 
Saro Visu
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We have problems when using XADataSource with a PreparedStatement.
The DB table has one column type as BLOB. We use PreparedStatement and run executeUpdate() method after setting values for the PreparedStatement. We set the value for the BLOB column as BinaryInputStream. The method doesn't looks to complete and we do not receive any error also.
The same stuff works fine when using the DB2ConnectionPoolDataSource.
We use com.ibm.db2.jcc.DB2XADataSource.

Thanks
Saro
 
Saro Visu
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Anyone out there having a solution for this ?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33699
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Saro,
The method doesn't looks to complete and we do not receive any error also.

What do you mean by this? Does it hang? Does it not update the row? Does it throw an exception?
 
Sara Visu
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The method hangs and no exception thrown. The method ends when the transaction timeout value is reached. So obviously the method doesnt complete and so record is not inserted.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33699
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sara,
Could the transaction settings different on your datasource with the XA driver?
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic