I am working on refactoring my companies search engine, and a
critical component of the search is that the results be displayed very
quickly.  We have done enourmous work on making the queries fast
(under 1 second), but the bottleneck always seems to be how we process

How can I do an update to a table where I dont want to allow records to have
a field(s) which occur in another record, whenm each record has a unique
integer id. For example, suppose I have a table setup as:
       "id INTEGER(11) PRIMARY KEY NOT NULL AUTO_INCREMENT," +

Ive created a small application in SUNONE STUDIO 4
databse server-pointbase.
It runs well in IDE.
When i create an executable jar ,

I'm trying to connect a simple javaprogram to a MySQL-database.
Do someone have a codeexample of a working program thats does a simple
selectquery and then print the answer on the screen. Lets say it should
print the famous word - HelloWorld. It should be "from the beginning".

SET PATH=C:\WINDOWS;C:\WINDOWS\COMMAND;C:\j2sdk1.4.1_01\bin;C:\MSSQL7\BINN
SET windir=C:\WINDOWS
SET winbootdir=C:\WINDOWS
SET COMSPEC=C:\WINDOWS\COMMAND.COM

I use the following code to query a column that contains a long data
type in an Oracle DB.
 String SQL = "select .....";
 ResultSet rs = statement.execute(SQL)

I found out that the MS JDBC driver is terribly slow when doing anything
slightly more complex than "select a,b,c from x". Keeping it that simple
gives a fast response. But adding even a simple where clause makes it very,
very slow (from 2 seconds suddenly down to 45 minutes). We've ...

I've created a class which should help me handling SQL request to the
database : SQLHelp.
I use this class as a base class for all the classes that need to get or put
data in db.

When I do a query in my database I get no results. Can someone tell me away
around this.
Select * From Table1 Where row = 80-11111-1
The dashes are my problem. Thanks.

Hello Can anybody help me with this ;-)
say I have an sql statement with place holder variables in it
in oracle
String sql = "select * from student where id = :1 and name = :2";

If I have an applet, which is donwloaded  to the local machine from server
A, and calls a servlet on server B.....can that servlet, via JDBC, access a
database on server C, assuming each of server's A, B and C are on separate
machines with separate URLs ?

Hy all,
For a few days, i have problems to instance a datasource from my Entitybean
EJB
jboss release is 3.2.2 , MySQL 3.23.38

I am wishing to write a Java application for the IPAQ. I have installed
Jeode and reading the literature, Jeode meets a number of specifications
including J2ME CDC/Foundation Profile
However I wish to install JDBC(TM) Optional Package for CDC/Foundation

I try to write a JDBC program, that calls stored procedures in a database
independent of a name and arguments list. To get a result of a query I must
call one of the functions int getInt(), int getString() etc. of
CallableStatement. I'd like to write a wrap function, for instance

Calling statement.executeQuery() hangs, anyone experienced this? Using
the Oracle thin driver v9.2.0.1.0 running on a Solaris 8 box. The
code:
 Connection connection = cdrDataSource.getConnection();