| From: | szilva(at)computer(dot)org |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | How to get rid of NOTICE: |
| Date: | 2003-09-19 16:57:29 |
| Message-ID: | Pine.LNX.4.58.0309191848250.4525@collapsed.wormhole.hu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Dear All,
Using pg 7.3.4, Sun jvm 1.4.1_02 and either pg73jdbc3.jar or
pg73jdbc2.jar on Linux Debian Woody I experiencing some problems when
creating a table via JDBC.
This statement: CREATE TABLE testtable(
cd_id serial NOT NULL PRIMARY KEY,
cd_structure BYTEA NOT NULL,
cd_smiles VARCHAR(1000) NULL,
cd_formula VARCHAR(100) NULL,
cd_molweight float8 NULL,
cd_fp1 int4 NOT NULL
);
works fine from rsql, but using JDBC I will have an error:
java.sql.SQLException: ERROR: current transaction is aborted, queries
ignored until end of transaction block
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
As far as I can see, it is because when creating the table a NOTICE will
be printed like:
NOTICE: CREATE TABLE will create implicit sequence 'asdasd_cd_id_seq' for
SERIAL column 'asdasd.cd_id'
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'asdasd_pkey' for table 'asdasd'
that is interpreted as an exception in JDBC. Is there a way to get rid of
this?
Cheers:
Szilva
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Lind | 2003-09-19 17:05:14 | Re: How to get rid of NOTICE: |
| Previous Message | Xavier Poinsard | 2003-09-19 15:31:10 | Parse problem in AbstractJdbc2ResultSet.parseQuery |