Hello, I am searching for a database as many other people are as well in
this newsgroup it seems. I have a free open source project that is
programmed in Visual Basic 6 and it uses MS Access .mdb database via
ADO. It seems that now it's time to switch to some other programming

I have a class with several methods that need to use data from a db
(jdbc). Is it a good idea to add the basic connection code in each
method or is there a better way , my code (one small file)
http://jonasg.ath.cx/jdbc/dbcon.java

Good Morning,
I've a Servlet with inside the doPost() method a connection to a dB,
the problem is that is a long query that work ok if launched on the dB
with something like TOAD and also works well on (JbuilderX + Tomcat)

I am somewhat new to JSP/Java world so don't flame me...
I am trying to generate a report of top 10 salespeople for each region
from an AS/400 data source.
It all works nicely except when I try to compare current region with

Just downloaded Sun's Early Access implementation of JDBC CachedRowset
(Rowset) [3].  I am trying to create (manufacture) a CachedRowset without
any direct links to a backend database.  These are my steps:
i.  Create a RowsetMetaData object (which defines the fields/columns etc);

I work on web-portal which is based on java. The rdbms I use is SAP DB 7.4.
My problem is that the SAPDB JDBC-driver writes a trace-file (which is a big
big big problem when you use it in connection with an applet --> I know: I
can modify the policy file or digitally sign it... --> ...

I say this about Oracle and dates in the Java glossary.  Somebody
wrote and said it was not true. I did not generate this from first
hand experience. What is the truth?
Oracle SQL databases expect dates stored to be presented in UTC, yet

I'm using MySQL Connector/J 3.0.11-stable,
My app compiles fine but when I run it I always get these errors:
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(DriverManager.java:532)

I am using borland's JBuilder X to connect to an access database (existing
project) via odbc.
The problem is that my queries don't like the "GROUP BY" clause.
If I omit the GROUP BY clause, the table fills up correctly,

is there anyone here who knows about OracleCachedRowSet?
My class calls a method in an existing DAO class which returns an
OracleCachedRowSet to me, containing data from the database. Do I need to
"close" this object after I have used it?

I am writing a bit of code that needs to execute two select statements
on two tables in the database - select 1 on table 1 and select 2 on
table 2. Once I have executed the statement 1 on table 1, I need to
ensure that no data is entered into the table 2 before I can execute

FileMaker Pro 7, IBM DB2,  - new !
23/Mar/2004
B02 FileMaker Pro 7
IBM DB2 UDB ENTERPRISE SERVER EDITION V8.1                      10 322

Hi, I'm new to this newsgroup...
How can I write a date/time to my acces database?
   Jdbc only supports java.sql.Date witch doesn't saves the time and
java.sql.time witch doesn't saves the date.

DB: Oracle8i Enterprise Edition Release 8.1.7.4.0
Thin Drivers
I use the "standard" trick to get the size of a ResultSet (scrollable)
--

I need some help with the syntax for properly calling the wasNull()
function in JSP.  (I'm using Win2K and Tomcat 5.0.19 with Oracle 8.1.5
and Mozilla 1.6 )
I have a table in which some records for a column may be null.  It is a