Re: The new driver and PostgreSQL7.1.3

Chantal,

The answer to your first question is that they can be used together.

The answer to your second question will require more information. Can
you send the table definition, and the insert sql

DAve

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Chantal Ackermann
Sent: Thursday, December 20, 2001 1:12 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] The new driver and PostgreSQL7.1.3

Hello all,

I' d like to use the new postgres driver without installing a new
postgres
(for the moment). My current PostgreSQL version is 7.1.3. I downloaded
the
driver jdbc7.2dev-1.2.jar. I get a connection, but I still want to be
sure
that the name of the jar does not mean that it can't be used together
with
the 7.1.3 version of the database.

My second question refers to the PreparedStatement. I would be satisfied
with
a link to a precise docu (or an answer, of course).
I have use as data types in my tables CHAR(4) and TEXT (and others). to
insert data into columns containing these data types I use
PreparedStatement.setString(int, String).

I get the Exception:
java.sql.SQLException: ERROR: Unable to identify an operator '='
for types 'int4' and 'text'
You will have to retype this query using an explicit cast

at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at
org.postgresql.jdbc2.PreparedStatement.execute(PreparedStatement.java:76
5)
at
de.biomax.geda.sql.DBManager.insertGeneData(DBManager.java:300)

the message is quit clear, however, I don't know where and what exactly
I
have to cast to make this work. On the other hand, if it would be better
to
change the column data types I could do that without problem. I've
chosen
CHAR(4) out of performance reasons.

thank you for any help!
chantal

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly