Hi, I have a problem while deploying ejb on j2ee server.I do not know how to use ms sql server as the database instead of cloudscape or oracle.I am having a problem specifying in the "Resources reference Wizard" the coded name field for e.g in one book i checked out they used jdbc/AccountDB as the coded name field and in the JNDI name they used jdbc/Oracle since oracle database is used. I want to use mssql database where the dsn tht i have created is FINANCE_DSN and database name is finance so how do i specify the coded name field and the JNDI name in my case.
Also while making connection to the database in my ejb code i would like to know the meaning of the following used in some books. context.lookup("java:comp/env/jdbc/AccountDB") they claim tht to be the component name or somethin .How ever i do not understand wht java:comp.... stands for and how do i get a connection to my msssql database using the context.lookup()in my code. Please give me some explanation to the 2 queries as i am very confused.