users@glassfish.java.net

Re: JDBC: Configuration / support for SAP MaxDB 7.x?

From: <glassfish_at_javadesktop.org>
Date: Tue, 18 Dec 2007 03:35:45 PST

With GlassFish V2, i have tried configuring a XA type of DataSource.
Create a connection pool with the resource type javax.sql.XADataSource. Specify the datasource classname "com.sap.dbtech.jdbcext.XADataSourceSapDB".

Under the additional properties section, add the properties "user", "password" and "url". The url takes values like "jdbc:sapdb://localhost/dbName". After creating this connection pool, you could test the correctness by pinging the pool (all from the admin console of GF v2) under the general tab of the CP that you just created. A JDBC resource could be created after this to lookup the datasource through an EJB (for example).

I have not tried the DataSource/ConnectionPoolDataSource resource types of this driver.

Hope this helps,
Shalini.
[Message sent by forum member 'sm157516' (sm157516)]

http://forums.java.net/jive/thread.jspa?messageID=250549