ya true the DataSourceImpl classes are not there in the jboss.jar its in a
separate jar for jdbc extention 2.0 its lying in the /jboss/lib dir.
here from conf file
<MLET CODE = "org.jboss.jdbc.JdbcProvider"
ARCHIVE="jboss.jar,idb.jar,hsql.jar,weblogic.jar" CODEBASE="../../lib/ext/">
</MLET>
and from jcml file
<mbean name="DefaultDomain:service=XADataSource,name=jdbc/MSSQLPOOL">
<attribute name="Properties"></attribute>
<attribute
name="URL">jdbc:weblogic:mssqlserver4:[EMAIL PROTECTED]:1433</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">alap</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password">alap</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
try it out.
regards,
alap.
----- Original Message -----
From: "Steven Haines" <[EMAIL PROTECTED]>
To: "jBoss" <[EMAIL PROTECTED]>
Sent: Saturday, December 09, 2000 3:54 AM
Subject: Re: [jBoss-User] 2.0-FINAL MS SQL Server
> Hi Alap,
>
> Glad to hear that you have it working.. I followed the
> tutorial but it failed in the jboss.conf when it came
> to adding the MLET - here is the code from the
> tutorial:
>
> <MLET CODE = "org.jboss.jdbc.DataSourceImpl"
> ARCHIVE="jboss.jar,{your JDBC-jar file}"
> CODEBASE="../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="{JDBC-url to the
> DB}">
> <ARG TYPE="java.lang.String" VALUE="{datasource name
> like: MsSQL}">
> <ARG TYPE="java.lang.String" VALUE="{JDBC-driver class
> name}">
> <ARG TYPE="java.lang.String" VALUE="{User name}">
> <ARG TYPE="java.lang.String" VALUE="{Password}">
> </MLET>
>
> Can you give me a snippet of your jboss.conf file
> specifically for this section?? It appears the problem
> is that org.jboss.jdbc.DataSourceImpl does not exist
> in the source code or jboss.jar..
>
> Thanks again for your help!
> Steve
>
>
> > --- alap <[EMAIL PROTECTED]> wrote:
> > > i could easily connect to MSSQL with jboss. right
> > > now i m using type-4
> > > driver provided by bea weblogic. u can download
> > this
> > > from bea site. u only
> > > need to specify the weblogic driver jar in the
> > place
> > > of archive. u also need
> > > jdbc standard extention 2.0 and this jar is
> > > available with jboss which gives
> > > provides a wrapper cos the MSSQL driver provided
> > by
> > > weblogic doesnt provide
> > > javax.sql classes. try it out it works fine.
> > > regards,
> > > alap.
> > > ----- Original Message -----
> > > From: "Steven Haines" <[EMAIL PROTECTED]>
> > > To: "jBoss" <[EMAIL PROTECTED]>
> > > Sent: Thursday, December 07, 2000 11:23 PM
> > > Subject: [jBoss-User] 2.0-FINAL MS SQL Server
> > >
> > >
> > > > Hi All,
> > > >
> > > > I am having extreme difficulties trying to hook
> > > JBoss
> > > > up to MS SQLServer - the tutorial on the website
> > > > appears to the out of date: it states to use the
> > > class
> > > > "org.jboss.jdbc.DataSourceImpl" to load the JDBC
> > > JAR
> > > > file, but that class no longer exists.
> > > >
> > > > If anyone has been successful in connecting
> > JBoss
> > > to
> > > > SQL Server, could you please send me a snippet
> > of
> > > your
> > > > jboss.conf file..
> > > >
> > > > Both JDBC-ODBC bridge and type 4 driver
> > solutions
> > > are
> > > > welcome!
> > > >
> > > > Thanks for all your help!
> > > > Steve
> > > >
> > > >
> > > >
> > > >
> > > > =====
> > > > Steven Haines
> > > > Technical Lead
> > > > IPNet Solutions
> > > > [EMAIL PROTECTED]
> > > > [EMAIL PROTECTED]
> > > > (949)476-4463 x388
> > > >
> > > >
> > __________________________________________________
> > > > Do You Yahoo!?
> > > > Yahoo! Shopping - Thousands of Stores. Millions
> > of
> > > Products.
> > > > http://shopping.yahoo.com/
> > > >
> > > >
> > > > --
> > > >
> > >
> >
> --------------------------------------------------------------
> > > > To subscribe:
> > > [EMAIL PROTECTED]
> > > > To unsubscribe:
> > > [EMAIL PROTECTED]
> > > > Problems?: [EMAIL PROTECTED]
> > >
> > >
> > >
> > > --
> > >
> >
> --------------------------------------------------------------
> > > To subscribe:
> > > [EMAIL PROTECTED]
> > > To unsubscribe:
> > > [EMAIL PROTECTED]
> > > Problems?: [EMAIL PROTECTED]
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Shopping - Thousands of Stores. Millions of
> > Products.
> > http://shopping.yahoo.com/
> >
>
>
> =====
> Steven Haines
> Technical Lead
> IPNet Solutions
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> (949)476-4463 x388
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Shopping - Thousands of Stores. Millions of Products.
> http://shopping.yahoo.com/
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
