如何访问我的本地MySQL数据库使用引导从云铸造？

Question

我已经从STS-3.8.2创建了一个Spring Boot Rest应用程序来执行Crud操作，它在本地环境中运行得很好。当部署到云铸造中时，操作简单的rest调用工作良好。但是当我调用rest执行Crud操作时，它说

无法打开连接；嵌套异常是org.hibernate.exception.jdbcConnectionException：无法打开连接

请帮我解决这个问题。

null

SpringBootandMySQLApplication.java：

@SpringBootApplication

public class SpringBootAndMySqlApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringBootAndMySqlApplication.class, args);
    }
}

java：

@RestController

public class HomeController {

    @Autowired
    private TaskDao taskDao;

    @RequestMapping("/greeting")
    public String greeting() {
        return "Welcome to Boot + SQL";
    }

    @RequestMapping("/list")
    public List<TaskEntity> taskList() {
        return taskDao.findByTaskArchived(0);
    }
}

java：

public interface TaskDao extends CrudRepository<TaskEntity, Integer> {

    List<TaskEntity> findByTaskArchived(Integer tas);

}

@Entity

@Table(name = "task_list")

public class TaskEntity 

{

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "task_id")
    private int id;

    @Column(name = "task_name")
    private String taskName;

    @Column(name = "task_description")
    private String taskDescription;

    @Column(name = "task_priority")
    private String taskPriority;

    @Column(name = "task_status")
    private String taskStatus;

    @Column(name = "task_archived")
    private int taskArchived = 0;

// getter & setter

}

spring.datasource.url = jdbc:mysql://127.0.0.1:3306/taskmanager
spring.datasource.username = root
spring.datasource.password = root
spring.jpa.show-sql = true
spring.jpa.hibernate.ddl-auto = update
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect
spring.datasource.driverClassName = com.mysql.jdbc.Driver

create database taskmanager;

use taskmanager;

create table task_list(task_id int not null auto_increment, task_name varchar(100) not null, task_description text,task_priority varchar(20),task_status varchar(20),task_start_time datetime not null default CURRENT_TIMESTAMP,task_end_time datetime not null default CURRENT_TIMESTAMP,task_archived bool default false,primary key(task_id));

insert into task_list values(1,'Gathering Requirement','Requirement Gathering','MEDIUM','ACTIVE',curtime(),curtime() + INTERVAL 3 HOUR,0);

insert into task_list values(2,'Application Designing','Application Designing','MEDIUM','ACTIVE',curtime(),curtime() + INTERVAL 2 HOUR,0);

insert into task_list values(3,'Implementation','Implementation','MEDIUM','ACTIVE',curtime(),curtime() + INTERVAL 3 HOUR,0);

insert into task_list values(4,'Unit Testing','Unit Testing','LOW','ACTIVE',curtime(),curtime() + INTERVAL 4 HOUR,0);

insert into task_list values(5,'Maintanence','Maintanence','LOW','ACTIVE',curtime(),curtime() + INTERVAL 5 HOUR,0);

select * from task_list;

有解决办法吗？

Answer 1

您包含了application.properties。那是什么侧写？您是否有用于云配置文件的application.properties？

云铸造通常与MySql一起提供服务。要充分利用它，首先需要创建一个服务实例。

如果您希望您的应用程序使用外部数据库（云铸造之外），您必须创建一个用户提供服务(CUPS)定义。