Problems with JDBC data source

[Former Member]

Hi, I installed netweaver 2004s.

I created a JDBC data source in application resources of netweaver, but I don't know whether it is successful or not. How to test it?

How to map the table of this JDBC data source to entity bean?

Thanks in advance!

[Former Member · Accepted solution]

Hi,

the easiest way to test the DataSource would be (in my opinion) to use the TEST_DS shell command.

To execute it, start a telnet console, connect to the dispatcher by executing

telnet <host> <port>

, where port is 5<JC_instance_number>08.

Then execute jump 0 to connect to the server process, then execute ADD DBPOOL to add the commands to the environment, then execute the TEST_DS command. For more info on command's attributes, see <a href="http://help.sap.com/saphelp_nw04/helpdata/en/06/37c8886ccd4759ae64ba831431864a/frameset.htm">this</a> page.

How to make use of the datasource: well, you usually declare a reference in the deployment descriptor of your servlet, or EJB application, and then lookup the datasource from JNDI in your application code using this reference.

Hope that helps!

[Former Member · Accepted solution]

hi, Ivaylo Ivanov, Thanks!

[Former Member]

Could anyone help me?

Thanks!