JDBC Drop/Create problem?

Lists: Postg토토 베이SQL : Postg토토
From: Peter Mount <petermount(at)maidstone(dot)gov(dot)uk>
To: "'Allan Huffman'" <huffmana(at)ppc(dot)pims(dot)org>, pgsql-interfaces(at)postgresql(dot)org
Subject: RE: JDBC PC Driver (Looking for)
Date: 2000-12-07 15:23:12
Message-ID: 1B3D5E532D18D311861A00600865478CF1B633@exchange1.nt.maidstone.gov.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-interfaces

The one in the source/cvs works well on PC's (I only have a PC to develop
with ;-) )

Actually, you didn't say on which browser its not running under. My guess is
IE, as IE's java.sql.DriverManager class is broken.

For IE, if your applet is using JDBC directly (rather than a servlet/3tier
design) then you'll have to call the org.postgresql.Driver class directly.

Peter

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

> -----Original Message-----
> From: Allan Huffman [mailto:huffmana(at)ppc(dot)pims(dot)org]
> Sent: Thursday, December 07, 2000 3:10 PM
> To: pgsql-interfaces(at)postgresql(dot)org
> Subject: [INTERFACES] JDBC PC Driver (Looking for)
>
>
> Hi Everyone,
>
> Trying to create a new PC baseline for Nt 4.0 SP6 with
> Netscape 4.75 and
> Explorer 5.5 SP1. Java is running after installing the VM but I can't
> get a JDBC driver to work.
>
> Does anyone know where a free PC JDBC driver is?
>
> Thanks,
>
> Allan from Belgium
>


From: Greg Speegle <Greg(at)10happythings(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: JDBC Drop/Create problem?
Date: 2000-12-07 16:34:47
Message-ID: 3A2FBC27.5010207@10happythings.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg토토 베이SQL : Postg토토


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