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]

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.
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.
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.