-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Thu, Jun 27, 2002 at 11:19:07AM +0530, Tejeshwar wrote:
> Hi
hi.
> I had configured MS SQLServer 2000 as the SQlServerpool in jboss.jcml
> file. I am using jboss-2.4.4 and the driver is microsoft sql server
> driver. How can sepecify a specific database name in jboss.jcml file.
if i understand your questions correctly you need to do 2 things. 1)
you need to tell jboss to load your jdbc driver. you do this by
adding your driver to the JDBC section of the jcml file. below is an
example using the mm.mysql driver:
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">org.gjt.mm.mysql.Driver,org.hsqldb.jdbcDriver
</attribute>
</mbean>
the next thing you need to do is create a datasource. below is an
example (notice where you need to add your user and password info and
also you will need to change the url to match you driver):
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=usersDB">
<attribute name="PoolName">usersDS</attribute>
<attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:mysql://localhost/users</attribute>
<attribute name="JDBCUser">ADD YOUR USER NAME HERE</attribute>
<attribute name="Password">ADD YOUR PASSWORD HERE</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="MaxSize">10</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">true</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
- --
Peter Abplanalp
Email: [EMAIL PROTECTED]
PGP: pgp.mit.edu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9GweSggA8sH0iRXQRAk9gAJ9fbOGwLqLd5P/CyIEWEodZHnBXsgCfQPD+
yUGghOvsydfA/Vy/Gdrgtuo=
=MBz8
-----END PGP SIGNATURE-----
-------------------------------------------------------
Sponsored by:
ThinkGeek at http://www.ThinkGeek.com/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
