Re: JDBC Connection problem

[Ishpal]

Thanks David,
 
        Now I have configured the data-source as 


 <data-source
                name="Default data-source"
                class="com.evermind.sql.ConnectionDataSource"
                location="jdbc/DefaultDS"
                pooled-location="jdbc/DefaultPooledDS"
                xa-location="jdbc/xa/DefaultXADS"
                ejb-location="jdbc/DefaultEJBDS"
                connection-driver="org.gjt.mm.mysql.Driver"
                url="jdbc:mysql://localhost/defaultdb"
                username="sa"
                password=""
                schema="database-schemas/mysql.xml"
        />
                                                

But whenever I try to start the server I get an error that Driver not
found.
I have kept the jar file for the driver in orion/lib and have also tried
by unjarring the same in the orion/lib directory..

# java -jar orion.jar
Error initializing server: DriverManagerDataSource driver
'org.gjt.mm.mysql.Driver' not found

What could the problem be ..????

Thanks,
-Ishpal




Dave Smith wrote:
> 
> You have updated the wrong fields.
> 
> You need something like
> 
>         <data-source
>                 name="Profile"
>                 class="com.evermind.sql.ConnectionDataSource"   {DO NOT
> CHANGE}
>                 location="jdbc/DefaultDS"
>                 pooled-location="jdbc/DefaultPooledDS"
>                 xa-location="jdbc/xa/DefaultXADS"
>                 ejb-location="jdbc/DefaultEJBDS"
>                 url="jdbc:mysql://localhost/test"
>                 connection-driver="org.gjt.mm.mysql.Driver"
>                 username="testusr"
>                 password="testpwd"
>         />
> 
> Dave Smith
> Senior Team Leader
> Aristocrat Technologies Australia Pty Ltd
> 
> mailto:[EMAIL PROTECTED]
> 
> -----Original Message-----
> From: Ishpal [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 27 July 2000 13:38
> To: Orion-Interest
> Subject: JDBC Connection problem
> 
> hello,
> 
> I'm new here and trying to setup orion server.
> The problem is with the data-souce.xml
> 
> My environment is as ...
> 
> O.S.-- Linux RedHat-6.2,
> JDK-- jdk1.2.2 from Sun
> DataBase-- MySQL.
> JDBC driver-- mm.mysql.jdbc-1.2c
> 
> In the config/data-sources.xml file My configurations are...
> 
>         <data-source
>                 name="Profile"
>                 class="org.gjt.mm.mysql.Driver"
>                 connection-driver="org.gjt.mm.mysql.Driver"
>                 location="../lib"
>                 url="jdbc:mysql://localhost/test"
>                 username="testusr"
>                 password="testpwd"
>         />
> 
> I have kept the JDBC-driver's jar file in ../lib directory.
> 
> Whenever I try to start the server with
> 
> java -jar orion.jar
> 
> I get an error as
> Error initializing server: Unknown DataSource type:
> org.gjt.mm.mysql.Driver
> 
> What is it that I'm doing wrong...??
> I dont want to use any other database right now.
> 
> Any help would be highly appreciated.
> 
> Thanks,
> Ishpal.