Spring boot – derby database – GenerationTarget encountered exception accepting command : Error executing DDL "drop table wire"

huangapple
go评论111阅读模式
英文:

Spring boot - derby database - GenerationTarget encountered exception accepting command : Error executing DDL "drop table wire"

问题

我是春季引导世界的新手。我不知道Maven Pom.xml文件中是否存在版本冲突。

GenerationTarget遇到异常，接受命令时出现异常：通过JDBC语句执行DDL "drop table wire"

org.hibernate.tool.schema.spi.CommandAcceptanceException：通过JDBC语句执行DDL "drop table wire"时出错
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept（GenerationTargetToDatabase.java:67）〜[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString（SchemaDropperImpl.java:375）[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings（SchemaDropperImpl.java:359）[hibernate-core-5.4.12.Final.jar:5.4.12.Final]

在运行独立的Spring Tool Suite 4.4.7.2时出现异常

Pom.xml文件

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd&quot;>
<modelVersion>4.0.0</modelVersion>
<groupId>io.wires.springbootquickstart</groupId>
<artifactId>wires-api</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>Wires API Sample </name>

<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.2.6.RELEASE</version>
</parent>

<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.apache.derby</groupId>
<artifactId>derby</artifactId>
</dependency>

</dependencies>
</project>

实体文件- wire类是模型层，也称为实体层
//在MVC模式中，Wire类是模型层，也称为实体层////我们需要将Wire类的对象，换句话说，wire类的实例保存到数据库中

package io.wiresapi.springbootstarter.Wires.SendWires;
import javax.persistence.Entity;
import javax.persistence.Id;

@Entity
public class Wire {

//在MVC模式中，Wire类是模型层，也称为实体层
//我们需要将Wire类的对象，换句话说，wire类的实例保存到数据库中

public Wire() {

}

public Wire(int wireId, String lPID, float wireAmount) {
super();
this.WireId = wireId;
this.LPID = lPID;
this.WireAmount = wireAmount;
}

@Id
private int WireId;
private String LPID;
private float WireAmount;

public int getWireId() {
return WireId;
}
public void setWireId(int wireId) {
WireId = wireId;
}
public String getLPID() {
return LPID;
}
public void setLPID(String lPID) {
LPID = lPID;
}
public float getWireAmount() {
return WireAmount;
}
public void setWireAmount(float wireAmount) {
WireAmount = wireAmount;
}

}

主方法

package io.wiresapi.springbootstarter;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class WiresAPI {

public static void main(String[] args) {
// TODO Auto-generated method stub

  1. //SpringApplication是一个静态类
  2. SpringApplication.run(WiresAPI.class, args);

}

}

存储库文件

package io.wiresapi.springbootstarter.Wires.SendWires;

import org.springframework.data.repository.CrudRepository;

//Spring data JPA已经为所有CRUM操作提供了一个接口

public interface WireRepository extends CrudRepository<Wire,String>{

}

控制器文件

package io.wiresapi.springbootstarter.Wires.SendWires;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

@RestController
public class WiresSendController {

@Autowired
private WiresService aWireService;

//我们将客户端的传入请求映射到适当的方法。

//获取所有电线URI
@RequestMapping("/Wires")
public List TotalWiresSent() {

  1. return aWireService.getAllWires();

}

}

英文:

I am a novice in spring boot world. I don't know if it is version conflicts in the Maven Pom.xml file.

  1. GenerationTarget encountered exception accepting command : Error executing DDL &quot;drop table wire&quot; via JDBC Statement
  3. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL &quot;drop table wire&quot; via JDBC Statement
  4. at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final]
  5. at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString(SchemaDropperImpl.java:375) [hibernate-core-5.4.12.Final.jar:5.4.12.Final]
  6. at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings(SchemaDropperImpl.java:359) [hibernate-core-5.4.12.Final.jar:5.4.12.Final]

exception while I run my stand-alone spring tool suite 4.4.7.2

Pom.xml file

  1. &lt;project xmlns=&quot;http://maven.apache.org/POM/4.0.0&quot; xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema- 
  2. instance&quot; xsi:schemaLocation=&quot;http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven- 
  3. 4.0.0.xsd&quot;&gt;
  4. &lt;modelVersion&gt;4.0.0&lt;/modelVersion&gt;
  5. &lt;groupId&gt;io.wires.springbootquickstart&lt;/groupId&gt;
  6. &lt;artifactId&gt;wires-api&lt;/artifactId&gt;
  7. &lt;version&gt;0.0.1-SNAPSHOT&lt;/version&gt;
  8. &lt;name&gt;Wires API Sample &lt;/name&gt;
  10. &lt;parent&gt;
  11.     &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  12.     &lt;artifactId&gt;spring-boot-starter-parent&lt;/artifactId&gt;
  13.      &lt;version&gt;2.2.6.RELEASE&lt;/version&gt;
  14.  &lt;/parent&gt;
  16.  &lt;dependencies&gt;
  17.       &lt;dependency&gt;
  18.            &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  19.            &lt;artifactId&gt;spring-boot-starter-web&lt;/artifactId&gt;
  20.       &lt;/dependency&gt;
  21.      &lt;dependency&gt;
  22. 	       &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  23. 	       &lt;artifactId&gt;spring-boot-starter-data-jpa&lt;/artifactId&gt;			
  24.      &lt;/dependency&gt;
  25.     &lt;dependency&gt;
  26. 	      &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  27. 	      &lt;artifactId&gt;spring-boot-starter-web&lt;/artifactId&gt;			
  28.      &lt;/dependency&gt;
  29.     &lt;dependency&gt;
  30. 	     &lt;groupId&gt;org.apache.derby&lt;/groupId&gt;
  31. 	     &lt;artifactId&gt;derby&lt;/artifactId&gt;			
  32.       &lt;/dependency&gt;
  34.    &lt;/dependencies&gt;
  35. &lt;/project&gt;

Entity file- wire class is the Model layer also called the entity layer
//In a MVC pattern, the Wire class is the Model layer also called the entity layer////We need to save the objects of the Wire class in other words instances of the wire class into the

  1. package io.wiresapi.springbootstarter.Wires.SendWires;
  2. import javax.persistence.Entity;
  3. import javax.persistence.Id;
  5. @Entity
  6. public class Wire {
  8. //In a MVC pattern, the Wire class is the Model layer also called the entity layer
  9. //We need to save the objects of the Wire class in other words instances of the wire class into the database
  11. public Wire() {
  12. 	
  13. }
  16. public Wire(int wireId, String lPID, float wireAmount) {
  17. 	super();
  18. 	this.WireId = wireId;
  19. 	this.LPID = lPID;
  20. 	this.WireAmount = wireAmount;
  21. }
  23. @Id
  24. private  int WireId;
  25. private String LPID;
  26. private float WireAmount;
  28. public int getWireId() {
  29. 	return WireId;
  30. }
  31. public void setWireId(int wireId) {
  32. 	WireId = wireId;
  33. }
  34. public String getLPID() {
  35. 	return LPID;
  36. }
  37. public void setLPID(String lPID) {
  38. 	LPID = lPID;
  39. }
  40. public float getWireAmount() {
  41. 	return WireAmount;
  42. }
  43. public void setWireAmount(float wireAmount) {
  44. 	WireAmount = wireAmount;
  45. }
  48.  }

Main method

  1. package io.wiresapi.springbootstarter;
  3. import org.springframework.boot.SpringApplication;
  4. import org.springframework.boot.autoconfigure.SpringBootApplication;
  6. @SpringBootApplication
  7. public class WiresAPI {
  10. public static void main(String[] args) {
  11. 	// TODO Auto-generated method stub
  12. 	
  13. 	//SpringApplication is a static class
  14. 	SpringApplication.run(WiresAPI.class, args);
  16.   }
  18.  }

Repository file

  1. package io.wiresapi.springbootstarter.Wires.SendWires;
  3. import org.springframework.data.repository.CrudRepository;
  5. //Spring data JPA has already an interface for all CRUM operations
  7.  public interface WireRepository extends CrudRepository&lt;Wire,String&gt;{
  10. }

Controller file

  1. package io.wiresapi.springbootstarter.Wires.SendWires;
  4. import java.util.ArrayList;
  5. import java.util.Arrays;
  6. import java.util.List;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.web.bind.annotation.PathVariable;
  10.  import org.springframework.web.bind.annotation.RequestBody;
  11.  import org.springframework.web.bind.annotation.RequestMapping;
  12. import org.springframework.web.bind.annotation.RequestMethod;
  13. import org.springframework.web.bind.annotation.RestController;
  15. @RestController	
  16. public class WiresSendController {
  18. @Autowired
  19. private WiresService aWireService;
  21. //We map an incoming request from the client to an appropriate method.
  23. //Get all wires URI
  24. @RequestMapping(&quot;/Wires&quot;)
  25. public List&lt;Wire&gt; TotalWiresSent() {
  26. 	
  27. 	return aWireService.getAllWires();
  28. }
  30. }

Console

  1. :: Spring Boot ::        (v2.2.6.RELEASE)
  3.   2020-09-26 14:50:32.465  INFO 19332 --- [           main] io.wiresapi.springbootstarter.WiresAPI   
  4.   : Starting WiresAPI on WN-CA14R9Y6H224 with PID 19332 (C:\Users\myname\Documents\workspace-spring- 
  5.   tool-suite-4-4.7.2.RELEASE\wires-api\target\classes started by bxnath1 in 
  6.   C:\Users\myname\Documents\workspace-spring-tool-suite-4-4.7.2.RELEASE\wires-api)
  7.   2020-09-26 14:50:32.474  INFO 19332 --- [           main] io.wiresapi.springbootstarter.WiresAPI   
  8.   : No active profile set, falling back to default profiles: default
  9.  2020-09-26 14:50:33.961  INFO 19332 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : 
  10.  Bootstrapping Spring Data JPA repositories in DEFAULT mode.
  11.  2020-09-26 14:50:34.119  INFO 19332 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : 
  12.   Finished Spring Data repository scanning in 140ms. Found 1 JPA repository interfaces.
  13.  2020-09-26 14:50:35.301  INFO 19332 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : 
  14.  Tomcat initialized with port(s): 3000 (http)
  15.   2020-09-26 14:50:35.317  INFO 19332 --- [           main] o.apache.catalina.core.StandardService   
  16.     : Starting service [Tomcat]
  17.   2020-09-26 14:50:35.318  INFO 19332 --- [           main] org.apache.catalina.core.StandardEngine  
  18.  : Starting Servlet engine: [Apache Tomcat/9.0.33]
  19.  2020-09-26 14:50:35.635  INFO 19332 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : 
  20.   Initializing Spring embedded WebApplicationContext
  21.    2020-09-26 14:50:35.636  INFO 19332 --- [           main] o.s.web.context.ContextLoader            
  22.    : Root WebApplicationContext: initialization completed in 3041 ms
  23.   2020-09-26 14:50:36.051  INFO 19332 --- [           main] com.zaxxer.hikari.HikariDataSource       
  24.  : HikariPool-1 - Starting...
  25.  2020-09-26 14:50:36.053  WARN 19332 --- [           main] com.zaxxer.hikari.util.DriverDataSource  : 
  26.   Registered driver with driverClassName=org.apache.derby.jdbc.EmbeddedDriver was not found, trying 
  27.   direct instantiation.
  28.     2020-09-26 14:50:36.914  INFO 19332 --- [           main] com.zaxxer.hikari.pool.PoolBase          
  29.   : HikariPool-1 - Driver does not support get/set network timeout for connections. (Feature not 
  30.    implemented: No details.)
  31.   2020-09-26 14:50:36.920  INFO 19332 --- [           main] com.zaxxer.hikari.HikariDataSource       
  32.  : HikariPool-1 - Start completed.
  33.   2020-09-26 14:50:37.110  INFO 19332 --- [           main] o.hibernate.jpa.internal.util.LogHelper  
  34.   : HHH000204: Processing PersistenceUnitInfo [name: default]
  35.   2020-09-26 14:50:37.333  INFO 19332 --- [           main] org.hibernate.Version                    
  36.   : HHH000412: Hibernate ORM core version 5.4.12.Final
  37.   2020-09-26 14:50:37.772  INFO 19332 --- [           main] o.hibernate.annotations.common.Version   
  38.   : HCANN000001: Hibernate Commons Annotations {5.1.0.Final}
  39.   2020-09-26 14:50:38.088  INFO 19332 --- [           main] org.hibernate.dialect.Dialect            
  40.   : HHH000400: Using dialect: org.hibernate.dialect.DerbyTenSevenDialect
  41.      2020-09-26 14:50:39.795  WARN 19332 --- [           main] o.h.t.s.i.ExceptionHandlerLoggedImpl     
  42.    : GenerationTarget encountered exception accepting command : Error executing DDL &quot;drop table wire&quot; 
  43.    via JDBC Statement
  45.   org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL &quot;drop table wire&quot; via 
  46.   JDBC Statement
  47.    at

答案1

得分: 2

这个错误出现在Derby中，是因为默认值被设置为：spring.jpa.hibernate.ddl-auto=create-drop
你需要在你的application.properties文件中将其设置为：spring.jpa.hibernate.ddl-auto=update。

英文:

This error appears in Derby due to the default value is set to: spring.jpa.hibernate.ddl-auto=create-drop
You have to set it to: spring.jpa.hibernate.ddl-auto=update in your application.properties file

huangapple
  • 本文由 发表于 2020年9月27日 06:45:43
  • 转载请务必保留本文链接：https://go.coder-hub.com/64083180.html
  • derby
  • hibernate
  • java
  • spring-boot
  • spring-data-jpa
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定