On Wed, 11 Apr 2001, Matthew Setter wrote:
> Has anyone successfully gotten a connection pool in jboss 2.1 running using
> the freetds driver to an ms sql database??
>
> If so, could you email jboss.jcml snippets pls.
>
> Having a very frustrating time trying to get it running.
>
> thanks,
>
> Matthew
>
Put your freetds_jdbc.jar in the $JBOSSHOME/lib/ext dir.
jboss.jcml:
<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
<attribute
name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,com.internetcds.jdbc.tds.Driver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=MSQLDB">
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="PoolName">MSQLDB</attribute>
<attribute name="URL">jdbc:freetds:sqlserver://bahama/JBoss</attribute>
<attribute name="JDBCUser">jbossuser</attribute>
<attribute name="Password">jbossuser</attribute>
</mbean>
in ejb-jar.xml:
<enterprise-beans>
<entity>
<display-name>LoginServletBean</display-name>
<ejb-name>LoginServletBean</ejb-name>
<home>LoginHome</home>
<remote>Login</remote>
<ejb-class>LoginEJB</ejb-class>
<persistence-type>Bean</persistence-type>
<prim-key-class>java.lang.Object</prim-key-class>
<reentrant>False</reentrant>
<resource-ref>
<res-ref-name>jdbc/JBossDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</entity>
</enterprise-beans>
in jboss.xml:
<resource-managers>
<resource-manager res-class="org.jboss.ejb.deployment.JDBCResource">
<res-name>jdbc/JBossDB</res-name>
<res-jndi-name>MSQLDB</res-jndi-name>
</resource-manager>
</resource-managers>
in your EJB:
private String dbName = "java:comp/env/jdbc/JBossDB";
InitialContext ic = new InitialContext();
DataSource ds = (DataSource)ic.lookup(dbName);
con = ds.getConnection();
Hope that helps,
Daren
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
