RE: JDBC Drop/Create problem?

Dropping a non-existent table should throw an exception as well as mark any
open transaction as aborted.

I'd say either:

* using autoCommit while checking for existing tables.
* commit and begin a new transaction afterwards.
* Use temporary tables, so the table doesn't survive the connection.

Peter

-- 
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council


> -----Original Message-----
> From: Greg Speegle [mailto:Greg@10happythings.com]
> Sent: Thursday, December 07, 2000 4:35 PM
> To: pgsql-interfaces@postgresql.org
> Subject: [INTERFACES] JDBC Drop/Create problem?
> 
> 
> 
> Scenario:
> Want to create a table via JDBC
> 
> Plan:
> Drop existing table (if any)
> Create new one
> 
> Problem:
> If there was no table before, the Statement to drop the table 
> throws an 
> exception, which is fine and not a problem.
> However, if I then continue to try to create the table, I get 
> a "table 
> not found" exception thrown by the Create
> Statement. Doing a commit between the two eliminates the problem, but 
> this doesn't look like how the code
> should work, or am I missing something?
> 
> Thanks for input,
> 
> Greg Speegle
> BaylorUniversity
>