On Fri, Aug 10, 2012 at 7:19 AM, Tom Lane wrote:
> Haifeng Liu writes:
> > I have a program running like a daemon, which analyze data and write to
> postgresql 9.1 on centos 5.8. There is only one connection between my
> program and the postgresql database, and I hope the connection may keep
> a
Haifeng Liu writes:
> I have a program running like a daemon, which analyze data and write to
> postgresql 9.1 on centos 5.8. There is only one connection between my program
> and the postgresql database, and I hope the connection may keep alive all the
> time. But I failed, the connection will
Hi experts,
I have a program running like a daemon, which analyze data and write to
postgresql 9.1 on centos 5.8. There is only one connection between my program
and the postgresql database, and I hope the connection may keep alive all the
time. But I failed, the connection will be reset after
You could do a stored procedure for inserting into another table... Otherwise if
you want to get the result as a query, you could do something like,
Select field1, exp(field2) as expoffield2 from tablename1
Hope that helps,
Srini
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
The problem is resolved. OpenOffice doesn't edit tables without primary
key with any driver (I've tried JDBC,native OpenOffice, ODBC). But - the
primary key can't be ignored, when it is made on OID.
Greetings
Adam
Adam Radlowski wrote:
I'm using very often OpenOffice to administrate databases
Dear Adam,
I usualy do use the native driver for OpenOffice from
http://dba.openoffice.org/drivers/postgresql/index.html.
With this driver a lot of things do work out of the box which do need tweeking
with the JDBC driver.
Best regards
Ivo Rossacher
Am Dienstag, 5. Dezember 2006 12.09 schrieb
I'm using very often OpenOffice to administrate databases (It has
options, wchich are not present in pgadmin3).
If I use JDBC connection and server don't requiers md5 passwords, I can
edit and administrate the databases/tables via OpenOffice and JDBC. I
can only read the tables. When server requ
Adriaan Joubert wrote
>Dave Cramer wrote:
>>
>> On 23-Oct-06, at 9:49 AM, Adriaan Joubert wrote:
>>
>>> Hi,
>>>
>>> I've run into an intermittent problem with our code recently. We
>>> have the following set-up:
>>>
>>> table A : some data table
>>> table B : a history table for table A
>>>
>>
Sriram Dandapani wrote:
Autocommit is set to off once a connection is obtained from the jboss
pool. It is turned back on when it is closed (so that any idle
transactions are committed).
Don't know what to suggest then -- if autocommit is off then the JDBC
driver should be sending BEGIN before
FYI..I use the postgres8.1.404 jdbc driver
-Original Message-
From: Oliver Jowett [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 28, 2006 3:24 PM
To: Sriram Dandapani
Cc: pgsql-jdbc@postgresql.org; pgsql-admin@postgresql.org
Subject: Re: [JDBC] number of transactions doubling
Sriram
Autocommit is set to off once a connection is obtained from the jboss
pool. It is turned back on when it is closed (so that any idle
transactions are committed).
I had the following 2 lines in my postgres-ds.xml which I commented
Even after this, I am seeing twice the number of transactions.
Sriram Dandapani wrote:
The target table has triggers that route data to appropriate tables. The
tables to which data is routed has check constraints that do further
inserts. (All of this happens in 1 jdbc transaction)
I expect JDBC Batching to generate fewer transactions depending on
batch
Hello,
I have a problem with the driver JDBC3,
MyTable(col1(SERIAL), col2(VARCHAR), Col3(VARCHAR))
When i do
rs.moveToInsertRow();
rs.updateString("col2",col2);
rs.updateString("col3",col3);
rs.insertRow();
con.commit();
rs.next();
rs.refreshRow();
The ResulSet is not refreshed for the fi
On Tue, 2006-04-18 at 14:32 +0300, Achilleus Mantzios wrote:
> Thanx for your thoughts, but this would require touching
> 173 tables +
> 2,594 SQL statements in a sum of 324 programs (which sum into 125,085
> lines of code)
We did a very similar conversion to the one proposed here a couple of
ye
Hi, Achilleus,
Achilleus Mantzios wrote:
[schema trickery]
> Why do you think its ugly after all?
It is not ugly to split such things via schemas per se, but it is ugly
to use this schema trick together with a bunch of views, rules and
triggers to "upgrade" a legacy single-deployment application
O Markus Schaber έγραψε στις Apr 18, 2006 :
> Hi, Achilleus,
>
> Achilleus Mantzios wrote:
>
> > Now i am thinking of restructuring the whole architecture as:
> > - Create one EAR app for every mgmt company
> > - Create one DB USER for every mgmg company
> > - Create one SCHEMA (same as the USER
Hi, Achilleus,
Achilleus Mantzios wrote:
> Now i am thinking of restructuring the whole architecture as:
> - Create one EAR app for every mgmt company
> - Create one DB USER for every mgmg company
> - Create one SCHEMA (same as the USER) for every mgmt company
> (mgmtcompany1,mgmtcompany2,etc...
Is your client machine on the same machine as the database?
Your pg_hba.conf file needs to have an entry in it that covers your
client machine. It's not 100% clear from your post whether you've
achieved that or not (I think you've added your server to the
pg_hba.conf, not your client).
So i
Title: JDBC conncetion fails, please, advise
Hi,
Please can you assist.
I am trying to connect to PostgreSQL via JDBC.
Database version is 8.0.1 and java software version 1.4.2.
I have configured the pg_hba.conf file as follows
host all all ip_address/32 trust
ip_address is th
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
> Also, I found by re-indexing the pg_largeobject table the problem seems to
> have gone away.
Um. That's probably destroyed the evidence :-( ie gotten rid of
whatever weird state you'd gotten the index into. But if you have
any luck reproducin
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
> I am putting a large object into my database using jdbc interface and using
> LargeObjectManager to do largeobject open, write and close. After several
> largeobject writes I get the following message
> 'failed to re-find parent-key in "pg_lar
This is 7.4.5. I'm not sure I can get it to happen on an empty database, the
database this is happening on has about 300 large objects, but I will try.
Also, I found by re-indexing the pg_largeobject table the problem seems to
have gone away.
Chris White
-Original Message-
From: Tom Lane
Functions can't have transactions inside of them
You need to start the transaction then call the function.
couple of questions though
why not use sequences ? Then you have no concurrency issues. They are
guaranteed to be incremented.
Also you can use select for update, instead of locking the en
On Wed, Apr 28, 2004 at 10:13:14 +0200,
Edoardo Ceccarelli <[EMAIL PROTECTED]> wrote:
> do you mean that, declaring an index serial, I'd never have to deal with
> incrementing its primary key? good to know!
That isn't what is happening. Serial is a special type. It is int plus
a default rule li
do you mean that, declaring an index serial, I'd never have to deal with
incrementing its primary key? good to know!
anyway in this particular situation I don't need such accurate
behaviour: this table is filled up with a lot of data twice per week and
it's used only to answer queries.
I could
do you mean that, declaring an index serial, I'd never have to deal with
incrementing its primary key? good to know!
Yep. You can use 'DEFAULT' as the value, eg:
INSERT INTO blah (DEFAULT, ...);
anyway in this particular situation I don't need such accurate
behaviour: this table is filled up wit
I am going to use them as primary key of the table, so I'll surely need
them unique :)
Eduoardo, I REALLY suggest you don't use them at all. You should make a
primary key like this:
CREATE TABLE blah (
id SERIAL PRIMARY KEY,
...
);
Also note that by default, OIDs are NOT dumped by pg_dump.
I am going to use them as primary key of the table, so I'll surely need
them unique :)
thank you for you help
Edoardo
Dave Cramer ha scritto:
Edoardo,
Are you using them for referential integrity? If so you would be wise to
use sequences instead.
Christopher: yes you are correct, I wasn't sur
Edoardo,
Are you using them for referential integrity? If so you would be wise to
use sequences instead.
Christopher: yes you are correct, I wasn't sure if that is what he was
doing.
Dave
On Tue, 2004-04-27 at 11:01, Christopher Kings-Lynne wrote:
> > AFAIK, oids aren't used for anything inter
AFAIK, oids aren't used for anything internally, so duplicates don't
really matter. Besides, what would you do about duplicate oid's ?
If he's using them _externally_, then he does have to worry about
duplicates.
Chris
---(end of broadcast)---
TIP 5
AFAIK, oids aren't used for anything internally, so duplicates don't
really matter. Besides, what would you do about duplicate oid's ?
The best suggestion is of course his last, don't use them.
On Mon, 2004-04-26 at 22:48, Christopher Kings-Lynne wrote:
> > I am using the oid of the table as the
Yes, you can create an index on the oid, but unless you are selecting on
it, it is of little use.
you would have to do select * from foo where oid=? to get any value out
of the index.
Dave
On Mon, 2004-04-26 at 12:38, Edoardo Ceccarelli wrote:
> I am using the oid of the table as the main key and
I had similar failures with JSDK 1.4, I used 1.3.1_03 instead and everything was
ok.
The build.xml file for the JDBC driver looks for a special class for deciding
between J2EE and J2SE, but there were some changes between 1.3 and 1.4, so this
way doesn't work.
Egon
"Ravi K.R." wrote:
> JDBC co
JDBC compile did not work.
problems faced during installation of postgreSQL7.2.1 version on linux
during compilation with java/jdbc support which gave error messages and was
not compiled.
1. Ant java based build tools was successfully installed and classpath was
set.
2. to build the drive
Gordon-
This looks like a subject for the PSQL-ADMIN list. I'll forward it over
there, & you should also look there for the response. I know that one of the
7.1->7.2 issues is that unicode chars were not checked/rejected by 7.1 if
there was no multibyte support in the compile, but you seem to hav
Hi,
I have trawled the web and the newsgoroups and it seems like no-one has
really been able to get the JDBC driver working with Jbuilder. In
particular I want to get the JDBC driver working with Jbuilder 4's
database explorer.
Has anyone succeeded in this? Can they send me instructions on ho
88
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of James Kelty
> Sent: Friday, April 19, 2002 12:33 PM
> To: [EMAIL PROTECTED]
> Subject: [ADMIN] JDBC and servle
We seem to be having an issue with the JDBC driver, Resin 2.0.5 servlet
engine, and/or postgres 7.1.2.
Basically what happens is this. In the Java Servlet code, the programmers
are making an explicit close connection call to the database through the
JDBC driver (As they should). Now! When the cod
http://www.ontko.com/
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of James Kelty
> Sent: Friday, April 19, 2002 1:30 PM
> To: [EMAIL PROTECTED]
> Subject: [ADMIN] JDBC and servlet
>
>
> We seem to be having an issue with the JDBC drive
We seem to be having an issue with the JDBC driver, Resin 2.0.5 servlet
engine, and/or postgres 7.1.2.
Basically what happens is this. In the Java Servlet code, the programmers
are making an explicit close connection call to the database through the
JDBC driver (As they should). Now! When the cod
Hi:
I install postgresql in Windows NT and I'm able to query simple
database. I try to configure JDBC in the postgresql package under the
interface directory. I reconfigure the system (JDBC and the rest of the
postgresql) over again using ./configure --with-java. When I compile the
source cod
It looks like it is fixed in the current sources. He probably had an
old version.
Bruce Momjian wrote:
>
> We have had a number of fixes in the 7.1 beta JDBC driver. Would you test
> that and let us know if it is still broken. You can get the JAR file
> from the JDBC website at http://www.ret
We have had a number of fixes in the 7.1 beta JDBC driver. Would you test
that and let us know if it is still broken. You can get the JAR file
from the JDBC website at http://www.retep.org.uk.
> Hello to all,
> I'm writing because i have noticed a problem with the JDBC driver:
> JDBC specific
> Hello to all,
> I'm writing because i have noticed a problem with the JDBC driver:
> JDBC specification say that "ResultSet.absolute( 1 )" is equivalent to
> "ResultSet.first()". With the postgresql jdbc driver this is not true.
> I suppose that this problem happens because theVector implementat
Hello to all,
I'm writing because i have noticed a problem with the JDBC driver:
JDBC specification say that "ResultSet.absolute( 1 )" is equivalent to
"ResultSet.first()". With the postgresql jdbc driver this is not true.
I suppose that this problem happens because theVector implementation of
Res
Hi all,
I want to use PostGreSQL in my Java application. I have compiled jdbc2 since
I am using JDK1.2
I have placed the jar file in my CLASSPATH. I am trying to connect to
PostGreSQL server running in HP-UX machine connected to my PC through LAN.
In my machine, I am working in Windows 95 platfor
My guess is that you are using Kaffe. It does not handle self-dependent
compiles like Sun java. The only solution is to download the
precompiled jar file from the URL in the interfaces/jdbcc README.
[ Charset ISO-8859-15 unsupported, converting... ]
> Hello,
> I tried to build the JDBC2 driver
Hello,
I tried to build the JDBC2 driver from Postgresql 7.0.2 distribution
(/src/interfaces/jdbc), but I got errors :
$ make jdbc2 jar
(echo "package org.postgresql;" ;\
echo "public class DriverClass {" ;\
echo "public static String
connectClass=\"org.postgresql.jdbc2.Connection\";" ;\
echo
I want to use JDBC with postgresql.
I installed postgresql, and I tried a Java program from postgresql JDBC
examples (called basic.java), but I get the error:
Exception caught :
java.lang.ClassNotFoundException: org.postgresql.Driver ,etc
My CLASSPATH is ok I think.
$ echo $CLASSPATH
/usr/loc
Postgresql v6.5.2 - postgresql.jar
The ResultSet metadata function getColumnDisplaySize() is returning the number of
characters in the column's name.
I don't THINK SO.
1. The JavaDocs say it's supposed to be the "the column's normal max width in chars".
I take this as the DATA width, not
Greetings,
I am using PostgreSQL 6.5.1 on a Ultra Sparq 10 running Solaris 2.7
when I do a make in /postgresql-6.5.1/src/interfaces/jdbc I get this
error
make $(java makeVersion)
/bin/sh: syntax error at line 1: '(' unexpected
make: *** [all] Error 2
any ideas on how to go about fixing this
Colin wrote:
>
> Any ideas on jdbc for postgres and where I can get the software?
>
> -Colin Bodor
> 3GE Development
Check src/interfaces in the distribution ;-)
/Palle
Any ideas on jdbc for postgres and where I can get the software?
-Colin Bodor
3GE Development
Vance Greenway wrote:
>
> i am using visual cafe for windows to develop an applet to access my
> postgresql data on a linux server. the package requires that the
> driver i want to develop with reside on the same computer...ie the
> windows box. can the jdbc driver "jdbc6_4.jar" be placed on th
i am using visual cafe for windows to develop an
applet to access my postgresql data on a linux server. the package
requires that the driver i want to develop with reside on the same computer...ie
the windows box. can the jdbc driver "jdbc6_4.jar" be placed on
the windows box and access t
On Mon, 6 Jul 1998, Gabor wrote:
> Hi,
>
> One of my users needs a JDBC driver for Postgres, where do I find the
> darn thing? The machine is Intel PII 400 running FreeBSD 3.0. I went
> to the javasoft site but the only applicable driver was from OpenLink
> and wasn't for FreeBSD.
Since V6.3,
Gabor wrote:
>
> Hi,
>
> One of my users needs a JDBC driver for Postgres, where do I find the
> darn thing? The machine is Intel PII 400 running FreeBSD 3.0. I went
> to the javasoft site but the only applicable driver was from OpenLink
> and wasn't for FreeBSD.
>
Take a look in /usr/src/pg
Hi,
One of my users needs a JDBC driver for Postgres, where do I find the
darn thing? The machine is Intel PII 400 running FreeBSD 3.0. I went
to the javasoft site but the only applicable driver was from OpenLink
and wasn't for FreeBSD.
gabor.
--
Sorry. My testing organization is either t
58 matches
Mail list logo
