lost the data in String type

[loquitowen]

ISSUE_TEMPLATE

DBFlow Version:4.2.4

Bug or Feature Request:lost the long string data

Description: i have a long json string,and i inserted the bean without any wrong,but i read it from the database,the value is null. my string like this as follow:

{ "rings": [ [ [512182.45, 750701.602], [512200.686, 750691.269], [512228.647, 750682.151], [512223.177, 750652.366], [512218.185, 750632.565], [512216.715, 750626.737], [512217.286, 750608.477], [512216.651, 750605.898], [512210.362, 750580.353], [512209.885, 750578.415], [512208.824, 750578.373], [512198.228, 750578.68], [512198.058, 750578.689], [512185.516, 750579.122], [512170.812, 750577.824], [512166.055, 750575.662], [512164.757, 750574.364], [512164.747, 750574.313], [512164.709, 750574.291], [512162.403, 750563.335], [512144.7, 750502.007], [512164.319, 750468.202], [512177.941, 750444.729], [512187.03, 750438.391], [512230.724, 750433.585], [512231.482, 750433.58], [512237.05, 750432.961], [512241.936, 750433.504], [512268.455, 750433.312], [512271.492, 750437.782], [512273.348, 750475.9], [512290.095, 750473.968], [512308.269, 750468.623], [512326.416, 750429.932], [512354.561, 750382.944], [512372.109, 750371.126], [512411.557, 750312.097], [512416.244, 750278.704], [512431.356, 750257.5], [512429.597, 750257.079], [512399.686, 750250.955], [512399.652, 750251.011], [512393.256, 750253.57], [512393.133, 750253.552], [512382.608, 750261.131], [512382.595, 750261.246], [512378.757, 750267.216], [512378.169, 750267.607], [512363.356, 750289.372], [512363.29, 750289.658], [512362.081, 750291.385], [512362.016, 750291.45], [512357.743, 750323.297], [512357.668, 750324.27], [512349.606, 750346.842], [512349.078, 750347.547], [512339.657, 750362.701], [512334.657, 750367.701], [512299.657, 750377.701], [512234.657, 750377.701], [512199.656, 750367.701], [512184.656, 750357.7], [512184.656, 750348.387], [512137.731, 750321.421], [512136.381, 750321.121], [512069.278, 750309.378], [512061.17, 750308.297], [512021.066, 750301.005], [511995.546, 750301.005], [511971.484, 750301.004], [511970.191, 750300.806], [511939.655, 750297.7], [511887.204, 750290.099], [511885.761, 750289.955], [511884.259, 750290.002], [511849.729, 750292.846], [511848.986, 750292.983], [511847.762, 750293.032], [511798.286, 750298.116], [511794.651, 750298.566], [511793.405, 750298.595], [511744.655, 750302.7], [511707.929, 750314.862], [511706.984, 750315.263], [511689.593, 750319.383], [511661.675, 750322.129], [511645.656, 750323.731], [511644.965, 750323.652], [511523.296, 750322.519], [511499.922, 750316.945], [511499.125, 750317.252], [511489.891, 750314.614], [511489.739, 750314.522], [511329.234, 750283.363], [511302.777, 750278.296], [511302.453, 750278.296], [511278.75, 750272.114], [511278.241, 750271.921], [511172.782, 750244.254], [511151.666, 750237.399], [511119.098, 750227.821], [511093.936, 750219.371], [511068.188, 750209.877], [511065.711, 750209.701], [511061.991, 750207.592], [511052.629, 750204.141], [511000.499, 750202.836], [510907.708, 750201.298], [510902.1, 750217.692], [510902.023, 750218.073], [510901.832, 750218.477], [510896.978, 750232.667], [510883.275, 750263.211], [510873.617, 750282.423], [510848.454, 750336.227], [510844.079, 750359.381], [510842.092, 750369.896], [510710.018, 750355.382], [510676.777, 750351.908], [510660.367, 750353.88], [510642.578, 750371.531], [510642.428, 750371.68], [510641.851, 750372.526], [510622.148, 750401.415], [510621.633, 750402.169], [510621.567, 750402.359], [510614.502, 750422.66], [510610.967, 750438.764], [510608.208, 750446.753], [510608.058, 750447.186], [510606.157, 750449.379], [510599.748, 750451.259], [510594.605, 750451.193], [510594.313, 750451.062], [510588.626, 750448.511], [510587.987, 750448.224], [510586.332, 750447.992], [510570.42, 750445.765], [510569.019, 750445.569], [510552.088, 750448.02], [510552.045, 750448.059], [510533.388, 750465.233], [510533.347, 750465.272], [510532.975, 750465.378], [510510.991, 750471.675], [510470.227, 750466.716], [510469.722, 750466.654], [510465.72, 750466.478], [510452.055, 750465.877], [510450.383, 750465.804], [510445.439, 750459.544], [510441.286, 750454.285], [510441.27, 750454.265], [510441.214, 750454.194], [510441.199, 750454.206], [510440.916, 750454.45], [510428.252, 750465.369], [510426.259, 750467.087], [510423.034, 750472.281], [510418.7, 750479.26], [510418.527, 750479.539], [510418.595, 750479.566], [510453.675, 750493.067], [510503.164, 750519.141], [510557.697, 750547.498], [510605.413, 750576.372], [510661.713, 750608.673], [510780.877, 750659.942], [510810.333, 750663.093], [510828.561, 750620.04], [510828.256, 750562.898], [510834.243, 750549.956], [510838.355, 750541.067], [510852.785, 750528.822], [510856.687, 750525.219], [510864.28, 750521.039], [510872.872, 750520.889], [510891.815, 750521.806], [510911.827, 750526.545], [510940.709, 750538.796], [510961.899, 750549.352], [510984.451, 750567.469], [510984.495, 750567.537], [510984.502, 750567.543], [510984.516, 750567.569], [510992.498, 750579.818], [510996.996, 750588.021], [510998.981, 750594.238], [511001.869, 750606.796], [511004.983, 750633.463], [511005.583, 750660.306], [511007.711, 750658.684], [511048.143, 750627.879], [511049.514, 750626.834], [511076.599, 750605.081], [511077.593, 750604.33], [511094.152, 750591.813], [511122.89, 750570.09], [511165.952, 750541.178], [511168.017, 750538.85], [511171.59, 750534.825], [511182.197, 750522.873], [511184.083, 750520.748], [511198.928, 750504.021], [511199.998, 750503.266], [511207.056, 750498.283], [511216.213, 750491.818], [511233.272, 750486.602], [511256.044, 750484.179], [511301.378, 750477.686], [511353.967, 750470.241], [511354.098, 750470.289], [511411.033, 750491.207], [511451.126, 750516.636], [511503.183, 750539.002], [511558.978, 750553.697], [511599.288, 750543.65], [511619.876, 750519.185], [511631.806, 750505.267], [511653.18, 750496.32], [511692.88, 750482.003], [511692.994, 750481.962], [511696.017, 750482.611], [511706.153, 750484.572], [511744.302, 750492.965], [511755.512, 750495.369], [511755.616, 750495.455], [511803.954, 750534.965], [511815.952, 750546.405], [511815.968, 750546.451], [511816.002, 750546.478], [511816.002, 750546.549], [511822.889, 750566.515], [511829.655, 750587.701], [511843.591, 750615.436], [511860.254, 750627.126], [511887.05, 750638.971], [511915.5, 750643.582], [512013.023, 750666.61], [512132.16, 750702.105], [512156.92, 750728.348], [512182.45, 750701.602] ], [ [511647.713, 750450.311], [511645.822, 750448.63], [511644.561, 750447.159], [511643.931, 750446.319], [511642.88, 750445.478], [511640.149, 750445.268], [511636.997, 750445.058], [511630.273, 750442.747], [511626.281, 750438.544], [511624.81, 750436.863], [511624.992, 750433.697], [511625.216, 750430.784], [511625.216, 750429.215], [511625.216, 750428.543], [511622.078, 750426.301], [511616.251, 750425.405], [511610.424, 750426.301], [511605.045, 750428.767], [511602.131, 750431.232], [511599.442, 750431.68], [511597.424, 750428.991], [511594.959, 750427.422], [511592.718, 750427.422], [511591.821, 750427.87], [511592.045, 750429.215], [511592.045, 750432.352], [511591.597, 750433.249], [511589.804, 750434.818], [511580.988, 750438.553], [511574.414, 750440.944], [511570.529, 750440.944], [511568.437, 750440.944], [511565.15, 750437.358], [511561.564, 750429.588], [511561.564, 750424.209], [511563.058, 750422.117], [511566.046, 750419.727], [511568.03, 750418.412], [511569.948, 750417.261], [511573.4, 750414.961], [511574.55, 750412.659], [511577.235, 750411.892], [511579.536, 750411.892], [511581.837, 750414.577], [511581.837, 750418.412], [511583.755, 750421.48], [511586.439, 750421.864], [511592.959, 750421.864], [511601.013, 750418.796], [511608.684, 750418.796], [511617.121, 750419.563], [511625.561, 750421.864], [511628.632, 750421.557], [511629.246, 750420.022], [511629.553, 750415.723], [511630.167, 750412.652], [511630.781, 750410.81], [511637.537, 750410.81], [511641.529, 750412.653], [511643.064, 750413.574], [511643.678, 750416.951], [511643.064, 750421.557], [511643.371, 750425.549], [511644.906, 750428.006], [511649.184, 750435.182], [511651.075, 750438.334], [511652.966, 750438.965], [511654.226, 750441.696], [511656.118, 750445.058], [511656.538, 750446.739], [511656.538, 750449.05], [511654.016, 750450.521], [511650.865, 750451.572], [511647.713, 750450.311] ] ], "spatialReference": { "wkid": 4524, "latestWkid": 4524 } }

and my code is :

PlotCanvasBean plotCanvasBean = new PlotCanvasBean(plotWithGeo);

                    plotCanvasBean.setLoginId(AppManager.getInstance().getUserSession().getUid());
                    plotCanvasBean.setCreateTime(new Date());
                    plotCanvasBean.setUUID(UUID.randomUUID().toString());
                    plotCanvasBean.setPlotId(param.getId());

                    plotCanvasBean.insert();

                    List<PlotCanvasBean> plotCanvasBeans1 = SQLite.select()
                            .from(PlotCanvasBean.class)
                            .where(PlotCanvasBean_Table.id.isNotNull())
                            .queryList();

and the column declare as a String

screenshot as follow: the bean insert into the database

the bean read from the database

[loquitowen]

@agrosner ~please give me a hand

[agrosner]

did you figure it out? I would check the table in the database using the DB explorer in Android Studio. Its not clear to me where you set points is that a String field? I dont see it getting set in the code you shared.