Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tFOjT-00Cmt4-IH for pgsql-general@arkaria.postgresql.org; Mon, 25 Nov 2024 02:21:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tFOjS-00BAUq-7v for pgsql-general@arkaria.postgresql.org; Mon, 25 Nov 2024 02:21:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tFOjR-00BAUa-JC for pgsql-general@lists.postgresql.org; Mon, 25 Nov 2024 02:21:45 +0000 Received: from mail-il1-x130.google.com ([2607:f8b0:4864:20::130]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tFOjO-003caY-HE for pgsql-general@lists.postgresql.org; Mon, 25 Nov 2024 02:21:44 +0000 Received: by mail-il1-x130.google.com with SMTP id e9e14a558f8ab-3a75c24f447so14223745ab.0 for ; Sun, 24 Nov 2024 18:21:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732501301; x=1733106101; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=XZN8nGX2z9BcNCspJ5EUvz6b2H6XFMdi51PaddGlPOo=; b=OzPHAL9Z3bZnj5Rou79vOaLXhTdoRVkaNhXpuXtIB9AHPkiHsL4Qhu5CeBquvhZOSL N6tYZp/WB0AKpCeUMmmWSPbl9x0/L5UzF4iO5fmKhtbZPU/WefkEo7o3YTKP1z6aTFxQ YelkGWKDA+eqSVu6ADnHfHN2cidvEcErA0KqbwDzovYhblzT2Qc2SrKW2P/s3GCQQJcu PHw/yLdBFADBlQJqBBCvbMg0yXEsuLmDDmaaO2P3LUMdw7azWWjiwQPwiE7SdAciSOlC qSeQSR7iU+ar0rkSYRuV6iNX/pnL2wnIYdWWP4CMWicD83ZgsirWqPIWOGaw9DfR6Aps pL9Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732501301; x=1733106101; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=XZN8nGX2z9BcNCspJ5EUvz6b2H6XFMdi51PaddGlPOo=; b=Krg6/+0ipHeMvIw2lHSNaG7L0SqGCPsI4vMDT+p+aalgj+MAwRAMD1mN7qyjJW4F8x 2NQJAA3kYdvu8us+JJWd+mNRXFB9JCqagy7FXEY83p2cBIBX3iuN9ycTfVBdxCYw6cOt A8GMm3zTBUy1LZogYEmPZbqG+O0YLpKd7nExQwwvBgxrwMp7iuWmXMPR4oXaX3ebqCMP DiHUtzaFTOIcuKlXylwlsKhX1J2GHSGL7o5NnnhEEpXMFZuMPcwVPHrYB2tWnJ+Ny80u IPzmV2fOcIoiHky47lkOseD/0SGhu+KK+KUiyFWhO6WKlkLCD2MR18hv2T6hbauITNza u6OQ== X-Gm-Message-State: AOJu0YzJCX3sNRQZYrE39CrsyIYTn1AShXKZGtKMe7degb9+wXYes7Af CFP9goBL59XWsbqxtEfZTWuuI2D30kRv+iZRdf41ta53wzhHahOecZnm1Q== X-Gm-Gg: ASbGncupThkpPldmfIy3P44xfgIX6j8bVP+m1arnJTHb7THt3gXi0Jxw5jE+tPgcv3+ dEQhniF/SZGcbXpvuCf/b+3vGe+FeQKjcs9WtmGjqGYE2l7G7bIQ+9QuyvQEMmYHmb4mArlbdtu UKthHrJ6aavw9OnsbIXe0FVACJpVan4l6W0O31G7CuC8URujnGjMcnCe3GGLFSGQu/9FxbQv/zC 9dto2fJNXZInLICtSLz45nWLkbco9udmlXp0pKCXzZTkcJAdPEi5hIkkMCaFjXG6fqSLo5qYpE+ MEE= X-Google-Smtp-Source: AGHT+IENdyIGO5+p6PkjUllaK52cVnK5/9sxbBr0oZwjkhD0FJbp5sGzfeTv9S8zoBx9T07Mft2n3A== X-Received: by 2002:a05:6e02:1a08:b0:3a6:ac4e:264a with SMTP id e9e14a558f8ab-3a79adc71bdmr118606265ab.10.1732501301421; Sun, 24 Nov 2024 18:21:41 -0800 (PST) Received: from smtpclient.apple ([2601:681:4c01:7310:ec70:2267:70cf:1c57]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-7fbcc422d0bsm4586171a12.84.2024.11.24.18.21.40 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 24 Nov 2024 18:21:41 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-A08C4DF8-9AC3-4B5E-A01B-0A8389938D5A Content-Transfer-Encoding: 7bit From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: JDBC using REFERENCES Date: Sun, 24 Nov 2024 19:21:30 -0700 Message-Id: <2BA0EBBC-CFB1-4F23-8279-C3D781FCDE30@gmail.com> References: Cc: pgsql-general@lists.postgresql.org, PostGreSQL MailingList In-Reply-To: To: Arbol One X-Mailer: iPhone Mail (21G93) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-A08C4DF8-9AC3-4B5E-A01B-0A8389938D5A Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable > On Nov 24, 2024, at 7:15=E2=80=AFPM, Arbol One wrote= : >=20 > =EF=BB=BF > In an application that uses JDBC I am trying to use the following statemen= t >=20 > // Table parameters > var sql =3D new MyString(); > sql.setData("CREATE TABLE IF NOT EXISTS "); > sql.append(this.tableName); > sql.append(" ("); > sql.append("index SERIAL NOT NULL, "); > sql.append("id TEXT PRIMARY KEY, "); > sql.append("day TEXT NOT NULL, "); > sql.append("month TEXT NOT NULL, "); > sql.append("year TEXT NOT NULL, "); > sql.append("hour TEXT NOT NULL, "); > sql.append("minute TEXT NOT NULL, "); > sql.append("second TEXT NOT NULL, "); > sql.append("millisecond TEXT NOT NULL, "); > sql.append("am_pm TEXT NOT NULL, "); > sql.append("admin boolean NOT NULL DEFAULT false, "); > sql.append("CONSTRAIN id PRIMARY KEY (id)"); <=3D=3D Error= > sql.append(");"); >=20 > but I get a message saying : >=20 > Exception in thread "main" java.sql.SQLException: In company.contact.creat= eTable() > ERROR: syntax error at or near "(" > Position: 315 >=20 Collapse all the append()s after rable e and see if parentheses are balance= d. > Does JDBC allow us to do this? > What am I doing wrong? > How to fix this >=20 > -- > ArbolOne =E2=84=A2 > Using Fire Fox and Thunderbird. > ArbolOne is composed of students and volunteers dedicated to providing fre= e services to charitable organizations. > ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in prog= ress [ =C3=AD ] --Apple-Mail-A08C4DF8-9AC3-4B5E-A01B-0A8389938D5A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

On Nov 24, 2024, at 7:= 15=E2=80=AFPM, Arbol One <ArbolOne@hotmail.ca> wrote:

=EF=BB=BF =20 =20

In an application that uses JDBC I am trying to use the following statement

   &nbs= p;           // Table parameters
           =      var sql =3D new MyString();
           =      sql.setData("CREATE TABLE IF NOT EXISTS ");
           =      sql.append(this.tableName);
           =      sql.append(" (");
           =      sql.append("index SERIAL NOT NULL, ");
           =      sql.append("id TEXT PRIMARY KEY, ");
           =      sql.append("day TEXT NOT NULL, ");
           =      sql.append("month TEXT NOT NULL, ");
           =      sql.append("year TEXT NOT NULL, ");
           =      sql.append("hour TEXT NOT NULL, ");
           =      sql.append("minute TEXT NOT NULL, ");
           =      sql.append("second TEXT NOT NULL, ");
           =      sql.append("millisecond TEXT NOT NULL, ");
           =      sql.append("am_pm TEXT NOT NULL, ");
           =      sql.append("admin boolean NOT NULL DEFAULT false, ");
           =      sql.append("CONSTRAIN id PRIMARY KEY (id)"); <=3D=3D Error
           =      sql.append(");");

but I get a message saying :


Exception in thread "main" java.sql.SQLException: In company.contact.createTable()
ERROR: syntax error at or near "("
  Position: 315


 Collapse all the append()s after rable e and see if parentheses are b= alanced.
Does JDBC allow us to do this?
What am I doing wrong?
How to fix this

--
ArbolOne =E2=84=A2
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in progress [ =C3=AD ]
=20
= --Apple-Mail-A08C4DF8-9AC3-4B5E-A01B-0A8389938D5A--