Error setting non null for parameter #1 with JdbcType null . dm.jdbc.driver.DMException: Invalid sequence number

Problem occurred org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{<!– –>property=’__frch_item_0.batchId’, mode=IN, javaType=class java.lang.Long, jdbcType=null, numericScale=null, resultMapId=’null’, jdbcTypeName=’null’, expression=’null’}. Cause: org. apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: dm.jdbc.driver.DMException: The sequence number […]

ctypes of faster python calls so/dll

Directory .so and .dll files Compile go code into dynamic link library Compile C code into a dynamic link library ctypes library Basic data types Instructions Basic data types array type pointer type Structure type Nested structure Structure array Structure pointer Array of structure pointers How ctypes loads DLL 1. Use the `CDLL` class 2. […]

scp tab completion error: F-bash: warning: setlocale: LC_CTYPE: cannot change locale (en_US.UTF-8)

1. Problem description During a certain Linux operation, the function scp command was used, and the following directory could not be completed using Tab. The error was reported: -bash: warning: setlocale: LC_CTYPE: cannot change locale (en_US.UTF-8): No such file or directory Related links: character map file `UTF-8’ not found 2. Cause handling 1) As shown […]

DOCTYPE mapper PUBLIC

<?xml version=”1.0″ encoding=”UTF-8″?> <!DOCTYPE mapper PUBLIC “-//mybatis.org//DTD Mapper 3.0//EN” “http://mybatis.org/dtd/mybatis-3-mapper.dtd”> <mapper namespace=”org.jeecg.modules.device.spare.mapper.SpareWarehousingMapper”> <resultMap type=”org.jeecg.modules.device.spare.entity.SpareWarehousing” id=”DevSpareWarehousingMap”> <result property=”id” column=”id” jdbcType=”VARCHAR”/> <result property=”createBy” column=”create_by” jdbcType=”VARCHAR”/> <result property=”createTime” column=”create_time” jdbcType=”TIMESTAMP”/> <result property=”updateBy” column=”update_by” jdbcType=”VARCHAR”/> <result property=”updateTime” column=”update_time” jdbcType=”TIMESTAMP”/> <result property=”sysOrgCode” column=”sys_org_code” jdbcType=”VARCHAR”/> <result property=”tenantId” column=”tenant_id” jdbcType=”VARCHAR”/> <result property=”deleted” column=”deleted” jdbcType=”INTEGER”/> <result property=”inStorageNo” column=”in_storage_no” jdbcType=”VARCHAR”/> <result property=”inStorageDate” column=”in_storage_date” jdbcType=”TIMESTAMP”/> […]

All jdbcType types of MyBatis

MyBatis handles MySQL field types date and datetime 1) DATETIME Display format: yyyy-MM-dd HH:mm:ss Time range: [ ‘1000-01-01 00:00:00’ to ‘9999-12-31 23:59:59’] 2) DATE Display format: yyyy-MM-dd Time range: [‘1000-01-01’ to ‘9999-12-31’] 3) TIMESTAMP Display format: yyyy-MM-dd HH:mm:ss Time range: [ ‘1970-01-01 00:00:00’ to ‘2037-12-31 23:59:59’] copy One, MyBatis has two types of jdbcType for […]

enctype of form form in HTML

Preface Recently, I found that although the form form is often used to submit data, it is still a little vague, such as: What is the difference between post and put, application/x-www-form-urlencoded and multipart/form-data, and why it can only be uploaded by mutipart/form-data file; so thought I’d spend some time digging through it Post And […]

[Solved] pyenv fails with : ModuleNotFoundError: No module named ‘_ctypes’ error

After installing 3.9.7 with pyenv, during use This problem was encountered when installing psycopg2. Re-execution found no effect. System python3 import without error The python3.9.7 installed by pyenv reports an error After checking the information, you need to install libffi-dev. The ubuntu installation command is as follows: sudo apt-get install libffi-dev Installation error: Unable to […]

[Solved] python3 running spark program error: ModuleNotFoundError: No module named ‘_ctypes’

Table of Contents 1. Project Scenario: 2. Problem description 3. Reason analysis: Fourth, the solution: 1. Project Scenario: After installing spark and anaconda, I was going to use python for spark programming. I reported this error when I ran the python program with the python command. Here is how to solve it. 2. Description of […]

[Solved] [Problem solving] Two solutions for mybatis type mismatch -Result type not match for select id=”selectUser” srcType: com.kuang.pojo

Problem description: Result type not match for select id=”selectUser” srcType: com.kuang.pojo.User targetType: com.kuang.pojo.User Solution: method one: Re-alias the entity class in mybatis-config.xml; <typeAlias type=”com.kuang.pojo.User” alias=”User”/> Method Two: There are multiple User classes in your project, just rename User to Users;