Hey Guys,
This may not be the best place to post this thing but I just wanted to
know which one is a better database, speed wise(speed with the which the
database can handle hundreds of thousands of transaction), data capacity

Hello, All
I installed mysql server on my suse box. I am trying to connect to it
through java jdbc application. The
program does connect to suse server when I run it on localhost. But when I

I have a problem using HSQLDB 1.7.1
Here is the code after creating a connection and a statement...
ResultSet rs=some_statement.executeQuery(some_query_string);
System.out.println(rs.getRow());

I am using Oracle 9i release 2 on Red Hat Linux 9. I have written a simple
application, which inserts one millions rows
into a single table. The application uses Oracle JDBC driver type 4. The
problem is that after approximately 20 thousands inserts

I'm having some issues with the method
java.sql.DatabaseMetaData#getTables(String, String, String, String[])
and Microsoft's SQLServer JDBC driver.
According to the javadocs in the following code the ResultSet r should

This is a little long winded, but please bear with me.  There is a lot
of background necessary to explain my questions.
My application has been heavily using Oracle 9i stored procedures that
return 'reference cursors' for some time now as a performance

I have been reading a lot of posts and websites about not creating
your own threads in a servlet and that you should not do it because it
is bad practice and will be illegal in the future.   What I don't
understand is why and what the alternatives are.  All I every see is

I do this:
SELECT a Set of records from database
compare this with another Set
If they are the same I UPDATE, INSERT & DELETE to the database

I dont know what the type of connection is called, but I know it is
the worst kind.  Through a servlet, lets say I open a oracle 9.2
connection, run the query and then close the connection, will this
hurt the oracle server in terms of performance.  I know this is the

I am considering using Hibernate in some project i am working on. i looked
at the supported databases and MS Access is not one of them.
Is there anything i can do to make it work with MS Access?
P.S. I am using a JDBC-ADO bridge (www.infozoom.de) to connect to MS Access

FWD From the hsqldb codebase Maintainer:
The first Release Candidate for 1.7.2 is available in the file download
section.
Recent enhancements include support for SEQUENCE objects. The documentation

All - Cannot be too precise since I heard this from secondhand from one of
my developers but thought I'd throw it out here and can provide more details
later if needed... He (the developer) is trying to insert roughly 1 million
rows into an HSQLDB database. He notes that 100k ...