Tag Archives: Idea error

idea Error: Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource

Error:

在这里插入图片描述
Error Message:

APPLICATION FAILED TO START
***************************

Description:

Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.

Reason: Failed to determine a suitable driver class


Action:

Consider the following:
	If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
	If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).


Solution:- [ ] List item
Just check the nacos port and change it to the port used by the project you are running.

[Solved] ERROR–Unable to process Jar entry [module-info.class] from Jar

Unable to process Jar entry [module-info.class] from Jar

Cause Analysis Unable to process jar entry [module-info.class] from Jar package
Scenes Serious red error when starting Idea projectimageimage

Step 1: Go to the Maven repository to find the jar. (I am running the jar reporting an error)
image

Step 2: Right-click the jar and open it with a compression tool, (not unzip it, but open it with WinRar) image

Step 3: Delete the module-info.class folder in the open file (mine has been deleted, you can delete it directly, and then re-run the project.)

1. Generally, this kind of error will not affect the normal operation of the program.

2. The lombok warning in the second picture can be solved by adding the permission <scope>provided</scope> to the location where lombok depends on the import in pom.xml

[Solved] IDEA Error: Unable to resolve column XXXX

IDEA reported an error Unable to resolve column XXXX solution.

Cause Analysis IDEA cannot fully identify the information of the database
Scenes When Mybatis in IDEA needs to write SQL statements, the compilation process will report a warninginsert image description here

In idea, file>setting–>languages&Frameworks–>SQL Resolution Scopes–>Project mapping select the library table of your own project–>click the plus sign to add your own project address–>Select your own library table as under Resolution Scope ——>Apply——>OK is solved.
image

IDEA Error: ERROR 16720 —[ restartMain] o.a.coyote. http11.Http119Protocol: Failed to sta

Idea reports error: ERROR 16720 – [restartedmain] o.a.coyote http11.Http11NioProtocol : Failed to start end point associated with ProtocolHandler [“http-nio-80”]

1. Error 16720

idea version is IntelliJ idea 2018.3.6 x64

The error reporting codes of running items are as follows:


the detailed error reporting code of the third figure

Sun May 29 10:42:36 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun May 29 10:42:36 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun May 29 10:42:37 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun May 29 10:42:37 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun May 29 10:42:37 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun May 29 10:42:37 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun May 29 10:42:37 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun May 29 10:42:37 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun May 29 10:42:37 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Sun May 29 10:42:37 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

2. Error reporting causes and Solutions

1. cause

Port number 80 is occupied

2. solutions

1. change the port number and use the idle port number

the occupied port number here is 80, and the idle port number is 81

(1) Find the configuration file to write the port number

server:
  port: 80

(2) Change the port number to an idle and unoccupied port number

server:
  port: 81

 

[Solved] IDEA Error: Unknown system variable ‘tx_isolation‘ at

IDEA Error: Unknown system variable ‘tx_isolation’ at

java.sql.SQLException: Unknown system variable ‘tx_isolation’ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2820) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2769) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1569) at com.mysql.jdbc.ConnectionImpl.getTransactionIsolation(ConnectionImpl.java:3372) at com.mchange.v2.c3p0.impl.NewPooledConnection.(NewPooledConnection.java:107) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:198) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access800 ( B a s i c R e s o u r c e P o o l . j a v a : 32 ) a t c o m . m c h a n g e . v 2. r e s o u r c e p o o l . B a s i c R e s o u r c e P o o l 800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool800(BasicResourcePool.java:32)atcom.mchange.v2.resourcepool.BasicResourcePoolAcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

 

Solution:
1. the version of mysql-connector-java is too low and you need to upgarde to version 8.0.*
2. After you had upgraded the version of mysql-connector-java, update the driver:
com.mysql.jdbc.Driver——>com.mysql.cj.jdbc.Driver

IDEA Error: lombok.extern.slf4j is not exist [How to Solve]

Idea reports an error Lombok extern. Slf4j is not exist no solution exists

Problem background solution summary Lyric: maltose wine

Problem background

When you start the idea project, you suddenly report an error Lombok extern. It’s been a long time since I found that the version of 4fj is compatible with Maven

Solution

1 file → setting

2 build → build tools → maven → runner, check delegate ide build and click OK

Mac Start IDEA Error: Cannot load JVM bundle…Value of IDEA_VM_OPTIONS is (null)

Open the package under the application. Double click MacOS/idea to open it. The following error message is displayed:

