hu.gov.nav.ebt.client.backend.tools

Class LobUtils

java.lang.Object

hu.gov.nav.ebt.client.backend.tools.LobUtils

public class LobUtils
extends Object

HSQLDB-ben problemas a BLOB-ok betoltese/mentese sql kliens-bol. Ezt a segedosztalyt a HSQLDB szerveren a classpath-ba felveve tarolt eljarassal megoldhato a dolog.

Constructor Summary

Constructors

Constructor and Description
LobUtils()

Method Summary

Modifier and Type	Method and Description
static void	freeTempLobs(Connection conn)
static String	lobSubstr(Blob lobData, int offset, int length)
static String	lobSubstr(Clob lobData, int offset, int length)
static Blob	readBlob(Connection conn, String path) BLOB betoltese file-bol
static void	writeLobToFile(Blob lobData, String path) BLOB kiirasa file-ba
static void	writeLobToFile(Clob lobData, String path) CLOB kiirasa file-ba

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

LobUtils

public LobUtils()

Method Detail

freeTempLobs

public static void freeTempLobs(Connection conn)
                         throws SQLException

Throws:

SQLException

readBlob

public static Blob readBlob(Connection conn,
                            String path)
                     throws SQLException,
                            IOException

BLOB betoltese file-bol

Parameters:

conn - Rejtett parameter, a HSQLDB adja at neki az aktualis Connection-t

path - Eleresi ut, ahonnan be kell tolteni

Returns:

A betoltott BLOB

Throws:

SQLException

IOException

writeLobToFile

public static void writeLobToFile(Blob lobData,
                                  String path)
                           throws SQLException,
                                  IOException

BLOB kiirasa file-ba

Parameters:

lobData - A kiirando BLOB

path - Eleresi ut, ahova ki kell irni a BLOB-ot

Throws:

SQLException

IOException

writeLobToFile

public static void writeLobToFile(Clob lobData,
                                  String path)
                           throws SQLException,
                                  IOException

CLOB kiirasa file-ba

Parameters:

lobData - A kiirando BLOB

path - Eleresi ut, ahova ki kell irni a CLOB-ot

Throws:

SQLException

IOException

lobSubstr

public static String lobSubstr(Blob lobData,
                               int offset,
                               int length)
                        throws SQLException,
                               IOException

Throws:

SQLException

IOException

lobSubstr

public static String lobSubstr(Clob lobData,
                               int offset,
                               int length)
                        throws SQLException,
                               IOException

Throws:

SQLException

IOException