Hi,
I am a new member. My name is MANU. I am currently working on a java application that requires me to insert a zip file as a clob in a database. If anyone could help me on this as soon as possible, would really appreciate it.
I would really appreciate the sample code...
I am working on TERADATA DATABASE.. so if anyone is using that and knows the solution would be really helpful.. Else, the solution in Oracle or DB2 will be highly appreciated.
Thanks in advance
5  1947 
For a zip file, better use a blob instead (Binary large object instead of Character
large object). You create a blob, open a Writer on it and write to it. For reading,
retrieve it, open a Reader and read its contents.
kind regards,
Jos
For a zip file, better use a blob instead (Binary large object instead of Character
large object). You create a blob, open a Writer on it and write to it. For reading,
retrieve it, open a Reader and read its contents.
kind regards,
Jos
thanks. I will try it and let u know how it goes..
how do u decide which is better, a blob or a clob, for a zip file? also can u provide me some sample code just to ensure how its done??
thanks in advance ..
Manu
thanks. I will try it and let u know how it goes..
how do u decide which is better, a blob or a clob, for a zip file? also can u provide me some sample code just to ensure how its done??
thanks in advance ..
Manu
A lob is a binary large object. A clob is a character large object.
If you want to store a large binary object use a blob is you want to store a large object with characters only use a clob.
A lob is a binary large object. A clob is a character large object.
If you want to store a large binary object use a blob is you want to store a large object with characters only use a clob.
can anyone help me with the code... i havent used clobs before.. .so have no clue...
regards
Manu
can anyone help me with the code... i havent used clobs before.. .so have no clue...
regards
Manu
It's best that you get a tutorial on the subject and read it.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Rachel Pevtzow |
last post by:
i currently have a few (non-oracle) databases containing personal papers of
wellington, mountbatten, etc. i'm thinking about moving it into oracle, but
i'm worried about how to get the data in. ...
|
by: Srinadh |
last post by:
Hi all,
We have files with about 20 to 30 fields per row.
We are trying to update such files with about 60 rows as contiguous
data in a CLOB field.
It passes through.
But when we try...
|
by: Fred |
last post by:
Hello,
I found a CLOB column in a DMS table that programmers were using to
store tiny strings (less than a couple kilobytes). Since CLOB columns
can only allocate entire kilobytes of space at...
|
by: kacper |
last post by:
Hello,
Recently I had to connect my application (Delphi, dbexpress) to
remote db2 server connected via WAN. (3Mb/s).
If I'm not working with clobs - everything works just great - I have
an...
|
by: amitabh.mehra |
last post by:
Hi
I m new to DB2..
I am using DB2 version8. I have a few queries (which i create
dynamically) stored in a table. The column which stores them is clob
32k. Each of these query has a ":wf_id"...
|
by: Starsky |
last post by:
Hello everyone!
I am spanish and I am developing an application using DB2 v9 and Java. I´m currently trying new things but I have a problem.
I can easily do INSERTS from my application into the...
|
by: dav3 |
last post by:
Alright folks I am in need of a lil guidance/assistance here. I have a program which reads in a txt file. This txt file contains lines of the form
January 3, 2007, 85.8
Now each line of the txt...
|
by: msankardas |
last post by:
Hi,
I am a new member. My name is MANU. I am currently working on a java application that requires me to insert a zip file as a clob in a database. If anyone could help me on this as soon as...
|
by: sdanda |
last post by:
Hi ,
Do you have any idea how to improve my java class performance while selecting and inserting data into DB using JDBC Connectivity .........
This has to work for more than 8,00,000...
|
by: Eraser |
last post by:
Hello,
I'm just starting to learn PL/SQL. To get my feet wet,
I'm trying to write a simple stored procedure that takes some
values as parameters, and inserts those values into a table.
For...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
