> On Nov 24, 2024, at 7:15 PM, Arbol One <arbol...@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 [ í ]