JDBC Help?

[jfradkin]

I am new to both Jboss and Java.
I have written 3 applications so far and used the MSSQL driver with no problems. I am getting started on a major re-write of our ASP app and have figured out I should use pooled conection over the device method I use now. I tried configureing the MSSQLDS xml file and removed the default hypersonic xml file.
My hope is to use enterprise beans for data conectivity and servlets (Velocity front end) for client.
I can not even get the JNDI name thing going and am brain dead. I did buy the doco for Jboss and several books, but am just not gettig a working model of pooling. Is there a example that explains it in simple way from the ground up. I asume that Jboss is the only server I need, I am using jboss-3.2.1_tomcat-4.1.24 version and eclipse. I got Velocity going and can use the non pooled conection, but would rather learn the basics any examples appreciated. I did read the JNDI sun tutorial, but it left me going DOh. DO I need Ldap to get JDBC going? I keep getting need to define class in env. I tried a few of the examples on the forum, but figure I must be missing something basic.

Thanks Joel

[jfradkin]

more specifics in jdbc forum (have my mssql-ds.xml included)

I tried deleting all java installs (I did have an old directory) and re-installing as I read this had to do with more then one install, but I should be clean.

Works fine with.
Class.forName(driver);
Connection con1 = DriverManager.getConnection(url, username, password);
Statement stmt = con1.createStatement();

blows up on
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:/MSSQLDS");
con = ds.getConnection();

with
javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial

[jfradkin]

I figured it out I needed more client libs to get jndi working. I ended up using ds config from an example on this forum to get the connection happy. I am sure I am including more libs then I need but I did not see the exact combo and once I knew that was the issue I just included all the ones from jboss client.

Jope this helps, more detail under JDBC forum.