create table #myTable (value varchar(12) NULL)

create temporary table myTable (value varchar(12) NULL)

DECLARE LOCAL TEMPORARY TABLE mytable (value varchar(12) NULL)

@Repository
public class MyDaoJdbc MyDao {

    private DialectHelper dialectHelper;

    /* the meat of the DAO removed for clarity */

    @Override
    public void createTemporaryTable() {
        getSimpleJdbcTemplate().update(dialectHelper.getTempTableCreateSql());
    }

    @Autowired
    public final void setDialectHelper(DialectHelper dialectHelper) {
        this.dialectHelper = dialectHelper;
    }
}

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName"    value="com.sybase.jdbc2.jdbc.SybDriver" />
    <property name="url"                    value="${jdbc.url}" />
    <property name="username"           value="${jdbc.username}" />
    <property name="password"           value="${jdbc.password}" />
</bean>

<bean id="dialectHelper" class="com.acme.myapp.jdbc.DialectHelperSybase" />

<jdbc:embedded-database id="dataSource" type="HSQL">
     <jdbc:script location="classpath:/resources/schema.sql"/>
     <jdbc:script location="classpath:/resources/test-data.sql"/>
</jdbc:embedded-database>

<bean id="dialectHelper" class="com.acme.myapp.dao.jdbc.DialectHelperHsql" />

public class DialectHelperHsql implements DialectHelper {
    @Override
    public String getTempTableCreateSql() {
        return "create temporary table myTable (value varchar(12) NULL)";
    }
}

public class DialectHelperSybase implements DialectHelper {
    @Override
    public String getTempTableCreateSql() {
        return "create table #myTable (value varchar(12) NULL)";
    }
}

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={
    "classpath:resources/spring-context.xml",
    "classpath:resources/spring-db-test.xml"})
@Transactional
@TransactionConfiguration(defaultRollback = true)
public class MyDaoIntegrationHsqlTest {
    ...
}