[JDBC] Inserting text and binaries in OID column

Hello, I'm new in this list so I don't know if this question has been asked before. If so, sorry. The question is that I'm trying to insert text and/or binaries in an OID column but I can't find the way to do it. I have tried to use the code in the documentation (section "Using large objects") but

[JDBC] deleting large objects from jdbc

Hi, I've been browsing the newsgroup archives and came across the following: > > > > > Can you see a scenario where a programmer would forget to delete the > > > > > data from pg_largeobject and the database becoming very large filled > > > > > with orphaned large objects? Does this mean that

[JDBC] JDBC 2.0 conformance, documentation and todo list

Hello, I've created a web page that aims to document the level of conformance of the JDBC driver to the JDBC 2.0 API. It also aims to document any deviations from the JDBC standard that have been found. http://lab.applinet.nl/postgresql-jdbc/ No need to say its still far from complete. I just wr

Re: [JDBC] cast in JDBC update

On 07 Aug 2001 13:39:09 +0200, you wrote: >I am trying to update a field which contains an array of >type INT4 via JDBC. Java source code? UPDATE statement? Table description? Regards, René Pijlman ---(end of broadcast)--- TIP 5: Have you checked

[JDBC] BIGINT vs Java's long

According to the Java Language Specification, http://java.sun.com/docs/books/jls/second_edition/html/typesValues.doc.html#9151 "For long, from -9223372036854775808 to 9223372036854775807, inclusive" Indeed, I have java code which generate random long's and println's them, and I end up with valu

[JDBC] JDBC Performance

I am having some performance problems with postgresql and JDBC when it comes to updates. If I try and update a record it seems to be taking 1.7 seconds for 100 records or 14 seconds for 500 records. An insert is only taking between 3-5 ms/record. Performance on the updates continue to decrease

Re: [JDBC] Bug found in the driver

Denis Bucher wrote: > > At 22:01 03.08.01 +0200, Rene Pijlman wrote: > >On Fri, 03 Aug 2001 15:06:46 +0200, Denis Bucher wrote: > > >I've FOUND A BUG in the postgres JDBC driver ! > > > >OK, please help us fix it. > > > > >If you want to see the source online : > > >http://cs.baylor.edu/~speegle/

[JDBC] PG Point and Circle data types, and JDBC?

Forgive me if this is more of a JDBC question than PostgreSQL, but I don't profess to be an expert at either.. Can anyone offer a short example of how to update or extract the PostgreSQL data types "Point" and "Circle" from my Java application via JDBC? (Actually I'm using EJB CMP which is ano

[JDBC] cast in JDBC update

hello, I am trying to update a field which contains an array of type INT4 via JDBC. ERROR: Attribute 'filmid' is of type '_int4' but expression is of type 'int4' You will need to rewrite or cast the expression How do I cast the expression in an JDBC update statement? The code used is lovingly