# Generate sql file using spring liquibase

**URL:** <https://forum.liquibase.org/t/generate-sql-file-using-spring-liquibase/3461>\
**Category:** General Discussion\
**Created:** [December 29, 2016, 5:12am UTC](https://forum.liquibase.org/t/generate-sql-file-using-spring-liquibase/3461 "2016-12-29T05:12:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krishnahotha](https://avatars.discourse-cdn.com/v4/letter/k/8797f3/32.png) [@Krishnahotha](https://forum.liquibase.org/u/Krishnahotha)\
**Post date:** [December 29, 2016, 5:12am UTC](https://forum.liquibase.org/t/generate-sql-file-using-spring-liquibase/3461/1 "2016-12-29T05:12:00Z")

</div>

Hi,

Is there any way i can generate the sql file using Springliquibase without executing the scripts? i am using the below code to generate the sql file.

public class SpringLiquibaseWriter extends SpringLiquibase {

```
@Override</div>

public void afterPropertiesSet() throws LiquibaseException {</div>

```

```
    try (Connection connection = getDataSource().getConnection()) {</div>

```

```
        Liquibase liquibase = createLiquibase(connection);</div>

        Writer writer;</div>

        try {</div>

            writer = new FileWriter("c:\\files\\temp.sql");</div>

            System.out.println(getDataSource().getConnection().getMetaData().getURL());</div>

            String s=null;</div>

            liquibase.update(s,writer);</div>

            </div>

            super.afterPropertiesSet();</div>

            writer.close();</div>

        } catch (LiquibaseException | IOException e) {</div>

            // handle</div>

        }</div>

```

```
    } catch (SQLException e1) {</div>

        // TODO Auto-generated catch block</div>

        e1.printStackTrace();</div>

    }</div>

}</div>

</div>

</div>

```

}

But it is still not working. can you please help me?