表太过长了，可以多表查询嘛？？

木叁。

自建表太长，拆开的话，查询视图可以实现多表查询嘛



Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs {stmnt 178174785 CREATE TABLE QRY_DYN_LEAVEINFO (xid VARCHAR(64) NOT NULL, xcreateTime DATETIME(0), xsequence VARCHAR(128), xupdateTime DATETIME(0), xdistributeFactor INTEGER, xbirthday VARCHAR(255), xbundle VARCHAR(255), xcSituation VARCHAR(255), xcarCard VARCHAR(255), xcarType VARCHAR(255), xdepart VARCHAR(255), xdocumentNum VARCHAR(255), xdriverLicense VARCHAR(255), xdriverLicenseTime VARCHAR(255), xdropTime1 VARCHAR(255), xdropTime10 VARCHAR(255), xdropTime2 VARCHAR(255), xdropTime3 VARCHAR(255), xdropTime4 VARCHAR(255), xdropTime5 VARCHAR(255), xdropTime6 VARCHAR(255), xdropTime7 VARCHAR(255), xdropTime8 VARCHAR(255), xdropTime9 VARCHAR(255), xdueLeave VARCHAR(255), xduties VARCHAR(255), xeducation VARCHAR(255), xenlistday VARCHAR(255), xfamilySituation VARCHAR(255), xgrade VARCHAR(255), xidCard VARCHAR(255), xlegalNum VARCHAR(255), xlevelTime VARCHAR(255), xmarriage VARCHAR(255), xmilitaryRank VARCHAR(255), xname VARCHAR(255), xnativePlace VARCHAR(255), xnote VARCHAR(255), xotherNum VARCHAR(255), xoutLive VARCHAR(255), xoutlook VARCHAR(255), xpartyjoiningday VARCHAR(255), xrankTime VARCHAR(255), xrealDuties VARCHAR(255), xreason1 VARCHAR(255), xreason2 VARCHAR(255), xreason3 VARCHAR(255), xreason4 VARCHAR(255), xreason5 VARCHAR(255), xreason6 VARCHAR(255), xreason7 VARCHAR(255), xreason8 VARCHAR(255), xreason9 VARCHAR(255), xresidueNum VARCHAR(255), xretiredNum VARCHAR(255), xreturnTime1 VARCHAR(255), xreturnTime10 VARCHAR(255), xreturnTime2 VARCHAR(255), xreturnTime3 VARCHAR(255), xreturnTime4 VARCHAR(255), xreturnTime5 VARCHAR(255), xreturnTime6 VARCHAR(255), xreturnTime7 VARCHAR(255), xreturnTime8 VARCHAR(255), xreturnTime9 VARCHAR(255), xspouse VARCHAR(255), xspouseName VARCHAR(255), xstate VARCHAR(255), xstateNote VARCHAR(255), xteamState VARCHAR(255), xtechnicalLevel VARCHAR(255), xtechnicalTitle VARCHAR(255), xtitleTime VARCHAR(255), xunit VARCHAR(255), xwayNum VARCHAR(255), UNIQUE QRY_DYN_LEAVEINFO_DUC (xid, xcreateTime, xupdateTime, xsequence)) ENGINE = innodb} [code=1118, state=42000]

论坛管理员

可以，原生sql支持联表查询