G'Day all,
Thought I'd make a post to see what other people think of something I
just started to think about..  I'm developing a swing based App, at the
moment during development i'm switching between using mySql & hsqldb as

Hello I'm trying to learn how to work with stored procedures in Oracle and
java. I deal fine with ResultSets and PreparedStatement now I want to use
functions and CallableStatement.
I wrote my code looking at this sites:

 I use Oracle 10g as my backend repository. I am trying to do some
performance analysis against this DB.
All I need is time spent by DB for a particular query.
I used statspack to capture DB statistics. But, I am not able to

hello everybody....
I need to create a database for my office. Trucks come in, deliver goods
which we have to give out to customers (as we get them, no different items,
just different airwaybills) and then bill somebody for all the sweat and

I have a database design issue. Let me first state the problem.
A user stores his transaction details like
order id, user id, order desc, amount spend, transaction currency
into a table. Each user has an own-currency associated with him.

I am using Oracle 10g for retrieving XML documents as XMLType and
manipulate them in Java, using the method
org.w3c.dom.Node.setTextContent() to set the text child node of a DOM
node. The oracle DOM implementation just appends a child node to the

After reading lots of docs, a got the impression that it is possible to
write an Java Applet, that uses jdbc to connect to MS SQLServer (Without
 flushing all security permissions down to drain).
Here is what I've done:

I have a quick question. Which is faster as a preparedstatement in a
loop (ie, doesn't get reparsed)?  Does anyone have a definitive answer
and not a hunch like me?
1) insert into aaa values (?,?,SYSDATE)

i must compare efficency of tomcat vs ibm websphere server. also i have to
point mysql or prostgrsql as target database system. im trying to run xwiki
(http://www.xwiki.org/) as example application.
doeas anybody know any application that could measure server efficency both

I have to extract the data from several tables (Oracle is the database)
and insert them into a file, in a specified format.
Each column will be allocated a certain size (filled with empty spaces if
size is too big), and I will assign a line for each record extracted from

I'm new to this, so bear with me!
I have a web application which is for installing on multiple other
users' servers (running Tomcat). I want to use connection pooling, but
I don't want users to have to set up data source information in their

I wonder if someone could send me or provide me a link for an
*evaluation* version of
Pointbase Micro.
I subscribed on their website with my compagny's email address and tel

I want to use the MS-Sqlserver's OPENXML function in my java application (to
load data from xml file into database)
I am using mssqlserver.jar (JDBC fro sqlserver by MS).
Can somebody tell me how do i execute the OPENXML function from JDBC.

I am looking for a driver for SQL queries on .csv files.
The driver should be able to deal with both local files and remote
files.
Does anyone familiar with something like that?

is it possible to extract data from a web based java applet in order to
enter that data in mysql?
for example, something that would let me extract the data shown in applet on
http://gcitrading.com/forex-quotes.htm and enter it in mysql. The data needs