0 Replies Latest reply on Sep 28, 2006 9:59 AM by fernando gamba

    error  enabling the hsql MBean and tcp/ip connections

    fernando gamba Newbie

      hi, i follow the indications the startguide to run a process inside jboss, everything works fine until i try to enable the hsql mbean and the tcp/ip connections.
      I check like the guide says in the hsqldb-ds.xml file if the line jdbc:hsqldb:hsql://localhost:1701 is uncommented in the <url-connection> and the other same tags are commented
      next, i check if the mbean declaration is uncommented, now the guide says that if you choose to delete the other mbean definition? , it refers to the other mbean definition below the other mbean definition right?
      next says that make sure to change the dependency on the datasource from jboss:service=hipersonic,database=localDB to jboss:service=hipersonic

      it refers to the same mbean definition wich i choose to delete before?
      excuse me if the question seems dumb but i dont understand that, besides when i try to create de databas schema ant -f jboss-buil.xml db-create-table give me the following:
      Buildfile: jboss-build.xml

      db-create-table:
      [java] ScriptTool.init error: socket creation error
      [java] java.sql.SQLException: socket creation error
      [java] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      [java] at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
      [java] at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
      [java] at org.hsqldb.jdbcDriver.connect(Unknown Source)
      [java] at java.sql.DriverManager.getConnection(DriverManager.java:525)
      [java] at java.sql.DriverManager.getConnection(DriverManager.java:171)
      [java] at org.hsqldb.util.ScriptTool.execute(Unknown Source)
      [java] at org.hsqldb.util.ScriptTool.main(Unknown Source)
      [java] Exception in thread "main" java.lang.NullPointerException
      [java] at org.hsqldb.util.ScriptTool.execute(Unknown Source)
      [java] at org.hsqldb.util.ScriptTool.main(Unknown Source)
      [java] Java Result: 1

      BUILD SUCCESSFUL
      and the ant -f jboss-build.xml db-insert give me the following

      db-insert:
      [java] SQL Error at line 269: java.sql.SQLException: Table not found in statement [DELETE FROM tx]

      idem for ant -f jboss-build.xml db-list



      and when a run the jboss it give me the following log


      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: jboss:service=DefaultPartition
      State: FAILED
      Reason: ChannelException: java.lang.Exception: exception caused by UDP.start(): java.lang.Exception: UDP.createSockets(): cannot list on any port in range 0-1
      I Depend On:
      jboss:service=Naming
      Depends On Me:
      jboss:service=HASessionState
      jboss:service=HAJNDI
      jboss.cache:service=InvalidationBridge,type=JavaGroups
      jboss.ha:service=HASingletonDeployer
      jboss:service=FarmMember,partition=DefaultPartition

      ObjectName: jboss:service=Hypersonic,database=localDB
      State: NOTYETINSTALLED
      Depends On Me:
      jboss.jca:service=ManagedConnectionFactory,name=DefaultDS

      ObjectName: jboss:service=CorbaTransaction
      State: FAILED
      Reason: java.lang.Exception: Cannot bind transaction factory in CORBA naming service:
      org.omg.CORBA.TRANSIENT: Retries exceeded, couldn't reconnect to 10.0.248.247:3528 vmcid: 0x0 minor code: 0 completed: No
      I Depend On:
      jboss:service=TransactionManager
      jboss:service=CorbaORB
      jboss:service=CorbaNaming

      ObjectName: jboss.cache:service=TomcatClusteringCache
      State: FAILED
      Reason: ChannelException: java.lang.Exception: exception caused by UDP.start(): java.lang.Exception: UDP.createSockets(): cannot list on any port in range 0-1
      I Depend On:
      jboss:service=Naming
      jboss:service=TransactionManager

      i hope to be clear, thanks for any suggestions