P.S.
To be more professional I think that .conf should add to ARG the PARAM=
e.g.
<ARG TYPE=" " PARAM="user" VALUE="adi">
<ARG TYPE=" " PARAM="password" VALUE="123"> etc...
even now only for documentation, but later to use it instead of position!
I still dont know where I tell the JBOSS to use a new driver for CMP
usage. any answer????
> -----Original Message-----
> From: Anthony Robins [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 11, 2000 5:42 PM
> To: Adi Lev
> Cc: jBoss Developer
> Subject: [jBoss-Dev] Re: Adding a new JDBC driver
>
> 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.JDBCDr
> iver
>
> 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
> > >
>
