If you see a huge jump from odbc to jdbc, that is probably more due to the driver and the database. Some db vendors have a more robust jdbc driver and support. If odbc is setup correctly, and both drivers are equally maintained, odbc should have a slight edge on windows. On the mac, jdbc will probably give you better performance, due to poor odbc support.
-- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 15520 Coutelenc Rd Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [email protected] - [email protected] http://bighead.net/ - http://eventpix.com/ On Dec 2, 2010, at 3:37 PM, John Carrieri wrote: > Do you recommend jdbc over odbc or other the other way > around either for either performance reasons or other > features? > > We saw a huge jump in performance when switching to jdbc, > but didn't know if others had the same experience. > > Thoughts might be useful to all. > > Sincerely, > John > > > On 12/2/10 12:57 PM, "Robert Shubert" <[email protected]> wrote: > >> Dale, >> >> We are working on the documentation as quickly as we can. Much of the v5.5 >> doc >> still applies, although there are many differences which need to be >> explained, >> most notably in the Studio. We will get it out ASAP. >> >> ODBC on Windows should work out of the box. You will first need to setup a >> DSN >> in the OS. Since the Studio runs as a 32-bit application, you must use the >> 32-bit ODBC administrative tool. If you are on a 64-bit version of Windows, >> this is a little tricky. >> >> Once you have an ODBC DSN setup, you should be able to simply to select Data >> Sources > New Data Source > ODBC and then select the appropriate DSN from the >> dialog. >> >> For JDBC, you must first download the appropriate JDBC driver from your >> database vendor. Simply install and/or uncompress it wherever you want. Note >> that you should always use the latest version of the JDBC drivers. You should >> look for drivers which are compatible with JAVA 6 and are JDBC v4 compliant. >> For example, the MySQL Connector/J version 5.1 is the correct choice. >> >> Once the JDBC driver is on your machine, simply select Data Sources > JDBC >> Drivers to open up the JDBC dynamic driver utility. Use the appropriate >> Browse >> button to locate the JAR file of the driver and close the window. The JDBC >> driver will dynamically load. (We just added this code recently and it might >> be necessary to close and reopen the Studio to see the new driver). >> >> Lastly, you can use Help > System Info to see which JDBC drivers are loaded >> (and what versions they are). >> >> Once you have successfully loaded the driver, you can use Data Sources > New >> Data Source > JDBC to load up a database. You will not need to know anything >> about the driver, but you will need to know the JDBC URL and any necessary >> parameters. >> >> Note that at this time we only support JDBC for MySQL, MS SQL Server and >> Oracle. I will quickly add additional database support as they are requested >> and I verify that the driver loads properly. I will also post a compatibility >> chart on the website soon, which will contain exact version numbers of >> various >> drivers, etc. so you know what to download. >> >> Robert >> >> -----Original Message----- >> From: Dale Graham [mailto:[email protected]] >> Sent: Thursday, December 02, 2010 3:26 PM >> To: [email protected] >> Subject: Witango-Talk: Um, let me be the first to start with the dumb >> questions vis a vis version 6 ... >> >> Though I am waiting for the Mac version, I downloaded and installed the >> Windows version to fool around with while I was waiting. >> >> And now I have questions. >> >> Is there any documentation? I couldn't find any on the website. >> There doesn't seem to be any built into the application >> >> I can't figure out how to configure datasources, add JDBC drivers, (or ODBC >> drivers) etc. On the Mac, if a JDBC driver is located in a particular place, >> then all programs know where to find them. On this Windows machine, I do have >> classfile info set up pointing to the JDBC drivers. And have been using them >> for my Windows 5.5 developer studio. >> >> When I select "JDBC drivers available", a black box appears. Nothing else. >> When I try to add EITHER a new JDBC datasource or an ODBC data source, I get >> a >> nice black box. Nothing else. >> >> I did try copying my JDBC drivers into the wds6_lib directory, and restarting >> DS v 6, but no joy. >> >> >> >> On a different note, I cannot find a "configuration directory" any where, >> even >> after starting up Witango 6. >> >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to [email protected] >> with "unsubscribe witango-talk" in the body. >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to [email protected] >> with "unsubscribe witango-talk" in the body. >> > > __________________________________________________ > > John Carrieri > Chairman > > U. Inc. > 12264 El Camino Real, Suite #401 > San Diego, Ca. 92130 > Office: (858) 847-3350 x1001 > email: [email protected] > __________________________________________________ > > #1 in College Search - http://www.colleges.com > Power to the People - http://www.campaign.com > The Name says it All - http://www.employment.com > __________________________________________________ > > > > Colleges.com Natural Listings: > #1 Yahoo keyword colleges¹ > #1 Bing keyword colleges¹ #1 MSN keyword colleges¹ > #1 Bing keyword college¹ #1 Ask keyword colleges¹ > #1 or #2 Google keyword colleges¹ > > Employment.com Natural Listings: > #1 Bing keyword employment¹ > Top three Google keyword employment¹ > > U. Magazine - Largest college magazine > #1 on Google keyword college magazine¹ > #1 on AOL keyword college magazine¹ > #1 on Ask keyword college magazine¹ > > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
