[jBoss-Dev] Re: Adding a new JDBC driver

[Anthony Robins]

Adi,

We are not using CMP here so i cannot answer your question there.
But i did add the driver into jboss.conf

<MLET CODE = "org.jboss.jdbc.DataSourceImpl"
ARCHIVE="jboss.jar,cloudscape.jar" CODEBASE="../lib/ext/">
   <ARG TYPE="java.lang.String"
VALUE="jdbc:cloudscape:CloudscapeDB;create=true">
   <ARG TYPE="java.lang.String" VALUE="CloudscapeDB">
   <ARG TYPE="java.lang.String" VALUE="COM.cloudscape.core.JDBCDriver">
   <ARG TYPE="java.lang.String" VALUE="">
   <ARG TYPE="java.lang.String" VALUE="">
</MLET>

and into jboss.properties
jdbc.drivers=org.hsql.jdbcDriver,jdbc.idbDriver,COM.cloudscape.core.JDBCDriver

Then inside my bean i use

private Connection getConnection() throws SQLException {
      try {
        Context ctx = new InitialContext();
        DataSource ds =
            (DataSource)ctx.lookup("java:comp/env/Cloudscape");
        return ds.getConnection();
      }
      catch (NamingException e) {
       e.printStackTrace();
       throw new EJBException(ne);
      }
    }

You also have to add a resource manager as your database.

-- tony


Adi Lev wrote:

> How do you add a new JDBC driver in Jboss.conf
> How do you set the CMP to use this driver
> In my case i want to add OracleDriver from classes111.zip
>
> Thanks
> Adi
>
> > -----Original Message-----
> > From: Anthony Robins [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, July 11, 2000 1:50 AM
> > To:   [EMAIL PROTECTED]
> > Subject:      [jBoss-Dev] Adding a cloudscape driver and removing the
> > default jdbc drivers
> >
> > Hi,
> >
> > When i tried to add a cloudscape jdbc driver to jboss.conf and
> > jboss.properties, I
> > assumed that the 2 default drivers should be removed.  I received the
> > "java.sql.SQLException: No suitable driver" exception.
> >
> > When I put the drivers back, the Cloudscape driver gets loaded
> > successfully.
> > It seems strange that we need the default drivers loaded when there is a
> > third party
> > jdbc driver available.
> >
> > -- tony
> >