【数据库】数据库问题整理

1. 【kingbase】kingbase 为什么无法启动服务器？

windows下，打开命令行窗口，进入kingbase安装目录的bin目录下，通过命令行尝试启动kingbase，根据打印出的报错信息定位问题，命令： .\kingbase -D ../data

2. 【神通】神通ShenTong数据库报错：表对象没有自增列，不支持getGeneratedKeys()

useGeneratedKeys="false"

3. 【神通】DATE_FORMAT函数不存在

CREATE OR REPLACE FUNCTION XCJC.DATE_FORMAT(PARA1 TIMESTAMP, PARA2 TEXT) RETURNS TEXT 
AS declare
 form1 text;
BEGIN
 form1:=replace(para2,'%M','Month');
 form1:=replace(form1,'%W','Day');
 form1:=replace(form1,'%D','DDth');
 form1:=replace(form1,'%Y','YYYY');
 form1:=replace(form1,'%y','yy');
 form1:=replace(form1,'%a','Dy');
 form1:=replace(form1,'%d','DD');
 form1:=replace(form1,'%e','DD');
 form1:=replace(form1,'%m','MM');
 form1:=replace(form1,'%c','MM');
 form1:=replace(form1,'%b','Mon');
 form1:=replace(form1,'%j','DDD');
 form1:=replace(form1,'%H','HH24');
 form1:=replace(form1,'%k','HH24');
 form1:=replace(form1,'%h','HH');
 form1:=replace(form1,'%I','HH');
 form1:=replace(form1,'%l','HH');
 form1:=replace(form1,'%i','MI');
 form1:=replace(form1,'%r','HH:MI:SS');
 form1:=replace(form1,'%T','HH24:MI:SS');
 form1:=replace(form1,'%S','SS');
 form1:=replace(form1,'%s','SS');
 form1:=replace(form1,'%%','%');
 return to_char(para1,form1);
END DATE_FORMAT;