Re: [U2] Uniobjects - What Is It?
Kevin, when it takes about a couple of seconds just to spool up the connector and make that first connection I haven't noticed that with the Undiata as much as I have with remote mySql connections. I typically load the HTML and then make many, short connections. The initial connection might be appear to be part of the page loading. The performance is good on the web applications that use UOJ. The UOJ libraries are on the same server as the PHP code. I prefer using the JavaBridge in Zend Server because of the management interface and PHP optimization. The SourceForge project works well also. Now that's been my experience. Keep in mind that I am working in an intranet. Our servers don't have to handle more than 100 people. I don't know how it would perform under heavier loads. As to the PDO connector, I looked into the PDO, but it was a while back. It didn't seem to be ready. Charles Shaffer Senior Analyst NTN-Bower Corporation Kevin King precisonl...@gmail.com Sent by: u2-users-boun...@listserver.u2ug.org 05/21/2011 05:50 PM Please respond to U2 Users List To: U2 Users List u2-users@listserver.u2ug.org cc: Subject:Re: [U2] Uniobjects - What Is It? Charles, how is the performance using the Java bridge? That's my #1 concern about UO right now (and UOJ by association) - when it takes about a couple of seconds just to spool up the connector and make that first connection, it's something to be questioned. After the connection is established it's remarkably fast, but the speed of making that connection is not as fast as I personally would prefer. As to the PDO connector, I did actually look into it. Even with source code I couldn't find the magic combination of things to make it work across platforms. That was a few years ago, and my available time these days is significantly less, as I'm just too busy dreaming up hodge podge schemes! :-) -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
For heavier loads it becomes unworkable - you have to use connection pooling and take the cost that that brings. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 23 May 2011 14:17 To: U2 Users List Cc: U2 Users List; u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Uniobjects - What Is It? Kevin, when it takes about a couple of seconds just to spool up the connector and make that first connection I haven't noticed that with the Undiata as much as I have with remote mySql connections. I typically load the HTML and then make many, short connections. The initial connection might be appear to be part of the page loading. The performance is good on the web applications that use UOJ. The UOJ libraries are on the same server as the PHP code. I prefer using the JavaBridge in Zend Server because of the management interface and PHP optimization. The SourceForge project works well also. Now that's been my experience. Keep in mind that I am working in an intranet. Our servers don't have to handle more than 100 people. I don't know how it would perform under heavier loads. As to the PDO connector, I looked into the PDO, but it was a while back. It didn't seem to be ready. Charles Shaffer Senior Analyst NTN-Bower Corporation Kevin King precisonl...@gmail.com Sent by: u2-users-boun...@listserver.u2ug.org 05/21/2011 05:50 PM Please respond to U2 Users List To: U2 Users List u2-users@listserver.u2ug.org cc: Subject:Re: [U2] Uniobjects - What Is It? Charles, how is the performance using the Java bridge? That's my #1 concern about UO right now (and UOJ by association) - when it takes about a couple of seconds just to spool up the connector and make that first connection, it's something to be questioned. After the connection is established it's remarkably fast, but the speed of making that connection is not as fast as I personally would prefer. As to the PDO connector, I did actually look into it. Even with source code I couldn't find the magic combination of things to make it work across platforms. That was a few years ago, and my available time these days is significantly less, as I'm just too busy dreaming up hodge podge schemes! :-) -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1375 / Virus Database: 1509/3654 - Release Date: 05/22/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
Kevin, At the time I set this up here, there was no PDO for U2 in PHP, so I looked into the UOJ libraries. Using them requires a bridge. There is a SourceForge project that works well. I am currently using Zend Server CE. No cost and it does the job, in fact it optimizes the PHP code. I build a Java class for each project and include it in a java archive that I put in the same directory as the UOJ includes. The java object uses Uniobjects for Java to access Unidata. Although, Uniobjects has a rich command set, I have come to the conclusion that the Java layer should be minimized as much as possible. I just use the java to run UniBasic subroutines. It passes in the parameters and returns the result. This is partly to reduce traffic, but mostly because I want to push the database logic to the database. It would be better if there was a PDO for U2, but this approach works. Here is a example. In the javascript function make a request object call to PHP on the webserver var XHR = GetXHR(); var urlstr = getNextId.php; urlstr += ?sid= + Math.random(); XHR.onreadystatechange = function() { if(XHR.readyState === 4) { // Process the results in XHR.responseText } }; XHR.open(GET,urlstr,true); XHR.send(null); return; * In PHP create an object from the java archive for the project and call the java function. Must be cataloged. $cnU2 = new Java('com.ntnbower.webutil.u2ProjectName'); $cnU2-setAccount(PRODUCTION); echo $cnU2-getNextId(); // This is returned to javascript as reponseText return; * In java public String getNextId() { OpenU2Session(); UniSubroutine uSub = uSession.subroutine(getNextId, 1); uSub.call(); return uSub.getArg(0); } ** In UniBasic. Get the requested data and return it in RESULT SUBROUTINE getNextId(RESULT) OPEN 'FILENAME' TO F.NSH THEN READU R.NSH FROM F.NSH, 'NEXT_ID' THEN RESULT = R.NSH1 R.NSH1 += 1 WRITE R.NSH TO F.NSH, 'NEXT_ID' END CLOSE F.NSH END ELSE RESULT = -1 END END RETURN Charles Shaffer Senior Analyst NTN-Bower Corporation Kevin King precisonl...@gmail.com Sent by: u2-users-boun...@listserver.u2ug.org 05/19/2011 11:26 PM Please respond to U2 Users List To: U2 Users List u2-users@listserver.u2ug.org cc: Subject:Re: [U2] Uniobjects - What Is It? I'm interested to know more about how folks are using UOJ with PHP. I've tried making that connection numerous times but .. just haven't been successful yet. Big fan of PHP but using the UO connection on Windows is ... less than optimal for my needs. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
[ad] We built a middle-ware connection using open source JavaPHP bridge after seeing Kevin do this hodge podge connection scheme using a COM UniObject at a CMUG meeting in Denver in 2009. Our middle-ware software is called U2WebLink and it manages the connections with Unidata or Universe using Apache Tomcat. U2WebLink comes with logging and monitor software to figure out what you web site is doing using graphs and user displayed grids. You need this line of code to start: ?php require_once(java/Java.inc); Then you need to connect to Tomcat server: $javasession = java_session(); $request = java_context()-getHttpServletRequest(); $requestedsessionid = $request-getRequestedSessionId(); $requestsession = $request-getSession(); $requestsessionid = java_values($requestsession-getId()); ? Register your session with U2WebLink™ using our java function XLr8SharedSub: ?php $sharedsub = java_values($requestsession-getAttribute(XLr8SharedSub)); ? To call any of your previously developed UniBasic subroutines: $args = $sharedsub-getArrayListForSubroutineArgs(); $args-add(param1); $args-add(param2); $args-add(param3); $results = $sharedsub-subroutine($request, 0, MySubroutine, $args); $retargs = print_r(java_values($args), true); Regards, Doug www.u2logic.com/php.html [/ad] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [AD] - U2] Uniobjects - What Is It?
In a message dated 5/20/2011 7:04:01 AM Pacific Daylight Time, dave...@gmail.com writes: [ad] We built a middle-ware connection using open source JavaPHP bridge after seeing Kevin do this hodge podge connection scheme using a COM UniObject at a CMUG meeting in Denver in 2009. Our middle-ware software is called U2WebLink and it manages the connections with Unidata or Universe using Apache Tomcat. U2WebLink comes with logging and monitor software to figure out what you web site is doing using graphs and user displayed grids. You'd might as well tell us how much. So how much? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
In a message dated 5/19/2011 9:43:16 PM Pacific Daylight Time, dmc...@imb.com.au writes: Have you seen the PHP PDO driver article on u2devzone.com? Although it is a 'build it yourself article', it does come with the source code so you should be able to just compile and use it. Head + Wall + Beating ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [AD] - U2] Uniobjects - What Is It?
U2WebLink includes our JavaScript and UniBasic API software for Universe or Unidata with the PHP connection at the price $750.00 per connection per year. UniObjects for Java is the mechanism for communicating with the databases. One connection can handle between 5 and 20 users depending on the application.. At $150.00 to $37.50 per user this is very economical and robust software. Regards, Doug www.u2logic.com First with Eclipsed based tools for U2 On Fri, May 20, 2011 at 9:29 AM, fft2...@aol.com wrote: In a message dated 5/20/2011 7:04:01 AM Pacific Daylight Time, dave...@gmail.com writes: [ad] We built a middle-ware connection using open source JavaPHP bridge after seeing Kevin do this hodge podge connection scheme using a COM UniObject at a CMUG meeting in Denver in 2009. Our middle-ware software is called U2WebLink and it manages the connections with Unidata or Universe using Apache Tomcat. U2WebLink comes with logging and monitor software to figure out what you web site is doing using graphs and user displayed grids. You'd might as well tell us how much. So how much? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Uniobjects - What Is It?
I have been in the PICK world for decades and have worked with several interfaces. Green screen, SB, BlackSmith and Redback/web are my biggest areas of expertise. I have simply never worked with anything else because these are the tools at the places I have worked. I am embarrassed to ask, but need to do so. What are UniObjects? Other than what I mentioned above, what other technologies are out there are rock solid? Where can I go to get an get your feet wet intro? If our business is doing fine without them, why would I want to use them? What can I do with them? We are a SB Redback/web shop. What benefit would there be to my company to have me learn these other technologies? I am not saying that we don't want any of these technologies, but if we don't even know what it is or are aware of what it can do, we will never look to it for a solution. I understand that this is a VERY broad question, but if I don't start asking, I will never learn. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
Uniobjects is a C module that has been wrapped and packaged for java, vb, and .NET. PickWiki has several examples, as well as the rocket software docs. If you upgrade to the new WebDE you will be using uniobjects for communication (really deep down.) On Thu, May 19, 2011 at 8:37 AM, Israel, John R. johnisr...@daytonsuperior.com wrote: I have been in the PICK world for decades and have worked with several interfaces. Green screen, SB, BlackSmith and Redback/web are my biggest areas of expertise. I have simply never worked with anything else because these are the tools at the places I have worked. I am embarrassed to ask, but need to do so. What are UniObjects? Other than what I mentioned above, what other technologies are out there are rock solid? Where can I go to get an get your feet wet intro? If our business is doing fine without them, why would I want to use them? What can I do with them? We are a SB Redback/web shop. What benefit would there be to my company to have me learn these other technologies? I am not saying that we don't want any of these technologies, but if we don't even know what it is or are aware of what it can do, we will never look to it for a solution. I understand that this is a VERY broad question, but if I don't start asking, I will never learn. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
My understanding is somewhat limited, and like yourself, I have only ever learned what I had the time to do, or what was required at my job. Recently though, I have been putting effort into branching out. That being said... My understanding of UniObjects is that it is a connector into Universe or Unidata. You have to have a windows machine as the go between. So for example, if you wanted to use some .NET language or C#, or PHP, or whatever to connect your Universe or Unidata database to a web form, etc., you could use UniObjects running on a Windows Server running IIS or Apache (a web server) that sits alongside your U2 database server. It doesn't have to be web apps I don't think... For example, some of the software offered as part of the Client CD you get from Rocket uses it to edit dictionaries, programs, etc. As far as other technologies that are out there... I am still pretty much a noobie myself, but, there are a ton out there that you can use to talk to Universe or Unidata. I know more about the Linux/AIX side of things than I do Windows, but, in most cases if you get to the point where you can make a programming language (PHP/Perl/Python, etc. etc.) launch a Universe or Unidata session, read in some data, and write some data back out, then you are a great deal of the way there (and of course security is always part of the design, in whatever you build). I currently have been having a lot of fun with the following scenario: Using Ubuntu Linux as a web server running Apache/PHP Sending http requests to the AIX server running Universe/Apache/PHP which then launches a Universe session to pick up the data and write it back out which then sends the result back to the Ubuntu web server. (JSON is used as the standard data interchange format) (JQuery is used to make the web forms pretty and work with data - not required really) (PHP is used to send the requests and also work with the data) Of course, like anything... in a production environment (which this is not currently in), you have to lock down your U2 machine to only receive requests from that Web Server, etc. I got the idea (and help) from another gentleman named Kevin King. I have been having a lot of fun with it. Like anything though, everybody has their tools that they like. The beauty of this in my opinion is that you can try it out for free, and if you don't like it, the only thing you have possibly wasted is some time. On Thu, May 19, 2011 at 8:42 AM, Steve Romanow slestak...@gmail.com wrote: Uniobjects is a C module that has been wrapped and packaged for java, vb, and .NET. PickWiki has several examples, as well as the rocket software docs. If you upgrade to the new WebDE you will be using uniobjects for communication (really deep down.) On Thu, May 19, 2011 at 8:37 AM, Israel, John R. johnisr...@daytonsuperior.com wrote: I have been in the PICK world for decades and have worked with several interfaces. Green screen, SB, BlackSmith and Redback/web are my biggest areas of expertise. I have simply never worked with anything else because these are the tools at the places I have worked. I am embarrassed to ask, but need to do so. What are UniObjects? Other than what I mentioned above, what other technologies are out there are rock solid? Where can I go to get an get your feet wet intro? If our business is doing fine without them, why would I want to use them? What can I do with them? We are a SB Redback/web shop. What benefit would there be to my company to have me learn these other technologies? I am not saying that we don't want any of these technologies, but if we don't even know what it is or are aware of what it can do, we will never look to it for a solution. I understand that this is a VERY broad question, but if I don't start asking, I will never learn. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
On 05/19/11 09:26, John Thompson wrote: My understanding of UniObjects is that it is a connector into Universe or Unidata. Yes, but: You have to have a windows machine as the go between. Not true - you can do this with *nix. So for example, if you wanted to use some .NET language or C#, or PHP, or whatever to connect your Universe or Unidata database to a web form, etc., you could use UniObjects running on a Windows Server running IIS or Apache (a web server) that sits alongside your U2 database server. It doesn't have to be web apps I don't think... For example, some of the software offered as part of the Client CD you get from Rocket uses it to edit dictionaries, programs, etc. As far as other technologies that are out there... I am still pretty much a noobie myself, but, there are a ton out there that you can use to talk to Universe or Unidata. I know more about the Linux/AIX side of things than I do Windows, but, in most cases if you get to the point where you can make a programming language (PHP/Perl/Python, etc. etc.) launch a Universe or Unidata session, read in some data, and write some data back out, then you are a great deal of the way there (and of course security is always part of the design, in whatever you build). I currently have been having a lot of fun with the following scenario: Using Ubuntu Linux as a web server running Apache/PHP Sending http requests to the AIX server running Universe/Apache/PHP which then launches a Universe session to pick up the data and write it back out which then sends the result back to the Ubuntu web server. (JSON is used as the standard data interchange format) (JQuery is used to make the web forms pretty and work with data - not required really) (PHP is used to send the requests and also work with the data) Of course, like anything... in a production environment (which this is not currently in), you have to lock down your U2 machine to only receive requests from that Web Server, etc. I got the idea (and help) from another gentleman named Kevin King. I have been having a lot of fun with it. Like anything though, everybody has their tools that they like. The beauty of this in my opinion is that you can try it out for free, and if you don't like it, the only thing you have possibly wasted is some time. On Thu, May 19, 2011 at 8:42 AM, Steve Romanowslestak...@gmail.com wrote: Uniobjects is a C module that has been wrapped and packaged for java, vb, and .NET. PickWiki has several examples, as well as the rocket software docs. If you upgrade to the new WebDE you will be using uniobjects for communication (really deep down.) On Thu, May 19, 2011 at 8:37 AM, Israel, John R. johnisr...@daytonsuperior.com wrote: I have been in the PICK world for decades and have worked with several interfaces. Green screen, SB, BlackSmith and Redback/web are my biggest areas of expertise. I have simply never worked with anything else because these are the tools at the places I have worked. I am embarrassed to ask, but need to do so. What are UniObjects? Other than what I mentioned above, what other technologies are out there are rock solid? Where can I go to get an get your feet wet intro? If our business is doing fine without them, why would I want to use them? What can I do with them? We are a SB Redback/web shop. What benefit would there be to my company to have me learn these other technologies? I am not saying that we don't want any of these technologies, but if we don't even know what it is or are aware of what it can do, we will never look to it for a solution. I understand that this is a VERY broad question, but if I don't start asking, I will never learn. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
That is new news to me... Thanks for the info. On Thu, May 19, 2011 at 9:38 AM, Jeffrey Butera jbut...@hampshire.eduwrote: On 05/19/11 09:26, John Thompson wrote: My understanding of UniObjects is that it is a connector into Universe or Unidata. Yes, but: You have to have a windows machine as the go between. Not true - you can do this with *nix. So for example, if you wanted to use some .NET language or C#, or PHP, or whatever to connect your Universe or Unidata database to a web form, etc., you could use UniObjects running on a Windows Server running IIS or Apache (a web server) that sits alongside your U2 database server. It doesn't have to be web apps I don't think... For example, some of the software offered as part of the Client CD you get from Rocket uses it to edit dictionaries, programs, etc. As far as other technologies that are out there... I am still pretty much a noobie myself, but, there are a ton out there that you can use to talk to Universe or Unidata. I know more about the Linux/AIX side of things than I do Windows, but, in most cases if you get to the point where you can make a programming language (PHP/Perl/Python, etc. etc.) launch a Universe or Unidata session, read in some data, and write some data back out, then you are a great deal of the way there (and of course security is always part of the design, in whatever you build). I currently have been having a lot of fun with the following scenario: Using Ubuntu Linux as a web server running Apache/PHP Sending http requests to the AIX server running Universe/Apache/PHP which then launches a Universe session to pick up the data and write it back out which then sends the result back to the Ubuntu web server. (JSON is used as the standard data interchange format) (JQuery is used to make the web forms pretty and work with data - not required really) (PHP is used to send the requests and also work with the data) Of course, like anything... in a production environment (which this is not currently in), you have to lock down your U2 machine to only receive requests from that Web Server, etc. I got the idea (and help) from another gentleman named Kevin King. I have been having a lot of fun with it. Like anything though, everybody has their tools that they like. The beauty of this in my opinion is that you can try it out for free, and if you don't like it, the only thing you have possibly wasted is some time. On Thu, May 19, 2011 at 8:42 AM, Steve Romanowslestak...@gmail.com wrote: Uniobjects is a C module that has been wrapped and packaged for java, vb, and .NET. PickWiki has several examples, as well as the rocket software docs. If you upgrade to the new WebDE you will be using uniobjects for communication (really deep down.) On Thu, May 19, 2011 at 8:37 AM, Israel, John R. johnisr...@daytonsuperior.com wrote: I have been in the PICK world for decades and have worked with several interfaces. Green screen, SB, BlackSmith and Redback/web are my biggest areas of expertise. I have simply never worked with anything else because these are the tools at the places I have worked. I am embarrassed to ask, but need to do so. What are UniObjects? Other than what I mentioned above, what other technologies are out there are rock solid? Where can I go to get an get your feet wet intro? If our business is doing fine without them, why would I want to use them? What can I do with them? We are a SB Redback/web shop. What benefit would there be to my company to have me learn these other technologies? I am not saying that we don't want any of these technologies, but if we don't even know what it is or are aware of what it can do, we will never look to it for a solution. I understand that this is a VERY broad question, but if I don't start asking, I will never learn. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
What are UniObjects? Uniobjects are libraries. Theses can be included in a variety of applications and provide access to U2 databases. On Linux there is Uniobjects for Java. There is a version for .NET. And there is an older COM version that can be used for applications that don't support .NET. I mainly use the Uniobjects for Java to access data from our Unidata system from PHP. I use some .NET in VB applications. The COM version is used in some Domino agents.. HTH Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
Thanks for correcting that too. I'm still new and learning... On Thu, May 19, 2011 at 9:38 AM, Jeffrey Butera jbut...@hampshire.eduwrote: On 05/19/11 09:26, John Thompson wrote: My understanding of UniObjects is that it is a connector into Universe or Unidata. Yes, but: You have to have a windows machine as the go between. Not true - you can do this with *nix. So for example, if you wanted to use some .NET language or C#, or PHP, or whatever to connect your Universe or Unidata database to a web form, etc., you could use UniObjects running on a Windows Server running IIS or Apache (a web server) that sits alongside your U2 database server. It doesn't have to be web apps I don't think... For example, some of the software offered as part of the Client CD you get from Rocket uses it to edit dictionaries, programs, etc. As far as other technologies that are out there... I am still pretty much a noobie myself, but, there are a ton out there that you can use to talk to Universe or Unidata. I know more about the Linux/AIX side of things than I do Windows, but, in most cases if you get to the point where you can make a programming language (PHP/Perl/Python, etc. etc.) launch a Universe or Unidata session, read in some data, and write some data back out, then you are a great deal of the way there (and of course security is always part of the design, in whatever you build). I currently have been having a lot of fun with the following scenario: Using Ubuntu Linux as a web server running Apache/PHP Sending http requests to the AIX server running Universe/Apache/PHP which then launches a Universe session to pick up the data and write it back out which then sends the result back to the Ubuntu web server. (JSON is used as the standard data interchange format) (JQuery is used to make the web forms pretty and work with data - not required really) (PHP is used to send the requests and also work with the data) Of course, like anything... in a production environment (which this is not currently in), you have to lock down your U2 machine to only receive requests from that Web Server, etc. I got the idea (and help) from another gentleman named Kevin King. I have been having a lot of fun with it. Like anything though, everybody has their tools that they like. The beauty of this in my opinion is that you can try it out for free, and if you don't like it, the only thing you have possibly wasted is some time. On Thu, May 19, 2011 at 8:42 AM, Steve Romanowslestak...@gmail.com wrote: Uniobjects is a C module that has been wrapped and packaged for java, vb, and .NET. PickWiki has several examples, as well as the rocket software docs. If you upgrade to the new WebDE you will be using uniobjects for communication (really deep down.) On Thu, May 19, 2011 at 8:37 AM, Israel, John R. johnisr...@daytonsuperior.com wrote: I have been in the PICK world for decades and have worked with several interfaces. Green screen, SB, BlackSmith and Redback/web are my biggest areas of expertise. I have simply never worked with anything else because these are the tools at the places I have worked. I am embarrassed to ask, but need to do so. What are UniObjects? Other than what I mentioned above, what other technologies are out there are rock solid? Where can I go to get an get your feet wet intro? If our business is doing fine without them, why would I want to use them? What can I do with them? We are a SB Redback/web shop. What benefit would there be to my company to have me learn these other technologies? I am not saying that we don't want any of these technologies, but if we don't even know what it is or are aware of what it can do, we will never look to it for a solution. I understand that this is a VERY broad question, but if I don't start asking, I will never learn. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
Are you saying that UniObjects are used instead of Redback or is it used in addition to Redback? Without giving away company secrets, can you briefly describe some real world examples of what kind of applications were written with UniObjects? Loosely speaking, what practical uses are there that I am not grasping? If I am content with doing things from TCL, why do I need this? Is this more for end-user applications (i.e. not programmers)? What sort of things can I take to management that I could do with UniObjects that will make them go WOW! John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, May 19, 2011 9:52 AM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? What are UniObjects? Uniobjects are libraries. Theses can be included in a variety of applications and provide access to U2 databases. On Linux there is Uniobjects for Java. There is a version for .NET. And there is an older COM version that can be used for applications that don't support .NET. I mainly use the Uniobjects for Java to access data from our Unidata system from PHP. I use some .NET in VB applications. The COM version is used in some Domino agents.. HTH Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
On Thu, May 19, 2011 at 9:26 AM, John Thompson jthompson...@gmail.com wrote: You have to have a windows machine as the go between. Not completely true. I have used UOJ with jython on linux to talk to U2 on AIX. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
Yes thank you Steve for correcting that. Jeff had corrected that earlier. Being new to some of this, I should have probably just kept my mouth shut so I didn't give bad information :) On Thu, May 19, 2011 at 10:20 AM, Steve Romanow slestak...@gmail.comwrote: On Thu, May 19, 2011 at 9:26 AM, John Thompson jthompson...@gmail.com wrote: You have to have a windows machine as the go between. Not completely true. I have used UOJ with jython on linux to talk to U2 on AIX. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
On Thu, May 19, 2011 at 10:27 AM, John Thompson jthompson...@gmail.com wrote: Yes thank you Steve for correcting that. Jeff had corrected that earlier. Being new to some of this, I should have probably just kept my mouth shut so I didn't give bad information :) No please contribute. I was just chiming in. :) Dont be afraid to post. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
I imagine most people simply use it to run subroutines in external applications, but you can achieve a lot (perhaps most or all?) of the things you can do at the prompt and UniBasic program with uniobjects natively in .net, java or any other language that you can use UO with. You can also deploy it with the application and open a session directly which is the one thing Redback can't do. We actually use both since some of our third party software is built on redback and our internal software runs through a WCF webservice that manages a connection pool of uniobjects sessions in a windows service. I haven't ever done anything with RBOs and redpages but I haven't ever seen the need when I can do everything much more easily right in my .net applications (obviously backed by UniBasic Subs on the server). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, May 19, 2011 9:05 AM To: 'U2 Users List' Subject: Re: [U2] Uniobjects - What Is It? Are you saying that UniObjects are used instead of Redback or is it used in addition to Redback? Without giving away company secrets, can you briefly describe some real world examples of what kind of applications were written with UniObjects? Loosely speaking, what practical uses are there that I am not grasping? If I am content with doing things from TCL, why do I need this? Is this more for end-user applications (i.e. not programmers)? What sort of things can I take to management that I could do with UniObjects that will make them go WOW! John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, May 19, 2011 9:52 AM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? What are UniObjects? Uniobjects are libraries. Theses can be included in a variety of applications and provide access to U2 databases. On Linux there is Uniobjects for Java. There is a version for .NET. And there is an older COM version that can be used for applications that don't support .NET. I mainly use the Uniobjects for Java to access data from our Unidata system from PHP. I use some .NET in VB applications. The COM version is used in some Domino agents.. HTH Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
Are there any Avanté users out there that have things written with UniObjects that would be willing to share an example of something they have done? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Thursday, May 19, 2011 10:52 AM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? I imagine most people simply use it to run subroutines in external applications, but you can achieve a lot (perhaps most or all?) of the things you can do at the prompt and UniBasic program with uniobjects natively in .net, java or any other language that you can use UO with. You can also deploy it with the application and open a session directly which is the one thing Redback can't do. We actually use both since some of our third party software is built on redback and our internal software runs through a WCF webservice that manages a connection pool of uniobjects sessions in a windows service. I haven't ever done anything with RBOs and redpages but I haven't ever seen the need when I can do everything much more easily right in my .net applications (obviously backed by UniBasic Subs on the server). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, May 19, 2011 9:05 AM To: 'U2 Users List' Subject: Re: [U2] Uniobjects - What Is It? Are you saying that UniObjects are used instead of Redback or is it used in addition to Redback? Without giving away company secrets, can you briefly describe some real world examples of what kind of applications were written with UniObjects? Loosely speaking, what practical uses are there that I am not grasping? If I am content with doing things from TCL, why do I need this? Is this more for end-user applications (i.e. not programmers)? What sort of things can I take to management that I could do with UniObjects that will make them go WOW! John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, May 19, 2011 9:52 AM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? What are UniObjects? Uniobjects are libraries. Theses can be included in a variety of applications and provide access to U2 databases. On Linux there is Uniobjects for Java. There is a version for .NET. And there is an older COM version that can be used for applications that don't support .NET. I mainly use the Uniobjects for Java to access data from our Unidata system from PHP. I use some .NET in VB applications. The COM version is used in some Domino agents.. HTH Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
Hi John, We have our shipping software setup to execute a sql stored procedure which calls an Avante subroutine with UniObjects. I'll send it to you offline in a bit. Amy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, May 19, 2011 9:10 AM To: 'U2 Users List' Subject: Re: [U2] Uniobjects - What Is It? Are there any Avanté users out there that have things written with UniObjects that would be willing to share an example of something they have done? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Thursday, May 19, 2011 10:52 AM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? I imagine most people simply use it to run subroutines in external applications, but you can achieve a lot (perhaps most or all?) of the things you can do at the prompt and UniBasic program with uniobjects natively in .net, java or any other language that you can use UO with. You can also deploy it with the application and open a session directly which is the one thing Redback can't do. We actually use both since some of our third party software is built on redback and our internal software runs through a WCF webservice that manages a connection pool of uniobjects sessions in a windows service. I haven't ever done anything with RBOs and redpages but I haven't ever seen the need when I can do everything much more easily right in my .net applications (obviously backed by UniBasic Subs on the server). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, May 19, 2011 9:05 AM To: 'U2 Users List' Subject: Re: [U2] Uniobjects - What Is It? Are you saying that UniObjects are used instead of Redback or is it used in addition to Redback? Without giving away company secrets, can you briefly describe some real world examples of what kind of applications were written with UniObjects? Loosely speaking, what practical uses are there that I am not grasping? If I am content with doing things from TCL, why do I need this? Is this more for end-user applications (i.e. not programmers)? What sort of things can I take to management that I could do with UniObjects that will make them go WOW! John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, May 19, 2011 9:52 AM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? What are UniObjects? Uniobjects are libraries. Theses can be included in a variety of applications and provide access to U2 databases. On Linux there is Uniobjects for Java. There is a version for .NET. And there is an older COM version that can be used for applications that don't support .NET. I mainly use the Uniobjects for Java to access data from our Unidata system from PHP. I use some .NET in VB applications. The COM version is used in some Domino agents.. HTH Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
I don't know much about RedBack. It may provide more developed tools than Uniobjects does. UO gives you libraries that you can use in your applicaitons. can you briefly describe some real world examples of what kind of applications were written with UniObjects? I use UniObjects to access data from Unidata where our main systems are. Examples; A Visual Basic application for scanning in Invoices and Checks for image archiving. I use the UO libraries in the VB application to retrieve as much informatino as possible about the document from Unidata where our financials are. The image and the information are stored in a Domino database and later, after the invoices are paid, the rest of the information is gathered using the COM version of the Uniobjects libraries in a LotusScript script. Mostly though. I use Uniobjects for Java on Linux web servers to provide PHP access to data on our Unidata system. We use web interfaces for spending analysis, work orders, crib inventory, production order analysis, and shipping, When I first started working with PICK in the 80s, we had to use a pair of programs to manually move data between the PICK ennvironment and the native file system. Now I can validate a field in a web browser against our Unidata database, in real time. This integrates the Unidata based information with information from other database systems. Very useful. Uniobjects comes on the client disk so there is nothing to buy. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
Cool. I look forward to looking at it. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Amy Cook Sent: Thursday, May 19, 2011 2:11 PM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? Hi John, We have our shipping software setup to execute a sql stored procedure which calls an Avante subroutine with UniObjects. I'll send it to you offline in a bit. Amy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, May 19, 2011 9:10 AM To: 'U2 Users List' Subject: Re: [U2] Uniobjects - What Is It? Are there any Avanté users out there that have things written with UniObjects that would be willing to share an example of something they have done? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Thursday, May 19, 2011 10:52 AM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? I imagine most people simply use it to run subroutines in external applications, but you can achieve a lot (perhaps most or all?) of the things you can do at the prompt and UniBasic program with uniobjects natively in .net, java or any other language that you can use UO with. You can also deploy it with the application and open a session directly which is the one thing Redback can't do. We actually use both since some of our third party software is built on redback and our internal software runs through a WCF webservice that manages a connection pool of uniobjects sessions in a windows service. I haven't ever done anything with RBOs and redpages but I haven't ever seen the need when I can do everything much more easily right in my .net applications (obviously backed by UniBasic Subs on the server). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, May 19, 2011 9:05 AM To: 'U2 Users List' Subject: Re: [U2] Uniobjects - What Is It? Are you saying that UniObjects are used instead of Redback or is it used in addition to Redback? Without giving away company secrets, can you briefly describe some real world examples of what kind of applications were written with UniObjects? Loosely speaking, what practical uses are there that I am not grasping? If I am content with doing things from TCL, why do I need this? Is this more for end-user applications (i.e. not programmers)? What sort of things can I take to management that I could do with UniObjects that will make them go WOW! John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, May 19, 2011 9:52 AM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? What are UniObjects? Uniobjects are libraries. Theses can be included in a variety of applications and provide access to U2 databases. On Linux there is Uniobjects for Java. There is a version for .NET. And there is an older COM version that can be used for applications that don't support .NET. I mainly use the Uniobjects for Java to access data from our Unidata system from PHP. I use some .NET in VB applications. The COM version is used in some Domino agents.. HTH Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
I'm interested to know more about how folks are using UOJ with PHP. I've tried making that connection numerous times but .. just haven't been successful yet. Big fan of PHP but using the UO connection on Windows is ... less than optimal for my needs. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
Kevin, Have you seen the PHP PDO driver article on u2devzone.com? Although it is a 'build it yourself article', it does come with the source code so you should be able to just compile and use it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, 20 May 2011 2:26 PM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? I'm interested to know more about how folks are using UOJ with PHP. I've tried making that connection numerous times but .. just haven't been successful yet. Big fan of PHP but using the UO connection on Windows is ... less than optimal for my needs. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users