Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2016
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.03 KB | None | 0 0
  1. <dependency>
  2. <groupId>org.springframework.boot</groupId>
  3. <artifactId>spring-boot-starter-data-jpa</artifactId>
  4. </dependency>
  5. <dependency>
  6. <groupId>org.springframework.boot</groupId>
  7. <artifactId>spring-boot-starter-web</artifactId>
  8. </dependency>
  9. <dependency>
  10. <groupId>mysql</groupId>
  11. <artifactId>mysql-connector-java</artifactId>
  12. </dependency>
  13.  
  14. @Entity
  15. @Table(name = "greetings")
  16. public class Greeting {
  17.  
  18. @Id
  19. @GeneratedValue(strategy = GenerationType.AUTO)
  20. @Column(name = "greeting_id")
  21. private long id;
  22.  
  23. @Column(name = "text")
  24. private String text;
  25.  
  26. // getters and setters here
  27. }
  28.  
  29. @Repository
  30. public interface GreetingRepository extends JpaRepository<Greeting, Long> {
  31. }
  32.  
  33. @RestController("/hello")
  34. public class GreetingsController {
  35.  
  36. @Autowired
  37. private GreetingRepository repo;
  38.  
  39. @RequestMapping(method = RequestMethod.GET)
  40. public Collection<Greeting> getGreetings() {
  41. return repo.findAll();
  42. }
  43.  
  44. @RequestMapping(value = "/{id}", method = RequestMethod.GET)
  45. public Greeting getGreeting(@PathVariable long id) {
  46. return repo.findOne(id);
  47. }
  48. }
  49.  
  50. spring.jpa.hibernate.ddl-auto=create-drop
  51. spring.jpa.properties.hibernate.globally_quoted_identifiers=true
  52.  
  53. spring.datasource.url=jdbc:mysql://localhost/example
  54. spring.datasource.username=root
  55. spring.datasource.password=secret
  56. spring.datasource.driverClassName=com.mysql.jdbc.Driver
  57.  
  58. mysql> describe greetings;
  59. +-------------+--------------+------+-----+---------+----------------+
  60. | Field | Type | Null | Key | Default | Extra |
  61. +-------------+--------------+------+-----+---------+----------------+
  62. | greeting_id | bigint(20) | NO | PRI | NULL | auto_increment |
  63. | text | varchar(255) | YES | | NULL | |
  64. +-------------+--------------+------+-----+---------+----------------+
  65. 2 rows in set (0.00 sec)
  66.  
  67. Failed to convert value of type 'java.lang.String' to required type 'long'; nested exception is java.lang.NumberFormatException: For input string: "hello"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement