开源论坛、问答系统，现有功能提问、回复、通知、最新、最热、消除零回复功能。功能持续更新中…… 技术栈 Spring、Spring Boot、MyBatis、MySQL/H2、Bootstrap

小匠

Last update: Dec 30, 2022

Overview

码问社区

在线演示地址

www.mawen.co

功能列表

开源论坛、问答系统，现有功能提问、回复、通知、最新、最热、消除零回复功能。功能持续更新中……

技术栈

技术	链接
Spring Boot	http://projects.spring.io/spring-boot/#quick-start
MyBatis	https://mybatis.org/mybatis-3/zh/index.html
MyBatis Generator	http://mybatis.org/generator/
H2	http://www.h2database.com/html/main.html
Flyway	https://flywaydb.org/getstarted/firststeps/maven
Lombok	https://www.projectlombok.org
Bootstrap	https://v3.bootcss.com/getting-started/
Github OAuth	https://developer.github.com/apps/building-oauth-apps/creating-an-oauth-app/
UFile	https://github.com/ucloud/ufile-sdk-java
Bootstrap	https://v3.bootcss.com/getting-started/

在线视频

标题	链接
【Spring Boot 实战】论坛项目【第一季】	https://www.bilibili.com/video/BV1r4411r7au
【Spring Boot 实战】热门话题【第二季】	https://www.bilibili.com/video/BV1Z4411f7RK
【Spring Boot 实战】接入广告流量变现【第三季】	https://www.bilibili.com/video/BV1L4411y7J9
【Spring Boot 实战】Vue 零基础入门【第四季】	https://www.bilibili.com/video/BV1gE411R7YA
【Spring Boot 实战】快速搭建免费 HTTPS 服务	https://www.bilibili.com/video/BV1oJ411K7VT

本地运行手册

安装必备工具
JDK，Maven
克隆代码到本地

git clone https://github.com/codedrinker/community.git

运行打包命令

mvn package

运行项目

java -jar target/community-0.0.1-SNAPSHOT.jar

访问项目

http://localhost:8887

资源文件

未使用 Flyway 之前的数据库脚本

CREATE TABLE USER
(
    ID int AUTO_INCREMENT PRIMARY KEY NOT NULL,
    ACCOUNT_ID VARCHAR(100),
    NAME VARCHAR(50),
    TOKEN VARCHAR(36),
    GMT_CREATE BIGINT,
    GMT_MODIFIED BIGINT
);

运行 migrate 和 generator 的命令

mvn flyway:migrate
mvn -Dmybatis.generator.overwrite=true mybatis-generator:generate

扩展资料

Spring 文档
 Spring Web
es
Github deploy key
Bootstrap
Github OAuth
Spring
菜鸟教程
 Thymeleaf
Spring Dev Tool
Spring MVC
Markdown 插件
 UFfile SDK
Count(*) VS Count(1)
Git
Visual Paradigm
Flyway
Lombok
ctotree
Table of content sidebar
One Tab
Live Reload
Postman

更新日志

2019-7-30 修复 session 过期时间很短问题
2019-8-2 修复因为*和+号产生的搜索异常问题
2019-8-18 添加首页按照最新、最热、零回复排序
2019-8-18 修复搜索输入 ? 号出现异常问题
2019-8-22 修复图片大小限制和提问内容为空问题
2019-9-1 添加动态导航栏

联系我

有任何问题可以扫码下面两个二维码找到我，左边是微信订阅号，关注回复 ‘面试’即可获得我整理的(2W字)阿里面经，右边是个人微信号，有任何技术上面的问题可以给我留言。

微信公众号	个人微信
码匠笔记	xj17500

Comments

Cannot resolve method 'create' in 'RequestBody'

RequestBody body = RequestBody.create(mediaType, JSON.toJSONString(accessTokenDTO)); Request request = new Request.Builder() .url("https://github.com/login/oauth/access_token") .post((okhttp3.RequestBody) body) .build();

create方法报错，如何解决啊？卡在这里了

opened by woow-wu7 4
mvn clean compile package 报错

mvn compile -e [INFO] Error stacktraces are turned on. [INFO] Scanning for projects... [INFO] [INFO] ------------------< life.majiang.community:community >------------------ [INFO] Building community 0.0.1-SNAPSHOT [INFO] --------------------------------[ jar ]--------------------------------- [INFO] [INFO] --- maven-resources-plugin:3.1.0:resources (default-resources) @ community --- [INFO] Using 'UTF-8' encoding to copy filtered resources. [INFO] Copying 440 resources [INFO] [INFO] --- maven-compiler-plugin:3.1:compile (default-compile) @ community --- [INFO] Changes detected - recompiling the module!

[INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 4.200 s [INFO] Finished at: 2022-12-29T16:06:38-05:00 [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.1:compile (default-compile) on project community: Compilation failure -> [Help 1]
org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.1:compile (default-compile) on project community: Compilation failure at org.apache.maven.lifecycle.internal.MojoExecutor.doExecute2 (MojoExecutor.java:375) at org.apache.maven.lifecycle.internal.MojoExecutor.doExecute (MojoExecutor.java:351) at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:215) at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:171) at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:163) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:117) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81) at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56) at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:128) at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:294) at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192) at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105) at org.apache.maven.cli.MavenCli.execute (MavenCli.java:960) at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:293) at org.apache.maven.cli.MavenCli.main (MavenCli.java:196) at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source) at java.lang.reflect.Method.invoke (Unknown Source) at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282) at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406) at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347) Caused by: org.apache.maven.plugin.compiler.CompilationFailureException: Compilation failure at org.apache.maven.plugin.compiler.AbstractCompilerMojo.execute (AbstractCompilerMojo.java:862) at org.apache.maven.plugin.compiler.CompilerMojo.execute (CompilerMojo.java:129) at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo (DefaultBuildPluginManager.java:137) at org.apache.maven.lifecycle.internal.MojoExecutor.doExecute2 (MojoExecutor.java:370) at org.apache.maven.lifecycle.internal.MojoExecutor.doExecute (MojoExecutor.java:351) at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:215) at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:171) at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:163) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:117) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81) at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56) at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:128) at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:294) at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192) at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105) at org.apache.maven.cli.MavenCli.execute (MavenCli.java:960) at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:293) at org.apache.maven.cli.MavenCli.main (MavenCli.java:196) at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source) at java.lang.reflect.Method.invoke (Unknown Source) at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282) at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406) at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347) [ERROR] [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException

环境变量错了已解决

opened by damon46kai 1
Bump h2 from 1.4.199 to 2.0.206
Bumps h2 from 1.4.199 to 2.0.206.

Release notes

Sourced from h2's releases.

Version 2.0.206

Critical security issue with H2 console is fixed.

Also important changes included:

Version 2.0.204

Multilple regression fixes discovered after 2.0.202 release,

There are no persistence changes between 2.0.202 and 2.0.204, so jar file swap is enough, if database had been upgraded to 2.0.202 already, otherwise please read the message below:

Between version 1.4.200 and version 2.0.202 there have been considerable changes, such that a simple update is not possible. The official way to upgrade is to do a BACKUP of your existing database USING YOUR CURRENT VERSION OF H2. Then create a fresh database USING THE NEW VERSION OF H2, then perform a SCRIPT to load your data.

Version 2.0.202

Besides many dozens of fixed bugs, performance improvements, more adherence to a standard SQL syntax and type system, there are

Some new features:

Complete re-work of INFORMATION_SCHEMA to be more in-line with the standard

Support for new types: ARRAY, ROW, JAVA_OBJECT

Numerous bit, string, array and system functions implemented

Standard-based access to generated keys

JDBC 4.2 compliance

Support for JDK 7 is dropped

PageStore is discontinued

MVStore changes:

Descending MVMap and TransactionMap cursor

Disk space reclamation algorithm improvements

Between version 1.4.200 and version 2.0.202 there have been considerable changes, such that a simple update is not possible. The official way to upgrade is to do a BACKUP of your existing database USING YOUR CURRENT VERSION OF H2. Then create a fresh database USING THE NEW VERSION OF H2, then perform a SCRIPT to load your data.

Version 1.4.200

Some new features:

JSON data type; JSON_OBJECT, JSON_ARRAY, JSON_OBJECTAGG, and JSON_ARRAYAGG functions; JSON predicate

TIME WITH TIME ZONE data type

BITNOT, LSHIFT, and RSHIFT functions

... (truncated)

Commits

3d957a0 Release 2.0.206 preparation

2b6e303 Update changelog

b24aa46 Check URL scheme

4a2e677 Get data types directly from linked tables from H2

69aff24 Fix ValueVarcharIgnoreCase.equals()

0ebf142 Fix group-sorted optimization for data types with different equal values

8aca5f4 Correct Date and Time part in tutorial.html

4bfd6f0 Add support of H2 2.0+ to source.html and sourceError.html

927c830 Update copyright years

abac6c8 Next development version

Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

@dependabot use these labels will set the current labels as the default for future PRs for this repo and language

@dependabot use these reviewers will set the current reviewers as the default for future PRs for this repo and language

@dependabot use these assignees will set the current assignees as the default for future PRs for this repo and language

@dependabot use this milestone will set the current milestone as the default for future PRs for this repo and language

You can disable automated security fix PRs for this repo from the Security Alerts page.

dependencies java
opened by dependabot[bot] 1
Bump mysql-connector-java from 5.1.45 to 8.0.16
Bumps mysql-connector-java from 5.1.45 to 8.0.16.

Changelog

Sourced from mysql-connector-java's changelog.

Changelog

https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/

Version 8.0.20

Fix for Bug#30805426, IN CASE OF ISAUTHMETHODSWITCHREQUESTPACKET , TOSERVERS > 1 ARE IGNORED.

Fix for Bug#97714 (30570249), Contribution: Expose elapsed time for query interceptor to avoid hacky thread local implementations. Thanks to Matti Sillanpää and Johnathan Crawford for their contribution.

Fix for Bug#97724 (30570721), Contribution: Allow '3.' formatted numbers. Thanks to Nick Pollett for his contribution.

Fix for Bug#98536 (30877755), SIMPLEDATEFORMAT COULD CACHE A WRONG CALENDAR.

Fix for Bug#91112 (28125069), AGAIN WRONG JAVA.SQL.DATE.

Fix for Bug#30474158, CONNECTOR/J 8 DOES NOT HONOR THE REQUESTED RESULTSETTYPE SCROLL_INSENSITIVE ETC.

Fix for Bug#98445 (30832513), Connection option clientInfoProvider=ClientInfoProviderSP causes NPE.

WL#12248, DevAPI: Connection compression.

Fix for Bug#30636056, ResultSetUtil.resultSetToMap() can be unsafe to use.

Fix for Bug#97757 (30584907), NULLPOINTEREXCEPTION WITH CACHERESULTSETMETADATA=TRUE AND EXECUTEQUERY OF "SET".

Version 8.0.19

WL#13346, Support for mult-host and failover.

Fix for Bug#97413 (30477722), DATABASEMETADATA IS BROKEN AFTER SERVER WL#13528.

WL#13367, DNS SRV support.

WL#12736, DevAPI: Specify TLS ciphers to be used by a client or session.

Fix for regression tests broken by Bug#97079 fix.

Fix for Bug#96383 (30119545) RS.GETTIMESTAMP() HAS DIFFERENT RESULTS FOR TIME FIELDS WITH USECURSORFETCH=TRUE.

Fix for Bug#96059 (29999318), ERROR STREAMING MULTI RESULTSETS WITH MYSQL-CONNECTOR-JAVA 8.0.X.

Fix for Bug#96442 (30151808), INCORRECT DATE ERROR WHEN CALLING GETMETADATA ON PREPARED STATEMENT.

Version 8.0.18

WL#13347, Connectors should handle expired password sandbox without SET operations.

Fix for Bug#84098 (25223123), endless loop in LoadBalancedAutoCommitInterceptor.

Commits

34cbc6b License book updated.

793bd55 Minor fix for tests failing with URL without parameters.

58600cc WL#12825, Remove third-party libraries from sources and bundles.

5aa15d5 Fix for Bug#93590 (29054329), javax.net.ssl.SSLException: closing inbound bef...

1fecc2b Fix for Bug#94414 (29384853), Connector/J RPM package have version number in ...

f5d24e3 Fix for Bug#27786499, REDUNDANT FILES IN DEBIAN PACKAGE FOR DEBIAN9(COMMUNITY...

c49db58 WL#12246, DevAPI: Prepared statement support.

a5c3d29 Added definition file for msi building tools.

13045c2 WL#10839, Adjust c/J tests to the new "ON" default for

2e350a5 Fix for Bug#29329326, PLEASE AVOID SHOW PROCESSLIST IF POSSIBLE.

Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

@dependabot use these labels will set the current labels as the default for future PRs for this repo and language

@dependabot use these reviewers will set the current reviewers as the default for future PRs for this repo and language

@dependabot use these assignees will set the current assignees as the default for future PRs for this repo and language

@dependabot use this milestone will set the current milestone as the default for future PRs for this repo and language

You can disable automated security fix PRs for this repo from the Security Alerts page.

dependencies
opened by dependabot[bot] 1
Add unit tests
Hi. I've analysed your codebase and noticed that it is not fully tested. I've written some tests for the methods in the following classes with the help of Diffblue Cover:

life.majiang.community.dto.ResultDTO

life.majiang.community.exception.CustomizeErrorCode

Hopefully, these tests will help you detect any regressions caused by future code changes. If you would find it useful to have additional tests written for this repository, I would be more than happy to look at other classes that you consider important in a subsequent PR.
opened by EdgarScott 1
修改页数栏逻辑和修复问题二次提交的bug

页数栏逻辑：最多显示5个页码下标。当页码栏有第 1 页下标时不显示首页跳转 << ,尾页同理；当位于第 1 页时不显示跳转 <, 尾页同理。问题二次提交的bug：当修改问题时，修改出错会丢失问题 id ，再次修改时当作新问题发布，现已修复。其他：优化部分代码，忽略 test 文件夹。

opened by hasafox 0
Bump commons-io from 2.6 to 2.7
Bumps commons-io from 2.6 to 2.7.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

@dependabot use these labels will set the current labels as the default for future PRs for this repo and language

@dependabot use these reviewers will set the current reviewers as the default for future PRs for this repo and language

@dependabot use these assignees will set the current assignees as the default for future PRs for this repo and language

@dependabot use this milestone will set the current milestone as the default for future PRs for this repo and language

You can disable automated security fix PRs for this repo from the Security Alerts page.

dependencies java
opened by dependabot[bot] 0
前端的一个小bug
提问页面，添加标签时，若添加了"docker"就无法再添加"c", 因为字符串"c"在"docker"中出现过。即添加一个标签时，如果这个标签之前并不存在，但是只要有一个包含了这个标签字符串的另一个标签存在，就无法添加这个标签。 community.js中的selectTag方法，

function selectTag(e) { var value = e.getAttribute("data-tag"); var previous = $("#tag").val(); if (previous.indexOf(value) == -1) { if (previous) { $("#tag").val(previous + ',' + value); } else { $("#tag").val(value); } } }

目前只判断了待添加标签字符串value是否在previous中出现过，可以改为: 找到previous中出现的所有value子串, 并判断每个value子串是一个独立标签还是另一个标签的一部分。若都只是另一个标签的一部分，那么这个新标签是可以添加的
opened by jerrykcode 0
mvn package 报错

Caused by: java.lang.IllegalStateException: Cannot load driver class: @db.driver@

[INFO] [INFO] Results: [INFO] [ERROR] Errors: [ERROR] CommunityApplicationTests.contextLoads ? IllegalState Failed to load Applicati... [INFO] [ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0 [INFO] [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 7.301 s [INFO] Finished at: 2022-12-29T20:18:53-05:00 [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.22.1:test (default-test) on project community: There are test failures. [ERROR]

opened by damon46kai 1
发现NPE风险

您好，我正在用蚂蚁的单元测试用例自动生成工具（https://github.com/TRaaSStack/auto-unit-test-case-generator）对这个项目进行测试，发现如下两个可能引发NPE的问题，期待得到您的反馈。一 HotTagCache类中可能抛出NPE 被测方法的入参为Map，在其中一个添加的元素的value赋null值被测方法：

源码中在遍历元素的时候，由于其中的一个元素的value值为空，而代码中未对null做非空校验，导致在进入compareTo的时候，this.getPriority()获取的值为null，从而报npe异常

二 UserStrategyFactory类中可能抛出NPE 调用被测方法之前，先对被测类的私有属性类型为list的strategies赋初值，即在list中添加null元素被测方法：在被测方法中，遍历list时，未对元素strategy做非空判断，导致strategy.getSupportedType()操作时报npe

opened by xiuji666 0
mybatis生成表报错

Execution default-cli of goal org.mybatis.generat or:mybatis-generator-maven-plugin:1.3.7:generate failed: Exception getting JDBC Driver

作者你好，我把数据库连接改成mysql后，mvn flyway:migrate语句可以正常执行，数据库里也可以看到生成的表，但是执行mvn -Dmybatis.generator.overwrite=true mybatis-generator:generate语句后报上面的错误，我看了下plugin那里有些mysql依赖，不知道是什么原因

opened by qingzhu0214 0
Bump mysql-connector-java from 5.1.45 to 8.0.28
Bumps mysql-connector-java from 5.1.45 to 8.0.28.

Changelog

Sourced from mysql-connector-java's changelog.

Changelog

https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/

Version 8.0.29

Fix for Bug#21978230, COMMENT PARSING NOT PROPER IN PREPSTMT.EXECUTEBATCH().

Fix for Bug#81468 (23312764), MySQL server fails to rewrite batch insert when column name contains word select.

Fix for Bug#106435 (33850099), 8.0.28 Connector/J has regressive in setAutoCommit after Bug#104067 (33054827).

Fix for Bug#106240 (33781440), StringIndexOutOfBoundsException when VALUE is at the end of the query.

Fix for Bug#106397 (33893591), Contribution: fix: fix LocalizedErrorMessages.properties doc: less then -> ... Thanks to Jianjian Song for his contribution.

Fix for Bug#77924 (25710160), JDBC SOCKS SHOULD NOT PERFORM LOCAL DNS RESOLUTION.

Fix for Bug#82084 (23743938), YEAR DATA TYPE RETURNS INCORRECT VALUE FOR JDBC GETCOLUMNTYPE().

Fix for Bug#106441 (33850155), Add charset mapping for utf8mb3.

WL#15048, Upgrade Protocol Buffers dependency to protobuf-java-3.19.4.

Fix for Bug#106065 (33726184) Contribution: BigDecimal.toPlainString no need to check decimal exponent. Thanks to Baoyi Chen for his contribution.

Fix for Bug#106171 (33757217), Contribution: Remove unnecessary boxing in ResultSetImpl. Thanks to Ningpp Ning for his contribution.

Fix for Bug#25701740, STMT EXECUTION FAILS FOR REPLICATION CONNECTION WHEN USECURSORFETCH=TRUE.

Fix for Bug#33723611, getDefaultTransactionIsolation must return repeatable read.

Fix for Bug#38954 (11749415), DATA TRUNCATION WHILE USING BIT(1) IN STORED PROCEDURE WITH INOUT TYPE.

Fix for Bug#85317 (25672958), EXECUTE BATCH WILL THROW NULL POINTER EXCEPTION WHERE THE COLUMN IS BLOB!

Fix for Bug#105915 (33678490), Connector/J 8 server prepared statement precision loss in execute batch.

Fix for Bug#104349 (33563548), com.mysql.cj NPE.

Fix for Bug#62006 (16714956), JAVA.IO.NOTSERIALIZABLEEXCEPTION: JAVA.IO.STRINGREADER WHEN PROFILESQL=TRUE.

WL#14750, Better unification of query bindings.

WL#14834, Support for FIDO authentication.

WL#14835, Align TLS option checking across connectors.

... (truncated)

Commits

7ff2161 Updating copyright years

b13af38 Fix for DateTimeTest according to changes in MySQL server.

5c7b775 Update in test for Bug#96900 (30355150).

e1169ee Fix for Bug#99260 (31189960), statement.setQueryTimeout,creates a database co...

05778ef Fix for Bug#103324 (32770013), X DevAPI Collection.replaceOne() missing match...

48219f2 Fix for Bug#105197 (33461744), Statement.executeQuery() may return non-naviga...

24cf7e2 Fix for Bug#105323 (33507321), README.md contains broken links.

ad46620 Fix for Bug#96900 (30355150), STATEMENT.CANCEL()CREATE A DATABASE

4d19ea1 Fix for Bug#104067 (33054827), No reset autoCommit after unknown issue occurs.

bc45d35 Fix for Bug#85223 (25656020), MYSQLSQLXML SETSTRING CRASH.

Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

@dependabot use these labels will set the current labels as the default for future PRs for this repo and language

@dependabot use these reviewers will set the current reviewers as the default for future PRs for this repo and language

@dependabot use these assignees will set the current assignees as the default for future PRs for this repo and language

@dependabot use this milestone will set the current milestone as the default for future PRs for this repo and language

You can disable automated security fix PRs for this repo from the Security Alerts page.

dependencies java
opened by dependabot[bot] 0
Bump fastjson from 1.2.57 to 1.2.83
Bumps fastjson from 1.2.57 to 1.2.83.

Release notes

Sourced from fastjson's releases.

FASTJSON 1.2.83版本发布（安全修复）

这是一个安全修复版本，修复最近收到在特定场景下可以绕过autoType关闭限制的漏洞，建议fastjson用户尽快采取安全措施保障系统安全。

安全修复方案：https://github.com/alibaba/fastjson/wiki/security_update_20220523

Issues

安全加固

修复JDK17下setAccessible报错的问题 #4077

下载 https://repo1.maven.org/maven2/com/alibaba/fastjson/1.2.83/

文档 https://github.com/alibaba/fastjson/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98

源码 https://github.com/alibaba/fastjson/tree/1.2.83

fastjson 1.2.79版本发布，BUG修复

这又是一个bug fixed的版本，大家按需升级

Issues

修复引入MethodInheritanceComparator导致某些场景序列化报错的问题

增强JDK 9兼容

修复JSONArray/JSONObject的equals方法在内部对象map/list相同时不直接返回true的问题

相关链接

下载 https://repo1.maven.org/maven2/com/alibaba/fastjson/1.2.79/

文档 https://github.com/alibaba/fastjson/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98

源码 https://github.com/alibaba/fastjson/tree/1.2.79

fastjson 1.2.76版本发布，BUG修复增强兼容

这又是一个bug fixed的版本，大家按需升级

Issues

修复一些直接抛RuntimeException的问题 #3631

parser自动识别gzip bytes #3614

修复Throwable继承类属性不支持自动类型转换问题 #3217

修复PrettyFormat情况下引用计算不对的问题 #3672

修复AutoType不兼容LinkedHashMap的问题

增强对Enum类型的自定类型转换

修复deserializeUsing在泛型某些场景不能正常工作的问题 #3693

提升JSONReader性能，减少小对象创建 #3627

增强对JSONPath对filter的支持 #3629

JSONPath支持忽略NullValue的选项 #3607

增强对定制化enum的支持 #3601

增强对java.time.Instant和org.joda.time.Instant的支持 #3539

修复Parser某些场景不能识别引用的问题

相关链接

下载 https://repo1.maven.org/maven2/com/alibaba/fastjson/1.2.76/

文档 https://github.com/alibaba/fastjson/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98

源码 https://github.com/alibaba/fastjson/tree/1.2.76

fastjson 1.2.75版本发布，例行Bug修复

... (truncated)

Commits

26f13f8 1.2.83

8f3410f bug fix for autotype

cd3c2de improved jdk8 java.time support

c63866e remove unused import

35db4ad bug fix for autoType

3f009e1 Merge pull request #4085 from hengyunabc/fix_setAccessible

dd3de5f fix InaccessibleObjectException in jdk17. #4077

a234f9a Merge pull request #4084 from alibaba/revert-4078-master

0814909 Revert "fix InaccessibleObjectException in jdk17. #4077"

ab82d0b Merge pull request #4078 from hengyunabc/master

Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

@dependabot use these labels will set the current labels as the default for future PRs for this repo and language

@dependabot use these reviewers will set the current reviewers as the default for future PRs for this repo and language

@dependabot use these assignees will set the current assignees as the default for future PRs for this repo and language

@dependabot use this milestone will set the current milestone as the default for future PRs for this repo and language

You can disable automated security fix PRs for this repo from the Security Alerts page.

dependencies java
opened by dependabot[bot] 0