|
Hi,
Am using the following to connect to hsqldb using
JBOSS3.0.3
a. ANT script
<target name="build-db" depends="init"> <echo message="------- building database tables --------" /> <echo message="JDBC Driver ${jdbc.driver}" /> <echo message="JDBC URL ${jdbc.url}" /> <echo message="JDBC JAR ${hsqldb.jar}" /> <sql driver="${jdbc.driver}" url="" userid="${jdbc.userid}" password="${jdbc.password}" src="" print="yes"> <classpath> <pathelement location="${hsqldb.jar}"/> </classpath> </sql> b. ANT properties file hsqldb.jar = ${env.JBOSS_HOME}/server/default/lib/hsqldb.jar jdbc.url = ""> jdbc.driver = org.hsqldb.jdbcDriver jdbc.userid = sa jdbc.password = ${env.OLS_EJB}/lib </target> c. jbosscmp-jdbc.xml <jbosscmp-jdbc> <defaults> <datasource>java:/DefaultDS</datasource> <datasource-mapping>Hypersonic SQL</datasource-mapping> </defaults> ..... d. jaws.xml <jaws> <datasource>java:/DefaultDS</datasource> <type-mapping>Hypersonic SQL</type-mapping> ..... d. I get the following error Build exception: D:\OLSurveyEJB\build\builDB.xml:124: java.sql.SQLException: Connection is broken: Connection refused: connect Any feed back would be appreciated, Thanks. Martin |
