FW: FW: pgsql - query - Mailing list pgsql-jdbc

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.

***************************************************************************