[jboss-jira] [JBoss JIRA] Issue Comment Edited: (JBAS-8330) org.jboss.jdbc.HypersonicDatabase stopping HSQLDB 2.0 throws Exception

[Ondrej Medek (JIRA)]

    [ https://jira.jboss.org/browse/JBAS-8330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12544993#action_12544993 ] 

Ondrej Medek edited comment on JBAS-8330 at 8/15/10 2:36 PM:
-------------------------------------------------------------

But the JBoss uses improper method, anyway. The thing is, that this wrong method call passes OK for HSQLDB 1.8, but HSQLDB 2.0 throws an exception. And, IMHO, JBoss should be able to work with as many SQL RDBMS as possible.

Maybe you can change the Type: to the enhancement or something else, as you like. 

(I hope, JBoss will ship with HSQLDB 2.0 soon. It has implemented some new features, which makes the work with 2.0 more comfortable.)

      was (Author: xmedeko):
    But the JBoss uses improper method, anyway. The thing is, that for HSQLDB 1.8 this wrong method call passes OK, but HSQLDB 2.0 throws an exception. And, IMHO, JBoss should be able to work with as many SQL RDBMS as possible.

Maybe you can change the Type: to the enhancement or something else, as you like. I hope, JBoss will ship with HSQLDB 2.0 soon. (It has implemented some new features, which makes the work with 2.0 more comfortable.)
  
> org.jboss.jdbc.HypersonicDatabase stopping HSQLDB 2.0 throws Exception
> ----------------------------------------------------------------------
>
>                 Key: JBAS-8330
>                 URL: https://jira.jboss.org/browse/JBAS-8330
>             Project: JBoss Application Server
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>    Affects Versions: JBossAS-5.1.0.GA
>         Environment: JBoss 5.1.0GA, HSQLDB 2.0
>            Reporter: Ondrej Medek
>            Priority: Minor
>
> Hi,
> I have tried a new HSQLDB 2.0 with JBoss 5.1.0GA. It works fine. Just the org.jboss.jdbc.HypersonicDatabase.stopStandaloneDatabase() throws an exception:
> org.hsqldb.HsqlException: statement does not generate a result set
> I guess the code:
> statement.executeQuery(shutdownCommand);
> should be replaced by
> statement.executeUpdate(shutdownCommand);
> (But i have not tried it, though).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira