Sybase Java

[khamus]

Hi, im working on an application supposed to interact with sybase but i have 2 problems. One, is there a driver for this? the application will be running under linux 6.1

two. How can i save files on the database? do i have to convert to binary and save as text?

thanks in advance

[kib63613]

I think that you may contact the vendor of sybase for the JDBC driver. One thing that
you may take care is if it supports JDBC 1.2 or 2.0. If it support JDBC 2.0, you may
use Blob method to save your binary data in the database. The detail usage should be
reference to the document of sybase database. If it does not support JDBC 2.0, you
may save the file name in the database. When you want to process your binary data,
you may query that file with the specified file name to access the stuff which will be
processed by your programs. This is an indirect method, but it can save your disk
space. with this method, you do not have to define the large space for the field to save
your data. It might eliminate the sparse effect.
good luck
Alfred Wu