own implementation of db connection / pooling

[jagdeep]

Apologize if this has been asked before.

If I have a custom implementation for database connection and pooling in my application (connects to MS SQL server), is there a way to not configure / use -ds.xml / JBoss db connection pooling, and have JBoss connect to the DB? If so, how would one achieve this?

Thanks

[jagdeep]

As an addendum, even if I don't define a ds.xml, I need to customise some modules which require DB connections and ideally do so by doing the datasource lookup.

[peterj]

On seeing your first post, I was going to say: If you are doing all of your own database handling, you do not need a *-ds.xml file.

But after seeing your second post, I should say: Use the *-ds.xml file for those apps that will use a data source to access the database (your app with the customized db access will continue to use that customized access).

There is no issue with using multiple mechanisms to access a single database - database were designed to handle multiple simultaneous client apps.