cancel
Showing results for 
Search instead for 
Did you mean: 

How to use JDO with external database

Former Member
0 Kudos

Hi,

is it possible do use JDO (part of WAS 6.4) with an external relational database that is not contained in the data dictionary? If so, what are the steps to do it?

Any help appreciated!

Martin

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Martin,

What you need to do is as follows:

1. Create a DataSource for the database that you want to connect to, using either native or vendor SQL. You can do that in Visual Administrator, in the runtime tab of JDBC Connector Service.

2. Change the ConnectionFactoryName of the JDO resource adapter to point to the new DataSource. You can do that again in Visual Administrator, in the runtime tab of Connector Container Service.

You can get more information about these two steps in the Administration Manual for SAP Web AS Java under Server Administration -> SAP J2EE Engine Administration -> Transactions and Resource Handling at the following link:

http://help.sap.com/saphelp_nw04/helpdata/en/13/a3bb3eff62847ae10000000a114084/frameset.htm

For more information about the ConnectionFactoryName property of the JDO resource adapter, see the Development Manual under Developing Business Logic -> Java Persistence -> Object Persistence for Java -> Java Data Objects -> Architecture Overview -> The Default PersistenceManagerFactory.

Hope that helps,

Zornitsa

Message was edited by: Zornitsa Yankulova