Hi Johann, Thank you for the reply. I have executed those commands in the H2 console and all what it gives is the location of the jar file where h2 database has been picked up from. I have added the My SQL Connector Jar file into both CLASSPATH and H2DRIVERS environment variables. But when I try connecting to MySQL database with the proper Url, it does not let me get in. Any luck?
Cheers, Raghavan alias Saravanan M. http://groups.google.com/group/S_H_a_D_E "Do not break the bridge that you might need to cross someday!!!" - Wisemen. On Thu, Feb 19, 2009 at 12:37 AM, Johann Schleier-Smith <[email protected]>wrote: > Raghavan, > > If it says "The driver was not found" then your problem is probably with > the jdbc url, not the class path. > > You can confirm that the MySQL client is properly loaded in the class path > with the following commands: > CREATE ALIAS GET_PROPERTY FOR "java.lang.System.getProperty"; > CALL GET_PROPERTY('java.class.path'); > > For example, on my system I have see: > h2-1.1.107.jar;C:\oracle\db\jdbc\lib\ojdbc5.jar; > > Which reflects my environment variable setting: > H2DRIVERS=C:\oracle\db\jdbc\lib\ojdbc5.jar > > You will have a MySql jar in place of the Oracle jar. > > The jdbc url needs to be something like jdbc:mysql:... for the driver to be > found. E.g., > CREATE LINKED TABLE LT > ('com.mysql.jdbc.Driver','jdbc:mysql://localhost/test','username','password','tablename'); > > > On Wed, Feb 18, 2009 at 6:21 AM, Raghavan.30May1981_GMail < > [email protected]> wrote: > >> I guess i missed out one part.. my question was based on the "H2 Console" >> wherein you can connect to other databases using the respective JDBC Driver. >> >> Cheers, >> Raghavan alias Saravanan M. >> http://groups.google.com/group/S_H_a_D_E >> >> "Do not break the bridge that you might need to cross someday!!!" - >> Wisemen. >> >> >> On Wed, Feb 18, 2009 at 7:07 PM, Raghavan.30May1981_GMail < >> [email protected]> wrote: >> >>> That's fine. But my query was all about how to deal with the driver >>> entries. The entries pertaining to the MySQL Driver seems to be vanishing >>> once I clicked on 'Remove' button. >>> >>> Further, even after setting the H2DRIVERS environment entry with the >>> appropriate the MySQL JDBC Driver jar file, it still does NOT let me get >>> connected and keeps me giving an error saying, "The driver was not found". >>> Any rescue? >>> >>> Cheers, >>> Raghavan alias Saravanan M. >>> http://groups.google.com/group/S_H_a_D_E >>> >>> "Do not break the bridge that you might need to cross someday!!!" - >>> Wisemen. >>> >>> >>> >>> On Wed, Feb 18, 2009 at 6:42 PM, Todd Stout <[email protected]>wrote: >>> >>>> I don't understand what connecting to MySQL has to do with the H2 >>>> database. If you want to connect to MySQL, use the MySQL JDBC driver. >>>> >>>> >>>> On Tue, Feb 17, 2009 at 4:47 PM, Raghs <[email protected]>wrote: >>>> >>>>> >>>>> Hi All, >>>>> >>>>> I have been trying to connect to a MySQL Database which is already >>>>> existing. Though I have added the mysql connector jar file (with full >>>>> path) to an environment variable named H2DRIVERS as suggested in the >>>>> documentation, it keeps giving me an error "Database driver not >>>>> found". Am I missing something ? >>>>> >>>>> Where are the entries with respect to the databases getting stored? I >>>>> just once tested by clicking on the 'Remove' button and it had taken >>>>> off the MySQL related entries. I had searched in "C:\Windows\Documents >>>>> and Settings\<userName>", the location where I had extracted the h2- >>>>> zip folder and ran the h2 executable jar. But no luck. >>>>> >>>>> Moreover when I logged off, deleted and completely unzipped the >>>>> contents freshly, still I can see those entries in the Cache. Is it >>>>> getting stored in browser cache? >>>>> >>>>> Thanks, >>>>> Raghavan alias Saravanan M. >>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
