DeployingTables in my own datasource

[Former Member]

Hi, I have created some tables with the Java Dictionary. When I make the deploy, they are automatically created in de default datasource of the J2EE Engine.

I need to deploy them in another datasource that I have created with the visual administrator. How can i configure this?

Thanks in advance

Pablo

[Vlado · Accepted solution]

Hi Pablo,

Unfortunately this is not possible. The Java Dictionary deploys tables only in the J2EE Engine system database via its default datasource.

Best regards,

Vladimir

[Former Member · Accepted solution]

Thanks Vladimir.

I was using the Java Dictionare to specify the O/R mapping in a CMP Entity Bean. Wich is the best way to do this if I want to use another Database distinct that de default one?

Thanks again.

Pablo

[Vlado · Accepted solution]

Hi Pablo,

You specify the O/R mapping for CMP entity beans in the persistent.xml. For this purpose you have to define the DataSource that will be used. Since you want to use another DB and not the system one, you have the option to define its SQL Engine type as VendorSQL or NativeSQL only (i.e. you cannot benefit from the OpenSQL persistency layer). For more information please have a look at these documents:

http://help.sap.com/saphelp_nw04/helpdata/en/bb/69da54d8aedc419d46d9ea074e4d41/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/d2/369f1dddb7ff4c96c2bacdd7aa6c87/frameset.htm

and the links from there.

Hope that helps!

Vladimir

[Former Member · Accepted solution]

Thank you Vladimir, it works!!!!!!!

Pablo