目标语句:
create tablespace nsems datafile 'G:/WebProjects/NewStudentsEnrollmentManagerSystem/NewStudentsEnrollmentManagerSystem/Database/nsems.oradat' size 512k reuse autoextend on next 512k maxsize 5mcreate user nsems identified by nsems default tablespace nsems quota unlimited on nsemscreate table "nsems.StudentStatus"("IDCard" nvarchar2(18),"examineeID" nvarchar2(14),"studentID" nvarchar2(9),"department" nvarchar2(32),"speciality" nvarchar2(32),"classID" nvarchar2(4),"dormitoryID" nvarchar2(8),"bedID" nchar(1),"finalLevel" nvarchar2(4),constraint finalLevel_ck check ("finalLevel" in ('本科','专科')),constraint StudentStatus_pk primary key ("IDCard"))tablespace nsemscreate table "nsems.StudentIdentification"("IDCard" nvarchar2(18),"name" nvarchar2(8),"gender" nchar(1),constraint gender_ck check ("gender" in ('M','F')),"birthday" Date,"outlook" nvarchar2(16),constraint outlook_ck check ("outlook" in ('群众','共青团员','中共预备党员')),"address" nvarchar2(64),constraint StudentIdentification_pk primary key ("IDCard"))tablespace nsemscreate table "nsems.StudentEnrollment"("IDCard" nvarchar2(18),"register" nchar(1),"enrollNote" nchar(1),"source" nchar(1),"relationship" nchar(1),"key" nchar(1),"card" nchar(1),"dailyGoods" nchar(1),"owe" number(9,2),"regTime" Date,"res" nclob,constraint StudentEnrollment_pk primary key ("IDCard"))tablespace nsemscreate table "nsems.User"("userID" nvarchar2(32),"userName" nvarchar2(8),"password" nvarchar2(32),"roleID" nvarchar2(4),"department" nvarchar2(32),"classID" nvarchar2(4),constraint User_pk primary key ("userID"))tablespace nsemscreate table "nsems.Role"("roleID" nvarchar2(4),"roleName" nvarchar2(8),constraint Role_pk primary key ("roleID"))tablespace nsemscreate table "nsems.FieldsProperty"("field" nvarchar2(16),"canInput" nchar(1),"enrollNote" nchar(1),"isShow" nchar(1),"values" nvarchar2(1024),constraint FieldsProperty_pk primary key ("field"))tablespace nsemscreate table "nsems.ErrorMessage"("errorCode" nvarchar2(4),"message" nvarchar2(1024),"type" nvarchar2(4),constraint type_ck check ("type" in ('错误','异常','警告')),"measure" nclob,constraint ErrorMessage_pk primary key ("errorCode"))tablespace nsems
通过JDBC直接向Oracle 9i2 发送上述DDL语句,没有任何事务,并且一条一条的发出,未捕捉到任何异常,但数据库里却只有一小部分的表被创建,上述命令在sqlplus里都是可以运行的。实际上,上述语句是通过java和xml动态生成并提交没有异常后打印出的。是在想不通为什么,期待高人解答。顺便问一下,对于一个只需要执行基本select,insert,update和delete的user,就用本例第二句创建的用户,需要赋予那些权限。谢谢