Raghavan,
Please send a copy of the complete statement that you are executing, as well
as the full text of the error condition. I'll let you know if it gives me
any more ideas.
- Johann
On Fri, Feb 20, 2009 at 3:25 AM, Raghavan.30May1981_GMail <
[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
