Skip to Content
0
Former Member
Nov 01, 2005 at 05:03 PM

Native/Vendor SQL

25 Views

I'd like to experiment with the Native SQL access option in the SAP Java persistence framework, but I'm uncertain how to create a second (other than default) connection pool that I can configure to Native SQL. In the May/June 2004 SAP Professional Journal article, "A Guided Tour of the SAP Persistence Framework," the authors state that "The J2EE Engine can manage multiple connection pools for accessing the same or different schemas in one or more databases ..." It isn't clear to me how to get multiple connection pools for the same schema. In the Visual Administrator (I'm working with a central, not a local system, by the way), it looks like there is one configurable connection pool per DataSource. Given a default DataSource of SAPXYZDB, is there a way to create a second connection pool for it? Or can I create a second DataSource that actually points to the same database/schema? Bottom line: I'd like to experiment with Native SQL, but without messing around with the default DataSource and without installing a second database. Any help is appreciated.