Guest User

Untitled

a guest
Feb 3rd, 2018
319
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.70 KB | None | 0 0
  1. spring.datasource.platform=mssql
  2. spring.datasource.url=jdbc:sqlserver://localhost;databaseName=springboot_db
  3. spring.datasource.username=sa
  4. spring.datasource.password=einfochips@123
  5. spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
  6. spring.jpa.show-sql=true
  7. spring.jpa.hibernate.ddl-auto=create-drop
  8. spring.datasource.initialize=true
  9.  
  10. USE master
  11. IF EXISTS(select name from sys.databases where name='user_database')
  12. DROP DATABASE user_database;
  13. CREATE DATABASE user_database;
  14. USE user_database;
  15. CREATE TABLE tbl_users (
  16. id INTEGER NOT NULL IDENTITY(1,1),
  17. name VARCHAR(25),
  18. email VARCHAR(50),
  19. username VARCHAR(25),
  20. password VARCHAR(225),
  21. gender VARCHAR(1),
  22. contact_number VARCHAR(12),
  23. address VARCHAR(150),
  24. country VARCHAR(20),
  25. newsletter BIT,
  26. framework VARCHAR(500),
  27. skill VARCHAR(500),
  28. role_id INTEGER,
  29. PRIMARY KEY (id)
  30. );
  31. INSERT INTO tbl_users
  32. (name, email, username, password, gender, contact_number, address, country, newsletter, framework, skill, role_id)
  33. VALUES
  34. ('Admin User1', 'admin@gmail.com', 'admin', '$2a$10$WOf9uuaNfUgqpfXrfK1QiO.scUjxJMA.wENEu4c8GJMbPhFwbxMwu', 'f', 919979294062, 'Ahmedabad', 'India', 0, 'Spring MVC', 'Spring', 1);
  35.  
  36. @Entity
  37. @Table(name = "tbl_configuration_details")
  38. public class AppConfiguration implements Serializable {
  39.  
  40. /**
  41. *
  42. */
  43. private static final long serialVersionUID = 6657691404940352980L;
  44.  
  45. @Id
  46. @GeneratedValue(strategy = GenerationType.AUTO)
  47. @Column(name = "config_id")
  48. private Integer id;
  49.  
  50. @Column(name = "schedule_time")
  51. private Integer scheduleTimePeriod;
  52. // other variables and respective getter setters
  53. }
  54.  
  55. Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'tbl_configuration_details'.
  56. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:232) ~[mssql-jdbc-6.1.0.jre7.jar:na]
  57. at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1672) ~[mssql-jdbc-6.1.0.jre7.jar:na]
  58. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:460) ~[mssql-jdbc-6.1.0.jre7.jar:na]
  59. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:405) ~[mssql-jdbc-6.1.0.jre7.jar:na]
  60. at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7535) ~[mssql-jdbc-6.1.0.jre7.jar:na]
  61. at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2438) ~[mssql-jdbc-6.1.0.jre7.jar:na]
  62. at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:208) ~[mssql-jdbc-6.1.0.jre7.jar:na]
  63. at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:183) ~[mssql-jdbc-6.1.0.jre7.jar:na]
  64. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:317) ~[mssql-jdbc-6.1.0.jre7.jar:na]
  65. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_144]
  66. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_144]
  67. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_144]
  68. at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_144]
  69. at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-8.5.23.jar:na]
  70. at com.sun.proxy.$Proxy92.executeQuery(Unknown Source) ~[na:na]
  71. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  72. ... 94 common frames omitted
  73.  
  74. CREATE TABLE tbl_users
  75.  
  76. @Table(name = "tbl_configuration_details")
Add Comment
Please, Sign In to add comment