found BIT, but expecting BOOLEAN 或 found [tinyint (Types#BIT)], but expecting [bit (Types#BOOLEAN)]

最新推荐文章于 2022-11-14 10:57:33 发布

思想流浪者最新推荐文章于 2022-11-14 10:57:33 发布

spring jpa + mysql

之前mysql 版本 5.6.42 没有出现问题; 替换mysql版本为 8.0.18 后报错:

found [tinyint (Types#BIT)], but expecting [bit (Types#BOOLEAN)]

java中Entity的字段为

    @Column(name = "RP_STATUS")
    private boolean status;

具体报错如下:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [rpn_status] in table [recruit_position_name]; found [tinyint (Types#BIT)], but expecting [bit (Types#BOOLEAN)]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1778)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1105)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549)
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:743)
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:390)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:312)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1214)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1203)
	at cn.com.agree.affweb.OfficialWebsiteApplication.main(OfficialWebsiteApplication.java:13)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [rpn_status] in table [recruit_position_name]; found [tinyint (Types#BIT)], but expecting [bit (Types#BOOLEAN)]
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:402)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:377)
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1837)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1774)
	... 21 common frames omitted
Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [rpn_status] in table [recruit_position_name]; found [tinyint (Types#BIT)], but expecting [bit (Types#BOOLEAN)]
	at org.hibernate.tool.schema.internal.AbstractSchemaValidator.validateColumnType(AbstractSchemaValidator.java:159)
	at org.hibernate.tool.schema.internal.AbstractSchemaValidator.validateTable(AbstractSchemaValidator.java:143)
	at org.hibernate.tool.schema.internal.GroupedSchemaValidatorImpl.validateTables(GroupedSchemaValidatorImpl.java:42)
	at org.hibernate.tool.schema.internal.AbstractSchemaValidator.performValidation(AbstractSchemaValidator.java:89)
	at org.hibernate.tool.schema.internal.AbstractSchemaValidator.doValidation(AbstractSchemaValidator.java:68)
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:191)
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:57)
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:390)
	... 25 common frames omitted

解决:在Column中添加 columnDefinition = "TINYINT(1)"

    @Column(name = "RP_STATUS", columnDefinition = "TINYINT(1)")
    private boolean status;

即可解决.

https://stackoverflow.com/questions/3383169/hibernate-jpa-mysql-and-tinyint1-for-boolean-instead-of-bit-or-char/10224905#10224905

found BIT, but expecting BOOLEAN 或 found [tinyint (Types#BIT)], but expecting [bit (Types#BOOLEAN)] spring jpa + mysql之前mysql 版本5.6.42 没有出现问题; 替换mysql版本为8.0.18 后报错:found [tinyint (Types#BIT)], but expecting [bit (Types#BOOLEAN)]java中Entity的字段为 @Column(name = "RP_STATUS") private b... 在Python中提供了json包来方便快捷的解析json字串的转换过程，但是碰到了一个比较奇怪的问题，就是不太正确的json串如何来解析？ 1. 问题的提出今天在处理一个http请求的响应json之时，基于python进行解析，碰到了如下错误： Traceback (most recent call last): File , line 1, in json.loads(r.text) File /Users/tonychen/anaconda2/lib/python2.7/json/__ 使用 Python 处理 JSON 数据还是非常简单的，常用的命令有两个： json.loads：用于解码 JSON 数据。该函数返回 Python 字段的数据类型 json.dumps：用于将 Python 对象编码成 JSON 字符串（一）json.loads 用于解码 JSON 数据。该函数返回 Python 字段的数据类型，最常使用的代

Thinking with Types started, as so many of my projects do, accidentally. I was unemployed, bored, and starting to get tired of answering the same questions over and over again in Haskell chat-rooms. And so I started a quick document, jotting down a bunch of type-level programming topics I thought it’d be fun to write blog posts about. This document rather quickly turned into an outline ofwhat those blog posts might look like, but as I was about to tease it apart into separate files I stopped myself. Why not turn it into a book instead? I approached some friends to see if anyone was interested in writing it with me. A few nibbles, but nobody had time they wanted to dedicate to such a thing. My excitement subsequently burned out, and the idea lay dormant on the back-burner for a few months. But I was still unemployed, and I was still bored, and I found myself slowly fleshing out chapters regardless. My enthusiasm for writing a book had died down, but I still felt the urge to write. A friend caught me writing one day, and dared me to publish what I had. I acquiesced. And so on July 8th, 2018, I posted a 37 page document to reddit, gauging if there was any interest from the community in such a book. To my continual surprise, there was. The response was about 100x bigger than I was expecting . Kind words and letters of support rolled in, many of whom promised to pay me in order to continue writing it. That was enough for me. I put together a Patreon, started selling early access to the book, and was off to the races. The promise was to publish weekly updates, which—combined with not wanting to commit fraud—kept me extremely motivated to get this book finished. It’s a powerful technique to stay focused, and I’d strongly recommend it to anyone who is better at starting projects than finishing them. It sounds cliche, but this book couldn’t have happened without the overwhelming support of the Haskell community. It’s particularly telling that every day I learn new things from them about this marvelous language, even after five years. Written with love by Sandy Maguire. 2018.

在学习python语言中用json库解析网络数据时，我遇到了两个编译错误：json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes:和json.decoder.JSONDecodeError: Expecting value:。费了一些时间才找到原因，在此记录总结，希望能对学习python的同学有所帮助。我运行的程序初始如下： import json\ndata=''' 'name' : 'A', 'phone': { 'type' : 'intl', 'number' : +1

问题产生的原因是Hibernate/JPA生成的表与数据库保留字冲突，如‘USER’表，解决的方法是修改表名，或者数据库取消冲突的保留字：在配置表中设置：NON_KEYWORDS=USER其中完整的设置例如下：spring.datasource.url=jdbc:h2:mem:testdb;NON_KEYWORDS=USER spring.datasource.driverClassName=org.h2.Driver spring.datasource.username=sa spring.dataso

升级h2版本后出现如下错误，经排查为高版本h2有更多的关键字，创建表时如果列名与其冲突需要用英文双引号引起来。具体关键字可去h2官网查询http://www.h2database.com/html/advanced.html。命中该问题后的报错信息如下： SQL Error [42001] [42001]: Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS CRACKTASK (ID_ VARCHAR(255) , TYPE VARCHA.

在python中，对词典的值，可以新增，或者修改，如下：以上这篇对python中词典的values值的修改或新增KEY详解就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持软件开发网。您可能感兴趣的文章:python 对字典按照value进行排序的方法Python实现字典按key或者value进行排序操作示例【sorted】python中报错”json.decoder.JSONDecodeError: Expecting value:”的解决对python中字典keys,values,items的使用详解python字

openssl dsaparam -out dsa_param.pem 1024 b) 生成私钥 openssl gendsa -out dsa_private_temp_key.pem dsa_param.pem [b]将传统格式的私钥转换成PKCS#8格式的（java使用的是PKCS#8格式的私钥）[/b] openssl pkcs8 -topk8 -inform PEM -in dsa_private_temp_key.pem -outform PEM -nocrypt -out dsa_private_key.pem c) 生成公钥 openssl dsa -in dsa_private_key.pem -pubout -out dsa_public_key.pem

<br /><br />5.12.5.2.2.2.1.3.11. Finish the derived RECORD_TYPE – finish vtable<br />For our example of template instantiation, it contains no vtable as no virtual functions and virtual bases involved (C++ pro bit s template from having virtual fu

通过springboot写单元测试时，遇到一个问题： Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "([*]"; expected "(, WITH, SELECT, FROM"; SQL statement: ( [42001-197] 从报错信息看，很明显是sql语法错误，出错位置在 ‘（’ ...

org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #2 of class path resource [wxapp.sql]: insert into “PRODUCTS”(PRODUCT_DISC, PRODUCT_NAME, product_num,PRODUCT_PICTURE, PRODUCT_PRICE, PROVIDER_I

ValueError: X has 326125 features, but MultinomialNB is expecting 59079 features as input.

这个错误通常是因为你的训练集和测试集之间的特征数量不一致导致的。在使用MultinomialNB分类器时，你的训练集和测试集中的特征数量必须是相同的。你可以使用诸如scikit-learn的CountVectorizer或TfidfVectorizer来提取文本特征，并确保在训练和测试集上使用相同的向量化器。具体而言，你需要在测试集上使用训练集上已经拟合好的向量化器，可以通过以下代码实现： ```python from sklearn.feature_extraction.text import CountVectorizer from sklearn.naive_bayes import MultinomialNB # 假设已经使用CountVectorizer将训练集向量化 vectorizer = CountVectorizer() X_train = vectorizer.fit_transform(train_data) y_train = train_labels # 在测试集上使用已经拟合好的向量化器 X_test = vectorizer.transform(test_data) y_test = test_labels # 训练和预测 clf = MultinomialNB() clf.fit(X_train, y_train) y_pred = clf.predict(X_test) 这样就可以避免特征数量不一致的问题。

报错： Failed to install the following Android SDK packages as some licences have not been accepted. 89178