how can be a difference between an output of a query executed from the DBMS
(MSAccess, correctly 4 records as output) and a query executed from the
piece of Java code below (1 record output in the ResultSet) ??
I'm really crazing about it.

Could you help me to definy a trouble.
I wish see data retring db connection in a JTable.
Could you mailing an example.
Thanks.

Im connecting to Oracle 8.1.7 (running on a MS Windows Server) from a JBoss 2.4.10,
running on a Linux box. The code that generates the problem looks like this :
String query = "SELECT some_fields FROM some_table WHERE id = ?";
Prepared Statement ps = conn.prepareStatement(query);

I use a controller servlet and some action classes. Whats the best way
(preserving resources) to create new connections and close them
properly? Do it in the controller and give it to every action class,
or do it directly in every action class?

Topic: When is the Exception thrown in case of Oracle driver when
calling a stored procedure
Hello all, For executing a stored procedure one does something like
the following:

Okay guys,
Iv posted a lot here lately and i really appreciate all the help.
Here is my error messages listed below.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for

I have a problem with closing connection. I use DataSource to connect and at
the end of my function i call conn.close() and if i check with
conn.isClosed() it returns true, but there is still one connection opened
and every time my funciton is called, one more connection is opened, ...

I have a problem with the hsql driver.
When I try to read datas from an csv-file the program
crashes and the JBuilder says something like this:
java.sql.SQLException: Unexpected token: TEXT in statement [CREATE

I have a problem with open cursors in Java. I'm connecting to Oracle
with a jdbc driver and I've found the
next error: "Max Open Cursors Exceeded".
I've read many messages about this issue but this error follows me.

I was wondering if anyone could help me out. Im a student and im
making a project where i can access data in my Microsoft SQL 2000
local database, change it, delete it, ect.
I have all the groundwork laid out but im having problems with the

I'm working to a porting from python to java of a project about a
object's dbms, but i have seen any problems.
I must translate a primitive called "btopen" that returns a "btree"
object. I would like to use a structure already integrated in java, but

I have a database that can be accessed through an OLE DB Provider and am
interested in accessing that data through a JDBC driver.  Does anyone
know how this can be done?
Thank you,

Can anybody help me with this problem? :
I'v got a database of news in an XML file that looks like:
<?xml version='1.0' encoding="ISO-8859-1"?>
<news>

I want to use JDBC to connect a remote MS Access/MS SQL database,
however, I found that JDBC-ODBC is not support on remote database and
Linux.
I've visit the site of some middleware, like RmiJdbc, IDS,....

If a system requires ad-hoc querying of a DSS-style DB,
is either JDO or CMP a good choice over vanilla JDBC?
In either the JDO or CMP worlds, aren't the queries known
a priori, which would make both of them unsuitable for my