Hi
I am running HSQLDB server inside my appilcation that is running on a micro device that has only 64MB of RAM. I am creating a TEXT table on the device that can hold data.
Here is how I am creating text table
// Creating table
sql= "CREATE TEXT TABLE CAT (CATID VARCHAR(20), DESC1 VARCHAR(50),....)";
ps = con.prepareStatement(sql);
ps.executeUpdate();
// Creating Index
sql="CREATE INDEX cat_index ON CAT (CATID)";
ps = con.prepareStatement(sql);
ps.executeUpdate();
con.commit();
sql = "SET TABLE CAT SOURCE \"cat.dat;fs=|;all_quoted=true;quoted=true\"";
Once this table is created onto the device. My legacy will generate a data file (cat.dat) and then will FTP that data file onto device.
Now my question is:
===================
When I use SELECT statement on the device (inside my application on the device) it does not show data.
Any clue?
Thanks in advance.
Sohail
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at
http://www.sourceforge.net/community/cca08_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
