> I will send you schema and query for which I feel there is problem. > On the other hand the driver I used for connection between java and sqlite > (javasqlite- http://www.ch-werner.de/javasqlite/) states that this driver is > tested only in Linux. I was wondering even if I should use SQLite with java > on solaris in live applications.
I don't know about the java/sun interface to sqlite. I have used it on linux and windows and it's worked very well for me. Others on this list might know more.