Hellu, I am setting up a pooled database connection, but I am completely confused what should, and how, configured. I went through the mailing list, and got more configured still, as I think that many people are confused about this subject.
I am using the i-net opta driver which supports db pooling. I have the following questions concerning the configuration in the datasource.xml: - If I understand the little documentation on this subject, I noticed that you can let Orion emulate a connection pool, or let the driver offers this functionality. In my case the driver supports the functionality. But what do I put in the datsource.xml such that Orion knows that the driver handles the connection pooling and that Orion doesn't do this job ??? - What is the difference, and which should I use, between ?: + com.evermind.sql.DriverManagerDataSource ( I think I should use this one, when reading the Orion API) + com.evermind.sql.ConnectionDataSource (Can't find this one in the Orion API). + com.evermind.sql.OrionPooledDataSource (does Orion emulate database connection through this class ????). + There are more, but I think that I understand this difference I know the rest as well. - I noticed a configuration in the mailing list for the Opta driver , whereby there was one datasource of type "DriverManagerDataSource" and one of type "OrionPooledDataSource", whereby the latter one had the first one as source-location (http://www.mail-archive.com/orion-interest@orionserver.com/msg09179.html). I don't understand this configuration, and neiter does it work when I tested it. If someone understands this configuration, please give me some clearness on this issue ? - What is the difference between, and which should I use (the Orion documentation datasource.xml isn't clear on this issue) ? + ejb-location="jdbc/SQLServerDS" + pooled-location="jdbc/SybasePDS" (when do you use this one ??) It's a longggg story above, but hope that someone can clear some things. I now have the datasource configuration as listed below, which works, buttttt I like to know what it does and that it is the correct way to do this .annnddd. (I hate it when I don't know what's happening ) :( I hope that Magnus also included a guide on how to set up a (poold) database connection !? Eddie ------------------------ <data-source class="com.evermind.sql.DriverManagerDataSource" name="SQLServer" location="jdbc/SQLServerDS" xa-location="jdbc/xa/SQLServerXADS" ejb-location="jdbc/SQLServerDS" pooled-location="jdbc/SybasePDS" connection-driver="com.inet.tds.TdsDriver" url="jdbc:inetdae:localhost" inactivity-timeout="30" schema="database-schemas\ms-sql.xml" username="login" password="password" min-connections="2" max-connections="5" max-connect-attempts="2" wait-timeout="0" connection-retry-interval="3" />