Hi,
I was evaluating your jdbc driver for excel and I ran into a few issues which I need some clarification.
1. I configured a connection pool in weblogic 8.1.4 using this driver and tested it. When I perform a query, i am able to retrieve the results. But when I do a insert, i can see the INSERT statement in the log file but the data is not getting inserted into the excel file. I tried using local mode and server mode. Same issue with both
2. When the excel server is running, how can I update the excel file. For e.g. if I need to replace the existing excel file which is more recent with new data. Currently, I can't update the file when the excel server is running.
3. Can the driver return data from across multiple excel files with a single query. For .e.g. if I have MyFile1.xls, MyFile2.xls, MyFile3.xls which have a worksheet by name MyTable. Can I perform a query like "SELECT * FROM MyTable" which will return the data from all the three excel files ?
Thanks in advance.
Sincerely,
Prashanth
|
>1. I configured a connection pool in weblogic 8.1.4 using this driver and
>tested it. When I perform a query, i am able to retrieve the results. But when
> I do a insert, i can see the INSERT statement in the log file but the data is
> not getting inserted into the excel file. I tried using local mode and server
> mode. Same issue with both
1st. delayedClose connectin property is using to decide when HXTT Excel will flush the actual file.
2nd. If you using axlsFile.xls in your jdbc url, that file will be flushed after that connection close.
>2. When the excel server is running, how can I update the excel file. For e.g.
>if I need to replace the existing excel file which is more recent with new
>data. Currently, I can't update the file when the excel server is running.
1st solution: Call con.close() in time.
2nd solutuon: Don't use jdbc:excel:////dataidr/yourxlsfile.xls as jdbc url, you should use jdbc:excel:////datadir as jdbc url, then use yourxls.sheet1 in your sql, or use con.setCatalog() to open that xls.
>3. Can the driver return data from across multiple excel files with a single
> query. For .e.g. if I have MyFile1.xls, MyFile2.xls, MyFile3.xls which have a
> worksheet by name MyTable.
> Can I perform a query like "SELECT * FROM MyTable" which will return the data
>from all the three excel files ?
Yeah. It can query on different xls files on different hosts even. For instance,
select * from myfile1.mytable join select * from myfile2.mytable join select * from myfile3.mytable if your jdbc url is jdbc:excel:////datadir .
|
Main
webmaster@hxtt.com