First, I am new to Postgres. I am hoping to migrate an existing Java
application from a couple of tried but unreliable open source Java databases. I
have a fair amount of experience with Oracle, Informix and DB2 but it has been
a few years. No on to my problem.
I finally got PostgreSQL installe
I am migrating from another database to PostgreSQL and have run into a serious
problem. The Java program runs fine on the other DB but under PostgreSQL it
gives the error, "ResultSet is closed."
This result set is created in a method that processes each row sequentially.
Within the processing,
Apparently this did not go through the first time. I'll try again.
> Bayless Kirtley wrote:
>> Thanks Tom and Scott. You got me looking in the right direction. In this
>> case
>> the client and server are on the same machine (testing/development) and
>> psql
&g
You can establish a new connection without dropping the old one. Thus you
can be connected to 2 databases at the same time. Just use the appropriate
connection for the database you want.
Bayless
- Original Message -
From: "Scott Bailey"
To: "pgsql-general"
Sent: Friday, May 29, 200
For some reason, the PostgreSQL JDBC driver fails to properly recognize
daylight saving time. When retrieving the current time as a java.sql.Time,
if returns an hour behind when DST is in effect.
Here is a tested sample Java code that demonstrates the error..
private void getTime(Connection
Paul Taylor, 04.08.2009 15:48:
Thats a shame, I wanted to write junit test for a java program that
queried a database, requiring a full database to be available for unit
tests is not really an environment I want to have.
Well if you want to test the database, you will need a full database.
- Original Message -
From: "Paul Taylor"
To:
Sent: Tuesday, August 04, 2009 9:56 AM
Subject: Re: [GENERAL] Does derby have an embedded Mode like Derby ?
Of course you can always use Derby for testing the Postgres later. I have
found HSQLDB to be closer to Postgres than Derby is. I do
- Original Message -
From: Adam Rich
To: Sam Mason ; vinny
Cc: pgsql-general@postgresql.org
Sent: Monday, August 24, 2009 2:58 PM
Subject: Re: R: [GENERAL] Field's position in Table
From: vinny
Subject: Re: R: [GENERAL] Field's position in Table
Thanks a lot for your help. However I am new to Postgres database
therefore it would be nice if you can let me know how to set autocommit
off.
I know from psql client issuing “\set Autocommit Off” would set it off but
unfortunately it doesn’t set it off.
It's a client-side setting, not a serv
I have a two-user point-of-sale application on Windows XP PRO. The DB runs
on the cash register. The second user is a manager's computer. They are
connected through a wired router which is also connected to an internet
cable modem. The manager's computer just checks statistics on the DB and
mai
everal customers are standing in line trying to pay.
I tried
initially to get the customer to go Linux instead of Windows but without
much luck.
Thanks again for the thorough explanation.
Bayless
- Original Message -
From: "Craig Ringer"
To: "Bayless Kirtley"
- Original Message -
From: "Craig Ringer"
To: "Bayless Kirtley"
Cc: "List, Postgres"
Sent: Thursday, September 02, 2010 10:15 PM
Subject: Re: [GENERAL] Connection question
On 2/09/2010 11:59 PM, Bayless Kirtley wrote:
Thanks a lot Craig. The
An old app is giving a new error message. I query a table and make one update.
Later I come back to query the table again and get this error:
ERROR: current transaction is aborted, commands ignored until end of
transaction block
The error only occurs after I have made an update. As long as no u
I had to move my database to a new disk. I dropped the original after a pg_dump
and then removed the old directory. I then ran initdb on the new location,
created the database and restored from the pg_dump.
My problem now is that I have to supply the full pathnames to start or stop the
server.
Early Friday morning a bad record caused me to reload the Thursday night pgdump
backup. I performed a pgdump first to study later. In the backup I found
several incomplete transactions all done at the end of the day. Investigating
later I found the original bad record from the Friday dump and fi
Right, passthrough queries is the answer. I once had to build an Access
front end to a very large Oracle database for a client. As you discovered,
directAccess queries can be extermely slow and large. With a passthrough,
all the real work is done on the host database and just the result you want
i
Michelle, I don't think the list is going to change its operations for
one disgruntled user. Since you seem unwilling or unable to employ
the advice already given, maybe your only acceptable option is to
unsubscribe from the list. At least that would eliminate much of the
noise that currently i
- Original Message -
From: "Terry Lee Tucker"
To:
Sent: Monday, December 29, 2008 5:57 AM
Subject: Re: [GENERAL] open transaction?
On Monday 29 December 2008 06:48, blackwater dev wrote:
I just logged into postgres from the command line and did:
begin:
select blah;
select blah;
How can I tell PostgreSQL to use daylight saving time when applicable?
Times returned by the database are one hour behind.
TIA
Bayless
- Original Message -
From: "John R Pierce"
To: "Bayless Kirtley" ; "PostgreSQL"
Sent: Sunday, May 17, 2009 10:19 PM
Subject: Re: [GENERAL] Daylight saving time question
Bayless Kirtley wrote:
How can I tell PostgreSQL to use daylight saving time w
In
either
case I do now have a workaround but would like to know.
Thanks again.
- Original Message -
From: "Tom Lane"
To: "Bayless Kirtley"
Cc: "John R Pierce" ; "PostgreSQL"
Sent: Monday, May 18, 2009 12:26 PM
Subject: Re: [GENERAL]
- Original Message -
From: "Tom Lane"
To: "Bayless Kirtley"
Cc: "John R Pierce" ; "PostgreSQL"
;
Sent: Monday, May 18, 2009 3:22 PM
Subject: Re: [GENERAL] Daylight saving time question
"Bayless Kirtley" writes:
Is this
- Original Message -
From: "Lew"
To:
Sent: Saturday, May 23, 2009 2:18 PM
Subject: Re: [GENERAL] Daylight saving time question
Bayless Kirtley wrote:
Thanks Tom and Scott. You got me looking in the right direction. In this
case
the client and server are on the sa
23 matches
Mail list logo
