Hello,
I'm trying to get JBoss to use the Sybase JConnect 5.2 JDBC driver for CMP
entity beans. I've been looking at the "Using MS SQL Server with JBoss"
tutorial on the JBoss site, which is the closest thing I've found in terms
of relevant documentation:
http://www.jboss.org/documentation/HTML/ch11s17.html
And actually, it seems pretty applicable. But there's one area where the
instructions aren't too useful, because they vary considerably from driver
to driver, and that's the connection pool MBean declaration. I'm thinking it
would look something like this...
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=SQLServerPool">
<attribute
name="DataSourceClass">com.sybase.jdbcx.SybDataSource</attribute>
<attribute name="PoolName">SybasePool</attribute>
<attribute name="URL">???</attribute>
<attribute name="Properties">user=dbusername;
password=dbpassword</attribute>
<attribute name="MinSize">4</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
</mbean>
But, I have no idea how to formulate the JDBC URL, or if it's even needed.
Also, I wonder if I need "JDBCUser" and "Password" attributes. All of these
things seem to vary from driver to driver. Has anyone set this up for the
Sybase JDBC driver? Any help is appreciated.
Thanks,
Jason
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
