在应用程序启动时启动 HSQLDB 数据库管理器？

发布于 2024-11-17 13:36:46 字数 249 浏览 0 评论 0原文

当我在本地开发环境中工作时，是否可以以某种方式自动启动 HSQLDB 数据库管理器？我现在正在使用内存数据库。我找到了一些在运行测试用例时启动数据库管理器的代码。启动 Web 应用程序时也可以使用它吗？

org.hsqldb.util.DatabaseManagerSwing.main(new String[] { "--url","jdbc:hsqldb:mem:moviecollection", "--noexit" });

原文

Is it possible to start the HSQLDB Database manager automatically somehow when I´m working in my local dev environment? I´m using the in-memory DB at the moment. I found some code to start the database manager when running test cases. Can this be used when starting a web application as well?

org.hsqldb.util.DatabaseManagerSwing.main(new String[] { "--url","jdbc:hsqldb:mem:moviecollection", "--noexit" });

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

伴我老 2024-11-24 13:36:46

我假设您正在使用 Spring，因为您用它标记了您的问题。您可以创建一个 Spring bean，该 bean 的方法使用 JSR-250 注释进行注释 @PostConstruct。用@PostConstruct 注解的方法指示应在创建 bean 并完成依赖项注入后调用该方法。

@Component
public class Initializer
{
    @PostConstruct
    public void init()
    {
       org.hsqldb.util.DatabaseManagerSwing.main(new String[] { "--url","jdbc:hsqldb:mem:moviecollection", "--noexit" }); 
    }
}

如果您使用 Web 应用程序启动 DatabaseManagerSwing，它将被创建并显示在运行 WAR 的服务器上，而您可能不想这样做。

I am assuming you are using Spring because you tagged your question with it. You could create a Spring bean that has a method that is annotated with the JSR-250 annotation @PostConstruct. Method annotated with @PostConstruct indicates that the method should be invoked after the bean has been created and dependency injection is complete.

@Component
public class Initializer
{
    @PostConstruct
    public void init()
    {
       org.hsqldb.util.DatabaseManagerSwing.main(new String[] { "--url","jdbc:hsqldb:mem:moviecollection", "--noexit" }); 
    }
}

If you would start the DatabaseManagerSwing with a web application it would get created and displayed on the server your WAR is running on which you probably don't want to do.

回复收藏 0 原文

日暮斜阳 2024-11-24 13:36:46

您不需要明确地启动它。如果您配置连接 url 并添加 jars 就足够了。

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName" value="org.hsqldb.jdbcDriver"/>
  <property name="url" value="jdbc:hsqldb:mem:demo"/>
  <property name="username" value="sa"/>
  <property name="password" value=""/>      <
</bean>

You did not need to start it explicite. It is enougth if you configure the connection url and add the jars.

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName" value="org.hsqldb.jdbcDriver"/>
  <property name="url" value="jdbc:hsqldb:mem:demo"/>
  <property name="username" value="sa"/>
  <property name="password" value=""/>      <
</bean>

回复收藏 0 原文