Paul Kneeland | 2005-10-11 00:00:00.0 | |
I am evaluating your driver. I have it working but have two questions:
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. 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. | ||
HXTT Support | 2005-10-11 00:00:00.0 | |
>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. |