[vwnc] Creating Data Model with MYSQL as DataBase

Hello guys,
       This is my first mail in this forum/list. I read numerous reply s
given by other list members, some of which really helped me a lot. You
guys are quite helpful, which push me, to ask you this question. There
might be very obvious answer to this, but as a Beginner, I just don't
have any clue about this problem.
Hope You guys help me out.

       Here is the problem. I want to use DataModel (Object Lense) in a
DataBase dependant application. Problem is that, I want to use MySQL or
SqlServer 2005 as a database. I checked out Open repository provided by
Cincom, for Parcels / Bundles available for this purpose. I checked out
*JdmMysqlDriver* and *JdmMysqlDriverLens*, by loading them into my
image. But , whenever I tried to check connection in Tools -> DataBase
-> DataModeller, it gives me "invalid usernam or password" error. If I
tried , connecting database in Tools -> DataBase ->Ad Hoc SQL with same
password and Username, with MySqlConnection option from MYSQLEXDI
parcel, it works fine.
       Am I doing something wrong here or missing something? Are there
any other Parcels/ Bundles available for this purpose???

Regards
Kulkarni Simit S.

--
----------------------------------------------------------
Simit Kulkarni
Sutra Systems India Pvt Ltd
Tel:+91 20 24223463 Fax: +91 20 24223461
Web: www.sutrasys.com

Disclaimer :

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.



----------------------------------------------------------

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

In the Data Modeller Tool, you can set a username and passsword for your
connection specifically for this datamodel by choosing the menu Model >
Properties.
General options for connects can be set in the VisualWorks Settings in
the Launcher with System > Settings, there search for Tools/Database in
the tree.

HTH

Thomas


Simit Kulkarni schrieb:
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Hi Thomas,
      Thank You very much! I am very greateful for your prompt reply.  
But the problem still persists. I already tried the way you said. But no
gain.

What really surprises me is that, Using same UserName and Password and
Environment, I can connect to database through Tools -> DataBase -> Ad
Hoc SQL using MySql Connection from MYSQLEXDI parcel.

But if, you use, "JdmMySqlConnection" which comes with *JdmMysqlDriver*
and *JdmMysqlDriverLens* parcels, as I mentioned in earlies mail, no
connection is possible. Invalid user or password error is shown.

Thus, when I am using DataModeler tool( using same, above mentioned
parcels) , it again ( obviously) fails to connect to DataBase and same
error is shown.

Is there any known issues with *JdmMysqlDriver* and *JdmMysqlDriverLens*
parcels?

I would really appreciate, if you can throw light on this matter.

Thanks and waiting for Reply
    Kulkarni Simit S.

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

There is a supported MySQL driver in 7.6 as MySQLEXDI. However, I don't believe that ObjectLens is set up to be able to use it.

You may also be better off looking at Glorp rather than trying to use ObjectLens. While it does not have any tool support as yet, it has significantly better capabilities, and is much more maintained.

At 02:42 AM 11/27/2008, Simit Kulkarni wrote:

Hello guys,
       This is my first mail in this forum/list. I read numerous reply s
given by other list members, some of which really helped me a lot. You
guys are quite helpful, which push me, to ask you this question. There
might be very obvious answer to this, but as a Beginner, I just don't
have any clue about this problem.
Hope You guys help me out.

       Here is the problem. I want to use DataModel (Object Lense) in a
DataBase dependant application. Problem is that, I want to use MySQL or
SqlServer 2005 as a database. I checked out Open repository provided by
Cincom, for Parcels / Bundles available for this purpose. I checked out
*JdmMysqlDriver* and *JdmMysqlDriverLens*, by loading them into my
image. But , whenever I tried to check connection in Tools -> DataBase
-> DataModeller, it gives me "invalid usernam or password" error. If I
tried , connecting database in Tools -> DataBase ->Ad Hoc SQL with same
password and Username, with MySqlConnection option from MYSQLEXDI
parcel, it works fine.
       Am I doing something wrong here or missing something? Are there
any other Parcels/ Bundles available for this purpose???

Regards
Kulkarni Simit S.

--
----------------------------------------------------------
Simit Kulkarni
Sutra Systems India Pvt Ltd
Tel:+91 20 24223463 Fax: +91 20 24223461
Web: www.sutrasys.com

