Re: FW: FW: pgsql - query

Srikanth,

Can you provide a test case that demonstrates the problem?

thanks,
--Barry

srikanth nagaraju wrote:
> Thanks Fernando,
>
> I thought the reply mail-ID is set to the group.
>
> Hi All,
> Please see below for the version details.
>
> Regards,
> Srikanth
>
>>-----Original Message-----
>>From: Fernando Nasser [mailto:fnasser@redhat.com]
>>Sent: Tuesday, August 12, 2003 7:26 PM
>>To: srikanth nagaraju; fnasser@redhat.com
>>Subject: Re: FW: [JDBC] pgsql - query
>>
>>Hi,
>>
>>Do you mind posting this to the list?
>>
>>This way if someone already knows the answer (if it is a version
>
> problem,
>
>>if someone has encountered it before, etc.) you get a propter
>
> response.
>
>>Also, whoever in the list has some time will go and look at your
>
> problem.
>
>>I am very busy finishing a project this week so I will not be able to
>
> try
>
>>and help you as fast as you may need.
>>
>>Best regards,
>>Fernando
>>
>>
>>
>>srikanth nagaraju wrote:> First time it didn't work, resending it...
>>
>>>
>>>>Hi Fernando,
>>>>
>>>>Sorry, I was out of station...
>>>>
>>>>Please find the sample java file from which I am trying to create
>>>
>>>tables.
>>>
>>>
>>>>Since the database creation is happening on different setups (both
>>>
>>>oracle
>>>
>>>
>>>>and postgres), java application is error free.
>>>>
>>>>Here are the details that you have asked for:
>>>>Product:      PostgreSQL 7.2.1
>>>>JDBC Info:    PostgreSQL Native Driver PostgreSQL 7.2 JDBC2
>>>>Tried with this also-> JDBC Info:    PostgreSQL Native Driver
>>>
>>>PostgreSQL
>>>
>>>
>>>>7.3.3 JDBC3 jdbc driver build 112
>>>>
>>>>Please let me know if you need any more info.
>>>>
>>>>Thanks,
>>>>Srikanth
>>>>
>>>>
>>>>>-----Original Message-----
>>>>>From: Fernando Nasser [mailto:fnasser@redhat.com]
>>>>>Sent: Thursday, August 07, 2003 7:40 PM
>>>>>To: srikanth nagaraju
>>>>>Cc: pgsql-jdbc@postgresql.org
>>>>>Subject: Re: [JDBC] pgsql - query
>>>>>
>>>>>A test case to reproduce the problem please.
>>>>>
>>>>>And the version of the driver (and where you've got it from and
>>>>
>>>when),
>>>
>>>
>>>>>as well as the backend version will be helpful.
>>>>>
>>>>>Regards,
>>>>>Fernando
>>>>>
>>>>>srikanth nagaraju wrote:
>>>>>
>>>>>
>>>>>>Hi all,
>>>>>>
>>>>>>
>>>>>>
>>>>>>I have my java application which accesses the PG DB.
>>>>>>
>>>>>>
>>>>>>
>>>>>>I have created the PG database (named ?catt? owned by ?toolsdm?).
>>>>>>
>>>>>>
>>>>>>
>>>>>>When, I am trying to create tables (on the ?catt? DB) from my Java
>>>>>>application, I am getting the following message on the postmaster
>>>>>
>>>>>window:
>>>>>
>>>>>
>>>>>>*NOTICE:  current transaction is aborted, queries ignored until
>>>>>
>>>end of
>>>
>>>
>>>>>>transaction block*
>>>>>>
>>>>>>The tables are not created. Also, I don?t get a SQL exception in
>>>>>
>>>my
>>>
>>>
>>>>Java
>>>>
>>>>
>>>>>>application.
>>>>>>
>>>>>>
>>>>>>
>>>>>>I logged into the database (to ?catt? as ?toolsdm? user) and was
>>>>>
>>>able
>>>
>>>
>>>>to
>>>>
>>>>
>>>>>>create tables through command line.
>>>>>>
>>>>>>
>>>>>>
>>>>>>Please advice.
>>>>>>
>>>>>>
>>>>>>
>>>>>>Thanks,
>>>>>>
>>>>>>------------------
>>>>>>
>>>>>>/Srikanth N/
>>>>>>
>>>>>>ESN: 6-872-8711
>>>>>>
>>>>>>Ph: +91-80-5538301 Extn: 2644
>>>>>>
>>>>>>-----------------------------------------------------
>>>>>>
>>>>>>_More Details_:
>>>>>>
>>>>>>Postgres which comes inbuilt with RedHat Linux 7.3
>>>>>>
>>>>>>JDBC driver: pg73jdbc3.jar pre-compiled version (tried with
>>>>>>pg72jdbc2.jar also)
>>>>>>
>>>>>>I just included the pg73jdbc3.jar file in my java application
>>>>>
>>>>classpath.
>>>>
>>>>
>>>>>>I have given the database URLs properly.
>>>>>>
>>>>>>pg_hba.conf: host       all         164.164.24.227 255.255.255.255
>>>>>
>>>>>trust
>>>>>
>>>>>
>>>>>>postmaster.opts: /usr/bin/postmaster '-i' '-p' '5432' '-D'
>>>>>>'/var/lib/pgsql/data'
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
> **************************Disclaimer************************************
>
>>>>>>Information contained in this E-MAIL being proprietary to Wipro
>>>>>
>>>>Limited
>>>>
>>>>
>>>>>is
>>>>>
>>>>>
>>>>>>'privileged' and 'confidential' and intended for use only by the
>>>>>
>>>>>individual
>>>>>
>>>>>
>>>>>>or entity to which it is addressed. You are notified that any
>>>>>
>>>use,
>>>
>>>
>>>>>copying
>>>>>
>>>>>
>>>>>>or dissemination of the information contained in the E-MAIL in any
>>>>>
>>>>>manner
>>>>>
>>>>>
>>>>>>whatsoever is strictly prohibited.
>>>>>>
>>>>>>
>>>>>
> ************************************************************************
>
>>>**
>>>
>>>
>>>>>*
>>>>>
>>>>>
>>>>>--
>>>>>Fernando Nasser
>>>>>Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
>>>>>2323 Yonge Street, Suite #300
>>>>>Toronto, Ontario   M4P 2C9
>>>>
>>>
>>
>>
>>--
>>Fernando Nasser
>>Red Hat - Toronto                       E-Mail:  fnasser@redhat.com
>>2323 Yonge Street, Suite #300
>>Toronto, Ontario   M4P 2C9
>
>
>
> **************************Disclaimer************************************
>
> Information contained in this E-MAIL being proprietary to Wipro Limited is
> 'privileged' and 'confidential' and intended for use only by the individual
>  or entity to which it is addressed. You are notified that any use, copying
> or dissemination of the information contained in the E-MAIL in any manner
> whatsoever is strictly prohibited.
>
> ***************************************************************************
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>