Deployment of DataSource with Library SDA

[lars_decker]

Hi,

as mentioned in:

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

it should be poosible to deploy a DataSource together with my Library SDA. I have the data-sources.xml in the "/server/descriptors" directory of the library SDA

When I deploy the library i can't see the DataSource anywhere in Visual Admin (eg JDBC Connector). How can I be sure the DataSource is deployed. Or has it to be registered under JDBC Connector in Visual Admin anyway?

Thanks,

Lars

[Former Member]

Hi Lars,

What is the version of your SAP NetWeaver system?

It would be useful if you paste the code of your data-sources.xml file also.

Generally speaking, the two options for creating DataSources - with deployment or via Visual Administrator, are two separate alternatives, that is, if you deploy a DS with your application or library, you do not need to define it in the VA; this 'synchronization' should happen automatically...

Regards,

Yordan

[lars_decker]

I've tested it on different Netweaver Versions, current one is 7.00 SP9 (1000.7.00.9.1.20060913120000).

My data-sources.xml looks like (this is created be exporting a working datsource via Visual Admin):

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE data-sources SYSTEM 'data-sources.dtd'>

<data-sources>

<application-name>ee/escriba</application-name>

<data-source>

<data-source-name>EscribaDS</data-source-name>

<driver-name>ORACLE</driver-name>

<max-connections>25</max-connections>

<max-time-to-wait-connection>60</max-time-to-wait-connection>

<sql-engine>vendor_sql</sql-engine>

<jdbc-2.0>

<cpds-class-name>oracle.jdbc.pool.OracleConnectionPoolDataSource</cpds-class-name>

<object-factory>oracle.jdbc.pool.OracleDataSourceFactory</object-factory>

<properties>

<property>

<property-name>user</property-name>

<property-value>test_123_e</property-value>

</property>

<property>

<property-name>password</property-name>

<property-value>test_123_e</property-value>

</property>

<property>

<property-name>url</property-name>

<property-value>jdbc:oracle:thin:@192.168.200.8:1521:XE</property-value>

</property>

</properties>

</jdbc-2.0>

</data-source>

</data-sources>

and is located under: ./server/descriptors

Does it need to be referenced in any other deployment descriptor?

Regards,

Lars