Search Discussions

34 discussions - 147 posts

  • Hi, When using the ps.setMaxRows() call on PreparedStatement, the jdbc driver sets the row limit via the "raw" postgres protocol. However, in the words of Tom Lane, "the row limit in the protocol ...
    Sebastiaan van ErkSebastiaan van Erk
    Jun 21, 2006 at 9:18 am
    Jul 20, 2006 at 7:54 pm
  • Hi there, My question relates to trying to implement the binary transmission protocol for an Array type. I understand that the only place the format is documented is in the Postgres C source code. ...
    Michael GuyverMichael Guyver
    Jun 21, 2006 at 5:33 pm
    Jul 10, 2006 at 6:59 pm
  • This is just proof of concept. More work has to be done to make it build properly and work properly under different jdk's Couple of questions. 1) What to do if there are multiple concurrent requests ...
    Dave CramerDave Cramer
    Jun 19, 2006 at 4:55 pm
    Mar 5, 2007 at 6:29 am
  • There's an inconsistency between the handling of trailing whitespace in query parameters in the client jdbc driver compared to the PL/Java SPI based driver. According to Jean-Pierre, the former ...
    Thomas HallgrenThomas Hallgren
    Jun 27, 2006 at 4:57 pm
    Jun 28, 2006 at 6:20 am
  • Hi, I want a PostgreSQL trigger or rule that notifies a JBoss deployed J2EE application of a certain event. I was hoping that pljava would work, but for some -yet unknown to me- reason, it does not ...
    Joost KraaijeveldJoost Kraaijeveld
    Jun 22, 2006 at 10:59 am
    Jun 22, 2006 at 4:29 pm
  • Hi ! I get the following exception when I read a simple TXT file in Linux and try to INSERT to the psql. (8.1.4) org.postgresql.util.PSQLException: ERROR: character 0xefbfbd of encoding "UTF8" has no ...
    Bakos SandorBakos Sandor
    Jun 2, 2006 at 7:46 am
    Jun 2, 2006 at 5:27 pm
  • Hello everybody! Today I have found a strange bug in JDBC driver (I used the last version avilable - 8.2dev-503). The problem is with VARCHAR fields - driver returns "-1" on "getPrecision()" call. ...
    Sergii SinelnychenkoSergii Sinelnychenko
    Jun 22, 2006 at 3:19 pm
    Nov 3, 2006 at 7:22 am
  • The current postgresql driver has some memory issues when reading bytea fields from the backend. The problem is in the class org.postgresql.util.PGbytea, in method public static byte[] toBytes(byte[] ...
    Luis Vilar FloresLuis Vilar Flores
    Jun 13, 2006 at 12:49 pm
    Jun 30, 2006 at 11:24 pm
  • I was wondering what the status is for getting CallableStatments to run via executeBatch() to get inserts done in bulk. I've been attempting to get this to work on 8.1.4 with the 8.2 503 driver. ...
    Yukino MiyazawaYukino Miyazawa
    Jun 30, 2006 at 12:47 am
    Mar 5, 2007 at 5:26 pm
  • I'm trying to use the datatype defined in the uniqueidentifier contrib module from within my java application. I had originally thought I would process the values in java as strings, but I can't ...
    Jun 28, 2006 at 4:33 pm
    Jun 30, 2006 at 8:05 pm
  • Hi! Last week we tried to use the 8.1-407 JDBC 2EE driver with PostgreSQL 8.1.4on Debian. We use data sources in JBoss. The web application always run out of memory with this driver. Then whe changed ...
    Tamás BartaTamás Barta
    Jun 28, 2006 at 10:01 am
    Jun 29, 2006 at 7:35 am
  • Hi, I am using Postgresql 7.4.1 and pg74.214.jdbc3.jar. Postgresql is started under port 52008. I am using a java program to connect to the database. I am using java1.4.2_07_b05 on solaris. I am ...
    Vijay Kiran KamujuVijay Kiran Kamuju
    Jun 28, 2006 at 6:48 pm
    Jun 28, 2006 at 10:37 pm
  • Ok. This is a really weird thing I'm running into. Funny thing is, the thing ran OK until two of the tables were set with the lock-when-loaded consistency level. This is with Sun Java AS 8.1, using ...
    Jun 21, 2006 at 6:22 pm
    Jun 22, 2006 at 9:25 pm
  • Dear group, Let me explain my issue. We use Database - postgresql-8.1 JDBC Driver - postgresql-8.1-407.jdbc3.jar Java - jdk1.5 The default transaction isolation level is - Read Committed Auto Commit ...
    Jun 16, 2006 at 6:15 am
    Jun 16, 2006 at 12:15 pm
  • HI all. I have a function called: dbcmp( t varchar, p varchar[], c varchar[], n INTEGER ) RETURNS SETOF dbcmp_t ... Today, I call my function like this: String sql = "select * from dbcmp('" + t + ...
    José Arthur Benetasso VillanovaJosé Arthur Benetasso Villanova
    Jun 14, 2006 at 7:04 pm
    Jun 15, 2006 at 12:53 pm
  • i have a cloumn in my table which is date type i parse a file to get the date from there, and then i form a call to the stored procedure, with the above data as the parameter. but however it seems ...
    Jun 7, 2006 at 11:49 am
    Jun 7, 2006 at 1:47 pm
  • Hi Oliver and Dave, I agree with you. I could use conn.commit(), but I have a particular environment here and I'll try to explain. My application use XML in my business tier to create and validate my ...
    Rodrigo Willian BonattoRodrigo Willian Bonatto
    Jun 5, 2006 at 5:22 pm
    Jun 6, 2006 at 5:41 am
  • Hi, I have a problem using transactions with PGJDBC 8.0 or greater. For example: In the database I have the following record in the "employee" table: name age John 27 If I use the PGJDBC 7.4 to ...
    Rodrigo Willian BonattoRodrigo Willian Bonatto
    Jun 5, 2006 at 1:02 pm
    Jun 5, 2006 at 1:25 pm
  • Boa noite, Estou tentando fazer uma conexão no postgreSQL utilizando a linguagem jsp. Vocês podem tirar essa dívida para mim. Grato --------------------------------- Yahoo! Search Música para ver e ...
    Christiano TavaresChristiano Tavares
    Jun 23, 2006 at 10:42 pm
    Jul 10, 2006 at 1:48 am
  • Hi: I think setObject() has been discussed extensively on this list (particularly with setting null values). However, consider the following: In PSQL: test=# create table foo (number_column int); Now ...
    Jun 28, 2006 at 10:46 pm
    Jun 29, 2006 at 12:55 am
  • Is there any action being taken to expand the postgres jdbc to build under the 1.6 jdk? I'm interested in helping if there is. -- Maya Nigrosh Eddy Project/ISAM Group Carnegie Mellon
    Maya NigroshMaya Nigrosh
    Jun 19, 2006 at 6:09 pm
    Jun 19, 2006 at 6:22 pm
  • All, I am looking for the source code for the 7.3 Build 113 that matches the pg73jdbc3.jar file binary code. Do you know where I can find this source code? Thanks, Wes
    Wesley J GyureWesley J Gyure
    Jun 19, 2006 at 1:48 pm
    Jun 19, 2006 at 2:43 pm
  • Good day all, I have postgresql 8.1 (on WINXP service pack 2). I have a table t_users with the columns id (serial), username ( varchar(256) ), and password ( varchar(256) ) The database was created ...
    Yair ZasYair Zas
    Jun 18, 2006 at 8:10 am
    Jun 18, 2006 at 8:26 am
  • Hi there, I'm interested in leaning the status of XA support in the JDBC driver. The FAQ says this: 1.1. Does the driver have XA support? Yes, starting with the 8.1dev-403 driver XADataSource support ...
    Stefan ArentzStefan Arentz
    Jun 13, 2006 at 2:04 pm
    Jun 14, 2006 at 3:01 pm
  • Hi Is there any way to get a column's description (As defined using COMMENT ON [TABLE_NAME].COLUMN_NAME] IS ) and/or table name from the ResultSetMetaData or from the ResultSet, without actually ...
    Jun 12, 2006 at 5:14 pm
    Jun 13, 2006 at 8:04 am
  • Can someone help me with this error "An I/O occurred while sending the backend" i get this when i am trying to insert a new row, and when i do not get this error, then 2 rows are inserted i am using ...
    Daxel SakasakiDaxel Sakasaki
    Jun 8, 2006 at 4:24 pm
    Jun 9, 2006 at 2:10 am
  • Hi, am actually using postgres8.1.4 and JDBC driver 8.1-4.0.7. With this am having a problem with database encoding. I've created a db with encoding LATIN1 and having problem when inserting for ...
    Gulshan BabajeeGulshan Babajee
    Jun 5, 2006 at 4:46 am
    Jun 5, 2006 at 5:22 am
  • hi, I'm tring postgresql-8.1-407.jdbc3.jar (with PG 7.4.3 srv) and CachedRowSet (Sun implementation). I have a small test table: it has two fields: 1) id SERIAL NOT NULL PRIMARY KEY 2) info ...
    Jun 2, 2006 at 3:18 pm
    Jun 2, 2006 at 3:47 pm
  • unsubscribe
    Diego GaviolaDiego Gaviola
    Jun 26, 2006 at 10:47 pm
    Jun 26, 2006 at 10:47 pm
  • Hello guys, I just want to thanks the community for the great work around PostgreSQL JDBC. With your help, we were able to migrate a 500gig oracle database to PostgreSQL. We moved our java ...
    Kuon - Nicolas Goy (Goyman.com SA) - 時期精霊Kuon - Nicolas Goy (Goyman.com SA) - 時期精霊
    Jun 25, 2006 at 11:20 pm
    Jun 25, 2006 at 11:20 pm
  • Hi, What is the preferred way to update a largeobject where the size of the update is smaller than the original file? The only way I can think of is to remove the original largeobject then write the ...
    Michael BurnsMichael Burns
    Jun 13, 2006 at 5:12 pm
    Jun 13, 2006 at 5:12 pm
  • Hi, Had anybody success with using sun jsas 8.2 (PE, on linux) with postgresql 8.1 (8.1.3 in my case)? The configuration seems to work ("ping" works), but it ignores "port" parameter. It will connect ...
    Gábriel ÁkosGábriel Ákos
    Jun 10, 2006 at 10:41 pm
    Jun 10, 2006 at 10:41 pm
  • (Copying list) Since that thread I did some more testing, and ran into trouble on the server side as well, so we gave up on XA for now. I don't know if I could get you a formal patch, except for what ...
    Jan de VisserJan de Visser
    Jun 7, 2006 at 12:42 pm
    Jun 7, 2006 at 12:42 pm
  • Hi, I noticed that I have committed an error: the excpetion isn't raised from JDBC driver but from CacheRowSetImpl. I will send a post to sun-maillist. Exception in thread "main" ...
    Jun 3, 2006 at 7:28 am
    Jun 3, 2006 at 7:28 am
Group Navigation
period‹ prev | Jun 2006 | next ›
Group Overview
grouppgsql-jdbc @

47 users for June 2006

Dave Cramer: 21 posts Oliver Jowett: 16 posts Kris Jurka: 13 posts Mark Lewis: 7 posts Markus Schaber: 7 posts Thomas Hallgren: 7 posts Tom Lane: 7 posts Till toenges: 5 posts Joost Kraaijeveld: 4 posts Michael Guyver: 4 posts Sebastiaan van Erk: 4 posts Heikki Linnakangas: 3 posts J.random.programmer: 3 posts Luis Vilar Flores: 3 posts Surabhi.ahuja: 3 posts Bakos Sandor: 2 posts CG: 2 posts DanixDefcon5: 2 posts Rcolmegna: 2 posts Rodrigo Willian Bonatto: 2 posts
show more