Dear Sir/Madam,
I would like to assess the HXTT Driver to see if it works in my application. However I cannot get the driver to work at the moment. Could you please advise whether it is something I am doing incorrectly. I have two questions:
(1) When I run the driver using the following code I get the correct number of columns and rows in csv file but the data values are nonsense. Are the nonsense values deliberate as it is evaluation code or do I need to configure something??
Example Results from query:
[B@1ccb029 [B@1415de6 [B@7bd9f2 [B@121cc40 [B@1e893df [B@443226 null null [B@1386000 null null null null null null null null
(2) Also I would like to use the driver in Sun Studio Creator. This application uses Datasources and JNDI. In your documentation you say that driver properties are set using
Connection con = DriverManager.getConnection(url,properties);
I DO NOT use this method to get a connection from my rowset. How else do I set driver properties using a datasource method?
|
>Example Results from query:
>[B@1ccb029 [B@1415de6 [B@7bd9f2 [B@121cc40 [B@1e893df [B@443226 null null
> [B@1386000 null null null null null null null null
Check your CREATE TABLE sql. You can try to remove your CREATE TABLE sql to get the default varchar value too for CSV file.
>(2) Also I would like to use the driver in Sun Studio Creator.
> This application uses Datasources and JNDI.
HXTT Text (CSV) support JNDI too. For instance:
HxttConnectionPoolDataSource hxttDS = new
HxttConnectionPoolDataSource();
properties.setProperty("url","jdbc:text:////usr/local/ftproot/hxtt");
properties.setProperty("fileExtension","bin");
properties.setProperty("schemaFile","schemaHXTT.txt");
You can read How to set up HXTT Text (CSV) with Tomcat4.1 as PoolableConnection?
in http://www.hxtt.net/text/faq.html#interoperability if you need to set a similar xml setting.
|