在DBCP2中使用语句时，为什么后续创建临时表会抛出错误？

import org.apache.commons.dbcp2.BasicDataSource;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class DBCP2Example {
    public static void main(String[] args) {
        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setUrl("jdbc:mysql://localhost:3306/mydatabase");
        dataSource.setUsername("username");
        dataSource.setPassword("password");

        try (Connection connection = dataSource.getConnection()) {
            // 创建临时表
            String createTempTableSQL = "CREATE TEMPORARY TABLE temp_table (id INT, name VARCHAR(255))";
            try (PreparedStatement stmt = connection.prepareStatement(createTempTableSQL)) {
                stmt.executeUpdate();
            }

            // 使用临时表
            String insertDataSQL = "INSERT INTO temp_table (id, name) VALUES (?, ?)";
            try (PreparedStatement stmt = connection.prepareStatement(insertDataSQL)) {
                stmt.setInt(1, 1);
                stmt.setString(2, "Test");
                stmt.executeUpdate();
            }

            // 查询临时表
            String selectDataSQL = "SELECT * FROM temp_table";
            try (PreparedStatement stmt = connection.prepareStatement(selectDataSQL)) {
                try (ResultSet rs = stmt.executeQuery()) {
                    while (rs.next()) {
                        System.out.println("ID: " + rs.getInt("id") + ", Name: " + rs.getString("name"));
                    }
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                dataSource.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}