J2EE with MSSQL2000

How to configure J2EE to use MSSQL2000?Where i can find related tutorial or documents?I can not find any reference in J2EE Online TutorialThanks
[172 byte] By [kasayahk] at [2007-9-27 21:21:04]
# 1
Steps:1. Download the jdbc driver from http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/msdn-files/027/001/779/msdncompositedoc.xml and install it into your computer.2. Just follow the instructions provided.
nickhung at 2007-7-7 3:15:31 > top of Java-index,Other Topics,Patterns & OO Design...
# 2
Yes, I do.I can use MS SQL2000 Native Driver with applications written with J2SE.But i cannot find ways to configure J2EE Server to use it.Every time i try to generate SQL using delpoytool from J2EE, it always has error.
kasayahk at 2007-7-7 3:15:31 > top of Java-index,Other Topics,Patterns & OO Design...
# 3

I just installed Weblogic with MSSQL server 2000 jdbc driver, it seems ok.

Here are some tips may help you, after installing the driver:

1.Make sure your driver jar files path are included into CLASSPATH.

2.If you want to use datasource to connect to database, you need to config a datasouce in your EJB container, just follow the instruction of container's manual and JDBC driver's manual.

hciuts at 2007-7-7 3:15:31 > top of Java-index,Other Topics,Patterns & OO Design...
# 4
and this has what to do with patterns?
Dan Hinojosa at 2007-7-7 3:15:31 > top of Java-index,Other Topics,Patterns & OO Design...
# 5
As I think, J2EE pattern is database independent, either you use SQL Server or oracle or db2, it doesn't matter. As for jdbc installtion, most j2ee platforms have similiar steps.
hciuts at 2007-7-7 3:15:31 > top of Java-index,Other Topics,Patterns & OO Design...