Hi All,
In my Java application I was setting the AUTOCOMMIT parameter to false.
I was committing after creating a number of tables (~10). Now that I
have changed the AUTOCOMMIT parameter to true in my Java application,
tables are getting created.
Thanks to all those who gave suggestions and helped me in resolving this
issue.
Here is the Note from the PostgreSQL 7.3.2 Administrators Guide:
Note: As of PostgreSQL 7.3, setting autocommit to false is not
well-supported. This is a new feature and is not yet handled by all
client libraries and applications. Before making it the default setting
in your installation, test carefully.
Thanks,
Srikanth
> -----Original Message-----
> From: Paul Thomas [mailto:paul@tmsl.demon.co.uk]
> Sent: Tuesday, August 12, 2003 8:21 PM
> To: srikanth nagaraju
> Cc: pgsql-jdbc @ postgresql . org
> Subject: Re: FW: FW: [JDBC] pgsql - query
>
>
> On 12/08/2003 15:02 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.
> >
>
> Could you post the Java code you are using? Also, try creating a table
> using psql, insert some data into it and then see if you can retrieve
the
> data through JDBC.
>
>
> --
> Paul Thomas
>
+------------------------------+----------------------------------------
--
> ---+
> | Thomas Micro Systems Limited | Software Solutions for the Smaller
> Business |
> | Computer Consultants |
> http://www.thomas-micro-systems-ltd.co.uk |
>
+------------------------------+----------------------------------------
--
> ---+
**************************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.
***************************************************************************