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
-~----------~----~----~----~------~----~------~--~---
