`
woshixushigang
  • 浏览: 575815 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类

Out of range value for column 'bindUid' at row 1

 
阅读更多

今天弄新浪微博绑定,数据库oauth_token表需要插入bindUid耶就是新浪微博账户uid。第一步绑定获取token时候是获取不到uid的,因为AccessToken 类里面 uid没有 get方法。

 

public AccessToken(Response res) throws WeiboException{
		super(res);
		JSONObject json =res.asJSONObject();
		try{
			accessToken = json.getString("access_token");
			expireIn = json.getString("expires_in");
			refreshToken = json.getString("refresh_token");
			uid = json.getString("uid");
		} catch (JSONException je) {
			throw new WeiboException(je.getMessage() + ":" + json.toString(), je);
		}
	}

public String getAccessToken() {
		return accessToken;
	}
	public String getExpireIn() {
		return expireIn;
	}
	public String getRefreshToken() {
		return refreshToken;
	}
 

 没有getUid所以获取不到uid的,只能重新编译并打jar包引入程序。

 

插入数据库过程中报错,因为新浪微博uid是string的并且超过了Int范围。

0
0
分享到:
评论

相关推荐

    大牛总结 MySql常见错误集锦

    6. 错误1264: Out of range value for column 类似地,当插入的数据超出了列的允许范围(如浮点数或日期时间格式),会触发此错误。修改插入的数据以适应列的定义。 7. 错误1136: Column count doesn't match value...

    单元格插入毫秒

    Hx = .Range("A65536").End(xlUp).Row Lx = .Range("IV3").End(xlToLeft).Column .Range(.Cells(1, "E"), .Cells(Hx, Lx)).ClearContents .Range("E1") = "权限设置区" .Range("E1:IV2").HorizontalAlignment =...

    微软内部资料-SQL性能优化5

    Each index row in node pages contains an index key (or set of keys for a composite index) and a pointer to a page at the next level for which the first key value is the same as the key value in the ...

    java中常见的错误.docx

    3. 数据类型不匹配:当尝试将不兼容的数据类型插入到数据库中时,如`Data truncated for column 'gatheringMoney' at row 1`和`Data truncation: Out of range value adjusted for column 'amount' at row 14`,表明...

    python 自动办公- 在Excel中按条件筛选数据并存入新的表.zip

    DataFrame是pandas的核心,它是一个二维表格型数据结构,包含列标签(column labels)和行索引(row indices)。可以方便地处理CSV、Excel、SQL数据库等不同格式的数据。 3. **读取Excel文件**: 使用`pandas`的`...

    Excel-VBA宏编程实例源代码-由数据清单获取数据(List、Column).zip

    rowValues = dataRange.Rows(1).Value '将行1的值存入数组 For i = 1 To UBound(rowValues, 2) Debug.Print rowValues(1, i) '打印数组中的值 Next i ``` 4. **条件查找**: 使用Find方法可以在数据清单中...

    微软内部资料-SQL性能优化3

    For an example of how to decode value from this column using the information above, let us assume we have the following value: 0x000705001F83D775010002014F0BEC4E With byte swapping within each ...

    py源码实例在Excel表格中将上下行相同内容的单元格自动合并

    for row in range(2, ws.max_row + 1): # 从第二行开始 for col in range(1, ws.max_column + 1): cell_value = ws.cell(row=row, column=col).value if cell_value not in merge_dict: merge_dict[cell_value]...

    TMS Pack for FireMonkey2.3.0.1

    New : Support for update 4 hotfix 1 Fixed : Issue with order of freeing objects in TTMSFMXTableView v1.1.0.4 Fixed : Issue with state changing with mouse out of bounds in TTMSFMXSlider Fixed : ...

    Excel_VBA常用技巧_第01章[1].range(单元格)对象.doc

    Sheet2.Cells(i, 1).Value = i Next i End Sub ``` 此代码将在Sheet2的工作表A列中依次填入1至100的数字。 #### 三、单元格区域的选定与操作 除了引用单元格之外,`Range`对象还提供了丰富的属性和方法来对选定...

    Pythonxlwings调用Excel的工具[归纳].pdf

    third_row = [cell.value for cell in list(sheet.rows)[2]] ``` 对于特定区域的单元格操作,可以使用`range`函数或切片语法: ```python # 使用range函数获取A1到B3的矩形区域 for i in range(1, 4): for j in ...

    【办公自动化】python操作excel、word、pdf (含大量代码示例).pdf

    print(cell1.value, cell1.row, cell1.column, cell1.coordinate) print(cell2.value, cell2.row, cell2.column, cell2.coordinate) ``` 要获取一系列单元格的值,可以使用切片操作: ```python cell_range = ...

    c#读取excel一格一格读可以读合并的

    dataTable.Rows[row - 1][col - 1] = range.Value; } } } } // 输出结果 Console.WriteLine("数据已读取到DataTable:"); foreach (DataRow row in dataTable.Rows) { foreach (object value in row....

    mysql常见错误与标准错误对照表.docx

    12. **错误126422003**: "Out of range value adjusted for column '%s' at row %ld",表示试图插入的数据超出了列的范围,MySQL会自动调整值。 13. **错误12651000**: "Data truncated for column '%s' at row %ld...

    qt高效读取与写入excel的demo

    3. **写入Excel数据**:同样,我们可以通过设置`Range`的`Value`属性来写入数据。 ```cpp range->setProperty("Value", "新数据"); ``` 4. **QSpreadsheet库**:对于不依赖Microsoft Office环境或跨平台需求,可以...

    winform读取,保存excel

    for (int row = 1; row <= range.Rows.Count; row++) { for (int col = 1; col <= range.Columns.Count; col++) { if (row == 1) dataTable.Columns.Add(range.Cells[row, col].Value.ToString()); else ...

    Python-xlwings-调用Excel的工具.pdf

    使用 range 函数可以获取任意区间的单元格,例如:for i in range(1, 4): for j in range(1, 3): print(sheet.cell(row=i, column=j))。还可以使用 slice 语法,例如:for row_cell in sheet['A1':'B3']: print(row_...

    Cassandra的PHP客户端库phpcassa.zip

    $users->insert('key', array('column1' => 'value1', 'column2' => 'value2')); $users->get('key'); $users->multiget(array('key1', 'key2')); $users->remove('key1'); // removes whole row $users->remove('...

    EMS Advanced Data Import Component Suite 3.5.0.3 for XE2

    - range of cells in the row or column - A1-F1, B1-B12, C1-ROWFINISH, K4-COLFINISH; - sheet name - [Sheet2]B1-B6; - sheet number - [:3]D4-D9; - several cellsets for the same field - [Sheet2]C12-...

    C#操作Excel

    for (int row = 1; row <= range.Rows.Count; row++) { for (int col = 1; col <= range.Columns.Count; col++) { object cellValue = range.Cells[row, col].Value2; Console.WriteLine($"Row: {row}, Col: {...

Global site tag (gtag.js) - Google Analytics