当前位置：首页 > 编程日记 > 正文

java clob内存溢出_java - java.sql.SQLException：ORA-01704：字符串文字太长时插入或更新 - 堆栈内存溢出...

编程日记 2024-04-09 01:00:00

通常，当我插入4000个字符限制时，它的工作正常，但当超过4000个字符时，它抛出SQL异常字符串文字太长，即使我的DISCHARGE_TEXT数据类型是CLOB

我的JavaScript代码是

function saveAsDraftNew(){

var admissionNo = document.getElementById("apnNo").value;

if (admissionNo == "") {

alert("Please Insert Admission Number");

berak;

} else {

var idval = "";

var regNo = document.getElementById("regNo").innerHTML;

var editorValue = document.getElementById("editor").value;

//alert(editorValue.length);

alert(editorValue);

editorValuee = unescape(editorValue);

//alert(editorValuee.length);

//alert(editorValuee);

var referredTo = document.getElementById("otherAnswer").value = "";

var modeOfDischarge = document.getElementsByName('answer');

for ( var i = 0; i < modeOfDischarge.length; i++) {

if (modeOfDischarge[i].checked) {

var rate_value = modeOfDischarge[i].value;

$jf.ajax({

type: "POST",

url:"saveEditorValueAsTemplateIPDPatientInfo.do",

data:{

patientAdmissionNo:admissionNo,

editorValueM:editorValuee,

btnYesM:idval,

regNoM:regNo,

referredToM:referredTo,

rate_valueM:rate_value,

success : function(result) {

$jf("#btndiv").html(result);

});

}

我的行动类代码是

private String patientAdmissionNo = null;

Date date;

String regNoM;

String btnYesM = "";

String editorValueM = "";

String referredToM = "";

String rate_valueM;

public String saveEditorValueAsTemplate() {

String[] logInInfo = (String[]) ActionContext.getContext().getSession()

.get(sessionVariable.getUserLogInInfo());

String specialization_no = logInInfo[12];

int specializationInt = specialization_no == null

|| specialization_no.isEmpty() ? 0 : Integer

.parseInt(specialization_no);

String doctorEmpId = logInInfo[1].toString();

String companyNo = logInInfo[4].toString();

Long rowInserted = patientTreatmentOfDischargeSql

.addPatientDischargeValue(btnYesM, editorValueM,

patientAdmissionNo, regNoM, specializationInt,

doctorEmpId, companyNo, doctorEmpId, date, rate_valueM,

referredToM);

if (btnYesM.equals("0") || btnYesM.equals("1")) {

deschargeInfo.setBtnSave(false);

deschargeInfo.setBtnSaveAsDruft(false);

deschargeInfo.setBtnResumeOnDraft(false);

} else {

deschargeInfo.setBtnSave(false);

deschargeInfo.setBtnSaveAsDruft(false);

deschargeInfo.setBtnResumeOnDraft(true);

}

return "saveEditorValueAsTemplate";

}

我的SQL代码是

public Long addPatientDischargeValue(String CRITICAL_FLAG , String DISCHARGE_TEXT ,String ADMISSION_NO , String REG_NO ,Integer specialization_no,String ENTERED_BY, String COMPANY_NO, String UPDATE_BY, Date UPDATED_TIMESTAMP,String mode_of_discharge, String referred_to) {

Long rowInserted=(long) 0;

boolean fg = true;

con = dbc.connectDB();

if (con == null) {

fg = false;

}

if (fg) {

try {

st = con.createStatement();

String countQry = "SELECT COUNT(ADMISSION_NO) COUNT FROM IP_DISCHARGE WHERE ADMISSION_NO='"

+ ADMISSION_NO + "'";

int countNo= 0;

ResultSet rsCount=st.executeQuery(countQry);

if(rsCount.next()){

countNo = rsCount.getInt("COUNT");

}

String insertUpdate = null;

if (countNo > 0) {

insertUpdate="update ip_discharge set " +

" update_by ='"+UPDATE_BY+"', " +

" updated_timestamp = sysdate, " +

" critical_flag = '" + CRITICAL_FLAG + "' ," +

" discharge_text = '" + DISCHARGE_TEXT + "', " +

" mode_of_discharge = '" + mode_of_discharge + "', " +

" referred_to = '" + referred_to + "' " +

" where " +

" admission_no = '"+ ADMISSION_NO+ "'";

} else {

String PK_NO = generatedSequence("",

"SEQ_PATTYPEDTL", "D", "1", "Y");

insertUpdate = "INSERT INTO ip_discharge (DISCHARGE_ID,ADMISSION_NO , reg_no, DISCHARGE_TEXT , specialization_no , CRITICAL_FLAG , ENTERED_BY , COMPANY_NO, mode_of_discharge, referred_to "

+ ")values('"+ PK_NO+ "','"+ ADMISSION_NO+ "','"+ REG_NO+ "','" + DISCHARGE_TEXT + "'," + specialization_no + ",'" + CRITICAL_FLAG + "','" + ENTERED_BY + "','" + COMPANY_NO + "','" + mode_of_discharge + "','" + referred_to + "')";

}

System.out.println(insertUpdate);

st.executeUpdate(insertUpdate);

} catch (Exception ex) {

ex.printStackTrace();

} finally {

try {

st.close();

con.close();

} catch (SQLException ex) {

ex.printStackTrace();

}

return rowInserted;

}

我的表数据类型是

CREATE TABLE IP_DISCHARGE

(

DISCHARGE_ID VARCHAR2(16 BYTE),

ADMISSION_NO VARCHAR2(16 BYTE) NOT NULL,

ENTERED_BY VARCHAR2(16 BYTE),

ENTRY_TIMESTAMP DATE DEFAULT SYSDATE,

UPDATE_BY VARCHAR2(16 BYTE),

UPDATED_TIMESTAMP DATE,

COMPANY_NO VARCHAR2(10 BYTE),

DEPT_NO NUMBER,

CRITICAL_FLAG VARCHAR2(1 BYTE),

DISCHARGE_TEXT CLOB,

REG_NO VARCHAR2(22 BYTE),

MODE_OF_DISCHARGE VARCHAR2(22 BYTE),

REFERRED_TO VARCHAR2(22 BYTE),

SPECIALIZATION_NO NUMBER

)

https://www.dkcj.cn/info/4398.html

java clob内存溢出_java - java.sql.SQLException：ORA-01704：字符串文字太长时插入或更新 - 堆栈内存溢出...

相关文章：

LC并联谐振回路

zencart分类页产品页去掉url中的id号

hexo博客更新主题后上传Git操作

ceph bluestore源码分析：非对齐写逻辑

JVM系列（之ClassLoader）

java平台类成员访问修饰符_JAVA类的修饰符及访问权限

ios实例开发精品源码文章推荐

Spring BeanDefinitionRegistryPostProcessor BeanPostProcessor作用

关于ceph源码 backtrace 打印函数调用栈

泛型java 代码讲解_Java泛型详解

(转)金额转中文大写

[IOS]UIWebView实现保存页面和读取服务器端json数据

struts2之配置文件struts.xml详解

ceph bluestore 源码分析：刷缓存(trim)逻辑

php中怎么过滤器_PHP 过滤器（Filter）

c++ Qt向PHP接口POST文件流

在网络通讯中应用Protobuf

JS中Math函数的常用方法

C++ 泛型编程 -- 函数模版

bellman_ford寻找平均权值最小的回路

守护进程中创建的对象php,在PHP中生成守护进程(Daemon Process)

log4j个人使用整理

完全理解 Python 迭代对象、迭代器、生成器（转）

Rocksdb 与 TitanDb 原理分析及性能对比测试

经典SQL练习题

php url模式在哪修改,php如何修改url

国外十大最流行PHP框架排名

python_web框架

g-gdb 调试多线程

php数据库html文本,关于php，mysql，html的数字分页和文本_php