Disclaimer :

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.



----------------------------------------------------------

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Hi Alan,
    Thanks you so much for giving reply. Yes, what you saying is true!
    But , does it mean that, right now, in Visual Works 7.6, we can not
use MYSQL database for Data Model or Object Lens???
 Here,what I am trying to find out is, the Parcels or Bundles, which
works properly and help me using Data Model with MYSQL database. And
about Usage of
 GLORP, I can't use it. Since, the project, I will be working in, was
done , using Data Model. I am kind of preparing myself for that project.
    Is there any one, who did this? i.e. Data Model , with MYSQL
database. Please guys, help me out!!

Thanks and waiting for reply
    Kulkarni Simit S.
 
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Yes, I believe that's what it means. Unless someone else has done the work to make it work with MySQL, then it doesn't.

If you're just trying to get used to Lens, you could try using Postgresql instead of MySQL. There is a PostgreSQLLens package in the public repository. It's fairly old, but I doubt that very much has changed with it.

At 09:58 AM 11/27/2008, Simit Kulkarni wrote:

Hi Alan,
    Thanks you so much for giving reply. Yes, what you saying is true!
    But , does it mean that, right now, in Visual Works 7.6, we can not
use MYSQL database for Data Model or Object Lens???
 Here,what I am trying to find out is, the Parcels or Bundles, which
works properly and help me using Data Model with MYSQL database. And
about Usage of
 GLORP, I can't use it. Since, the project, I will be working in, was
done , using Data Model. I am kind of preparing myself for that project.
    Is there any one, who did this? i.e. Data Model , with MYSQL
database. Please guys, help me out!!

Thanks and waiting for reply
    Kulkarni Simit S.
 
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Yes, I believe that's what it means. Unless someone else has done the work to make it work with MySQL, then it doesn't.

If you're just trying to get used to Lens, you could try using Postgresql instead of MySQL. There is a PostgreSQLLens package in the public repository. It's fairly old, but I doubt that very much has changed with it.

At 09:58 AM 11/27/2008, Simit Kulkarni wrote:

Hi Alan,
    Thanks you so much for giving reply. Yes, what you saying is true!
    But , does it mean that, right now, in Visual Works 7.6, we can not
use MYSQL database for Data Model or Object Lens???
 Here,what I am trying to find out is, the Parcels or Bundles, which
works properly and help me using Data Model with MYSQL database. And
about Usage of
 GLORP, I can't use it. Since, the project, I will be working in, was
done , using Data Model. I am kind of preparing myself for that project.
    Is there any one, who did this? i.e. Data Model , with MYSQL
database. Please guys, help me out!!

Thanks and waiting for reply
    Kulkarni Simit S.
 
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Hi Alan,
       So sorry, for such a late response. I tried using PostgreSQLLens
package with PostGreSql 8.3 database on windows. Its somehow not working.
Anyways, Using parcels provided in Contributed -> Aragon for Sql Server,
I am able to start some development with Data Model.
       Thus, Thanks again for your replies. I also want to say thanks,
to all other List Members, for showing enthusiasm and giving me various
responses.

Thanks & Regards
Kulkarni Simit S.

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

From what I remember only the Oracle Lens has all the handy tools.

In any case I don't understand why you would use the Lens instead of Glorp which is way more advanced for everything but the most simple.

Rgrds,

@+Maarten,

> Message du 03/12/08 09:02

> De : "Simit Kulkarni"
> A : [hidden email]
> Copie à :
> Objet : [vwnc]  Creating Data Model with MYSQL as DataBase
>
>
> Hi Alan,
> So sorry, for such a late response. I tried using PostgreSQLLens
> package with PostGreSql 8.3 database on windows. Its somehow not working.
> Anyways, Using parcels provided in Contributed -> Aragon for Sql Server,
> I am able to start some development with Data Model.
> Thus, Thanks again for your replies. I also want to say thanks,
> to all other List Members, for showing enthusiasm and giving me various
> responses.
>
> Thanks & Regards
> Kulkarni Simit S.
>
> _______________________________________________
> vwnc mailing list
> [hidden email]
> http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
>
>

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc