Need Help with DBMS configuration

Author: syeed4@gmail.com (Syed)

Hi Guys, Im new to Uniface and come from a JAVA background. I have a trial version of Uniface 9.5 I have downloaded and installed the APS. I installed the Solid DB that came with Uniface. My aim is to understand how to connect a MySQL db and create a testing application to see how the components fit together and access data from DB. I'm getting very frustrated with the lack of detailed information in the documentation. Don't get me wrong there is lots and lots and lots and lots of docs, all documentation presumes you already have a good understanding of Uniface and does not give a beginners overview. So I have read the Library, I have read forums, I have gone through the Uniface University, I have watched numerous videos and I still can't find a example of connecting to a MySQL DB. I would really like to know where some decent blogs are so I can start decveloping with the helkp of the Uniface community. I hope someone can point me in the direction of what Im looking for.

5 Comments

  1. Syed, as a starting point, can you post your .asn file, and also the contents of the message frame online. That should give a starting point.


    Author: Adrian Gosbell (adrian.gosbell@synapse-i.jp)
  2. Hi Adrian thanks for the reply. I have at this moment reinstalled the whole APS. So I'm now with a vanilla flavour of Uniface 9.5. My dbms.asn file has not changed what would help me is to understand what needs to go into this configuration file. [DRIVER SETTINGS] SEQ U1.0 "What is SEQ? Where Do I find the correct setting for my chosen DB (MySQL)?" SOL U3.5 "What is SOL do I leave this alone or do I have to change this when I change DB's Where is the explanation of all the acronyms and there purpose?" I'm guessing this is the Solid DB Driver, but I want to be sure of my understanding. "I would really like to see the document explaining the details about this important configuration file. So before I start changing settings I know what should be left alone and what needs to be changed." [PATHS] $DBMS SOL:nmpipe Uniface_95_Development_Solid_Database : | uniface | nine "Again please explain why nmpipe is stated before the host name" $DBMS_SYS SOL:nmpipe Uniface_95_Development_Solid_Database : | uniface | nine "Why do we define the DB path twice?" What if our DB is running remotely? Can you please point me to the Docs that cleary explain how to configure remote DB's with Uniface (Not just the default Solid DB) I would really like to know what these mean: $UUU $DEF $IDF $WFM Why does the default asn file not come with inline comments for newbies like myself. Or at least a link to the online Doc that explains all the acronyms and there purpose. Anyways guys I'm stuck here until I figure out how to connect to a MySQL DB. I going to have play with Solid even though this is not what I want to do and therefore is really just wasting my development time. in regards to the error message that I was receiving I tried adding another driver setting but as I have said I could find a clear example so I was just hacking away at Uniface not developing. Regards Syed


    Author: Syed (syeed4@gmail.com)
  3. HI Syed, The [DRIVER_SETTINGS] part of the ASN details the version of the drive to use for the various databases. (So you are using sequential file driver 1.0 and solid driver 3.5). Checking the dll files in common\bin in your uniface install indicates there are two umql20.dll and umql21.dll. This means the dirvers available are MQL U2.0 and MQL U2.1, I am not sure which to choose, as we are using sql server on Uniface 9.3. Try looking for database drivers in the help file (ulibrary.chm in uniface\doc from your install folder). From the help file, here are the details of the paths available after installation. Repository Paths $DEF Path to the DBMS chosen as the default at installation. Not used by Uniface Flow. $IDF Path to the DBMS containing the application model DICT of the Application Objects Repository and the organization and process models of Uniface Flow. $SYS Path to the DBMS containing the application models PRINTER and SYSENV of the Application Objects Repository $UUU Path to the DBMS containing the application model TEXT of the Application Objects Repository Runtime Paths $SRU Path to the remote server used for executing Uniface service and report components $WFM Path to Uniface Flow workflow instance and session data $RES Path to the deployed runtime objects. Development Paths $RSO Path to runtime objects under development. This can be to resource files located on the file system (as specified in the $RESOURCES_OUTPUT assignment setting), or to various files and repository tables (component files, DOL and URR files, UOBJ and ULANA repository tables). I don;t know why the default defines the database twice. You could in theory set up $DBMS MQL:host:database|username|password $DBMS_SYS $DBMS which would use path redirection to create only one connection to the database. The way it's set up there are two connections with two different commit paths, which may be of import to whatever is defaulted. All rather confusing I know, and no, I've never found any documentation for setup telling you how to get up and running straight out of th ebox...


    Author: Iain Sharp (i.sharp@pcisystems.co.uk)
  4. HI Syed, On your question "I would really like to know what these mean: $UUU $DEF $IDF $WFM" : Just have a look in the uniface helpfile ulibrary.chm. If you use the SEARCH tab and enter MYSQL, you will find "Database Access on MySQL " you will get information how to set up an ASN Path Select the Index tab and enter $IDF and you will get your answer on a single page Repository Paths $DEF Path to the DBMS chosen as the default at installation. Not used by Uniface Flow. $IDF Path to the DBMS containing the application model DICT of the Application Objects Repository and the organization and process models of Uniface Flow. @Adrian, it's very nice to see even the "upper class people" like you take a more active role communicating with the crowd; max. stars of excellence plus an additional one for this. $SYS Path to the DBMS containing the application models PRINTER and SYSENV of the Application Objects Repository $UUU Path to the DBMS containing the application model TEXT of the Application Objects Repository Runtime Paths $SRU Path to the remote server used for executing Uniface service and report components $WFM Path to Uniface Flow workflow instance and session data $RES Path to the deployed runtime objects. Development Paths $RSO Path to runtime objects under development. This can be to resource files located on the file system (as specified in the $RESOURCES_OUTPUT assignment setting), or to various files and repository tables (component files, DOL and URR files, UOBJ and ULANA repository tables).


    Author: ulrich-merkel (ulrichmerkel@web.de)
  5. Hi Guys just thanking you for the reply. I will get back to you when I hot the next road block. Many Regards Syed


    Author: Syed (syeed4@gmail.com)