Spring Boot - MySQL / SQL Server

Spring Boot - MySQL

Add MySQL dependency

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

Add the properties in application.properties

spring.jpa.hibernate.ddl-auto=none

spring.datasource.url=jdbc:mysql://localhost:3306/baseband

spring.datasource.username=root

spring.datasource.password=admin

Spring Boot - SQL Server

Add dependency

<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>6.1.0.jre8</version>
</dependency>

Properties

spring.datasource.url=jdbc:sqlserver://146.250.116.35:1433;databaseName=ServiceRecruitment

spring.datasource.username=sa

spring.datasource.password=N@viembre2514

spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

spring.jpa.show-sql=true

spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect

spring.jpa.hibernate.ddl-auto = none

FAQ

How to create fields using reserved words

@Column(name="`condition`")

Comentarios

Entradas populares de este blog

C# Using tabs

To use tabs in C# use the TabContainer element from AjaxControlToolkit Include AjaxControlToolkit Include in the Web.config file, inside the tag <system.web> the following code <pages> <controls> <add tagPrefix="ajaxCTK" namespace="AjaxControlToolkit" assembly="AjaxControlToolkit"/> </controls> </pages> Include TabContainer element First include TabContainer element that is the section where all the tabs will be displayed. <ajaxCTK:TabContainer ID="TabContainerUpdate" runat="server" Height="800" CssClass="ajax__tab_style"> </ajaxCTK:TabContainer> Second per each tab include the following code corresponding to each ...

Rails - Basic Steps III

pValidations Validations are a type of ActiveRecord Validations are defined in our models Implement Validations Go to root_app/app/models Open files *.rb for each model Mandatory field validates_presence_of :field Ex: validates_presence_of :title Classes The basic syntax is class MyClass @global_variable def my_method @method_variable end end Create an instance myInstance = MyClass.new Invoke a mehod mc.my_method class() method returns the type of the object In Ruby, last character of method define the behavior If ends with a question -> return a boolean value If ends with an exclamation -> change the state of the object Getter / Setter method def global_variable return @global_variable end ...

Python create package

Create a root folder Create a sub-folder "example_pkg" that contains the funtionallity packaging_tutorial/ example_pkg/ __init__.py In the root folder create the following structure packaging_tutorial/ example_pkg/ __init__.py tests/ setup.py LICENSE README.md in the setup.py contains the configuration of the packages your package is found by find_packages() import setuptools with open ( "README.md" , "r" ) as fh : long_description = fh . read () setuptools . setup ( name = "example-pkg-YOUR-USERNAME-HERE" , # Replace with your own username version = "0.0.1" , author = "Example Author" , author_email = "author@example.com" , description = "A small example package" , long_description = long_description , long_description_content_type = "text/markdown" , url = "https://github.com/pypa/sam...

IT Knowledge

Buscar este blog