How to configure SAP datasource

[randahl]

Does anyone know the correct way to make JBoss connect to a sap database? I have tried appending the xml of sapdb-service.xml to the list of mbeans in jboss-service.xml, but this leads to the configuration problems shown below. Are there any other issues that needs to be taken care of?

R.

00:10:52,868 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean ope
ration 'checkIncompleteDeployments()'
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:

Incompletely deployed packages:

MBeans waiting for classes:

MBeans waiting for other MBeans:
[ObjectName: jboss.jca:service=LocalTxCM,name=SapdbDS
state: CREATED
I Depend On: jboss.jca:service=LocalTxDS,name=SapdbDS
jboss.jca:service=LocalTxPool,name=SapdbDS
jboss.jca:service=CachedConnectionManager
jboss.security:service=JaasSecurityManager
jboss.jca:service=RARDeployer

Depends On Me: , ObjectName: jboss.jca:service=LocalTxPool,name=SapdbDS
state: CREATED
I Depend On:
Depends On Me: jboss.jca:service=LocalTxCM,name=SapdbDS
]

[efly]

HI,
I've just made my SAP to JBOSS3.0 connection reference to the issue jboss 3.0.2 and oracle 8.1.7 .http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/ works quite well as you follow these steps:
1.edit $JBOSS/server/default/conf/standardjaws.xml:
java:/SapdbDS
<type-mapping>SapDB</type-mapping>
false
2.edit $JBOSS/server/default/conf/standardjbosscmp-jdbc.xml
java:/SapdbDS
<datasource-mapping>SapDB</datasource-mapping>
3.copy sapdbc.jar to $JBOSS/server/default/lib.
4.copied sapdb-service.xml to $JBOSS/server/default/deploy and edited it.
SapdbDS



<config-property name="ConnectionURL" type="java.lang.String">jdbc:sapdb://127.0.0.1/TST</config-property>
<config-property name="DriverClass" type="java.lang.String">com.sap.dbtech.jdbc.DriverSapDB</config-property>
<!--set these only if you want only default logins, not through JAAS -->
<config-property name="UserName" type="java.lang.String">test</config-property>
<config-property name="Password" type="java.lang.String">test</config-property>



5.edit jbosscmp-jdbc.xml that among your project deploy xml files.

java:/SapdbDS
<datasource-mapping>SapDB</datasource-mapping>
<create-table>true</create-table>
<remove-table>true</remove-table>
<pk-constraint>true</pk-constraint>
<preferred-relation-mapping>foreign-key</preferred-relation-mapping>


now you will work well with SAPDB in JBoss3.0.

[vinaysoni]

Could you please tell what version of SAP JDBC driver you are using?

I am able to connect to SAPDB from JBoss3.0 and execute SQL statements from my EJBs. However, once I have delay of 15 minutes, the subsequent SQLs start failing.

It did not appear stable to me.

From your message it appears you are using JBoss 3.2?

What is your version of SAP JDBC driver?

Is the environment stable?

[joelvogt]

one of our production sapdb databases just hit a gig of data (all inputs) and hasn't even needed to be restarted in about a years worth of up-time. (running on various jboss versions).
This has been with a couple of different drivers too, but mostly 21a.
If you get it set up, which can be a problem, then it is well worth your time