Hi, for a proto type i'm implementing a join-operation (as in relational
databases) on potentialy huge tables in java.
if implemented naively, this takes at least size(Table1) * size(Table2).
my plan was to put the keys of the smaller table into a hashtable and than

How can I make a query such that in the "WHERE" part of my clause, I want to
put something to the effect that, say, X days have elapsed since a given
date.
For example, suppose in my table, I have a boolean field and a date field.

I am trying to find out whether there are any known bugs
with Oracle's JDBC drivers that I need to be on the lookout
for. I am going to be using Java VM 1.4.2.02 on Slolaris 9,
connecting to Oracle 9.2.0.

 I have following problem scenario .....
 I have a XML of the format ....
 <Data>
  <Employee>

I have a RDB table where many rows are for 1 employee.
The application reads the rows for a certain employee.
The rows are mapped to Objects and these objects are modified by the
application.

Cannot create database connection pool when following Tomcat 5 JNDI Datasource HOW-TO. The exception is
Cannot create JDBC driver of class '' for connect URL 'null'
Seems that the variables for DB driver class and connect URL are not passed to the servlet container. But what I did ...

I am looking for a excellent and fast developer to convert my existing Java
program using (1.3.1) to the newest version of Java.
The program uses Graphics and database routines.  Review web site
http://www.uprealimager.com

Suppose I have a table, and it is populated with many rows already. However,
I realise I structured something wrong in my table. I dont want to have to
go back and repopulate the entire table.
For example, suppose I have a field:

I'm searching a jdbc driver that would be optimized for localhost db server  
communication layer. (linux, if platform dependant)
DB servers may work without tcp/ip (like mysql for example), straight on
kernel's inter-process communication facilities (pipes...)

I am going to be developing a little app which works with an Oracle 8i db
and will be java desktop application running on Windows 2000. Previously I
had been developing using Oracle 9i and .NET (ODP.NET). So I would like your
advice on how to get started. I would appreciate your ...

I am using a Callable Statement to run a stored procedure in the database.
The stored procedure takes an input parameter and passes an output parameter
of type int.  The output parameter is used to perform a test to see if the
stored procedure worked properly, or passed some logic ...

I've googled hours for detailed information on this topic, but both the
Oracle technical network as well as Google have let me down.
The situation is that I get a resultset (a cursor) from a stored
procedure, but this resultset (a nested table) contains objects created

I am new to MS SQL and JSP and am having trouble finding documentation
or code examples for this feature.
I do an INSERT into a table with an IDENTITY column, then want to
retrieve the value from the incremented IDENTITY column in the row

I'm having a problem with the following stored procedure.  
I have a connection pool that I return my connections to after use.  I
close all the resultsets and I even close the statement before
returning the connection to the pool.  However, I always end up with

Folks,
I really hope I am doing something wrong here as it is driving me
nuts.
I have a database table defined as follows: