Thread

1. JDBC using REFERENCES

   Arbol One <arbolone@hotmail.ca> — 2024-11-25T02:15:09Z

   In an application that uses JDBC I am trying to use the following statement
   
   *               // Table parameters
                    var sql = 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)"); *_<== 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
   
   Does JDBC allow us to do this?
   What am I doing wrong?
   How to fix this
   
   -- 
   */ArbolOne ™/*
   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 [ í ]

2. Re: JDBC using REFERENCES

   David G. Johnston <david.g.johnston@gmail.com> — 2024-11-25T02:19:56Z

   On Sunday, November 24, 2024, Arbol One <ArbolOne@hotmail.ca> wrote:
   
   >
   > *                 sql.append("CONSTRAIN id PRIMARY KEY (id)"); **<==
   > Error*
   >
   >
   >
   The word constraint ends with a “T”
   
   David J.
   

3. Re: JDBC using REFERENCES

   Rob Sargent <robjsargent@gmail.com> — 2024-11-25T02:21:30Z

   
   > On Nov 24, 2024, at 7:15 PM, Arbol One <ArbolOne@hotmail.ca> wrote:
   > 
   > 
   > In an application that uses JDBC I am trying to use the following statement
   > 
   >                // Table parameters
   >                 var sql = 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)"); <== 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 balanced.
   > Does JDBC allow us to do this?
   > What am I doing wrong?
   > How to fix this
   > 
   > --
   > ArbolOne ™
   > 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 [ í ]
   

4. Re: JDBC using REFERENCES

   David G. Johnston <david.g.johnston@gmail.com> — 2024-11-25T02:22:13Z

   On Sunday, November 24, 2024, Arbol One <ArbolOne@hotmail.ca> wrote:
   
   >
   >
   >
   >
   > *                 sql.append("index SERIAL NOT NULL, ");
   > sql.append("id TEXT PRIMARY KEY, ");                 sql.append("CONSTRAIN
   > id PRIMARY KEY (id)"); **<== Error*
   >
   >
   >
   This is quite confusing, having the index column be serial but not PK (or
   even unique…) while the id column is the PK, which you’ve redundantly
   specified.
   
   David J.