As of right now, everything is being ran on SQL Server 2000 We will upgrading to SQL 2008 soon, but as of right now, the platform is SQL 2000
I've installed the following driver http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en -SQL Server 2000 Driver for JDBC Service Pack 3- "The Microsoft® SQL Server™ 2000 Driver for JDBC™ is a Type 4 JDBC driver that provides highly scalable and reliable connectivity for the enterprise Java environment. This driver provides JDBC access to SQL Server 2000 through any Java-enabled applet, application, or application server." It appears this is the most current driver for the server. I'm in no way tied to ODBC, just that it was what I was using before, but appears that JDBC makes alot more sense since it is specifically for java->db connectivity and anything else requires additional overhead and still isn't as good. So it makes sense to use JDBC. Yes, there will be multiple front end webservers all connecting to the same db server(s). I say (s) because if needed, we can scale out. But at the moment, there will be one server on the immediately private network (same private subnet) named db01. So, I have the jdbc driver installed on sql, what else do I have to do? (i'm googling). Does the following config look correct? Assume the database hostname is 'db01', the datasource name should be 'members' and the actual database itself is named 'members' <datasource name="members"> <password>t3mpr00t</password> <connectionretries>0</connectionretries> <sqlupdate>true</sqlupdate> <sqldelete>true</sqldelete> <username>SA</username> <drivername>com.microsoft.sqlserver.jdbc.SQLServerDriver</ drivername> <sqlstoredprocedures>true</sqlstoredprocedures> <perrequestconnections>false</perrequestconnections> <sqlinsert>true</sqlinsert> <sqlselect>true</sqlselect> <connectiontimeout>120</connectiontimeout> <databasename>members</databasename> <initstring></initstring> <logintimeout>120</logintimeout> <hoststring>jdbc:sqlserver://db01:1433;databaseName=members</ hoststring> <maxconnections>24</maxconnections> <name>members</name> </datasource> --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
