Hi. I'm using Visual Age for Java (3.5.3). Problems with
prepareStatement. Basically it used to work and now doesn't. On
inspection I've found strange behaviour. using
sqlStatement = connection.prepareStatement(sqlString)

Does anyone know what has to be set in the PostgreSQL pg_hba.conf file to
allow all incoming TCP/IP connections?  Any help and/or example would be
greatly appreciated.  The PostgreSQL docs are beginning to get to me.
~ Matthew

I hava a problem: I would like to call Oracle stored procedure with clob
parameter (IN), but my code creating clob object with some data throws
exceptions. Could You show me some code creating Oracle clob object with
some data (taken from string object), which then will be pass as a ...

The problem we have is that our JDBC driver (JSQLConnect) prepends any
String parameters in PreparedStatements with "N".  e.g.  "Select *
From Customer Where SSN= N'123456789'".  SQL 2000 then assumes that
the column is a Unicode NVarchar, NText, etc., even if the column is

Hi, All
Can I make a jdbc connection to MS SQL Server 2000 wich is configured with
windows only authentication?
If yes, than can I make it from linux? May be throw jdbc-odbc, unixODBC?

Just looking for pointers to likely technologies here ... I have a Java
webapp running in Tomcat. It manages a relational database, in which
some of the tables can be interpreted as a directed acyclic graph (DAG).
For those who aren't familiar with the term, think of it as your ...

we are using the JdbcOdbc-Bridge to access a Microsoft Access Database
from Java 1.1/Microsoft VM. (Access XP is installed on the same
machine)
(I know, I know, this isn't exactly the perfect combination for a

I'd like to get some ideas on best object design for using multiple dbs
e.e. Oracle and Sybase. In the past I've only done some re-writing of
apps to point at either DB and just did some and then use a case
statement, looked at the JDBC driver class name. If it had the word

Bonjour,
  Je suis présentement en train de faire un programme en java qui
prend les données d'une base de données sur un serveur et les ramènes
dans une autre base de donnée situé sur un autre serveur.  J'ai donc

I have a problem executing PL/SQL block using Java Connection.
What I want is I have a Pl/SQL which prints the values using
dbms_output.print function
now this output i get spooled in a txt file when I execute that PL/SQL

I'm having a very confusing problem with my application...
The problem is when I try to load JDBC drivers when my app is in a jar file.
Here is a test case:
public class Test

I am trying to resolve a problem using JDBC and our ODBC-compliant database
engine.  We use the compiler-defined wchar_t to store Unicode data in our
database.  Now, using ResultSet.getString(), I cannot retrieve the Unicode
data from our database.  Does getString() expect the ...

Let's suppose that I have this method:
public void doUpdate() throws SQLException
{
 java.sql.Connection conn;

First of all I am sorry if this is a FAQ but I couldn't find any for
this newsgroup. Please be kind enough to redirect me to it, if it
exists!
I have a JSP application running on Apache and I have to query a SQL

I need to be able to get data out of the server and into a simple xml
representation. I think this should be really very easy. However having
tried to use the extension that was added to SQL Server 2000, which was
supposed to help with just this very problem, I have been left ...