Regd Dictionary Table

[Former Member]

Hi All,

I've created a test Table in Dictionary from WD Java with some columns, the same has been archived and deployed to DB.

Now,

1. How & where can i see the Table I deployed?

2. How do i insert the values to the table? What r the option available?

3. Is JNDI lookup the only option to work on this table or can i use JDBC? If yes how?

tnx in advance,

JB

[Former Member · Accepted solution]

Hi,

1. One way to check the details dic_table, goto SDM

SDM > Login > Target Systems and Deployment SDM Repository > CONFIG_DB

here you can see the Dictionary Project details (no the the table name).

2. For inserting or querying the table deployed, use the below code:

InitialContext iCtx = new InitialContext();
DataSource dS = iCtx.lookup("jdbc/SAPXXXDB"); 
Connection con = dS.getConnection();
Statement st = con.createStatement();

for local datasoure details, see below path:

SDM > Login > Deployment Parameter Substitutions (click) > check the value of com.sap.datasource.default as SAPXXXDB.

3. Once you are successful till step.2 you can use normal 'java.sql.*' api for using DDL/DML statements.

Thanks,

MS

[Former Member · Accepted solution]

Bvr, Thanks for providing the link.

MS, your code and other options solved my qry. Thanks a lot for the answering.

-JB

[ravindra_bollapalli2]

hi

check this link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/ded11778-0801-0010-258f-ac3b9408...

let me know am i apporch is correct or not

bvr

[Former Member]

No replies..!