Last login: Wed Jul 21 10:25:35 on ttys000
/Applications/IntelliJ\ IDEA.app/Contents/MacOS/idea ; exit;
lyuwalle@lyuwalle ~ % /Applications/IntelliJ\ IDEA.app/Contents/MacOS/idea ; exit;
2021-07-21 10:25:44.347 idea[2312:81949] allVms required 1.8*,1.8+
2021-07-21 10:25:44.349 idea[2312:81953] Cannot load JVM bundle: Error Domain=NSCocoaErrorDomain Code=3585 "dlopen_preflight(/Applications/IntelliJ IDEA.app/Contents/jbr/Contents/MacOS/libjli.dylib): no suitable image found.  Did find:
	/Applications/IntelliJ IDEA.app/Contents/jbr/Contents/MacOS/libjli.dylib: mach-o, but wrong architecture
	/Applications/IntelliJ IDEA.app/Contents/jbr/Contents/MacOS/libjli.dylib: mach-o, but wrong architecture" UserInfo={NSLocalizedFailureReason=The bundle doesn’t contain a version for the current architecture., NSLocalizedRecoverySuggestion=Try installing a universal version of the bundle., NSFilePath=/Applications/IntelliJ IDEA.app/Contents/jbr/Contents/MacOS/libjli.dylib, NSDebugDescription=dlopen_preflight(/Applications/IntelliJ IDEA.app/Contents/jbr/Contents/MacOS/libjli.dylib): no suitable image found.  Did find:
	/Applications/IntelliJ IDEA.app/Contents/jbr/Contents/MacOS/libjli.dylib: mach-o, but wrong architecture
	/Applications/IntelliJ IDEA.app/Contents/jbr/Contents/MacOS/libjli.dylib: mach-o, but wrong architecture, NSBundlePath=/Applications/IntelliJ IDEA.app/Contents/jbr, NSLocalizedDescription=The bundle “OpenJDK 11.0.11” couldn’t be loaded because it doesn’t contain a version for the current architecture.}
2021-07-21 10:25:44.349 idea[2312:81953] Retrying as x86_64...
2021-07-21 10:25:44.390 idea[2312:81955] allVms required 1.8*,1.8+
2021-07-21 10:25:44.392 idea[2312:81968] Current Directory: /Users/lyuwalle
2021-07-21 10:25:44.392 idea[2312:81968] Value of IDEA_VM_OPTIONS is (null)
2021-07-21 10:25:44.392 idea[2312:81968] Processing VMOptions file at /Users/lyuwalle/Library/Application Support/JetBrains/IntelliJIdea2021.1/idea.vmoptions
2021-07-21 10:25:44.393 idea[2312:81968] Done
Improperly specified VM option 'SoftRefLRUPolicyMSPerMB=50Å'
Improperly specified VM option 'SoftRefLRUPolicyMSPerMB=50Å'
2021-07-21 10:25:44.441 idea[2312:81968] JNI_CreateJavaVM (/Applications/IntelliJ IDEA.app/Contents/jbr) failed: -6
Saving session...
...copying shared history...
...saving history...truncating history files...
...completed.

The reason is that the idea.vmoptions file conflicts. Delete the idea.vmoptions (database library is a hidden folder) under the following folder
/users/XXXX/library/Application Support/JetBrains/intellijidea2020.1/idea.vmoptions

[Solved] IDEA Error: java: Compilation failed: internal java compiler error

In the project, use gradle to build the project. When we want to change the version of the JDK, the following error is reported:

Information:Using javac 1.8.0_111 to compile java sources
Information:java: javacTask: source release 1.8 requires target release 1.8
Information:java: Errors occurred while compiling module’Spring_1_main’
Information:2018/1/4 18:46-Compilation completed with 1 error and 0 warnings in 3s 768ms
Error:java: Compilation failed: internal java compiler error

In fact, there are a few things that need to be changed:

1. Change the build.gradle file

    sourceCompatibility = 1.8

2. Change the .idea/compiler.xml file

< bytecodeTargetLevel > 
      < module name ="common_main" target ="1.8"  /> 
      < module name ="common_test" target ="1.8"  /> 
      < module name ="questionnaire_main" target ="1.8"  /> 
      < module name =" questionnaire_test" target ="1.8"  /> 
</ bytecodeTargetLevel >

3. Change File->Project Structure->Project Settings->Modules->Project name->Dependencies->Module SDK on the right

4. Set the Target bytecode version of Module in Settings->Buile, Execution, Deployment->Compiler->Java Compiler