兼容人大金仓,异常信息报错解决大全

 乱码报错 ISO-8859-1

SQL 错误 [55006]: ´íÎó: ÆäËûÓû§ÕýÔÚʹÓÃÊý¾Ý¿â "ssss" (kbjdbc: autodetected server-encoding to be ISO-8859-1, if the message is not readable, please check database logs and/or host, port, dbname, user, password, pg_hba.conf)
  Detail: ÄÇÀïÓÐ3¸öÆäËü»á»°ÕýÔÚʹÓÃÊý¾Ý¿â.
  ´íÎó: ÆäËûÓû§ÕýÔÚʹÓÃÊý¾Ý¿â "ssssss" (kbjdbc: autodetected server-encoding to be ISO-8859-1, if the message is not readable, please check database logs and/or host, port, dbname, user, password, pg_hba.conf)
  Detail: ÄÇÀïÓÐ3¸öÆäËü»á»°ÕýÔÚʹÓÃÊý¾Ý¿â.
  ´íÎó: ÆäËûÓû§ÕýÔÚʹÓÃÊý¾Ý¿â "salary" (kbjdbc: autodetected server-encoding to be ISO-8859-1, if the message is not readable, please check database logs and/or host, port, dbname, user, password, pg_hba.conf)
  Detail: ÄÇÀïÓÐ3¸öÆäËü»á»°ÕýÔÚʹÓÃÊý¾Ý¿â.

遇到这个情况一脸懵逼,然后我重启了一下人大金仓的数据库管理工具就好了,还有一种方法就是减少连接人大金仓数据库的服务,推断大概率是数据库连接数的问题

人大金仓数据库脚本无法识别自增AUTO_INCREMENT

1.使用序列类型定义字段

//使用bigserial时，数据库会默认创建一个名为user_id_seq（表名_字段名_sql）的序列
DROP TABLE IF EXISTS "user";
CREATE TABLE "user"("id" bigserial NOT NULL,"user_name" varchar(20 char) NOT NULL,"age" int4,CONSTRAINT "user_pk" PRIMARY KEY (id);
);

2 手动创建序列，等价于上面语句

CREATE SEQUENCE user_id_seq;
DROP TABLE IF EXISTS "user";
CREATE TABLE "user"("id" int8 NOT NULL DEFAULT nextval('user_id_seq'),"user_name" varchar(20 char) NOT NULL,"age" int4,CONSTRAINT "user_pk" PRIMARY KEY (id);
);
ALTER SEQUENCE user_id_seq OWNED BY "user"."id";