how to configure MSSQL drivers for J2EE

[pardha saradhi]

Hi I am new to entity beans I am trying my first entity bean.
I got some questions please clarify them.
1. How to configure JNDI for jdbc in J2ee?
2. shall I have to make any changes in configuration files
3. Can I do it with deploy tool of j2ee?
4. I want to configure with MS SQL.
5. will there be any difference in congiguration
with BMP and CMP

Thanking you in advance.
Saradhi
[ February 06, 2002: Message edited by: pardha saradhi ]
[ February 06, 2002: Message edited by: pardha saradhi ]

[pardha saradhi]

Please some one help me in configuring my MSsql drivers for JNDI with J2EE
Thanking you in advance

[Jason Brawner]

Check out this link...
http://jakarta.apache.org/tomcat/tomcat-4.0-doc/jndi-resources-howto.html
There are examples of JNDI and JDBC using Tomcat.

[Ruilin Yang]

For CMP and BMP, configuration of a data source of MSSQL server is the same. All you do is to register the data source to the app server, so it can be found by you program. You need a JDBC Driver.
Regards,
Ruilin

[Ram Dhan Yadav K]

Hi Pardha Saradhi,
I am not able to access MySql site, what i can tell you is you have to find a TYPEIII(ideal for middleware) or any JDBC driver and follow the connection pool configuration of your server document.
Good luck!

[pardha saradhi]

Hi I am putting the procedure I followed to configure the JNDI for jdbc please go thru and help me in finding out where am I missing.

1.In my D:\j2sdkee1.3\lib\system I placed mssqlserver.jar
2.In D:\j2sdkee1.3\bin\userconfig.bat I added....
set J2EE_CLASSPATH=D:\j2sdkee1.3\lib\system\mssqlserver.jar;D:\j2sdkee1.3\lib\system\tools.jar
3. in D:\j2sdkee1.3\config\default.properties I added (as mentioned in documentation)....
# Database configuration
jdbc.drivers=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc.datasources=jdbc:microsoft:sqlserver://199.199.199.2:1433;user=saradhi;password=saradhi;DatabaseName=nags
4.I started J2ee server
5.opened another dos prompt window
6.typed...
D:\> j2eeadmin -addJdbcDriver jdbc.drivers=com.microsoft.jdbc.sqlserver.SQLServerDriver
7.typed...
D:\>j2eeadmin -addJdbcDatasource jdbc/AccountDB
jdbc:microsoft:sqlserver://199.199.199.2:1433;user=saradhi;password=saradhi;DatabaseName=nags
8. I stoped j2ee server.. j2ee -stop
9. restarted j2ee server .. j2ee -verbose

******************Now I got the following messages on console......****************
J2EE server listen port: 1050
Naming service started:1050
WARNING : config/default.properties contains the obsolete jdbc configuration property
jdbc.drivers=com.microsoft.jdbc.sqlserver.SQLServerDriver. JDBC configuration is now stored in config/resource.properties.
WARNING : config/default.properties contains the obsolete jdbc configuration property
jdbc.datasources=jdbc:microsoft:sqlserver://199.199.199.2:1433;user=saradhi;password=saradhi;DatabaseName=nags. JDBC
configuration is now stored in config/resource.properties.
Binding DataSource, name = jdbc/Cloudscape, url = jdbc:cloudscape:rmi:CloudscapeDB;create=true
----------------
----------------
----------------
Binding DataSource, name = jdbc/AccountDB, url = jdbc/AccountDB__xa
Binding DataSource, name = jdbc/AccountDB__xa, dataSource = com.microsoft.jdbc.sqlserver.SQLServerDriver@3576a2
Error in creating data source object: jdbc/AccountDB__xa
Starting JMS service ... Initialization complete - waiting for client requests
-----
-----
J2EE server startup complete.
************************************************************************************
1. Now my question is am I missing any thing here?

I got stuckup here please somebody help me. Even config. for mysql also ok.
Thanking you in advance
Saradhi

[pardha saradhi]

Hi please look into this error and find me solution
Thankin u
Saradhi

[pardha saradhi]

Hi how should I register JNDI for jdbc with J2EE
please if any one has the steps let me know
I am facing lot of problems while doing it. I got stuck up here
I tried a lot still could not succeeded.
I am trying to connect to MS sql server
Driver :jdbc.drivers=com.microsoft.jdbc.sqlserver.SQLServerDriver
Datasource jdbc:microsoft:sqlserver://199.199.199.2:1433;user=saradhi;password=saradhi;DatabaseName=nags
Thanking you in advance
Saradhi