Ticket #4 (assigned task)

Opened 2 years ago

Last modified 14 months ago

Support BLOBs

Reported by: chous Owned by: chous
Priority: normal Milestone: A-law algorithm (QueryJ 0.7)
Component: QueryJ Version: trunk
Keywords: oracle Cc:
Include in GanttChart: yes Depends on: 3
Due to assign (leave blank to use ticket's creation date): Due to close: 2006/08/31

Description

Handling BLOBs has never been a requested feature of QueryJ, so far. Now, a customer requests it, so it's time to implement it. Since Oracle support is required, this becomes the kind of bug which requires many weird if-else stuff due to what some vendors think "supporting JDBC" mean.

Change History

Changed 2 years ago by anonymous

  • owner changed from chous to anonymous
  • status changed from new to assigned

There're some things to notice:

  1. DAO.stg sees Blobs as if they were Clobs
  2. Result Set Extractor?.stg needs to include code to support Blobs.

Probably the best choice would be to use Spring's AbstractLobStreamingResultSetExtractor and AbstractLobCreatingPreparedStatementCreator. However, all logic is defined in DefaultLobHandler, which follows JDBC API, and doesn't support Oracle8 CLOB/BLOBs.

Changed 2 years ago by chous

  • owner changed from anonymous to chous
  • status changed from assigned to new

Changed 2 years ago by chous

  • status changed from new to assigned

Changed 2 years ago by chous

(In [1599]) Added missing file. refs #4

Changed 2 years ago by chous

(In [1600]) Fixed CLOB bug. Released 1.9-synchr-23. refs #4

Changed 2 years ago by chous

(In [1601]) Tagged 1.9-synchr-23. refs #4

Changed 2 years ago by chous

(In [1602]) Updated version. refs #4

Changed 14 months ago by chous

(In [2064]) Implementing more stuff. refs #4

Note: See TracTickets for help on using tickets.