I have a problem with java and PostgreSQL. When I type:
connection =
DriverManager.getConnection("jdbc:postgresql://"+host+":"+postgresPort+"/thesis",
user, password);

Hi. I've got an Oracle stored procedure with an
user defined output parameter my_array_type:
describe my_array_type;
 my_array_type TABLE OF VARCHAR2(30)

In oracle, if I need to get the sysdate, I would do some thing like this
   select sysdate from dual;
And if I need , the difference between sysdate and a specific date ,say
"pdate" ,I would do,

HI;
  I have MySQL running on a mandrake Linux box.  I installed MySQL
Query Browser client. I added a user to my MySQL called zico. I was
able to connect from MySQL Query Browser to the database and run a

can anyone explain to me how one might implement the classic
"Person/Friend" problem using Hibernate?
in relational land a "Person" table has an ID and some info and a
"Friend" table is a self-join of the "Person" table -- that is, the

I am currently using oracle/jdbc/lib/classes12.zip to connect to
Oracle8i:
String driver="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@serverName:1521:dbName";

I'm not a PL/SQL guy and I need to load data to Oracle tables from
Excel Spreedsheets.  Can anyone show me an example of a program/script
to do this?  Or maybe just some direction to follow?
Thanks

We need to use the Oracle specific jdbc features such as mapping an Java
object to a Oracle Type and for that reason we need to cast the
connection and statements returned from the jndi datasource to Oracle
extensions, such as the code below:

Can anyone please advise me with the following problem:
I have an html file containing a list as follows:
<Select>
<option value ="T1"> prod1

I'm using java servlets with jdbc to query MS sqlserver.
Some of the queries can be large i.e. querying a table of 1 billion
rows and resultsets of 1 million rows. The queries
are all read only looping through the resultset up to a maximum

Sorry for my poor english on the size of the post.
I have a critical problem with a prepared query and bind variable in Java.
I try to execute the following query which do return one row :
select aclient.cli, bknom036.mnt1 tcli, aclient.nom, aclient.pre,

I have a stand alone Java application that uses MS SQL Server 2000 and
Microsoft JDBC ODBC drivers to access it. Before I run the application,
I open the task Manager to monitor the memory used by the SQL Server.
Generally it begins 21 MB and very soon it reaches around 100 MB if I

Hello, I've got a big memory problem :
I get many ResultSet from preparedStaments. Then when I call the
getString(), most of the Strings are not collected by the garbage
collector and it corresponds to huge memory.

I am in the procees to implement private area to our main webstite on
the internet. The private zone will allow authorized individual person
inside and outside the country to view his/her own data and transaction
For membership sign in, if they have paid. Payment would be made ...

I am having a problem with an application I am involved in.
SCENARIO -
We have a client/server app. Client sends a database request to a
server and the server does the database access and sends the response