Connecting Entity Bean with MS SQL SERVER 2000

Discussions

EJB programming & troubleshooting: Connecting Entity Bean with MS SQL SERVER 2000

  1. Connecting Entity Bean with MS SQL SERVER 2000 (3 messages)

    Hi,
    I am new to J2EE. I am using J2EE1.2 server.When I am working with Entity Bean, I could connect it with Cloudscape. But I can't connect it with MS SQL SERVER 2000. please anyone tell me which are the steps to follow to connect it with MS SQL SERVER 2000.
    Thanks in advance
    sini
  2. Hi,
         I dont have much idea about J2EE1.2 server but in oracle 9ias to acieve this we have to provide all the information(userid password connectstring) in Connection XML file.After providing all these information you have to bounce the server.

    Thanks
  3. There may be some issues in JDBC configuration. Try creating a simple JSP to use the DataSource that you are using for the entity bean

    This is how we do we in OC4J http://radio.weblogs.com/0135826/2004/03/29.html. You can mimic the steps in your J2EE server.

    -Debu Panda

    http://radio.weblogs.com/0135826/
  4. Hi,I am new to J2EE. I am using J2EE1.2 server.When I am working with Entity Bean, I could connect it with Cloudscape. But I can't connect it with MS SQL SERVER 2000. please anyone tell me which are the steps to follow to connect it with MS SQL SERVER 2000.Thanks in advancesini

    In case of the J2EE 1.2 server, Im guessing that u are using the Reference implementation? Also, may be you could tell us or give us a snapshot of the error that u are facing. Ideally to connect to any other database that cloudscape which is bundled with J2EE 1.2 server, i think you need to get the driver that is responsible for your database in the classpath to your container, in this case the J2EE Ri. After that I think its a bit of tweaking w.r.to the code mentioning the correct jndi name of the driver and we should be all set to go.