1 Reply Latest reply on Dec 16, 2001 1:13 PM by Luke Taylor

    cloudscape db and connection pool

    suresh Newbie

      Hi all,
      I palced the following lines in jboss.jcml file in order to create a connection pool. But on calling a servlet with
      DriverManager.getConnection(jdbc:cloudscape:db)
      an error message appeares and reports that the accessed "able is not found"



      COM.cloudscape.core.JDBCDriver
      db


      <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=somepool
      db
      somepool
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

      jdbc:cloudscape:db




      1200000
      10
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0


      I put the db(database name)into jboss/db directory
      i want to know the format of getConnection string. should i place the db name(db) or pool name somepool?

      any help is greatly appreciated
      rgsuresh

        • 1. Re: cloudscape db and connection pool
          Luke Taylor Novice

          You shouldn't be using DriverManager.getConnection() at all.

          I think you need to look at some basic examples on using javax.sql.Datasource - get the manual from flashline which has everything you need to know about JBoss 2.4 in it.

          Try to copy some of the examples in there - using the hypersonic database and the default datasource in jboss.jcml. Then move on to setting up your own datasources.

          Luke.