encoded string too long: 65729

java.io.UTFDataFormatException: encoded string too long: 65729 bytes
at java.io.DataOutputStream.writeUTF(DataOutputStream.java:364)
at java.io.DataOutputStream.writeUTF(DataOutputStream.java:323)
at socket.Server$3.run(Server.java:694)
at java.lang.Thread.run(Thread.java:745)

            请问上面的异常报错如何解决,潮手请各位大仙给个代码示例

            报错源代码如下:

            //接收客户端消息
                DataInputStream input=new DataInputStream(client.getInputStream());
                DataOutputStream output=new DataOutputStream(client.getOutputStream());
                String inputString=input.readUTF();
                logger.info("客户端访问信息:"+inputString);

                。。。。。。。。。
                。。。。。。。。。
            jsonString =jsonObjectCustomer.toString();
            System.out.println("Server.java封装完成的json数据格式:"+jsonString);

            //向客户端返回消息            
                                try {
                                    output.writeUTF(jsonString);



                                    。。。。。。。。。。。。

                                    。。。。。
                                    我传递的这个jsonString字符串参数是无限大的,

提示向客户端传输jsonString的时候报的异常,该如何解决

1个回答

encoded string too long: 65729 bytes 字符串参数超过了String可存储的最大字节 解决方法可以试下StringBuilder

m0_37271466
零一零一 回复qq_35728177: 非常感谢O(∩_∩)O哈哈~
大约一年之前 回复
qq_35728177
Tsui丶 http://blog.csdn.net/zi_jun/article/details/7624999 这里有
大约 2 年之前 回复
m0_37271466
零一零一 谢谢大仙关注,新手能否给个简单代码示例
大约 2 年之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
如何处理Java的64K限制【java.io.UTFDataFormatException: encoded string too long】
爬虫小白,用的下载工具中使用了AsyncHttpClient,其中用到了Hadoop。看到网上说是java是在IO操作中有限制64K,网上说可以将写文件切割,可关键是Hadoop使用的是Hadoop的包不能修改源码。rn-----------------------------------------------------rn出错代码如下:rn SequenceFile.Writer out = SequenceFile.createWriter(fs, conf, new Path(output),rn PairOfLongString.class, HtmlStatus.class, SequenceFile.CompressionType.BLOCK);rnrn for (Map.Entry entry : crawl.entrySet()) rn written++;rn out.append(entry.getKey(), entry.getValue());rn rnrn调用的append函数是在文件末尾附上键值对。rn----------------------------------------------rn但是报错如下:rnException in thread "main" java.io.UTFDataFormatException: encoded string too long: 91936 bytesrn at java.io.DataOutputStream.writeUTF(DataOutputStream.java:364)rn at java.io.DataOutputStream.writeUTF(DataOutputStream.java:323)rn at main.java.com.twitter.corpus.data.HtmlStatus.write(HtmlStatus.java:60)rn at org.apache.hadoop.io.serializer.WritableSerialization$WritableSerializer.serialize(WritableSerialization.java:90)rn at org.apache.hadoop.io.serializer.WritableSerialization$WritableSerializer.serialize(WritableSerialization.java:77)rn at org.apache.hadoop.io.SequenceFile$BlockCompressWriter.append(SequenceFile.java:1318)rn at org.apache.hadoop.io.SequenceFile$Writer.append(SequenceFile.java:984)rn---------------------------------------------rnrn求教各位大侠是否有什么设置可以规避掉这个问题。是因为爬取的文档太长了么?可是工具好多人都用的都没有问题啊。rn
ORA-01704: string literal too long
数据库中tableA(id,。。。articleContent) articleContent 是 [color=#FF0000]Blob [/color]类型。rnrn页面上用了FckEditor编辑了一篇文章。保存。得到ORA-01704: string literal too longrn这个异常。rnrn按理说我都用了Blob类型了,怎么还会报ORA-01704: string literal too long这个错误呢?
ORA-01489: result of string concatenation is too long
字符串联操作出现错误 rnORA-01489: result of string concatenation is too longrn把字符截断后就好了,请问rn数据库字符串联最多能允许多长?
ora_01704:string literal too long错误
SELECT TRIM(SUBSTR(STR,INSTR(STR, ',', 1, level) + 1,INSTR(STR, ',', 1, level + 1) - INSTR(STR, ',', 1, level) - 1)) AS CARDNUMrn FROM (SELECT ',' || 'Vcardnum'|| ',' AS STR FROM dual)rn CONNECT BY level <= LENGTH(STR) - LENGTH(REPLACE(STR, ',', '')) - 1;rn如果Vcardnum = 1000668854,1000672802,一千张卡号,就会报ora_01704:string literal too longrn有办法解决么
Request URL Too Long
下面这一段代码操作几次之后就出现报错,rnRequest URL Too LongrnHTTP Error 414. The request URL is too long.rnrnprotected void T_ItemId_TextChanged(object sender, EventArgs e)rn rn T_ItemName.Text = "";rn T_UnitId.Text = "";rn ColorList.Text = "";rn AXInterface AXInterface = new AXInterface(); rn AXInterface.ItemInfo ItemInfo = new AXInterface.ItemInfo();rn AXInterface.ItemDefaultInfo itemDefaultInfo = new AXInterface.ItemDefaultInfo();rn ItemInfo = AXInterface.getItemInfo(T_ItemId.Text);rnrn if (ItemInfo.ItemId != "")rn rn T_ItemName.Text = ItemInfo.ItemName;rn T_UnitId.Text = ItemInfo.UnitId;rn ColorList.Text = ItemInfo.ItemColor.ToString();rn //fill item default inforn itemDefaultInfo = AXInterface.getItemDefaultInfo(T_ItemId.Text);rn T_Inventlocation.Text = itemDefaultInfo.InventLocationId;rn ret = true;rn this.buildwMSLocation(T_Inventlocation.Text);rn T_Wmslocation.Text = itemDefaultInfo.wMSLocationIdFrom;rn ColorList.Text = itemDefaultInfo.ItemColor;rn this.getOnhand();rn T_Qty.Focus();rn rn elsern rn Response.Write("Item " + T_ItemId.Text + " not found");rn T_ItemId.Text = "";rn T_ItemName.Text = "";rn T_UnitId.Text = "";rn ColorList.Text = "";rn T_ItemId.Focus();rn rn
ls too long
linux shell ls *.txt 出现问题rn-bash: /bin/ls: Argument list too longrn大数据量下ls问题
ORA-00972 identifier is too long
在复制数据库的时候,遇到一个错误“ORA-00972 identifier is too long ”rn错误的原因是你模式对象的名字太长了。只能有30个字符。rn那怎么解决这个问题,哥们帮忙解决一下。
DATA TOO LONG FOR COLUMN
数据库改了一个字段的DATATYPE,Flag2的VARCHAR(8) DEFAULT VALYE '00000000' 改为VARCHAR(20) DEFAULT VALUE '00000000000000000000',rn[code=sql]rnCREATE TABLE `inventory` (rn `InventoryID` int(11) NOT NULL default '0',rn `BarCode` varchar(16) NOT NULL default '0',rn `InventoryName` varchar(16) NOT NULL,rn `Description` varchar(50) default NULL,rn `CategoryID` int(11) NOT NULL default '0',rn `Class` int(11) NOT NULL default '0',rn `Unit` varchar(10) NOT NULL default 'PCS',rn `Price` decimal(19,4) default '0.0000',rn `Price2` decimal(19,4) default '0.0000',rn `Price3` decimal(19,4) default '0.0000',rn `Price4` decimal(19,4) default '0.0000',rn `Onhand` double default '0',rn `ReorderLevel` double default '0',rn `MaxiumLevel` double default '0',rn `SafetyLevel` double default '0',rn `DateCreated` datetime default NULL,rn `Group1` varchar(16) default NULL,rn `Group2` varchar(16) default NULL,rn `Group3` varchar(16) default NULL,rn `Group4` varchar(16) default NULL,rn `Group5` varchar(16) default NULL,rn `NoPriceShift` tinyint(4) default '0',rn `Active` tinyint(4) default '0',rn `Updated` tinyint(4) default '0',rn `Photograph` varchar(60) default NULL,rn `Notes` text,rn `BranchUpdated` tinyint(4) default '0',rn `StockCode` varchar(16) default NULL,rn `Flag1` varchar(8) default '00000000',rn `Flag2` varchar(20) default '00000000000000000000',rn `PriceShiftId` int(11) NOT NULL default '0',rn `AllowDecimalValue` tinyint(4) default '0',rn `PackageType` int(11) default '0',rn `PackageValue` double default '0',rn `PackageDiscount` double default '0',rn `Serialized` tinyint(4) default '0',rn `CommissionPercent1` double default '0',rn `CommissionPercent2` double default '0',rn `CommissionPercent3` double default '0',rn `CommissionAmount1` decimal(19,4) default '0.0000',rn `CommissionAmount2` decimal(19,4) default '0.0000',rn `ERPItemCode1` varchar(30) default NULL,rn `ERPItemCode2` varchar(30) default NULL,rn `ERPItemDesc` varchar(40) default NULL,rn PRIMARY KEY (`InventoryID`),rn UNIQUE KEY `BarCode` (`BarCode`),rn UNIQUE KEY `InventoryID` (`InventoryID`),rn KEY `Class` (`Class`),rn KEY `CategoryID` (`CategoryID`),rn KEY `Group1` (`Group1`),rn KEY `Group2` (`Group2`),rn KEY `Group3` (`Group3`),rn KEY `Group4` (`Group4`),rn KEY `Group5` (`Group5`)rn) ENGINE=InnoDB DEFAULT CHARSET=utf8;rninsert into inventory value(rn1, 'ROUND', 'Round', 'Round', 1, 0, 'PCS', 0.0000, 0.0000, 0.0000, 0.0000, 0, 0, 0, 0, '2009-07-14 00:00:00', '', '', '', '', '', 0, 1, 0, '', ' ', 0, '', '00000000', '00000000', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.0000, 0.0000, '', '', '' );rn[/code] rnrnupdate inventory set flag2='00000000000000000000'; 运行这个就出问题
500 line too long
有一个朋友给我发邮件,但却出现:[b]500 line too long[/b]rnrn不知是什么原因?rn
ORA-00972 identitify is too long
for v_ser in '(select a.nbr1, rn a.nbr2, rn a.dura, rn a.date rn from'||TABLENAME1||'a'|| rn 'order by a.nbr1, rn a.nbr2, rn a.dura, rn a.date)' ; rnopen v_ser for v_sql; --15行 rnrn这块代码15行报ORA-00972 identitify is too long rn我定义的v_sql varchar2(4000); 大家帮看看什么问题啊
[delphi]line too long
遇到这样的问题,上网查过了,可是他们的方法都没用,谁有具体点的问题,急用!!!!多谢
Data too long for column
我讲一个长度为 645249字节数组写入一个LongBlob类型的字段,提示如下错误:rn[b]未处理 MySql.Data.MySqlClient.MySqlExceptionrn Message=Data too long for column 'result' at row 8rn Source=CTD.SQLrn ErrorCode=-2147467259rn Number=1406rn StackTrace:[/b]rnrn程序代码如下:rntryrn rn MySqlParameter[] arParms = new MySqlParameter[8];rn arParms[0] = new MySqlParameter("coil_id", MySqlDbType.VarChar, 20);rn arParms[0].Value = coilid;rnrn arParms[1] = new MySqlParameter("result", MySqlDbType.LongBlob, resultBytes.Length);rn if (resultBytes == null) arParms[1].Value = DBNull.Value; rn else arParms[1].Value = resultBytes; rnrn arParms[2] = new MySqlParameter("topavg1", MySqlDbType.Double);rn arParms[2].Value = topavg1;rnrn arParms[3] = new MySqlParameter("topavg2", MySqlDbType.Double);rn arParms[3].Value = topavg2;rnrn arParms[4] = new MySqlParameter("topavg3", MySqlDbType.Double);rn arParms[4].Value = topavg3;rnrn arParms[5] = new MySqlParameter("botavg1", MySqlDbType.Double);rn arParms[5].Value = botavg1;rnrn arParms[6] = new MySqlParameter("botavg2", MySqlDbType.Double);rn arParms[6].Value = botavg2;rnrn arParms[7] = new MySqlParameter("botavg3", MySqlDbType.Double);rn arParms[7].Value = botavg3;rnrn MySqlHelper2.ExecuteNonQuery(MySqlHelper2.ConnectionString, CommandType.StoredProcedure, "CTD_UpdateCoilResult", arParms);rn return true;rn rn catch (Exception ex)rn rn throw ex;rn rnrn请问如何解决这个问题?
data too long for column的问题
先解释下:rn我把编码集改成了GB2312rnmy.ini的rncharacter set=gb2312rn字符编码已经改了rncreate table(rn***rn)type=MYISAM default charset=`GB2312`rn字符编码已经设置了GB2312rnrn可是这个时候插入数据的时候却会提示data too long for columnrn不知道为什么会报这个错误rnrnsql-mode="STRICT_TRANS_TABLES,NO_AUTO_Create_USER,NO_ENGINE_SUBSTITUTION" 把其中的 "STRICT_TRANS_TABLES,"去掉,或者注释掉这一行,然后重启mysql就ok了 。rnrn我按照上面的方法试过了 重启MYSQL后 导入进去后 数据库中的数据却乱码了 不知道为什么rnrn还有没有别的方法解决data too long for column呢???rnrnrn
ORACE-01467 sort key too long
oracle 9i 高手看看:(下面的SELECT语句出现ORACE-01467 sort key too long,如何改正,当该select语句返回列数小于32列时没问题(rownum <= 31),但超过32列时,就出现01467的错误了????),下面的语句由存储过程生成,我直接把生成后语句贴出来了,rn rnrnrnselect SAMPLING_POINT, SAMP_ORDER, PRODUCT_NAME, NAME, SAMPLE_TYPE, UNITS_DISPLAY, TEST_ORDER_NUMBER, RESULT_ORDER_NUMBER ,max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-04-30 20:00:00' thenrnFORMATTED_ENTRY else '-' end) "2008-04-30 20:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-04-30 21:00:00' then FORMATTED_ENTRY else '-' end) "2008-04-30 21:00",rnmax(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-04-30 23:00:00' then FORMATTED_ENTRY else '-' end) "2008-04-30 23:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 00:00:00' thenrn FORMATTED_ENTRY else '-' end) "2008-05-01 00:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 01:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 01:00",rnmax(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 02:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 02:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 03:00:00' thenrn FORMATTED_ENTRY else '-' end) "2008-05-01 03:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 03:10:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 03:10",rnmax(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 04:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 04:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 05:00:00' thenrnFORMATTED_ENTRY else '-' end) "2008-05-01 05:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 06:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 06:00",rnmax(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 07:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 07:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 08:00:00' thenrnFORMATTED_ENTRY else '-' end) "2008-05-01 08:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 09:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 09:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 09:50:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 09:50",max(case whenrnTO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 09:55:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 09:55",max(casernwhen TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 10:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 10:00",rnmax(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 10:05:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 10:05",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 10:30:00' thenrn FORMATTED_ENTRY else '-' end) "2008-05-01 10:30",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 11:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 11:00",rnmax(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 12:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 12:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 13:00:00' thenrnFORMATTED_ENTRY else '-' end) "2008-05-01 13:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 13:20:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 13:20",rnmax(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 14:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 14:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 15:00:00' thenrnFORMATTED_ENTRY else '-' end) "2008-05-01 15:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 16:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 16:00",rnmax(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 17:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 17:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 18:00:00' thenrn FORMATTED_ENTRY else '-' end) "2008-05-01 18:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 19:00:00' thenrnFORMATTED_ENTRY else '-' end) "2008-05-01 19:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 19:10:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 19:10",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 20:00:00' thenrnFORMATTED_ENTRY else '-' end) "2008-05-01 20:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 20:30:00' thenrnFORMATTED_ENTRY else '-' end) "2008-05-01 20:30",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 21:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 21:00",rnmax(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 22:00:00' then FORMATTED_ENTRY else '-' end) "2008-05-01 22:00",max(case when TO_CHAR(SAMPLED_DATE,'YYYY-MM-DD HH24:MI:SS')='2008-05-01 23:00:00' thenrnFORMATTED_ENTRY else '-' end) "2008-05-01 23:00" from ( SELECT LIMS_WEB.SAMPLING_POINT, LIMS_WEB.SAMP_ORDER, LIMS_WEB.PRODUCT_NAME, LIMS_WEB.NAME, LIMS_WEB.SAMPLED_DATE, LIMS_WEB.SAMPLE_TYPE,rn LIMS_WEB.UNITS_DISPLAY, LIMS_WEB.FORMATTED_ENTRY, LIMS_WEB.TEST_ORDER_NUMBER, LIMS_WEB.RESULT_ORDER_NUMBER FROM ( SELECT B.sampled_date FROM ( SELECT distinct A.sampled_date FROM LIMS_WEB A WHERE A.sampled_date < TO_DATE('2008-05-01','YYYY-MM-DD') + 1rnAND A.sampled_date >= TO_DATE('2008-05-01','YYYY-MM-DD') - 30 AND A.PROD_EQUIP='1号' AND A.Workshop_Section = '1号' ORDER BY A.sampled_date DESC ) B WHERE rownum <= 35) SD,rnLIMS_WEB WHERE LIMS_WEB.SAMPLED_DATE = SD.SAMPLED_DATE AND LIMS_WEB.PROD_EQUIP='1号' AND LIMS_WEB.Workshop_Section = '1号' ORDER BY LIMS_WEB.SAMP_ORDER, LIMS_WEB.SAMPLING_POINT,rnLIMS_WEB.TEST_ORDER_NUMBER, LIMS_WEB.RESULT_ORDER_NUMBER ) T group by SAMPLING_POINT, SAMP_ORDER, PRODUCT_NAME, NAME, SAMPLE_TYPE, UNITS_DISPLAY, TEST_ORDER_NUMBER, RESULT_ORDER_NUMBER ORDER BY SAMP_ORDER,rnSAMPLING_POINT, TEST_ORDER_NUMBER, RESULT_ORDER_NUMBERrnrnrn
Oracle ORA-00972:Identification too long
create or replace function F_CHECK_SPECIALMAT_ORDER(AN_ORDER_ID in NUMBER,AS_ORDER_TYPE in varchar2) return number isrnrn /* rn 参数:AN_ORDER_ID in NUMBERrn AS_ORDER_TYPE in varchar2rn 返回:numberrn */rn rn ls_table_name varchar2(30);rn ls_sql_string varchar2(4000);rn ln_count number;rnbeginrn if SUBSTR(trim(AS_ORDER_TYPE),1,1) = '0' thenrn ls_table_name := 'mat_purchase_plan_detail';--计划rn ELSIF SUBSTR(trim(AS_ORDER_TYPE),1,2) = '11'thenrn ls_table_name := 'mat_quotation_request_detail'; --询 rn ELSIF (SUBSTR(trim(AS_ORDER_TYPE),1,2) = '12' or SUBSTR(trim(AS_ORDER_TYPE),1,2) = '13') thenrn ls_table_name := 'mat_supplier_confirm_detail'; --确rn ELSIF SUBSTR(trim(AS_ORDER_TYPE),1,1) = '2'thenrn ls_table_name := 'mat_purchase_contract_detail';--采rn ELSIF SUBSTR(trim(AS_ORDER_TYPE),1,1) = '3'thenrn ls_table_name := 'mat_purchase_in_store_detail';--采rn ELSIF SUBSTR(trim(AS_ORDER_TYPE),1,1) = '4'thenrn ls_table_name := 'mat_use_out_store_detail';--领rn elsern return 1; rn end if;rn rn ls_sql_string := 'select count(*) rn from equ_sys_info_detail rn where info_type_code = '||'420'||'rn and rn exists(select 1 from'||ls_table_name||rn 'where to_char(order_id) ='||to_char(AN_ORDER_ID)||' rn and rn MATERIALCODE LIKE info_detail_code||'||'%'||')rn and rn INFO_DETAIL_STATE = '||'N'||'rn and exists ( select 1 from v_message_unit_emp rn where unit_type = '||'3'||' rn and rn emp_code = f_get_cur_user_id() rn and rn (info_detail_desc like '||'%'||'||unit_code||'||'%'||'))';rn execute immediate ls_sql_string into ln_count;rn if ln_count>0 thenrn return 1;rn elsern return 0 ;rn end if;rnend F_CHECK_SPECIALMAT_ORDER;rn此数据库函数报错。
DisplayTag Url too long in IE
最近在做的一个项目,使用displayTag导出报表,displaytag会取出所有request中的值.由于页面显示的信息很多,又不允许分页,因此,在导出报表的时候URL过长,该功能在firefox正常.在IE就报错,不知道怎么解决.rnrnMicrosoft Internet Explorer (Browser)rnMicrosoft states that the maximum length of a URL in Internet Explorer is 2,083 characters, with no more than 2,048 characters in the path portion of the URL. In my tests, attempts to use URLs longer than this produced a clear error message in Internet Explorer. rnFirefox (Browser)rnAfter 65,536 characters, the location bar no longer displays the URL in Windows Firefox 1.5.x. However, longer URLs will work. I stopped testing after 100,000 characters. rnSafari (Browser)rnAt least 80,000 characters will work. I stopped testing after 80,000 characters. rnOpera (Browser)rnAt least 190,000 characters will work. I stopped testing after 190,000 characters. Opera 9 for Windows continued to display a fully editable, copyable and pasteable URL in the location bar even at 190,000 characters.
运行异常:Comand is too long。
maven project,windows,when i run testcase: Error running TestApp.readParameter: Command line is too long. In order to reduce its length classpath file can be used. Would you like to enable classpath f...
Error : path name too long
我公司使用Clearcase LT 200306。在进行deliver操作的时候,个别文件报错说path name too long。我检查了log文件,发现是一些文件在进行merge的时候,整体信息比较长,达到262个字符,比如:rn\\chnserver20\cc_views\integration\......\abcdefghijk.java。不知道是否有其他人也遇到过这个问题?有没有方法可以彻底的解决这个问题?
Data too long for column 的问题
我的数据库都设成UTF8了,页面上insert中文后就出上面的错误,怀疑又是字符集的问题。rn用MySql Query Browser插入的中文记录,用页面查询的结果也是空的。rn寻求解决方案rn
argument list too long的问题
各位看帖的兄弟姐妹,您们好。rn下底遇到了一个问题,不解。rn执行命令mount /dev/sdb /tmp 的时候提示mount:argument list too long的提示,挂载不成功。rn特来请教这是什么原因,谢谢了。
mysql :Data too long for column
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'truename' at row 1rn at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3374)rn at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)rn at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)rn at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)rn at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)rn at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)rn at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:998)rn at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)rn at dao.RegeditDao.add_member_info(RegeditDao.java:100)rn at dao.RegeditDao.reg(RegeditDao.java:169)rn at com.jzgc.struts.action.RegeditAction.add(RegeditAction.java:45)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)rn at java.lang.reflect.Method.invoke(Unknown Source)rn at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)rn at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)rn at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)rn at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)rn at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)rn at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)rn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)rn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)rn at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)rn at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)rn at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)rn at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)rn at java.lang.Thread.run(Unknown Source)
调用NetUserAdd失败,提示"_CrtDbgReport: String too long or IO Error"
调用NetUserAdd失败,提示"_CrtDbgReport: String too long or IO Error"
_CrtDbgReport: String too long or IO Error是啥意思?
程序关闭的时候会出现这样的玩意rn“Loader.exe”: 已加载“C:\Windows\System32\nsi.dll”rn“Loader.exe”: 已加载“C:\Windows\System32\version.dll”rn“Loader.exe”: 已加载“C:\Windows\System32\cryptbase.dll”rn“Loader.exe”: 已加载“C:\Windows\System32\clbcatq.dll”rn_CrtDbgReport: String too long or IO Error程序“[9872] Loader.exe: 本机”已退出,返回值为 0 (0x0)。rnrnvc9,因为要从wmi里面查询东西,就边看边抄了一下msdn的代码。rnrn我现在程序只要运行起loader,什么都不干,直接关掉程序都会出现。loader是我测试导出dll的一个对话框,本身没有什么用处。就放了几个按钮,那几个按钮就调试一下函数。rnrn对话框初始化什么的都没有做处理,都用默认的。很奇怪,网上找了一下,好像说是trace这个宏接收字符太短了。rnrn不懂
请教高手,用JAVA JDBC 操作ORACLE 8I LONG类型时出错:string literal too long
用下面的语句如果内容少点的话会成功。rnATPL_XML为LONG型rn语句如下:rnupdate DAPRINTXML set ATPL_XML = 'rnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrn' where ADTPL_CODE = 'BANK_L'rn
向oralce 的long 或clob类型的字段中插入数据时。报ORA-01704: string literal too long
如题.补充:rn这是一个新闻发布系统,我插入的内容是一个HTML的代码.rn问过一些人,说什么绑定变量,这个具体要怎么做??rn跪求这个问题的解决办法.和问题的真正原因.100分求解.~
Encoded Barcodes
Problem DescriptionnAll the big malls need a powerful system for the products retrieval. Now you are employed design a sub-system: reading the barcodes and return the matching products.nnA barcode is an optical machine-readable representation of data, which shows certain data on certain products. A barcode consists of a series of bars with different widths. In our system, the barcodes have been scanned and the widths have been recorded. Every consecutive eight bars are considered as representing the ASCII code of a character, each bar for each bit. Ideally, there should be only two kinds of widths in the eight bars, and the width of the wider bar is twice of the narrower. The wider bar indicates 1, while the narrower indicates 0. However, due to the inaccuracy of printing and scanning, there will be an error of at most 5%. That is, if the pretended exact width is x, you may get a value in the range [0.95x, 1.05x].nnFor example, the width sequence "10.0 20.0 10.0 10.0 10.0 10.0 10.0 20.0" is a valid barcode of our system, and it means (01000001)2, which is (65)10 and the corresponding character is "A". Note that "10.5 20.1 10.1 10.2 9.9 9.7 10.0 19.9" is also a valid barcode representing the same letter.nnYou are given the names of all the products and many queries. Every name contains lower-case letters only, and the length is no more than 30. The queries are represented as barcodes. For each query, you should decode it to a string S, and report the amount of products whose prefix is S. For the output may be very large, you only need to output the sum of all the queries for each case.nn nnInputnThere are several test cases in the input. The first line of each case contains two integers N and M (1 <= N <= 10000, 1 <= M <= 2000), indicating the number of products and queries. Then N lines follow, indicating the names of the products. Note that the names may be duplicated. Then M query blocks follow. The first line of each query block is an integer K (0 < K <= 30) indicating the length of the query, then K lines follow, each line contains 8 positive float numbers, indicating the barcode for each character.nnYou can assume that the barcodes are always valid, and always represent lower-case letters.n nnOutputnOutput one line for each test case, indicating the sum of all the query results as described above.nn nnSample Inputn4 3napplenapplenavatarnbookn1n1 2 2 1 1 1 1 2n2n1 2 2 1 1 1 1 2n10.1 20.1 19.9 20.0 10.2 9.8 9.9 10.0n1n1 2 2 1 1 1 2 2n nnSample Outputn5
long类型时间转换string
long commentTime = list.get(position).getCommentTime(); SimpleDateFormat simpleDateFormat = new SimpleDateFormat(&quot;yyyy-MM-dd HH:mm:ss&quot;); simpleDateFormat.setTimeZone(TimeZone.getTimeZone(&quot;GMT+00:00&quot;)...
jstl String转long
jstl String转longrnrnjavax.servlet.jsp.el.ELException: An exception occured trying to convert String "20.00" to type "java.lang.Long"rnrnrn原因 我在javabean中的get方法是String类型的rnrn在JSP取得时 我需要进行比较大小,因此出现数据类型错误rnrnrn $sp.so_pricern $sp.so_bzpricern rnrnrn因为涉及的地方太多,JAVABEAN中不能修改 so_price的属性类型了 有别的解决方式吗
String怎么转long
创建一个类,它将10个数字对应的单词(one 到 ten) 转换为一个long值,使用switch语气表示转换,并通过命令行参数获取要转换的单词。
查询的问题(Long string)
A表有一个varchar类型字段aa,aa存的其实是long型的数值rnrn现在想得到aa最大的那条记录,怎么写SQL?!rnrn(ORACLE+JSP)
HashMap mapData +long to String
[code=Java]rnHashMap mapDatarnmapData.put("id", new java.util.Date().getTime());rn[/code]rn怎么把[code=Java]new java.util.Date().getTime()[/code]rn转化为String
String 到 Long 的转换问题
new Long((String)ci.getPm("cardLength")rn如果我的cardLength的值为空,咋办?
String可以和long相加???
看书上的源代码:rnpublic class op_buy extends DataBase rn ……rn private String orderId = ""; //用户订单号rn ……rn public boolean payout(HttpServletRequest newrequest){rn ……rn long timeInMillis = System.currentTimeMillis();rn orderId=""+timeInMillis; //以系统时间产生位移的订单编号rn ……rnrn }rnrn}rnrn不明白啊,orderId是一个String,而timeInMillis是long;rn它们是如何合到一起的???
String和Long的强制转换
String str=(String)user.getName(); 当user.getName()为null时,不会报错。 Long l=(Long)user.getPrice(); 当user.getPrice()为null时,也不会报错。 long ll=(Long)user.getPrice(); 当user.getPrice()为null时,会报空指针异常。 因为基本类型的封装类自动拆箱...
convert long to string
把一个long类型(64bit)编码成string(char*,0结尾),使编码后平均长度尽量小
string 转 Long
String s="120.20";rn我想得到的结果是Long类型的12020rnrn请问怎么实现简单?
查询语言的问题 long和string
今天做程序遇到了一点小问题:rn 我做的考生报名程序中,考生报名后打印的准考证竟然没有准考证号!!。 (各人报的学校可能不一样)rnrn 我的想法是:在sql中建立一个BMXXB(报名信息表),里面有学校的准考证号,每次报一个学校就在BMXXB表里zkzh(准考证号列,定义为bigint,也曾试过nvarchar)中找报过这个学校的考生中最大值的那个考号,在这个值的基础上加1,赋值给zkzhid,也就是新报名的那个考生的准考证号了。rnrn现在在pb窗口代码中定义了long zkzhid,zkzhid1 ,检索符合条件的准考证号的代码如下:rnselect max(BMXXB.zkzh) into :zkzhid from BMXXB where BMXXB.bkyx=:bkyxid; rnzkzhid1=zkzhid+1rn然后把值插入到BMXXB中,语句如下:rn insert into "BMXXB"("zkzh") values (:zkzhid1);rnrn1、运行后BMXXB中zkzh值为1.是不是代码zkzhid1=zkzhid+1有问题啊??或long定义有问题??rnrn2、我把zkzhid,zkzhid1 重新定义为string后运行系统提示:rn incompatible types in expression:string,long!!rn 注销zkzhid1=zkzhid+1,把zkzhid插入到BMXXB的zkzh中却成功了!可是由于跟最大号的考号大小一样,也就没什么意义了。rn 请帮我看看这是怎么回事??非常感谢!!
long -> string 类型转换
代码如下:rnDWORD Serial;rnLPDWORD StrSerial=(LPDWORD)Serial;rnMessageBox(NULL,StrSerial,"",MB_OK);rn出错了。。。类型不对了。。rn如何转换rn还有如果。。日期之类的怎么办。。rn有没有转换表,可以看。。
String to long或Color)
我有一个字符串 colorX="#808080"rn如何能把colorX 还原为 #808080 或RGB()
Argument list too long”错误解决方法汇总
这篇文章是回复前几天在论坛一个朋友提出的问题,今天有空,整理了一下,发布出来,供大家参考! 当Linux下试图传递太多参数给一个系统命令(ls *; cp *; rm *; cat *; etc…)时,就会出现”Argument list too long”错误。本文将提供4种解决方法,按复杂程度由低到高排列。 方法#1: 手动把命令行参数分成较小的部分 例1 mv [a-l]* ../...
相关热词 c# 去空格去转义符 c#用户登录窗体代码 c# 流 c# linux 可视化 c# mvc 返回图片 c# 像素空间 c# 日期 最后一天 c#字典序排序 c# 截屏取色 c#中的哪些属于托管机制