Hi, folks -

Is there an ETA for support of the COPY command in the JDBC driver? I
am aware of the patch (http://kato.iki.fi/sw/db/postgresql/jdbc/copy/)
but notice that the provided jdbc drivers are from the previous
generation. Although I could patch the current driver myself, I'd
really rather have a blessed version from the Postgres committers.

Mark

Hi, folks –

 

Is there an ETA for support of the COPY command in the JDBC
driver?  I am aware of the patch (http://kato.iki.fi/sw/db/postgresql/jdbc/copy/)
but notice that the provided jdbc drivers are from the previous generation. 
Although I could patch the current driver myself, I’d really rather have
a blessed version from the Postgres committers.

 

Mark

Hello all,
in my application, queries with placeholder are created in a generic way without
knowing if the column is string or integer.
It uses setString(1, "1") even on int columns.
This was working for the pg74*.jar

Now I want to upgrade (postgresql-8*.jar I measured 20%% speedup in selects)
but with version 8 I get Exception:
ERROR: operator does not exist: bigint = character varying

In the thread "macaddr data type and prepared statements"
I found that I can use setObject(1, "1", Types.OTHER);
and this works for me too.

My question is if this is the "correct" way to continue
(I can exchange all the setString with setObject but I can not
find out the datatype of the columns in an easy way)
or if this has drawbacks I do not see at the moment.

Thank you and regards,
Michael

I have Postgresql 8.3 (PostgresPlus) running on an Apple with Tomcat 6.
I am using the postgresql-8.3-603.jdbc3.jar driver. My app runs fine
when on the apple, but when I move it over to a Windows machine running
Tomcat 6 that accesses the same exact database on the Apple I get a "Bad
Timestamp Format at 23 in 2008-09-16 18:41:00.479" error. I am guessing
that it has something to do with how Java creates Dates on Unix verses
Windows. What do I need to do to get this to work on the Windows machine?

--
Thanks,

Warren Bell
909-645-8864
warren@clarksnutrition.com

Hi,

I've been looking through the mail archives in the JDBC forum and have seen
a number of different ways to create a JDBC connection pool to Postgres.
Could someone point me in the right direction, eg Jdbc3ConnectionPool,
Apache's DBCP, etc.?

I'm using the following:

JRE: 1.6

PostgreSQL Server: 8.3

JDBC Driver: postgresql-8.2-506.jdbc4

Thanks.

Hi,

 

I’ve been looking through the mail archives in the
JDBC forum and have seen a number of different ways to create a JDBC connection
pool to Postgres.  Could someone point me in the right direction, eg Jdbc3ConnectionPool,
Apache's DBCP, etc.?

 

I’m using the following:

 

"pgBee is a set of Java classes I wrote for automating bulk updates of
Postgresql databases on Linux servers. It requires Java (doh!) and Ant (as a
build/execute front-end), it is cronnable and performs very well, especially
in multi-threaded mode, which takes full advantage of multi-core CPUs in
modern servers."

inspiration for this has come from
http://archives.postgresql.org/pgsql-jdbc/2007-04/msg00076.php and my own
tests...

until pgBee is hosted in pgFoundry, you may find the source code here:
http://freeyourtech.wordpress.com/2008/09/16/pgbee-a-postgresql-bulk-updater-in-.../

comments, suggestions welcome

Michael

"pgBee is a set of Java classes I wrote for automating bulk updates of
Postgresql databases on Linux servers. It requires Java (doh!) and Ant
(as a build/execute front-end), it is cronnable and performs very well,
especially in multi-threaded mode, which takes full advantage of
multi-core CPUs in modern servers."inspiration for this has come from http://archives.postgresql.org/pgsql-jdbc/2007-04/msg00076.php and my own tests...
until pgBee is hosted in pgFoundry, you may find the source code here: http://freeyourtech.wordpress.com/2008/09/16/pgbee-a-postgresql-bulk-updater-in-.../
comments, suggestions welcomeMichael

Estimado grupo de Programadores:

Actualmente estoy realizando un pequeño proyecto con una base de datos de postgres, esta la estoy linkando mediante una aplicacion de java, he utilizado el driver JDBC4 Postgresql, Version 8.3-603.zip que es la misma version que utilizo en postgres, el problema ha es que no me puede guardar datos en la tabla que yo estoy especificando, y me gustaria que me dijeran donde puede bajarme la documentacion de dicho driver para ver en que estoy fallando.

Jorge Luis Morales Mendez
Sistemas Computacionales
_________________________________________________________________
Live Search premia tus búsquedas, llévate hasta ¡Un Auto!
http://www.ganabuscando.com/Default.aspx

.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}

On Fri, 5 Sep 2008, Bob Bruynooghe wrote:

I'm not sure why you expect no fraction here, the numeric type does
support fractional parts.

Yes, this is a bug in the driver.

Kris Jurka

PostgreSQL: 8.2.4

JDK: 1.6.0_07

JDBC Driver: 8.2-508 JDBC4

I have found a problem with 8.2-508 JDBC 4. I can recreate the problem
every time.

Summary of problem:

When the below SQL is executed the result set returns the value of
"null" for the field "calendar_name". When I use driver "8.2-506 JDBC
4" and "8.2-507 JDBC 4" it work correctly and I get a valid value.

SQL that returns a "null" in 508 but not in 506 and 507 for the field
"calendar_name":

SELECT to_char(event.start_timestamp, 'Mon FMDD, YYYY') AS start_date,

to_char(event.end_timestamp, 'Mon FMDD, YYYY') AS end_date,

to_char(event.start_timestamp, 'FMHH:MI am') AS start_time,

to_char(event.end_timestamp, 'FMHH:MI am') AS end_time,

to_char(event.news_letter_timestamp, 'YYYYMMDD') AS news_letter_date,

to_char(event.news_letter_timestamp, 'FMHHMISS') AS news_letter_time,

to_char(last_updated_timestamp, 'MM/DD/YYYY') AS last_updated_date,

to_char(event.created_timestamp, 'MM/DD/YYYY') AS created_date,

Hi,

The JDBC API at the Sun website describes a two-parameter version of the method 'prepareStatement' in the interface 'Connection' with capability to retrieve auto-generated keys. One of the samples in the Sun JDBC Tutorial site also use this method.

Is this method available in the postgresql jdbc driver? I have not been able to locate it so far.
If it is not implemented as yet, is there any plan to implement this method any time soon?

Krishnan Trikkadeeri

Hi,
 
The JDBC API at the Sun website describes a
two-parameter version of the method 'prepareStatement' in the interface
'Connection'  with
capability to retrieve auto-generated keys. One of the samples in the Sun JDBC
Tutorial site also use this method.

 
Is this method available in the postgresql jdbc
driver? I have not been able to locate it so far.
If it is not implemented as yet, is there any plan
to implement this method any time soon?
 
Krishnan Trikkadeeri