Nitin Gupta [EMAIL PROTECTED] writes:
I am developing a java based desktop application which is
required to work across platforms. As I am new to embedded databases, I am
confused
about which database should I go with. I have come across following choices:
- Derby
- HSQLDB
- H2
I'm using embedded derby in a Java SE application, however I use Derby
as a network server while building the database. In that connection I
ran into problems.
I have a database with 65000 rows that I wanted to add to a Derby
database (total size before insert around 1 records, 30MB). Each row
Kristian Waagan [EMAIL PROTECTED] writes:
Ture Munter wrote:
I'm using embedded derby in a Java SE application, however I use Derby
as a network server while building the database. In that connection I
ran into problems.
I have a database with 65000 rows that I wanted to add to a Derby
, and in that case he can do
more interesting things than just making the server crash.
Thanks for the replies
- Ture Munter
Kristian Waagan [EMAIL PROTECTED] writes:
As Bryan says, you should close your statements. Even better would be to
use a PreparedStatement for all you queries (including those without any
variables).
Unless it is an application requirement, you could also do with just one
table and