>1) Is there a way to make the driver function on a stream or other in memory
> repository instead of only files. The reason for this is I have the data
> already in memory and would rather not have to save them as a file.
> I am using them read only.
Yeah. We can provide such a function. But how to provide an API for your? Your suggestions are welcome. Can we use "create MEMORY table ..." to provide a table defination? Then
String sql="insert into thatMemoryTable ?;";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setBytes(1,yourBytes);//insert your byte[] data into table thatMemoryTable.
Or
pstmt.setBinaryStream(1,yourStream);//insert yourStream into table thatMemoryTable.
pstmt.executeUpdate();
pstmt.close();
But it seems still complicated for utilzation. What's your opinion and suggestion?
>2) I am dealing with line feed terminated fixed formatted rows. However if
> the data in a row is not complete it is not pad filled. Is there a way to
> have the driver handle this or do I need to pad the files to the
> maximum size.
For instance, you can add "_StuffedColumn char(2) default '\r\n'" as the last column. Default value can be used for any column. Let me know more about your requirement, then I will show you how to use sql or code to solve your issue. You can send text sample to webmaster@hxtt.com too.
|
Main
webmaster@hxtt.com