Skip to Content
avatar image
Former Member

How to use JDO with external database

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 07, 2004 at 12:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded