I'm working on a java application and I've gotten stuck on an SQL
problem.
Consider the following query...
SELECT status

I've recently been studying Hibernate with a view to using it for future
application development, but I must say that I've found the whole
experience quite disenchanting. The need to maintain all that additional
XML configuration info adds a fair bit of overhead to the ...

I am working on a Applet at the moment which must be able to access an
MS Access Database.
I need to be able to setup a jdbc connection to an Access database.
Does any body know of any webpages on how to do this?

hi guys...why do i get an "invalid cursor state" error when i execute a
query with a group by?  the query works fine in MS Access but when i use it
with a resultset, it gives that error....thanks...

When trying to output a rather large database (around 10M rows) to a
textfile I get a memory problem that I guess has to do with the
ResaultSet (see a part of the code below). Is there any way in java to
get data direcly from the db NOT using ResultSet, something like a

I have an AS400 table and SQL server table and need do a JOIN in a
select, I did this:
SELECT GNORP.COORG, GNORG.ORDES, GNORP.CPAIS, GNPAI.PADES, GNORP.ORV01
FROM ((GNORP GNORP LEFT OUTER JOIN GNORG GNORG ON GNORP.COORG =

Hi All, This is quite a desperate cry, i've been trying to solve this
problem now for over a day and a half, I've seen lots of other threads
on google with the same issues and have have tried each solution I found
but to no avail.

I previously had several Java servlets that ran great on my Windows
2000 box.  All of my servlets basically just run SQL queries against
an Access database and print the results to the browser.  So, I had
Data Sources set up to point to the Access databases under Control

i have a gui based application which conects a MSSQL-server 2000.
I have buttons such as first-previous-next-last buttons to navigate
throught the database. I am using scrollable resultset
 st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,

I have a simple application that has been using standard serialization
for the save format.  I have a small user community; no one has
complained about the save format breaking with each new version
(because I change class structure).  But ... it is kind of

am facing problem while iterating through while(rs.next()).
I want to retrive userid from my database through username criteria.
I wrote one simple query for that.
But after getting connection,statement and executing query,at the time of

i search to use sun.jdbc.odbc.JdbcOdbcDriver on my Tomcat Webserver
and i have following error message.
Could you explain my mistake
Thanks

Below is my Java Program..there's no error when compiling but i cannot run
this file..
It stop executing when it reach the INSERT INTO statement.. Anybody knows
what's wrong?

I'm running an applet which should have a connection to a microsoft sql
server 2000. I've downloaded the JDBC Driver from the Microsoft site and
installed it. Now everytime I start the applet the console throws the
following message out:

Hi all
Please tell the meaning of " Degree of derived table does not match column
list" this error.
i am getting this error when i am trying to edit the data in mysql database