I am a java programmer used to using oracle database.
In my new job, we have oracle plus sybase database. Some applications
use oracle and some use Sybase. I am writing framework, so it can be
used by all applications.

I'm using Oracle 8.0 as database..for which i have created a new TNS
entry with my own SID. I tried a demo run of my app, which was running
fine..and was able to connect to the database as well. Bu recently i
have subscribed to a broadband service...and after the same i try to

I am starting a new application, it needs to use db such as access or
msde.  I know I can do this easily in c# or Java but my question is can
I distribute  a package as easy if it is created with java and say derby
db as I can with windows based.  It needs to be click to install ...

   "Mytable" contains more than 79,000 records
    my query is"select * from Mytable"...while processing Resultset I
got OutOfMemory exception.
I tried to solve it using cursors as follows.....

I am new in jdbc so plz send me
Oracle jdbc connection example source code with some explanation

When I
   select * from XX
I'm geting an OutOfMemoryError.   I'm using JDBC with Mysql,
and calls like:

We have a large database size( 80 million records).  How to handle such
a large database effectively using Java?