注册

在管理工具能执行通过的语句,通过驱动连接,在程序执行报异常:### Cause: dm.jdbc.driver.DMException: 第1 行附近出现错误: 不支持的语句类型]

简单点 2023/09/21 783 0

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:windows11
【CPU】:12900
【问题描述】*:驱动用过8.1.1.192和8.1.2.192;
在管理工具能执行通过的语句,通过驱动连接,在程序执行报异常:### Cause: dm.jdbc.driver.DMException: 第1 行附近出现错误: 不支持的语句类型]

DROP TABLE IF EXISTS tempNumberStu;
CREATE TEMPORARY TABLE tempNumberStu AS (
SELECT
stationName,examBout,examClassRoom,
examStudentBarcode,
CONCAT( ifnull(examBatchCode,''),'' ) AS prePaperBarcode,
CONVERT (INT,( floor(number/'50') - ( CASE WHEN number%50 = 0 THEN 1 ELSE 0 END )) ) as number
FROM
(
SELECT
stationName,examBout,examClassRoom,
examStudentBarcode,
examBatchCode,
enrollmentBatch,
ROW_NUMBER() OVER ( PARTITION BY stationName,examBout,examClassRoom ORDER BY examStudentBarcode ) AS number
FROM
(
SELECT
d.station_name AS stationName,
a.exam_bout AS examBout,
a.exam_class_room AS examClassRoom,
e.exam_place_name AS examPlace,
a.exam_student_barcode AS examStudentBarcode,
b.exam_batch_code AS examBatchCode,
g.enrollment_batch_name AS enrollmentBatch
FROM
oms_dev.oms_e_exam_student a
INNER JOIN oms_dev.oms_e_exam_batch b ON a.exam_batch_id = b.id
INNER JOIN oms_dev.oms_e_user_exam_type c ON c.exam_type_id = b.exam_type_id AND c.user_id = 80
LEFT JOIN oms_dev.oms_e_station d ON a.station_id = d.id
LEFT JOIN oms_dev.oms_e_exam_place e ON a.exam_place_id = e.id
LEFT JOIN oms_dev.oms_e_enrollment_batch g ON a.enrollment_batch_id = g.id
WHERE
a.exam_batch_id = '74'

					) tmp
    		) t 
	);
	
	SELECT * FROM tempNumberStu;
	
	SELECT
		stationName,examBout,examClassRoom,
		CONCAT( ifnull(stationName,''),'-',ifnull(examBout,''),'-',ifnull(examClassRoom,'') ) AS packInfoPackageRule,
		prePaperBarcode,
		number,
		( ROW_NUMBER() OVER ( ORDER BY  NLSSORT(stationName ,'NLS_SORT = SCHINESE_PINYIN_M'), NLSSORT(examBout ,'NLS_SORT = SCHINESE_PINYIN_M'), NLSSORT(examClassRoom ,'NLS_SORT = SCHINESE_PINYIN_M'), number ) + '1' - 1 ) packageNumber	
	FROM
		tempNumberStu 
	GROUP BY
		stationName,examBout,examClassRoom,
		prePaperBarcode,
		number;	
	
	DROP TABLE tempNumberStu;
回答 0
暂无回答
扫一扫
联系客服