免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › 程序设计 › Perl › 如何读取blob数据？
最近访问板块 发新帖
查看: 2776 | 回复: 0
打印 上一主题 下一主题

如何读取blob数据？ [复制链接]

小渔村

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2008-12-27 20:01 |只看该作者 |倒序浏览
mysql
往外读取的时候不好控制啊

比如说有这样的数据，LOG_MESSAGE和LOG_KEYWORD是blob型。
select LOG_NAME,LOG_SUBJECT,LOG_MESSAGE,LOG_KEYWORD,INPUT_DATE from LOG\G;
有很多行：
  1. *************************** 1. row ***************************
  2. LOG_NAME: 10.9.1.1 moblie.log
  3. LOG_SUBJECT:Log at 200812262250 [ERROR(1)]
  4. LOG_MESSAGE: 2008-1-2 22:46:28,199 WARN  [authority.service.LoginService#compareLeverageGroup:63] : 00019663 Deal LeverageGroup pass time :14 ms
  5. 2008-1-6 22:46:28,200 INFO  [lib.security.CheckLogin#insertLoginLog:45] : insert login info...customerId:00019663  userAgent:DoCoMo/2.0 P904i(c100;TB;W24H15;ser352880015552747;icc8981100010543834700F)  channel:mob
  6. 2008-12-26 22:46:28,240 INFO  [info.dao.SessionDAO#saveSessionData:91] : insert Session data table Jhf_Customer_Session with customerId:00019663 sessionID: 990247304395527628 date:Fri Dec 26 22:46:28 JST 2008,channelID:MOB
  7. 2008-12-26 22:46:28,242 INFO  [authority.action.QuickLoginAction#dologinquick:366] : quicklogin sucess, , phoneUID=icc8981100010543834700F, customerID=00019663
  8. 2008-12-26 22:46:28,901 INFO  [info.position.PositionReceiver#onMessage:70] : ======================get JMS message:===================00037538
  9. 2008-12-26 22:46:30,969 ERROR [lib.util.CurrencyUtil#getCurrencyPairInfo:81] : no data found according to the codeOrName!000000
  10. 2008-12-26 22:46:34,736 INFO  [dispatch.listener.DispatchListener#onMessage:39] : Receive Info For RealTime !!!
  11. 2008-12-26 22:46:34,737 INFO  [dispatch.listener.DispatchListener#onMessage:40] : Receive message !!!OrderResponseInfo:[priceId=20081226DBPD71d2e82c-02ea-460d-aa86-e12c6d7608df,currencyPair=null,productId=null,orderId=20081226ORD06070198,tradeId=null,fxOrderId=null,customerId=null,side=0,amount=null,executionPrice=null,tradeDate=null,valueDate=null,timequoteId=null,timequoteFlag=false,routeFlag=0,successFlag=false,errorCode=4088,errorMsg= RealTime Order Is Invalid!]
  12. 2008-12-26 22:46:35,013 INFO  [info.position.PositionReceiver#onMessage:70] : ======================get JMS message:===================00041095
  13. 2008-12-26 22:46:35,885 INFO  [common.util.BeanUtil#getRate:763] : checkPrice start
  14. 2008-12-26 22:46:35,886 INFO  [common.util.BeanUtil#getRate:767] : pairCode = USD/JPY
  15. LOG_KEYWORD: ERROR
  16. ERROR [lib.util.CurrencyUtil#getCurrencyPairInfo:81] : no data found according to the codeOrName!000000
  17. INPUT_DATE: 2008-12-26 22:50:05
  18. *************************** 2. row ***************************
  19.    LOG_NAME: 10.9.1.31 web.log
  20. LOG_SUBJECT:  Log at 200812262251 [ERROR(3)]
  21. LOG_MESSAGE: 2008-12-26 22:51:16,951 INFO  [core.custtrade.WriteOrderServiceImpl#abortOrder:1300] : abortOrder->obean.getOrderStatus() = 2
  22. 2008-12-26 22:51:16,952 INFO  [core.custtrade.WriteOrderServiceImpl#abortOrder:1302] : abortOrder->obean.getTradeType() = 1
  23. 2008-12-26 22:51:16,954 INFO  [core.dao.ContractDao#abortSettleOrderToContract:195] :  contract.AmountSettling:20000.00
  24. 2008-12-26 22:51:16,955 INFO  [core.dao.ContractDao#abortSettleOrderToContract:196] :  order.getOrderAmount:20000.00
  25. 2008-12-26 22:51:16,958 INFO  [core.dao.OrderDao#cancelOrder:4357] : cancelOrder->order number 0
  26. 2008-12-26 22:51:16,958 ERROR [core.dao.OrderDao#cancelOrder:4381] : problem  e r r
  27. cn.bestwiz.jhf.core.bo.exceptions.DaoException: order status is not (0,1) ,so can not cancel ,orderId:20081226ORD06070028
  28.         at cn.bestwiz.jhf.core.dao.OrderDao.cancelOrder(OrderDao.java:4359)
  29.         at cn.bestwiz.jhf.core.custtrade.WriteOrderServiceImpl.abortOrder(WriteOrderServiceImpl.java:1298)
  30.         at cn.bestwiz.jhf.core.custtrade.WriteOrderServiceImpl.abortOrder(WriteOrderServiceImpl.java:1549)
  31.         at cn.bestwiz.jhf.frontdesk.agent.OrderAgent.abortOrder(OrderAgent.java:423)
  32. --
  33.         at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
  34.         at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
  35.         at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
  36.         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
  37.         at java.lang.Thread.run(Thread.java:619)
  38. 2008-12-26 22:51:16,959 ERROR [core.custtrade.WriteOrderServiceImpl#abortOrder:1322] : abortOrder failed
  39. cn.bestwiz.jhf.core.bo.exceptions.DaoException: Exception  error
  40.         at cn.bestwiz.jhf.core.dao.OrderDao.cancelOrder(OrderDao.java:4382)
  41.         at cn.bestwiz.jhf.core.custtrade.WriteOrderServiceImpl.abortOrder(WriteOrderServiceImpl.java:1298)
  42.         at cn.bestwiz.jhf.core.custtrade.WriteOrderServiceImpl.abortOrder(WriteOrderServiceImpl.java:1549)
  43.         at cn.bestwiz.jhf.frontdesk.agent.OrderAgent.abortOrder(OrderAgent.java:423)
  44.         at cn.bestwiz.jhf.frontdesk.trade.biz.logic.OrderChangeHandler.buildOrderResponseData(OrderChangeHandler.java:189)
  45. --
  46.         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
  47.         at java.lang.Thread.run(Thread.java:619)
  48. Caused by: cn.bestwiz.jhf.core.bo.exceptions.DaoException: order status is not (0,1) ,so can not cancel ,orderId:20081226ORD06070028
  49.         at cn.bestwiz.jhf.core.dao.OrderDao.cancelOrder(OrderDao.java:4359)
  50.         ... 32 more
  51. 2008-12-26 22:51:16,961 WARN  [core.custtrade.WriteOrderServiceImpl#abortOrder:1579] : abortOrder failed code:4090 message: cn.bestwiz.jhf.core.bo.exceptions.DaoException: Exception  error
  52. 2008-12-26 22:51:16,962 WARN  [frontdesk.agent.OrderAgent#abortOrder:444] : code:4090 message: cn.bestwiz.jhf.core.bo.exceptions.DaoException: Exception  error
  53. 2008-12-26 22:51:16,963 INFO  [core.custtrade.WriteOrderServiceImpl#abortOrder:1561] : abortOrder send AlertFrontInfo Start
  54. 2008-12-26 22:51:16,979 INFO  [core.custtrade.WriteOrderServiceImpl#abortOrder:1563] : abortOrder send AlertFrontInfo End
  55. 2008-12-26 22:51:16,980 INFO  [info.position.PositionReceiver#onMessage:70] : ======================get JMS message:===================00032907
  56. 2008-12-26 22:51:16,988 INFO  [core.custtrade.WriteOrderServiceImpl#checkAccountStatusIfCancel:1227] : checkAccountStatusIfCancel->cts.getId() = 00032907
  57. 2008-12-26 22:51:16,988 INFO  [core.custtrade.WriteOrderServiceImpl#checkAccountStatusIfCancel:1229] : checkAccountStatusIfCancel->cts.getAccountStatus() = 0
  58. LOG_KEYWORD: ERROR
  59. ERROR [core.custtrade.WriteOrderServiceImpl#abortOrder:1322] : abortOrder failed
  60. ERROR [core.dao.OrderDao#cancelOrder:4381] : problem  e r r
  61. INPUT_DATE: 2008-12-26 22:52:02
复制代码


想弄出如下效果：
  1. LOG_NAME                        LOG_SUBJECT                LOG_MESSAGE        LOG_KEYWORD   INPUT_DATE

  3. 10.9.1.1 moblie.log  Log at 200120050 [ERROR(1)]  ...........................    ...............    2008-12-26 22:50:05
  4. 10.9.1.31 web.log   Log at 200812262251 [ERROR(3)] ...........................    .........    2008-12-26 22:52:02
  5.                                                                                        blob数据          blob数据
复制代码


请教各位高手
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP