what is the process to connect to database from webdynpro ?

[Former Member]

hi all

i am goutham

my dought is

what is the process to connect to database from wbedynpro ? please tell me the detailed procedure

thanks in advance

goutham.

[vijayakhanna_raman]

Hi,

Check this thread

Regards,

Vijayakhanna raman

[Former Member]

Hi Goutham

For the SQLServer Database Open Type

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

Connection conn= java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://Server:Host;user=UserName;password=Password;database=DBUser");

Otherwise You can Create a Data Source alias name and conect the Databace

InitialContext initialContext = new InitialContext();

DataSource dataSource = (DataSource)initialContext.lookup("jdbc/DataSource");

java.sql.Connection conn = dataSource.getConnection();

To Create Data Source alias Refer This

Kind Regards

Mukesh