Re: The new driver and PostgreSQL7.1.3
От | Dave Cramer |
---|---|
Тема | Re: The new driver and PostgreSQL7.1.3 |
Дата | |
Msg-id | 002c01c18984$c50593d0$c201a8c0@inspiron обсуждение исходный текст |
Ответ на | The new driver and PostgreSQL7.1.3 (Chantal Ackermann <chantal.ackermann@web.de>) |
Список | pgsql-jdbc |
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@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Chantal Ackermann Sent: Thursday, December 20, 2001 1:12 PM To: pgsql-jdbc@postgresql.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@postgresql.org so that your message can get through to the mailing list cleanly
В списке pgsql-jdbc по дате отправления: