malaganguo的踩坑合集

小灰灰 2021-10-30 05:10 283阅读 0赞

**目录**

trap1. 下拉框无法赋值

Connection to @172.16.25.79 failed.\[08006\]\[1034\] ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86\_64 Error: 2: No such file or directoryAdditional information: 4150Additional information: -1612462601

使用JDBC连接MySql时出现：The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration

针对mysql8.0报错：com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create

Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

org.apache.catalina.core.ContainerBase.addChildInternal ContainerBase.addChild: start: org.apache.catalina.LifecycleException: Failed to start component \[StandardEngine\[Catalina\].StandardHost\[localhost\].StandardContext\[\]\]

Caused by: java.lang.IllegalArgumentException: More than one fragment with the name \[spring\_web\] was found. This is not legal with relative ordering. See section 8.2.2 2c of the Servlet specification for details. Consider using absolute ordering.

--------------------

# trap1. 下拉框无法赋值 #

问题阐述：下拉框在初始化的时候需要发送ajax请求选项内容，操作中在发送请求后便往下拉框中赋值，实际上异步请求还没有执行完，所以初始化失败，下拉框中无法初始化值。

解决办法：给下拉框加flag，在ajax请求完成以后再允许进行赋值、取值操作。

# Connection to @172.16.25.79 failed.   \[08006\]\[1034\] ORA-01034: ORACLE not available   ORA-27101: shared memory realm does not exist   Linux-x86\_64 Error: 2: No such file or directory   Additional information: 4150   Additional information: -1612462601    #

用dataGrip连接oracle数据库出错!原因：dataGrip在生成的Oracle的URL格式是错误的，角色和端口之间本应该是斜杠：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODkzMDcwNg_size_16_color_FFFFFF_t_70][]

datagrip操作oracle问题多多，赶紧卸载，安装plsql！

# 使用JDBC连接MySql时出现：The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration #

在连接字符串后面加上**?serverTimezone=UTC**

其中UTC是统一标准世界时间。

完整的连接字符串示例：**jdbc:mysql://localhost:3306/test?serverTimezone=UTC**

或者还有另一种选择：**jdbc:mysql://127.0.0.1:3306/test****?useUnicode=true&characterEncoding=UTF-8**，这个是解决中文乱码输入问题，当然也可以和上面的一起结合：**jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC**

# 针对mysql8.0报错：com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create #

JDBC的驱动版本和MySQL版本版本没有对应，修改成对应版本的JDBC即可。

# Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column #

快速设置，直接在workbench里面的查询窗口输入“SET SQL\_SAFE\_UPDATES = 0；”就可以了。

图形界面设置：

1. 在workbench的菜单栏点击“edit-->Preferences”,然后会弹出对话框“workbench preferences”；

2. 在“workbench”左边栏点击“SQL Editor”，会看到最后一行是“Safe Updates……”是打钩的，我们只要缺消打钩即可。

3.当上面设置好之后，请重启workbench。

# org.apache.catalina.core.ContainerBase.addChildInternal ContainerBase.addChild: start:   org.apache.catalina.LifecycleException: Failed to start component \[StandardEngine\[Catalina\].StandardHost\[localhost\].StandardContext\[\]\] #

## Caused by: java.lang.IllegalArgumentException: More than one fragment with the name \[spring\_web\] was found. This is not legal with relative ordering. See section 8.2.2 2c of the Servlet specification for details. Consider using absolute ordering. ##

解决办法：在web.xml的<web-app>标签下添加<absolute-ordering/>标签。为什么这么做我也不知道。传送门：[https://stackoverflow.com/questions/54290263/more-than-one-fragment-with-the-name-spring-web-was-found-this-is-not-legal-w][https_stackoverflow.com_questions_54290263_more-than-one-fragment-with-the-name-spring-web-was-found-this-is-not-legal-w]

有人说absolute-ordering的所有子元素的name必须解析：[https://www.jianshu.com/p/a02b8eef8e84][https_www.jianshu.com_p_a02b8eef8e84]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODkzMDcwNg_size_16_color_FFFFFF_t_70]: /images/20211029/f1dee8c9b08e424ca4302da52e8274da.png
[https_stackoverflow.com_questions_54290263_more-than-one-fragment-with-the-name-spring-web-was-found-this-is-not-legal-w]: https://stackoverflow.com/questions/54290263/more-than-one-fragment-with-the-name-spring-web-was-found-this-is-not-legal-w
[https_www.jianshu.com_p_a02b8eef8e84]: https://www.jianshu.com/p/a02b8eef8e84