From: | dmp <danap(at)ttc-cmc(dot)net> |
---|---|
To: | Johnny Luong <johnny(dot)luong(at)trustcommerce(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: issuing insert preparedstatement queries with default values |
Date: | 2010-01-09 02:15:01 |
Message-ID: | 4B47E6A5.2090009@ttc-cmc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi,
>
> Is there a way to use the DEFAULT per column value on an INSERT sql in
> PG through the PreparedStatement JDBC API? It'd be nice so that I don't
> have to maintain a secondary list of PreparedStatements or a list of
> default values maintained outside of the database definition.
>
> e.g:
>
> INSERT INTO foo (a, b) (?, ?)
>
> where b has a default value in the database and a is something that I
> might set to some other value.
>
>
> I'm using postgresql-8.3-603.jdbc4.jar against a 8.3 postgresql server.
>
> Thanks,
> Johnny
I know this may be not the appropriate approach, but when a user enters
default I just skip the PrepareStatement value assignment for that field
and set in the initial assignment as such. See example below.
danap.
--
-- MyJSQLView SQL Dump
-- Version: 3.06
-- WebSite: http://myjsqlview.org
--
-- Host: 127.0.0.1
-- Generated On: 2010.01.08 AD at 07:07:55 MST
-- SQL version: PostgreSQL 8.3.3
-- Database: key_tables
--
-- ------------------------------------------
--
-- Table structure for table "public"."key_table4"
--
CREATE TABLE "public"."key_table4" (
"avatar_id" integer DEFAULT 0 NOT NULL,
"user_id" integer DEFAULT 0 NOT NULL,
"bing_id" smallint DEFAULT 0 NOT NULL,
PRIMARY KEY ("avatar_id","user_id")
);
TableEntryForm addUpdateTableEntry() Connection Created
INSERT INTO "public"."key_table4" ("avatar_id", "user_id", "bing_id")
VALUES (?, ?, default)
TableEntryForm addUpdateTableEntry() Connection Closed
From | Date | Subject | |
---|---|---|---|
Next Message | Johnny Luong | 2010-01-09 02:52:03 | Re: issuing insert preparedstatement queries with default values |
Previous Message | Johnny Luong | 2010-01-09 00:03:53 | issuing insert preparedstatement queries with default values |