Hi Sundondo,
This is probably because your HSSQL ds.xml file needs
to have the following things uncommented:
<!-- for tcp connection, allowing other
processes to use the hsqldb
database. This requires the
org.jboss.jdbc.HypersonicDatabase mbean.
<connection-url>jdbc:hsqldb:hsql://localhost:1701</connection-url>
-->
and:
<!-- This mbean should be used only when using tcp
connections. Uncomment
when the tcp based connection-url is used.
<mbean code="org.jboss.jdbc.HypersonicDatabase"
name="jboss:service=Hypersonic">
<attribute name="Port">1701</attribute>
<attribute name="Silent">true</attribute>
<attribute name="Database">default</attribute>
<attribute name="Trace">false</attribute>
<attribute name="No_system_exit">true</attribute>
</mbean>
-->
So uncomment those things and it should work.
Chad
--- Sunondo Ghosh <[EMAIL PROTECTED]> wrote:
> Hi Chad,
>
> I have a question about creating the tables used in
> the AnimalQuiz sample. When I run the
> initializeSchema then I get the error included at
> the bottom of my email. I looked in my JBoss deploy
> dir and saw the hsqldb-ds.xml config file. I
> modified the connection url there but then jboss
> startup threw some exceptions. Do you know what I
> need to do to set up hsqldb in order to create the
> tables? I went to the hsqldb site on sourceforge but
> didn't find much info there.
>
> In the older version of Andromda (2.x) the tables
> were getting created automatically. However in the
> new version it complains while trying to create a
> new entity that the table does not exist. Am I doing
> something wrong in the new version?
>
> Thanks for your help,
>
> Sunondo
>
>
C:\andromda-bin-3.0M1\samples\animal-quiz\app\target>java
> -classpath C:\jboss-3.
> 2.3\server\default\lib\hsqldb.jar
> org.hsqldb.util.ScriptTool -driver org.hsqldb.
> jdbcDriver -url jdbc:hsqldb:hsql: -database
> //localhost:1701 -script hibernate-s
> chema-initialize.sql
> ScriptTool.init error: Connection is broken:
> Connection refused: connect
> java.sql.SQLException: Connection is broken:
> Connection refused: connect
> at org.hsqldb.Trace.getError(Unknown Source)
> at org.hsqldb.Trace.error(Unknown Source)
> at
> org.hsqldb.jdbcConnection.reconnectHSQL(Unknown
> Source)
> at
> org.hsqldb.jdbcConnection.openHSQL(Unknown Source)
> at org.hsqldb.jdbcConnection.<init>(Unknown
> Source)
>
>
-------------------------------------------------------
This SF.Net email is sponsored by the new InstallShield X.
>From Windows to Linux, servers to mobile, InstallShield X is the
one installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504
_______________________________________________
Andromda-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/andromda-user
