Hi Ajit,
> I had serious trouble with Jboss and SAPDB sometime back.
> (Jboss was messing up my autocommit settings by randomly setting queries to
> autocommit true/false causing table locks to be set and not released.).
> I primarily wanted to use Jboss to maintain a connection pool.
> If you do get it working ok, please can you send me a copy of your
> sapdb-service.xml and let me know which version of the jdbc driver/Jboss you use.
I don�t know if it helps you, here is my sapdb-service.xml.
Regards Matthias Lakaemper
----------------sapdb-service.xml-------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: hsqldb-service.xml,v 1.2.2.5 2002/06/23 21:25:58 d_jencks Exp $ -->
<server>
<!-- ==================================================================== -->
<!-- New ConnectionManager setup for default hsql dbs -->
<!-- Build jmx-api (build/build.sh all) and view for config documentation -->
<!-- ==================================================================== -->
<mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager"
name="jboss.jca:service=LocalTxCM,name=SapdbDS">
<!--uncomment out this line if you are using the DB2DbRealm above
<attribute name="SecurityDomainJndiName">HsqlDbRealm</attribute>
-->
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
<mbean code="org.jboss.resource.connectionmanager.RARDeployment"
name="jboss.jca:service=LocalTxDS,name=SapdbDS">
<attribute name="JndiName">SapdbDS</attribute>
<attribute name="ManagedConnectionFactoryProperties">
<properties>
<config-property name="ConnectionURL"
type="java.lang.String">jdbc:sapdb://server/DbName?timeout=0&trace=c:/temp/JBossDbtestSap.pct</config-property>
<config-property name="DriverClass"
type="java.lang.String">com.sap.dbtech.jdbc.DriverSapDB</config-property>
<config-property name="UserName"
type="java.lang.String">user</config-property>
<config-property name="Password"
type="java.lang.String">pass</config-property>
<config-property name="TransactionIsolation"
type="java.lang.String">TRANSACTION_READ_UNCOMMITTED</config-property>
</properties>
</attribute>
<!--Below here are advanced properties -->
<!--hack-->
<depends
optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss
LocalTransaction JDBC Wrapper</depends>
<depends>jboss:service=Hypersonic</depends>
</mbean>
</depends>
<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->
<mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool"
name="jboss.jca:service=LocalTxPool,name=SapdbDS">
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">50</attribute>
<attribute name="BlockingTimeoutMillis">5000</attribute>
<attribute name="IdleTimeoutMinutes">15</attribute>
<!--criteria indicates if Subject (from security domain) or app supplied
parameters (such as from getConnection(user, pw)) are used to distinguish
connections in the pool. Choices are
ByContainerAndApplication (use both),
ByContainer (use Subject),
ByApplication (use app supplied params only),
ByNothing (all connections are equivalent, usually if adapter supports
reauthentication)-->
<attribute name="Criteria">ByContainer</attribute>
</mbean>
</depends>
<depends
optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>
<depends
optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager</depends>
<attribute name="TransactionManager">java:/TransactionManager</attribute>
<!--make the rar deploy! hack till better deployment-->
<depends>jboss.jca:service=RARDeployer</depends>
</mbean>
</server>
----------------sapdb-service.xml-------------------------------------------------
______________________________________________________________________________
Keine Zeit fur Firlefanz? Blitz-SMS von WEB.DE FreeMail! Die SMS, die
direkt auf's Display kommt! http://freemail.web.de/features/?mc=021166
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
