Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred
The arg count going in needs to be n+1. Arg 0 will be the return data. public ArrayList callSub(String sRoutine, ArrayList args) { Iterator it = args.iterator(); ArrayList oArgs = new ArrayList(); int iArgs = args.size(); System.out.println(Args: + iArgs); try { UniSubroutine uoSub = ses.subroutine(sRoutine, iArgs + 1); int iArg = 0; uoSub.setArg(iArg++, ); // dummy argument - this will become the return value // Set user arguments while (it.hasNext()) { Object arg=it.next(); //System.out.println(InputArg[+iArg+]=+arg); uoSub.setArg(iArg++, arg); } // call uoSub.call(); // get returned parameters iArgs = uoSub.getNumArgs(); for (int i = 0; i iArgs; i++) { String arg=uoSub.getArg(i); //System.out.println(OutputArg[+i+]=+arg); oArgs.add(arg); } } catch (Exception ex) { System.err.println(Call to + sRoutine + failed.); ex.printStackTrace(System.err); } return oArgs; } On 02/18/2011 01:16 PM, Stephen Jackson wrote: So we created a basic program to call so we are getting closer, thanks for all your input it is putting us on the correct path. I do seem to have some issues when trying to get the results. What is happening is it is just spitting out the input parameters .. //System.err.println(command.response()); UniSubroutine sub = session.subroutine(S.XTMS.TEST.BASIC, 1); sub.setArg(0, 0491865); sub.call(); sub.resetArgs(); System.err.println(sub.getNumArgs()); System.err.println(sub); System.err.println(sub.getArg(0)); //session.disconnect(); //String r = sub.getArg(0); //String r1 = sub.getArg(1); Logging statements: Version Number :4.1.3 Max Open Files :32 Account Path :/datatel/test/10day/development Locking Strategy :0 Release Strategy :12 Calling S.XTMS.TEST.LOOKUP... 1 asjava.uniobjects.UniSubroutine@6791d8c1 0491865 - same as input, not the result from the routine. On WednesdayF/16/11 5:45 PM, Hona, Daviddavid.h...@cba.com.au wrote: Does this subroutine do file I/O? Does it explicitly open the file or assume some other program or subroutine opens it and stores the file variable in labelled common...? Sometimes it can even be a call subroutine call that is called using a labelled common variable (CALL @MYSUB)... Easiest thing to do is look how the subroutine is used now...if you don't emulate the same initialisation sequence it requires from UV native runtime environment in Java runtime environment...it more than likely will not work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Stephen Jackson Sent: Thursday, 17 February 2011 1:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniSubroutineException: Unknown Error [30102] Occurred I am new to the U2 java api. I am trying to make a subroutine call but get the following Exception. It is not in the documentation and I have not had a lot of luck tracking it down. I am able to make a simple query so not sure if there is some configuration or something I am not aware of which is causing the error. Version Number :4.1.3 Max Open Files :32 Account Path :/mypath Locking Strategy :0 Release Strategy :12 Calling S.XTMS.TEST.LOOKUP... [IBM U2][UniObjects for Java][UniSubroutine Exception][ErrorCode: 30102]Unknown Error [30102] Occurred asjava.uniobjects.UniSubroutineException: Unknown Error [30102] Occurred at asjava.uniobjects.UniSubroutine.call(UniSubroutine.java:150) Any help would be much appreciated. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred
Try putting your input data into arg[1]. On 02/18/2011 06:25 PM, Stephen Jackson wrote: My issue is that what ever I use as my input args is what prints out as my return args along with the args number. Can that be caused by the routine not returning anything? Stephen Jackson -Original Message- From: Jeff Powell [j...@powellclan.com] Received: Friday, 18 Feb 2011, 6:43pm To: U2 Users List [u2-users@listserver.u2ug.org] Subject: Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred The arg count going in needs to be n+1. Arg 0 will be the return data. public ArrayList callSub(String sRoutine, ArrayList args) { Iterator it = args.iterator(); ArrayList oArgs = new ArrayList(); int iArgs = args.size(); System.out.println(Args: + iArgs); try { UniSubroutine uoSub = ses.subroutine(sRoutine, iArgs + 1); int iArg = 0; uoSub.setArg(iArg++, ); // dummy argument - this will become the return value // Set user arguments while (it.hasNext()) { Object arg=it.next(); //System.out.println(InputArg[+iArg+]=+arg); uoSub.setArg(iArg++, arg); } // call uoSub.call(); // get returned parameters iArgs = uoSub.getNumArgs(); for (int i = 0; i iArgs; i++) { String arg=uoSub.getArg(i); //System.out.println(OutputArg[+i+]=+arg); oArgs.add(arg); } } catch (Exception ex) { System.err.println(Call to + sRoutine + failed.); ex.printStackTrace(System.err); } return oArgs; } On 02/18/2011 01:16 PM, Stephen Jackson wrote: So we created a basic program to call so we are getting closer, thanks for all your input it is putting us on the correct path. I do seem to have some issues when trying to get the results. What is happening is it is just spitting out the input parameters .. //System.err.println(command.response()); UniSubroutine sub = session.subroutine(S.XTMS.TEST.BASIC, 1); sub.setArg(0, 0491865); sub.call(); sub.resetArgs(); System.err.println(sub.getNumArgs()); System.err.println(sub); System.err.println(sub.getArg(0)); //session.disconnect(); //String r = sub.getArg(0); //String r1 = sub.getArg(1); Logging statements: Version Number :4.1.3 Max Open Files :32 Account Path :/datatel/test/10day/development Locking Strategy :0 Release Strategy :12 Calling S.XTMS.TEST.LOOKUP... 1 asjava.uniobjects.UniSubroutine@6791d8c1 0491865 - same as input, not the result from the routine. On WednesdayF/16/11 5:45 PM, Hona, Daviddavid.h...@cba.com.au wrote: Does this subroutine do file I/O? Does it explicitly open the file or assume some other program or subroutine opens it and stores the file variable in labelled common...? Sometimes it can even be a call subroutine call that is called using a labelled common variable (CALL @MYSUB)... Easiest thing to do is look how the subroutine is used now...if you don't emulate the same initialisation sequence it requires from UV native runtime environment in Java runtime environment...it more than likely will not work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Stephen Jackson Sent: Thursday, 17 February 2011 1:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniSubroutineException: Unknown Error [30102] Occurred I am new to the U2 java api. I am trying to make a subroutine call but get the following Exception. It is not in the documentation and I have not had a lot of luck tracking it down. I am able to make a simple query so not sure if there is some configuration or something I am not aware of which is causing the error. Version Number :4.1.3 Max Open Files :32 Account Path :/mypath Locking Strategy :0 Release Strategy :12 Calling S.XTMS.TEST.LOOKUP... [IBM U2][UniObjects for Java][UniSubroutine Exception][ErrorCode: 30102]Unknown Error [30102] Occurred asjava.uniobjects.UniSubroutineException: Unknown Error [30102] Occurred at asjava.uniobjects.UniSubroutine.call(UniSubroutine.java:150) Any help would be much appreciated. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute
Re: [U2] UniObjects Java
I do a lot with UOJ and I'd be happy to help. Contact me offline if you're interested. On 02/15/2011 02:43 PM, Norman Bauer wrote: ha ha I can see that. Carbon breathing cave dweller. On Tue, Feb 15, 2011 at 2:58 PM, Steve Romanowslestak...@gmail.com wrote: On 2/15/2011 2:34 PM, Norman Bauer wrote: Thanks Steve, yeah using UOJ is a lot like giving directions to 4 year old. Imaging me tinkering with it. Not even a java dev. I am sure I looked like a caveman beating on it with a club. ___ 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] PowerHA
The new IBM Systems mag has an article on PowerHA for AIX. Does anyone know if this is compatible with UniData without requiring a dbpause? TIA Jeff ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] uniobjects error
Diane, You could have uniobject sessions that are not getting cleaned up. Be sure your application closes the connection when it is finished. If this is the case you should see more sessions open with a listuser -i command. The uniobjects connections on unidata are identifed as being on terminal udcs. Universe will probably look somewhat similar perhaps uvcs. On 08/23/2010 08:16 AM, Dianne Ackerman wrote: Just found out that people were reporting the error number wrong, it was 39134, which IS documented as the user limit problem. However, our logging system doesn't show that we ever came close to the user limit, so now I'm going to move onto that issue. Thanks. -Dianne On 8/22/2010 7:04 PM, Boydell, Stuart wrote: Dianne, It was just a guess but the error number - even though not documented - was around that range. It could also be something to do with NLS if you have it enabled? Good luck. Stuart -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Friday, 20 August 2010 23:28 To: U2 Users List Subject: Re: [U2] [UV] uniobjects error We are usually nowhere close to the user limit, we actually have some logging to keep track of that and it doesn't look like that's the issue. On 8/19/2010 7:11 PM, Boydell, Stuart wrote: What's the user limit on your server and how close to it do you normally get? Cheers Stuart -Original Message- We're occasionally getting an error code 39143, which isn't listed on the lovely list of error codes in the documentation - anyone know what it means? Thanks. -Dianne ___ 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] [UV] uniobjects error
Do you have a java exception stacktrace that might shed some light on what operation triggered it? On 08/19/2010 12:22 PM, Dianne Ackerman wrote: We're occasionally getting an error code 39143, which isn't listed on the lovely list of error codes in the documentation - anyone know what it means? Thanks. -Dianne ___ 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] [UV] uniobjects error
Is this application java or visual basic? I assumed you were using java. My bad. On 08/19/2010 01:33 PM, Dianne Ackerman wrote: Ugh, now you're getting too technical for me :) I've got a feeling I have to pass this off to someone who knows more about that end of things and can look at logs and stuff like that! On 8/19/2010 1:54 PM, Jeff Powell wrote: Do you have a java exception stacktrace that might shed some light on what operation triggered it? On 08/19/2010 12:22 PM, Dianne Ackerman wrote: We're occasionally getting an error code 39143, which isn't listed on the lovely list of error codes in the documentation - anyone know what it means? Thanks. -Dianne ___ ___ 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] 24 X 7 MV systems
Baker, My company has a 2 hour window backup to a standby server using rsync based sbom backup. At 10:00, 12:15, 3:00 and 6:00 we pause, split, resume and backup from the detached mirror. Recovery is far from automated but it fits our business needs. Jeff - Industrial Piping Specialists, Tulsa, OK On 07/26/2010 08:38 AM, Baker Hughes wrote: Hey y'all, I'm interested in hearing from folks who are currently on, or have worked with fault tolerant MV systems. We'd like to host our Business Layer on the MV system and serve It to our e-commerce portals, instead of re-coding our business rules first in Basic, then in .Net In order to get there though we must meet the primary business requirement of zero downtime (not even 2 minutes to manually switch). We're not talking about different levels of Raid - it's assumed the storage array is up and available. If the MV system has a hiccup of more than a few seconds it needs to hot failover to a backup twin sister. Is anyone doing this or something close to it? When I worked in public safety, Stratus sold such an automatic hot failover. I'm sure the EnRoute folks are doing something like this still. Maybe Nick G. or Margaret M. is listening in today. Thanks, -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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] AUTO: Haydon Bishop is out of the office. (returning 26/07/2010)
Both Dottie's and Haydon's out-of-office messages have the following header. Can the list server software filter these? I just create a new filter to automatically move messages with this header to my junk folder. Auto-Submitted: auto-generated On 07/22/2010 05:31 PM, Haydon Bishop wrote: I am out of the office until 26/07/2010. I will respond to your message when I return. Note: This is an automated response to your message U2-Users Digest, Vol 15, Issue 19 sent on 22/07/2010 20:00:02. This is the only notification you will receive while this person is away. ___ 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] Very much OT - AUTO: Haydon Bishop is out of the office (again)
Mr. Bishop's silence through all this is eerie. Do you suppose he might have a message filter on U2 posts that automatically moves them to a folder he never reads thus making him blissfully unaware of the sport he's become? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very much OT - AUTO: Haydon Bishop is out of the office (again)
He really does work for adserve.co.uk. http://www.adserve.co.uk/about/Profiles/h_bishop.html On 07/01/2010 02:19 PM, John Hester wrote: That's always been my assumption. People have been complaining about his out-of-office list spamming for at least the past 5 years, and there's never been any response that I can recall. Here's an archive of all his list posts going back to 2005: http://old.nabble.com/user/UserPosts.jtp?user=21546 Every single one is an out-of-office message. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Thursday, July 01, 2010 9:51 AM To: U2 Users List Subject: Re: [U2] Very much OT - AUTO: Haydon Bishop is out of the office (again) Mr. Bishop's silence through all this is eerie. Do you suppose he might have a message filter on U2 posts that automatically moves them to a folder he never reads thus making him blissfully unaware of the sport he's become? ___ 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] Saying Goodbye...
I love your signature quotes. I hope you enjoy your new job. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Print Wizard on Linux
Is this a rhetorical question? On 05/24/2010 09:44 AM, Brutzman, Bill wrote: I mostly agree with Jeff's philosophy but... What alternative does Jeff's recommend as the fix? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Print Wizard on Linux
On 05/24/2010 10:10 AM, Bob Rasmussen wrote: On Mon, 24 May 2010, Brutzman, Bill wrote: I mostly agree with Jeff's philosophy but... What alternative does Jeff's recommend as the fix? I understand it as well. However, the dearth of device-independent printer support in Linux/Unix environments limits the options. Let me sugget some modifications to your philosophy. 1) You have already removed some tasks from your server, most likely, into freestanding appliances, such as routers, firewalls, and possibly network storage devices. In fact, one could argue that this creates a MORE robust approach, because changes to your AIX system, for instance, are less likely to inadverantly affect their operation. That's a bit of a stretch isn't it? Our AIX machine has gone through hardware upgrades but we've always used our mksysb tape to transfer the operating system to the new box and then upgraded AIX to stay compatible with the newest UniData. Again, not a single infestation or root-kit since it's installation in 2001. So we have nine years of solid 24/7 performance from our AIX platform. I have Linux machines that have run as web servers and desktops and there has not been one infection since 2000 when I got my first RedHat liunx CD. Even my children only have linux Desktops. On the other hand, our windows PC have been infected and reinfected with various viruses and spyware programs that, among other things, cripple normal network connections. We do have network filtering and Symantec but there are so many exploits for Windows that it's impossible to avoid. Our systems manager routinely has to do fresh windows installations to eliminate the viruses. The latest outbreak propagated itself through the default share on the target PC by assuming System user privileges. Our systems manager is still cleaning this up. He's manually upgrading every PC in the company to SP3. We are considering making more changes to Print Wizard in order to make it more able to function as a printing appliance, sitting between the server and the printer. For totally non-interactive tasks, this could be an option. Great idea. Create a rack-mount unit that is completely secure and you'll have a product that could be vertically integrated. 2) If you are running Windows PCs as clients, using either terminal emulation or a GUI front end, then consider the possibility of a print job as a client task. Maybe not for printing thousands of invoices, but for more personalized jobs. We have most of our forms going to networked printers. Picking tickets print in the appropriate warehouse office, Packing lists print near the people who prepare the shipping documents for the customer and our invoices go to either the corporate office invoice printer, a pdf email, a flat file transfer or a text email. For example, some of our users will generate a purchase order on the server, feed it to the client, through Print Wizard, to generate a PDF of the PO. Print Wizard creates an email message with the PO as an attachment, and might also attach other files and documents to the email. Then it opens the email (in Outlook or in our own window) and allows the user to customize and personalize the email. They can enter recipient information, subject, body text, additional recipients, etc., and also attach other files. A similar process can be used for faxing. It seems like your product is really geared for the small office environment but wouldn't scale well to a company with hundreds of users. I figured out years ago that there are MANY ways, combinations, and permuations people want to do print-related tasks, and we continue to expand the number of them that Print Wizard can address. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ 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] Print Wizard on Linux (was Re: Code 128 Soft Font)
Bob, In our situation UniData runs on IBM Power5 / AIX server. All my third party software (VsiFax, Optio eComIntegrate and MITS) run on this same server. I purposefully avoid distributing any mission critical function, such as form printing, to another server regardless of the platform. I believe that the more complex a setup is the more opportunity there is for failure. With this in mind I would not have even considered your product in my environment since it cannot run on AIX. Your product would also not be recommended by our ERP vendor (Activant) either for the same reasons. Perhaps I'm not alone in this system management philosophy. That's my 2c. Jeff On 05/20/2010 03:35 PM, Bob Rasmussen wrote: However, I still don't see the business case for doing this development. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code 128 Soft Font
Marc, Tom Pellitieri who is active on this list has a routine that will print a barcode from Basic to a HP printer. Would that be helpful? Jeff On 05/18/2010 03:45 PM, Caminiti, Marc wrote: Quick, maybe not necessarily U2 related, question. We are looking to generate Code 128 Barcodes from an HP LaserJet printer. Testing on a 4050, but the production printer (yet to be purchased) will be an HP LaserJet 9050. I'm leaning toward using a soft font, but was wondering if anyone out there had any luck with a particular font and see what is being used out there. Thanks in advance marc Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax All generalisations are dangerous, even this one. CONFIDENTIALITY NOTICE: This e-mail and any attachments may contain confidential information that is legally privileged. The information is solely for the use of the intended recipient(s). Any disclosure, copying, distribution, or other use of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return e-mail and delete this message. ___ 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] Major release of XLr8 Installer
I bet you could have some fun with star bellied developers. On 04/19/2010 07:08 PM, Doug wrote: Hi Colin: I have two out of my three grandkids that live with us. I have read and watched too many Dr. Seuss books and DVD's: We have developed many a software, for those U2 developers that have been unaware. Most U2 developers will be accelerated, while blissfully creating UniBasic extrapolated. The XLr8 software you have not bought, should not be nary a forethought. This U2 programmer said more than he needs, making this a chore for those of you that reads. Regards, Doug www.u2logic.com Tools: XLr8Editor, XLr8Developer, XLr8Installer and XLr8Installer Middleware: U2WebLink for Apache Tomcat Web Software: Accounting, Alpaca Logic, CRM, Distribution, Doc Mgt, Transportation, Payroll and Warehousing Technologies: AJAX, Eclipse, JavaScript, Java, JSON, HTML, PHP, XML and open source. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Monday, April 19, 2010 4:14 PM To: 'U2 Users List' Subject: Re: [U2] Major release of XLr8 Installer Was it just me reading this after too many of the Haydon Bishop poems or did this sound way too much like Dr. Seuss??? No offense meant :) Colin Alfke Calgary Canada -Original Message- From: Doug [ad] Years ago we were happy just having a script based installer that worked. We did not have to remember which way to catalog programs on Unidata or Universe. We did not have to remember which VOC items would be needed for each package. We did not have remember which include files had to be there so the compiles wouldn't fail. We did have to remember to change the physical code when we ported from Universe to Unidata. So we have a tool that does all of that called XLr8Installer. It does not require any software on the origin or destination U2 database machines to run. But, of course, we wanted speed. Our payroll system took over 4 hours to create the files, copy the dictionary items, create the indexes, copy the data, copy the programs, compile the programs and catalog the programs. It does the same payroll job in 15 minutes. Now we have speed. Announcing the release of XLr8Installer 2.8.7. This is part of our family of tools that is an Eclipse based plug-in available for the low, low price of 99.00 per year. Congratulations to our team. [/ad] Regards, Doug www.u2logic.com/tools.html ___ 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] AUTO: Haydon Bishop is out of the office. (returning 16/04/2010) [not-secure]
Ah, excellent. Thanks. On 04/16/2010 01:59 PM, Jeff Schasny wrote: That would be me. I can't seem to find my original post but it went something like this: Based on Buckingham Palace By AA Milne Haydon Bishop is out of the office - Christopher Robin went down with Alice. Alice is marrying one of the guard. A soldier's life is terribly hard, Says Alice. Haydon Bishop is out of the office - Christopher Robin went down with Alice. We saw a guard in a sentry-box. One of the sergeants looks after their socks, Says Alice. Haydon Bishop is out of the office - Christopher Robin went down with Alice. We looked for the King but he never came. Well, God take care of him, all the same, Says Alice. Haydon Bishop is out of the office - Christopher Robin went down with Alice. They've great big parties inside the grounds. I wouldn't be King for a hundred pounds, Says Alice. Haydon Bishop is out of the office - Christopher Robin went down with Alice. A face looked out, but it wasn't the King's. He's much too busy a-signing things, Says Alice. Haydon Bishop is out of the office - Christopher Robin went down with Alice. Do you think the King knows all about me? Sure to, dear, but it's time for tea, Says Alice Jeff Powell wrote: Didn't someone post a poem / limerick about Mr. Bishop a couple of years ago? On 04/16/2010 10:22 AM, Nancy Fisher wrote: It sounds like the beginning of a poem though. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hennessey, Mark F. Sent: Friday, April 16, 2010 8:07 AM To: 'U2 Users List' Subject: Re: [U2] AUTO: Haydon Bishop is out of the office. (returning 16/04/2010) [not-secure] I was thinking the same thing. Maybe we need a Where's Haydon Bishop? Book... or perhaps we should form a Find Haydon Bishop group on Facebook -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Friday, April 16, 2010 9:10 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] AUTO: Haydon Bishop is out of the office. (returning 16/04/2010) I'm beginning to think Hayden Bishop doesn't actually have an office... He's never in it from all appearances. Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. Haydon Bishophaydon.bis...@adserve.co.uk 4/15/2010 3:59 PM I am out of the office until 16/04/2010. I will respond to your message when I return. Note: This is an automated response to your message U2-Users Digest, Vol 12, Issue 15 sent on 15/04/2010 20:00:02. This is the only notification you will receive while this person is away. ___ 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] AUTO: Haydon Bishop is out of the office. (returning 16/04/2010) [not-secure]
Didn't someone post a poem / limerick about Mr. Bishop a couple of years ago? On 04/16/2010 10:22 AM, Nancy Fisher wrote: It sounds like the beginning of a poem though. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com nan...@peninsulatruck.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hennessey, Mark F. Sent: Friday, April 16, 2010 8:07 AM To: 'U2 Users List' Subject: Re: [U2] AUTO: Haydon Bishop is out of the office. (returning 16/04/2010) [not-secure] I was thinking the same thing. Maybe we need a Where's Haydon Bishop? Book... or perhaps we should form a Find Haydon Bishop group on Facebook -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Friday, April 16, 2010 9:10 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] AUTO: Haydon Bishop is out of the office. (returning 16/04/2010) I'm beginning to think Hayden Bishop doesn't actually have an office... He's never in it from all appearances. Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. Haydon Bishophaydon.bis...@adserve.co.uk 4/15/2010 3:59 PM I am out of the office until 16/04/2010. I will respond to your message when I return. Note: This is an automated response to your message U2-Users Digest, Vol 12, Issue 15 sent on 15/04/2010 20:00:02. This is the only notification you will receive while this person is away. ___ 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] Quick poll - how many use 3-tier or N-tier Architecture
Hi Baker, We're doing a lot of java through web services and servlets. Mostly with Tomcat and Glassfish. Several servlets for reports and inquiries. Several java user interfaces that utilize web services that connect to UD for wireless picking, tag and label printing. HTH Jeff On 04/08/2010 12:16 PM, Baker Hughes wrote: Would those of you mind responding that use 3-Tier or N-Tier architecture - I'm trying to gather some quick numbers for some decision makers (somewhat urgent). Please respond if your site, or sites who you service have UniData, UniVerse, or any other MV db on the backend, and any fully graphical user interface: a. How many have a middle-tier application server? b. How many use IBM Websphere? c. How many use some other? Please give product name if you can. d. How many have a Java front end User Interface? e. How many have a C# front end User Interface? f. How many have other UI? Please give name. For anyone - what Multi-Value aware / friendly middleware products are there? (That don't require data normalization before sending to the middleware.) Thank you so much, -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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 exception question.
Has anyone seen this before? It has suddenly popped up after making changes to an unrelated part of the code. asjava.uniobjects.UniFileException: The RPC failed at asjava.uniobjects.UniFile.releaseLock(UniFile.java:1797) at asjava.uniobjects.UniFile.singleRelease(UniFile.java:1810) at asjava.uniobjects.UniFile.doOnChangeRelease(UniFile.java:1657) at asjava.uniobjects.UniFile.setRecordID(UniFile.java:1146) at asjava.uniobjects.UniFile.read(UniFile.java:835) TIA Jeff ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] JDBC - Finally - Hitch
Bill, You're trying to reference the connection out of it's scope. Try moving the declaration like the example below. On 03/24/2010 10:49 AM, Brutzman, Bill wrote: Ben: 1. I am glad to find out about the finally command. I was not aware of this feature in Java. 2. The new code below yields an IDE error... con cannot be resolved 3. Connection con was already defined... it gives an error when I do a con = null; 4. IDE does not accept con.close; 5. While I am happy to look into this and figure it out... right now I do not know the fix. Regards, --Bill import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class JDBC_1001 { public static void main(String[] args) { Connection con=null; try { try { Class.forName(com.ibm.u2.jdbc.UniJDBCDriver); } catch(Exception x){ System.out.println( Here + x ); } String url = jdbc:ibm-u2://192.168.0.102/SHIPPING; String userid = ups; String passWord = brown; *Connection* con = DriverManager.getConnection(url, userid, passWord); Statement stmt = con.createStatement(); String sql = select @ID, NAME, CITY, STATE from PACKSLIPS.X; ResultSet rs = stmt.executeQuery(sql); int i = 1; while (rs.next() i 6) { System.out.println(\nRecord + i + :); System.out.println(\...@id : \t + rs.getString(1)); System.out.println(\tNAME :\t + rs.getString(2)); System.out.println(\tCITY :\t + rs.getString(3)); System.out.println(\tSTATE :\t + rs.getString(4)); i++; } rs.close(); stmt.close() ; System.out.println(\n\t*--- QUERY test is done successful ---*\n); } catch (SQLException e ) { System.out.println(e); } finally{ try{ * if(con != null)* con.close(); } catch(Exception ignored){} } } } -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther Sent: Tuesday, March 23, 2010 5:34 PM To: U2 Users List Subject: Re: [U2] JDBC - ClassPath - Victory Glad it's working. Tip: You should always put the con.close() statement in a finally block. The close method itself can throw an exception so it needs to be in a nested try/catch. Putting in in a finally block insures that come Hello or high water the connection gets closed. One of the most common causes for memory leaks in JDBC applications is the build up of unclosed database connections. Connection con = null; try{ // establish connection and do stuff }catch(Exception e){ // deal with any problems }finally{ try{ con.close(); }catch(Exception ignored){} } On Mar 23, 2010, at 3:33 PM, Brutzman, Bill wrote: The following code works ok... Thanks to all those who responded especially John, Jeff, Bruce, Charles, Ben, and Mike. --Bill import java.sql.*; public class Uni_101 { public static void main(String[] args) { try { try { Class.forName(com.ibm.u2.jdbc.UniJDBCDriver); } catch(Exception x){ System.out.println( Here + x ); } String url = jdbc:ibm-u2://192.168.0.102/SHIPPING; String userid = ups; String passWord = brown; Connection con = DriverManager.getConnection(url, userid, passWord); Statement stmt = con.createStatement(); String sql = select @ID, NAME, CITY, STATE from PACKSLIPS.X; ResultSet rs = stmt.executeQuery(sql); int i = 1; while (rs.next() i 6) { System.out.println(\nRecord + i + :); System.out.println(\...@id : \t + rs.getString(1)); System.out.println(\tNAME :\t + rs.getString(2)); System.out.println(\tCITY :\t + rs.getString(3)); System.out.println(\tSTATE :\t + rs.getString(4)); i++; } rs.close(); stmt.close() ; System.out.println(\n\t*--- QUERY test is done successful ---*\n); } catch (SQLException e ) { System.out.println(e); } } }
Re: [U2] JDBC - Finally - Hitch
This text was supposed to be strikethrough to indicate that it needs to be removed since it's declared outside the outer try scope. On 03/24/2010 05:40 PM, Jeff Powell wrote: *Connection* con = DriverManager ... Should read con = DriverManager ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using JDBC on Unidata 7.1 on HPUX
Yes but you need a third party library from json.org which can be downloaded from sorceforge. On 03/21/2010 03:30 PM, Symeon Breen wrote: Does JSON really equate directly to a java object ?? It certainly equates directly to a javascript object (a very different beast indeed), it being Java Script Object Notation. Do you not need a json parser for Java, as you would for .net etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: 21 March 2010 00:32 To: 'U2 Users List' Subject: Re: [U2] Using JDBC on Unidata 7.1 on HPUX Hi Bruce: If you don't want to flatten or normalize you U2 files you can use JSON format. It is an open standard for languages like Java, JavaScript, jQuery, Ruby, Python, PowerShell, C#, and PHP to name just a few. When we looking at transferring data between sites, programs and the WEB, JSON was much easier to understand in Java because it maps into Java Objects directly. Here is a sample of a file read using JSON: [{IdCode:32828,TypeCode:14,Length:28',Cubes:720,MfgDate:0 3/01/2009, VehicleNo:,Year:2005,LicenseNo:,MfgCode:AJ,AssignedTerminal :0, Permits:[DIA],[FCA]],XLr8Company:01,XLr8NewItem:0,XLr8CheckSu m:62138}] If you equated this to a variable oData, the IdCode field would be oData.IdCode. The multivalve field Permits would be referenced by oData.Permits[0] and oData.Permits[1]. Then your data transmissions would match an industry standard. Regards, Doug www.u2logic.com U2WebLink(tm) for Java ___ 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] JDBC - ClassPath
Did you add the .jar to your project? Netbeans: Right click the libraries item under project then click add jar/folder, find your jar file and click ok. Then build run. On 03/23/2010 10:43 AM, Brutzman, Bill wrote: John: Thanks for writing. I tried it, it did not work... NetBeans still comes back with an error... Class Not Found Exception. While it does not make sense to me that the IDE talks to UV... I have concluded that I need to upgrade UV from 10.1 to 10.3.2. I installed HP-Ux on a fresh (removable) drive last night. I expect to install 10.3.2 on this new drive after hours. I hope to continue the install tomorrow night. Tonight in NYC there is a talk on the new Adobe ColdFusion9 IDE. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Monday, March 22, 2010 5:30 PM To: U2 Users List Subject: Re: [U2] JDBC - ClassPath Grasping at straws here, but when I upgraded to the latest IBM-branded version of the Eclipse IDE last year, it no longer liked the extension on asjava.zip. IBM instructed me to rename it asjava.jar, and it worked fine after that. You might try renaming and re-importing it. I doubt that's the problem since the class it can't find is in unijdbc.jar but worth a shot. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Monday, March 22, 2010 12:39 PM To: bsout...@fwdco.com; U2 Users List Subject: Re: [U2] JDBC - ClassPath I am seeing the error in the NetBeans IDE. It is curious that when I take away the double-quotes from com.ibm.u2.jdbc.UniDriver in the Class.forName line ... the code hints find all and pop-up each of the discrete text elements of... com... ibm... u2... jdbc... UniJDBCDriver... class... but then it comes back with cannot find symbol/ In NetBeans, I have both unijdbc.jar and asjava.zip listed in the Libraries folder; where all of the detailed sub-contents show up ok. --Bill ___ 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] Unibasic: Sample program - to extract data from Table
Dattatraya, Are you interested in getting training in UniData and SBClient? If so there are people (not me) on this list who have online training courses. If you are interested please let us know and I'm sure you'll get some recommendations. Jeff On 10/15/2009 12:59 AM, Dattatraya Walgude wrote: Sorry Symeon and all for asking such silly question. I manage @ID column in output.csv in following way, now I want multivalue columns in new lines with all columns (now its comes in one row/line) LINE = '' : CHANGE(CHANGE(REC,@AM,','),@VM,',') : ',':ID Thanks Regards, Dattatraya Walgude DBA Team -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Tuesday, October 13, 2009 1:12 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table This data is obviously from an company that deals with a Colorado data or is based in Colorado. And you are from outsource product develop company in India that has been tasked to work on this U2 system. So...We have some programmers that know U2 that need more work... So...Why are we teaching the competition?... So...They are probably only charging 10 to 20 per hour... So...We are charging a lot more per hour which is why we are not doing the work... A discussion for a different time, so maybe my next blog. Regards, Doug www.u2logic.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: Monday, October 12, 2009 7:24 AM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Thanks for your support. We get output of multivalve columns. Only things is we can not get out of DATE column is date format. So please give your suggestions. JonesBob123 E. 23rd St. Arvada CO 80276 3037768854 V4341 9611D C R 7 FrobisherKamal P.O. Box 9845 Denver CO 80209- 3037780880 K O 33 Steven Spender 1212 W. 44thDenver CO 80401 3034457878 3 Jamieson Dale 999 Independence WaySeattle WI 98733 V6670 96118 One more query @ID column is missing in output.csv, please suggest how to get that @ID column in output.csv. Regards Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 12 October 2009 12:58 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Output is not readable:- 14334ýITOý0ýAýý16811,14334ýCHAý CHA to Risk Rate: Mass_Aýýý16811 14369ýITOý0ýAýý61491,14369ýCHAý CHA to Risk Rate: Ten7_Aýýý61491 13977ýITAýýAýý60625 15030ýITOý0ýAýý70410,15030ýMEMý1ýPayment Responsibility ChangedýýFrom To N On 23-02-09ýýAýý70410,15030ýITAýýAýý70410 13973ýITAýýAýý38781,13973ýCHAý CHA to Risk Rate: MASS_Aýýý38781 15142ýITOý0ýAýý40128,15142ýMEMý1ýPayment Responsibility ChangedýýFrom To Y On 15-06-09ýýAýý40129 14369ýITOý0ýAýý64849,15263ýWKLýDC 040ýQueue 888Aýý47136 13910ýWKLýDC 040ýQueue 6AEAýý2898,13910ýSAPý13910ý6RE1ý1ý60+DAY EA ROUTE 1ýQ6AEýAýý7858,13910ýSUSýFailed ValidationýýýWITH SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý6RE1ýAýý14692,13911ýAOWýFrom BF01G013ýTo BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360,13911ýWKLýDC 040ýQueue 6EQ.03ýýQUEUE-SPLITTERýýAýý15360,13942ý WKLýDC 040ýQueue 6AEAýý5421,13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE 1ýQ6AEýAýý9757,13942ýSUSýFailed ValidationýýýWITH SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý Thanks Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: Monday, October 12, 2009 5:02 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Many Many Thanks Edward and Symeon Its work... Thanks Regards, Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Monday, October 12, 2009 4:55 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table ELSE NULL Will work. Syntax for all these commands is in BASR.PDF, downloadable from web for free... Edward -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 12 October 2009 12:22 To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Thanks Symeon I have created one program file (outfile ) with followinf contents Facing compilation error
Re: [U2] Unibasic: Sample program - to extract data from Table
On the other hand some of us end up spending senseless days re-engineering a product every time management changes it's mind what the product should do. It's a good thing I get paid for doing what the boss says rather than getting paid by completed projects. My boss actually brags about our ability to program on the fly. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] hpux to linux; Solaris 2.6 to Solaris 10
Just out of curiosity, why are you moving to windows? Are there specific benefits? Thanks. On 10/07/2009 10:55 AM, jpb-u2ug wrote: We have moved from Unix V5 on Motorola, to Solaris 2.6, to Solaris 8, to RH Linux AS3, and are now in the process of moving to Windows 2008. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe web connectivity
Java - Tomcat and Glassfish (Sun Application Server) with Uniobjects. Matthew Day wrote: Hi, We currently have a system with a VB6 front end and use Universe for the database and business logic. We are looking to develop a web solution for our product. What are people using to inteface universe with the web, and what are your experiences ( both good and bad ) with the route you have chosen. Thanks, Matt ___ 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] U2 being sold! {Unclassified}
I'm in the US and I have to agree you you on the credibility issue. I'm plenty alarmed by this announcement as is our Management team. HENDERSON MIKE, MR wrote: You can indeed say you now have a Rocket in your Pocket And I'm afraid that this rather exactly illustrates the damage to the products' image that will be done, or has already been done, by this disposal. How can anyone take a firm called Rocket Software seriously*? Sorry, but for me it's instant Zero Credibility for a DBMS vendor. Maybe it's cultural thing and it'll go down fine in the USA, but I think it'll go down like a 'cup of cold sick' in the UK AUS / NZ / RSA markets On the other hand, maybe we'll get more emphasis on integration with mainstream (= Microsoft) products and less on IBM. For example * MSMQ instead of MQSeries for reliable message handling, * SQL Server for EDA instead of DB2, * Windows Server 2008 the first and principal port of a release, then Linux, then AIX other niche O/Ses? Regards Mike * OK, I'll concede it might be an acceptable name for a missile guidance software company, but this ain't them -Original Message- From: u2-users-boun...@listserver.u2ug.org On Behalf Of Garry Smith Sent: Wednesday, 16 September 2009 8:28 a.m. To: victor.hender...@gmail.com; U2 Users List Subject: Re: [U2] Rocket Change is a coming! Now I can say I have a Rocket in my Pocket The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ___ 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 / DBPause
Is there any way for UniObjects to know if the database is paused? As far as I can tell an open session will wait and a new session will throw an exception. The reason I need to know is that we're now using the SBOM method for rsync-ing with our standby server. This however is causing problems with those applications that attempt to connect while the system is paused as the mirror is broken off. TIA Jeff ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Better and Better Application - Launching today Friday 8/21/09 -- Browser instructions
I think this project has a lot of potential. Kudos to those who are giving of their time to participate. I don't know if there is an intent to deploy it for Chrome, FF, Safari, etc, I'm guessing there is an intent to have it usable in IE 8 at some point. IE 6 7 are sunset. You may consider looking at the browser market share stats by following the link below. http://news.cnet.com/8301-1001_3-10303614-92.html?part=rsstag=feedsubj=Webware That a piece of deployable software could be written by volunteers in relatively short order is great. Even if I would rather see developers have toolsets and frameworks that provide cross-browser support, that can be quite expensive to write and support. After reading some of the posts by those who are working on this project it sounds like managing the project is the most difficult aspect. If that is the case perhaps a lesson can be gleaned from the open source community where developers from all over the world collaborate on a project. A few specific projects that come to mind are: -The linux kernel and various distributions (I use Ubuntu and Fedora). -Mozilla (firefox thunderbird) -Netbeans (Java IDE) -MySql -Chromium (google chrome) There also are the thousands of projects on sourceforge.net. All of these have many developers working together with source code control and formal bug reporting/assignment. Best regards. Jeff ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Better and Better Application - Launching today Friday 8/21/09 -- Browser instructions
I'm working on it and will hopefully have something to report in the next few days. Bill Haskett wrote: u2-users-ow...@listserver.u2ug.org said the following on 8/23/2009 8:59 AM: The message's content type was not explicitly allowed Subject: Re: [U2] Better and Better Application - Launching today Friday 8/21/09 -- Browser instructions From: Bill Haskett wphask...@advantos.net Date: Sun, 23 Aug 2009 08:59:51 -0700 To: U2 Users List u2-users@listserver.u2ug.org To: U2 Users List u2-users@listserver.u2ug.org Jeff: Sounds like you, or someone else, would like to volunteer to set up the development communications environment. :-)I too appreciate the work of these volunteers. I am using DesignBais to convert our somewhat large enterprise application. It is a long process that takes quite a bit of time but it looks nice and the least of my problems is the IE requirement. I exclusively use Firefox with the IE Tabs plug-in installed. Occasionally I have to be cautious about a Firefox upgrade but anyone who uses plug-ins knows this. I've been using this IE plug-in since FF 2 and it works great. So, anyone with a Windows machine can use Firefox. If one is running a Mac one needs Windows installed in parallels (or whatever) to use FF. Since we're all developers I'd think at least 90 - 95% of us use Windows (I didn't say everyone!). This means a vast majority of us can use IE or Firefox. I'm guessing IE and FF have at least 80% market share so I don't believe what the BB committee is doing is unreasonable by any stretch of the imagination. DesignBais is significantly easier to develop in than anything else. It uses straight U2 tools (U2 UO) effectively. Changes can be done easily and the installation and configuration issues can usually be resolved quickly. This is completely unlike most other technologies where multiple people need to be involved and getting the most simple change takes a lot more time and patience than most volunteers have. Besides, I suspect this small application was written using the W3C standards and should work with everything shortly. In addition, I suspect the IE8 issues will be resolved shortly too. Bill Jeff Powell said the following on 8/23/2009 7:00 AM: I think this project has a lot of potential. Kudos to those who are giving of their time to participate. I don't know if there is an intent to deploy it for Chrome, FF, Safari, etc, I'm guessing there is an intent to have it usable in IE 8 at some point. IE 6 7 are sunset. You may consider looking at the browser market share stats by following the link below. http://news.cnet.com/8301-1001_3-10303614-92.html?part=rsstag=feedsubj=Webware That a piece of deployable software could be written by volunteers in relatively short order is great. Even if I would rather see developers have toolsets and frameworks that provide cross-browser support, that can be quite expensive to write and support. After reading some of the posts by those who are working on this project it sounds like managing the project is the most difficult aspect. If that is the case perhaps a lesson can be gleaned from the open source community where developers from all over the world collaborate on a project. A few specific projects that come to mind are: -The linux kernel and various distributions (I use Ubuntu and Fedora). -Mozilla (firefox thunderbird) -Netbeans (Java IDE) -MySql -Chromium (google chrome) There also are the thousands of projects on sourceforge.net. All of these have many developers working together with source code control and formal bug reporting/assignment. Best regards. Jeff ___ 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] SBClient 5.3.8 on 64 bit vista
Thanks Kevin. Can you send me a link to the download page? Thanks again. Kevin King wrote: I just verified that Dynamic Connect does have U2 device licensing support. I thought so, but now I've verified, at least with DC6.0. ___ 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] SBClient 5.3.8 on 64 bit vista
I have a user who needs to work from home with his Vista PC. We are having trouble installing sbclient on this machine it is saying this program is not compatible with 64 bit. Has anyone made sbclient 5.3.8 work on a 64 bit vista machine? If not what can I do for this user. We are running Unidata 7.1 with SystemBuilder 5.3.8. We only use character mode. Thanks. Jeff ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SBClient 5.3.8 on 64 bit vista
Thanks Steve. I tried running Accuterm and a few other wyse60 emulators but I was getting errors from system builder. I forgot to mention that we have device licensing which is one of the reasons I need to use sbclient. Thanks again. Jeff Steve Romanow wrote: Jeff Powell wrote: I have a user who needs to work from home with his Vista PC. We are having trouble installing sbclient on this machine it is saying this program is not compatible with 64 bit. Has anyone made sbclient 5.3.8 work on a 64 bit vista machine? If not what can I do for this user. We are running Unidata 7.1 with SystemBuilder 5.3.8. We only use character mode. Thanks. Jeff ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Does he use smart query or any dde transfer capability? If not, you can use other clients with SB+. I personally use Putty (on windows and linux) but pretty much any terminal emulator will work (with enough tweaking.) I have TERM.DEFN records for VT100, VT220, and wy60 if you want to tinker. It is a pretty painstaking process, most times you will find that for each offering, almost everything works, but different things broken with each one. Things to check are F1-F4, F11 and F12 for insert and delete. Backspace and Delete compatibility. All of this is easier if you do not require 16-color. I have color working with mine, but it takes out half the work if monochrome is satisfactory. ___ 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] SBClient 5.3.8 on 64 bit vista
John, Are you connecting to a SB 5.3.8 server? I was told that SB SBClient needed to match. Also, do you know where I can download SBClient 5.4? I'd love to test it. Thanks, Jeff Israel, John R. wrote: I am using SB 5.4 on Vista64 w/o any problems. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Friday, August 21, 2009 10:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] SBClient 5.3.8 on 64 bit vista I have a user who needs to work from home with his Vista PC. We are having trouble installing sbclient on this machine it is saying this program is not compatible with 64 bit. Has anyone made sbclient 5.3.8 work on a 64 bit vista machine? If not what can I do for this user. We are running Unidata 7.1 with SystemBuilder 5.3.8. We only use character mode. Thanks. Jeff ___ 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/socket idle time?
I don't know what your connecting application is but can you disconnect the connection when you're done? This must be explicitly done with a session.disconnect();. We learned this when we ran out of license seats due to a process that would connect but never disconnected. If somehow you could make your application disconnect when it is done with each thread then you could to do a listuser and look for the udcs processes with grep. Then you would know that those connections were really active. HTH Jeff a ballpark figure of how many connections we have into the database at any one time. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects/socket idle time?
Doug, Can I ask what you ultimate goal is? Thanks, Jeff Doug Chanco wrote: Hey all, Is anyone aware of a way to see how long a uniobjects connection has been idle? I know that after x time the socket connection will close but until that moment I assume the connection is idle and I am trying to find a way to look through our uniobjects connections and figure out at any one moment how many are actually doing something. Any thoughts/suggestions/ideas are welcomed! Thanks Dougc Aix 6.1.2 Universe 10.2.x ___ 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] PHP vs Java
|boolean| |*add http://java.sun.com/javase/6/docs/api/java/util/ArrayList.html#add%28E%29*(E http://java.sun.com/javase/6/docs/api/java/util/ArrayList.html e)| Appends the specified element to the end of this list. | void| |*add http://java.sun.com/javase/6/docs/api/java/util/ArrayList.html#add%28int,%20E%29*(int index, E http://java.sun.com/javase/6/docs/api/java/util/ArrayList.html element)| Inserts the specified element at the specified position in this list. Adrian Merrall wrote: Bill, I don't have the javadoc for the dynamic array class provided by uniobjects handy but that may do it. I don't think a simple ArrayList will do it, primarily because it won't have insert capability. Building a dynamic array in java is certainly possible but has some interesting cases to handle. Regards, Adrian On Fri, Jul 31, 2009 at 10:39 AM, Brutzman, Bill bi...@hkmetalcraft.comwrote: Yes... It looks like it would. Thanks Jeff. I will plan to reVisit the Morris County Library to find the textbook that I found the java source code for the method to handle dynamic arrays... and try to determine why ArrayList was not mentioned. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Thursday, July 30, 2009 6:30 PM To: U2 Users List Subject: Re: [U2] PHP vs Java Wouldn't the ArrayList work? It has add and get methods plus a toArray method. Brutzman, Bill wrote: Thanks to Kevin and Ross for responding. I was surprised to learn that Java does not have built-in functionality to support dynamic arrays although a little method can be written to handle it. The battle inside my head continues... --B -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, July 29, 2009 9:21 PM To: U2 Users List Subject: Re: [U2] Using PHP To start, I'll echo Ross. PHP is great for sessions and all manners of web-type programming. Unlike Java - an otherwise excellent language which tends to require some complex-ish web server setup - PHP is much more lightweight and plugs into just about any web server quickly and efficiently. The language is purportedly derived from Perl but syntactically I find it closer to the original ANSI C++ with just a touch of Java-isms to keep it friendly. It's easy (dare I say fun?) to learn, easy to read, easy to deploy, and can be very maintainable (though of course individual mileage in this department varies per individual - as with all languages). There are all sorts of frameworks and infrastructures available for PHP but one doesn't have to use anything more than an editor to get started. The documentation is well written (I find it much more understandable than most) and there are plenty of books available with code samples to get one moving in the right direction. PHP can install with lots of different modules from SQL connectors to crypto libraries, ZIP and PDF creators and extractors, and a blindingly large array of other features as well. And if that's not enough there's a whole boatload of other user-contributed libraries available via PEAR. Generally speaking, (well written) PHP code performs very well, it's a reasonably mature language with a good object model (as of PHP5) but where it really shines is in passing data to and through a web server and managing sessions. I've also used it for *nix shell scripting for administration types of things and even had the pleasure of writing a NAGIOS plugin with it. Come to think of it, I've used it for all sorts of ad-hoc data analysis on my Windows box as well when awk was just a little too ... awkward? (pun intended, of course) I've heard PHP is the #2 language in the world behind C++, but I don't know definitively that's entirely reliable. That said, it does seem like it's gaining momentum because it's so flexible and pervasive. The fact that it can be used beyond the web and on nearly every platform imaginable without additional hardware or software, well, that has to account for something. The only downside to PHP in terms of U2 is that IBM has so far refused to create any kind of native connector. The UO connector works but it requires something of a walk on the wild side to mitigate some weirdness in the dynamic array extraction methods. Yeah, there's that TechConnect article which describes rolling your own, but even I'm not THAT geeky. Finally, FREE is always a good price, especially when you get so much with PHP. -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] Using PHP
That would be cool. Could PHP keep a persistent connection to a UniData server? One of my reasons for using Java is that I can eliminate the connection time overhead by keeping the the connection and key files open and available to all incoming HTTP requests. Brian Leach wrote: ... And I've found when teaching UniVerse Basic to died-in-the-wool .Net and C programmers, who tend to comment at the lack of variable declaration or strong typing and the idea that it's an interpreted language, the words 'just like PHP' tends to have a calming effect ... grin I just wish IBM would officially publish the UO protocol so it could be emulated in PHP. The problem with the other approaches, excluding web services, is that you need to install specific modules rather than using PHP code. Which then makes that module platform dependent and you may not have the rights to install it on a hosted system. Whereas writing a UO client in pure PHP would make it fully cross platform and no installation hassles. Brian ___ 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] PHP vs Java
Here is sun's javadoc for Java 6. http://java.sun.com/javase/6/docs/api/ I'm not advocating one platform over the other since I use both myself. PHP certainly has a place for rapid application development. I have however done extensive work with web-services that connect to UniData via UniObjects for java. One application that is in use in our warehouse uses JSON, reflection and webservices to create an interactive web picker tool with real time validation of the material codes entered by the picker. Brutzman, Bill wrote: Yes... It looks like it would. Thanks Jeff. I will plan to reVisit the Morris County Library to find the textbook that I found the java source code for the method to handle dynamic arrays... and try to determine why ArrayList was not mentioned. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Thursday, July 30, 2009 6:30 PM To: U2 Users List Subject: Re: [U2] PHP vs Java Wouldn't the ArrayList work? It has add and get methods plus a toArray method. Brutzman, Bill wrote: Thanks to Kevin and Ross for responding. I was surprised to learn that Java does not have built-in functionality to support dynamic arrays although a little method can be written to handle it. The battle inside my head continues... --B -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, July 29, 2009 9:21 PM To: U2 Users List Subject: Re: [U2] Using PHP To start, I'll echo Ross. PHP is great for sessions and all manners of web-type programming. Unlike Java - an otherwise excellent language which tends to require some complex-ish web server setup - PHP is much more lightweight and plugs into just about any web server quickly and efficiently. The language is purportedly derived from Perl but syntactically I find it closer to the original ANSI C++ with just a touch of Java-isms to keep it friendly. It's easy (dare I say fun?) to learn, easy to read, easy to deploy, and can be very maintainable (though of course individual mileage in this department varies per individual - as with all languages). There are all sorts of frameworks and infrastructures available for PHP but one doesn't have to use anything more than an editor to get started. The documentation is well written (I find it much more understandable than most) and there are plenty of books available with code samples to get one moving in the right direction. PHP can install with lots of different modules from SQL connectors to crypto libraries, ZIP and PDF creators and extractors, and a blindingly large array of other features as well. And if that's not enough there's a whole boatload of other user-contributed libraries available via PEAR. Generally speaking, (well written) PHP code performs very well, it's a reasonably mature language with a good object model (as of PHP5) but where it really shines is in passing data to and through a web server and managing sessions. I've also used it for *nix shell scripting for administration types of things and even had the pleasure of writing a NAGIOS plugin with it. Come to think of it, I've used it for all sorts of ad-hoc data analysis on my Windows box as well when awk was just a little too ... awkward? (pun intended, of course) I've heard PHP is the #2 language in the world behind C++, but I don't know definitively that's entirely reliable. That said, it does seem like it's gaining momentum because it's so flexible and pervasive. The fact that it can be used beyond the web and on nearly every platform imaginable without additional hardware or software, well, that has to account for something. The only downside to PHP in terms of U2 is that IBM has so far refused to create any kind of native connector. The UO connector works but it requires something of a walk on the wild side to mitigate some weirdness in the dynamic array extraction methods. Yeah, there's that TechConnect article which describes rolling your own, but even I'm not THAT geeky. Finally, FREE is always a good price, especially when you get so much with PHP. -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 ___ 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] PHP vs Java
Kevin, You can extract to another unidynarray and then work through the values locally. Kevin King wrote: Question to those who have used the UOJ connector... Is extract as stupid in Java as it is in PHP? With PHP you can't use this to extract an attribute to a local variable and then loop through the mv's like you would in BASIC. Every freakin' routine that wants to get a multivalue has to use Field(n) to get the attribute number first, then Field(m) for the value, and that's a RPITA. I've taken to parsing delimiters and using explode() in PHP to break things up by delimiter and convert the entire dynamic array to a first class PHP array; otherwise everything just gets too long and ugly. Does UOJ have this kind of thing as well? On Fri, Jul 31, 2009 at 12:06 PM, John Hester jhes...@momtex.com wrote: -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Thursday, July 30, 2009 2:59 PM To: U2 Users List Subject: Re: [U2] PHP vs Java Thanks to Kevin and Ross for responding. I was surprised to learn that Java does not have built-in functionality to support dynamic arrays although a little method can be written to handle it. The battle inside my head continues... --B The UOJ UniDynArray object and methods will let you pass dynamic arrays between Java applications and UniBASIC programs as a subroutine argument, but you can also use them independently of any U2 subroutine calls. We use them extensively. They have essentially the same functionality in Java as in UniBASIC. From the UOJ manual: The following table describes the UniDynArray methods. Primary Methods count ( ) dcount ( ) delete ( ) extract ( ) insert ( ) length ( ) remove ( ) replace ( ) toString ( ) Just include the UOJ asjava.zip library in your application. -John ___ 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] the XML/DB Tool
001|111|011|111 store Symeon Breen wrote: Yes - reminds me of some programmers i know who if they do not have a point and click interface and the ability to draw lines between tables, and tick boxes etc are incapable of any sql, and who are also incapable of coding anything outside of VS. Lol One of my pet hates i suppose is that toolsets make certain things like web services and xml easy for anyone to do - but should these people be doing it if they do not understand what it is they are doing ??? :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Morrissey Sent: 30 July 2009 09:24 To: U2 Users List Subject: Re: [U2] the XML/DB Tool Hardcoding and Handcoding are subtly different. On Thu, Jul 30, 2009 at 12:59 AM, Symeon Breen syme...@gmail.com wrote: Just one point - where you say hard code - I am not entirely in agreement - my xml handling code is generic for all the xml file i suck into u2, the EXT file is different for each xml file - it is in a way an addendum to the xsd and allows you to only import parts of the xml. If this is what you call hardcoding then i disagree it is a configuration. If however you are hardcoding your databasic for each xml file then yes that is hardcoding and i agree you should not do it that way ! Symeon. ___ 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] PHP vs Java
Wouldn't the ArrayList work? It has add and get methods plus a toArray method. Brutzman, Bill wrote: Thanks to Kevin and Ross for responding. I was surprised to learn that Java does not have built-in functionality to support dynamic arrays although a little method can be written to handle it. The battle inside my head continues... --B -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, July 29, 2009 9:21 PM To: U2 Users List Subject: Re: [U2] Using PHP To start, I'll echo Ross. PHP is great for sessions and all manners of web-type programming. Unlike Java - an otherwise excellent language which tends to require some complex-ish web server setup - PHP is much more lightweight and plugs into just about any web server quickly and efficiently. The language is purportedly derived from Perl but syntactically I find it closer to the original ANSI C++ with just a touch of Java-isms to keep it friendly. It's easy (dare I say fun?) to learn, easy to read, easy to deploy, and can be very maintainable (though of course individual mileage in this department varies per individual - as with all languages). There are all sorts of frameworks and infrastructures available for PHP but one doesn't have to use anything more than an editor to get started. The documentation is well written (I find it much more understandable than most) and there are plenty of books available with code samples to get one moving in the right direction. PHP can install with lots of different modules from SQL connectors to crypto libraries, ZIP and PDF creators and extractors, and a blindingly large array of other features as well. And if that's not enough there's a whole boatload of other user-contributed libraries available via PEAR. Generally speaking, (well written) PHP code performs very well, it's a reasonably mature language with a good object model (as of PHP5) but where it really shines is in passing data to and through a web server and managing sessions. I've also used it for *nix shell scripting for administration types of things and even had the pleasure of writing a NAGIOS plugin with it. Come to think of it, I've used it for all sorts of ad-hoc data analysis on my Windows box as well when awk was just a little too ... awkward? (pun intended, of course) I've heard PHP is the #2 language in the world behind C++, but I don't know definitively that's entirely reliable. That said, it does seem like it's gaining momentum because it's so flexible and pervasive. The fact that it can be used beyond the web and on nearly every platform imaginable without additional hardware or software, well, that has to account for something. The only downside to PHP in terms of U2 is that IBM has so far refused to create any kind of native connector. The UO connector works but it requires something of a walk on the wild side to mitigate some weirdness in the dynamic array extraction methods. Yeah, there's that TechConnect article which describes rolling your own, but even I'm not THAT geeky. Finally, FREE is always a good price, especially when you get so much with PHP. -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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Locked License Seat {unclassified}
Try kill -15 2160 kill 2160 15 and kill 2160 9 with no effect. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Locked License Seat {unclassified}
Sorry. I just noticed this was a windows server and I gave you *nix syntax. I didn't scroll down far enough. Jeff Powell wrote: Try kill -15 2160 kill 2160 15 and kill 2160 9 with no effect. ___ 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] Error 4 22 from PHP exec of uv on AIX
What account is Apache running as? Perhaps Apache does not have adequate permissions. Ross Morrissey wrote: Thanks Henry, this sent me down another path of exploration. I ran my PHP script from the command line (php connect.php) and it got through to uv just fine - which makes it difficult to debug further. I was able to compare user and environment variables and there are no smoking guns. If I can't get this working using PHP as an Apache module, maybe I'll hook it up via CGI. Thanks again U2-Users! On Fri, Jul 24, 2009 at 6:54 PM, Henry Unger hun...@hitech.com wrote: Permissions, perhaps? Running it using syscalls might provide some clues. ___ 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] [UD] Logoff on Telnet Disconnect
I just tried this on a session that the computer was suspended on and it thought the session was alive. I also did this to a non-existent tty (/dev/pts/7a) it also thought it was alive. if ! /dev/pts/7a; then echo dead; else echo alive; fi alive Does the /dev/pts/?? set the $? return value? Thanks. Jeff Dave Laansma wrote: I have a script that I run periodically does this. Here are the critical elements of said script: if ! /dev/${devn} 2/dev/null 1/dev/null then /usr/udthome/bin/stopudt ${proid} fi ${devn} is derived earlier in the script from the 'listuser' command. Basically, if there is a pts in the U2 user list but Unix cannot send a null redirected message to it, it must be disconnected. I am very interested if anyone has another idea that is more reliable. David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services, and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, July 24, 2009 1:19 PM To: U2 Users List Subject: [U2] [UD] Logoff on Telnet Disconnect Is there any UDT option that causes a Unidata (7.1.16) session to be dropped when the telnet session is inadvertently disconnected? Barring that, when a telnet session is inadvertently disconnected is there a reliable way (AIX 5) to determine that a session has or does not have a telnet client connected to it? -Kevin http://www.PrecisOnline.com ___ 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
Yes. As Marc said you can have a heartbeat. We do this as a way to keep the connect overhead down. I've had connections open for over a month. Jonathan Leckie wrote: Is it possible to keep a Uniobjects connexion open? Or is it possible to have a trigger that would allow an event that could allow the state change to be seen and re-opened? * This message has been scanned for viruses and dangerous content by * Blairs Email Server, and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairsltd.co.uk * * Name Registered Office: * -- * Blairs Limited * 9 Baker Street * Greenock * PA15 4TU * Company No: SC132926 * VAT No: 554698690 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] uniobjects/web services
We are using web services with uniobjects but they are Java service (JAX-WS) running on a glassfish (Sun Application Server) hosted on a Linux VM. HTH Doug Chanco wrote: Hey all, On aix 5.2/uv 10.2.x has anyone implemented web services with uniobjects? We are getting unknown errors when we use threading but they seem to go away when we serialize the web service. I know the info is a bit shaky (sorry) But I am more interested in shops that have successfully implemented web services with uniobjects (how you are doing it, how well or not does it work, etc ) Thanks Dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] uniobjects/web services
With Java services and servlets thread safety is handled by placing the UniObjects session inside a method. This ensures that each user gets it's own connection and session. Thus it is safe. Example: *Not Safe: * public class MyServlet extends Httpservlet... { public UniJava myUniJava; public UniSession myUniSession; public MyServlet() { ... myUniSession=myUniJava.openSession(); myMethodThatDoesSomethingUseful(); ... } private myMethodThatDoesSomethingUseful() { } *Safe*: public class MyServlet extends Httpservlet... { public MyServlet() { ... } private myMethodThatDoesSomethingUseful() { UniJava myUniJava; UniSession myUniSession; myUniSession=myUniJava.openSession(); ... } HTH Jeff Jacques G. wrote: I recall that someone posted on this list that uniobjects wasn't thread safe, that if you wanted to use threads you should use the .NET version. - Original Message From: Doug Chanco dcha...@sportsendeavors.com To: u2-users@listserver.u2ug.org Sent: Thursday, April 2, 2009 1:06:46 PM Subject: [U2] uniobjects/web services Hey all, On aix 5.2/uv 10.2.x has anyone implemented web services with uniobjects? We are getting unknown errors when we use threading but they seem to go away when we serialize the web service. I know the info is a bit shaky (sorry) But I am more interested in shops that have successfully implemented web services with uniobjects (how you are doing it, how well or not does it work, etc ) Thanks Dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] uniobjects/web services
Here is a list of applications we're consuming services with. 1. Product Labeler (1) 2. Stainless Tag engraver (1) 3. Saw nesting / programming (1) 4. MTR document processing 5. User authentication 6. Product drop manager (2) 7. Web based pick with custom data fields (1) 8. Warehouse user identification (1) reads a custom line item, marks line item as completed (2) creates, modifies, removes records These programs do UniQuery for selects, file reads, file writes and subroutine calls to actually kick off UniBasic execution. I use netbeans as the java IDE to create web services and clients through a simple wizard. The actual methods are then written by hand as to how to implement the uniobjects. The data is trasferred as XML but it becomes a real data object at each end. The web pick is tying javascript to unidata through a servlet and a web service. Jeff Doug Chanco wrote: Thanks for the response, can you give a me any details about how/what you are using web services for? Dougc Ps -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Thursday, April 02, 2009 2:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uniobjects/web services We are using web services with uniobjects but they are Java service (JAX-WS) running on a glassfish (Sun Application Server) hosted on a Linux VM. HTH Doug Chanco wrote: Hey all, On aix 5.2/uv 10.2.x has anyone implemented web services with uniobjects? We are getting unknown errors when we use threading but they seem to go away when we serialize the web service. I know the info is a bit shaky (sorry) But I am more interested in shops that have successfully implemented web services with uniobjects (how you are doing it, how well or not does it work, etc ) Thanks Dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Does anybody have a hot backup server?
I am trying to put together a backup strategy that involves keeping a standby server within two data hours of the primary. The idea is to be able to have users log into the backup server and keep the business running in the event of a crash. I'd like to hear what solutions others have found for this. I've been trying to contact IBM for the last 6 months but they haven't answered and my ERP vendor doesn't know how to do this. Any ideas are appreciated. TIA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Does anybody have a hot backup server?
UniData 7 on primary and 6 on backup. Thanks. Dan Fitzgerald wrote: UV or UD? -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Wednesday, March 18, 2009 3:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] Does anybody have a hot backup server? I am trying to put together a backup strategy that involves keeping a standby server within two data hours of the primary. The idea is to be able to have users log into the backup server and keep the business running in the event of a crash. I'd like to hear what solutions others have found for this. I've been trying to contact IBM for the last 6 months but they haven't answered and my ERP vendor doesn't know how to do this. Any ideas are appreciated. TIA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Does anybody have a hot backup server?
I've gotten some really great feedback on this and I'm glad it has sparked such a dialog. I am amazed at the variety of solutions out there. Thanks for all the input. Jeff Powell wrote: I am trying to put together a backup strategy that involves keeping a standby server within two data hours of the primary. The idea is to be able to have users log into the backup server and keep the business running in the event of a crash. I'd like to hear what solutions others have found for this. I've been trying to contact IBM for the last 6 months but they haven't answered and my ERP vendor doesn't know how to do this. Any ideas are appreciated. TIA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] time Verb {Unclassified}
On Tue, 2009-03-10 at 11:12 +1300, HENDERSON MIKE, MR wrote: [Digression: I wonder how a VM-ed Windows environment copes with that? Can you have different VMs in different Time Zones on the same real host? Can you use VMs to 'time travel', by setting the date/time on one VM to a completely different value to another and/or to the real time on the host?] The guest O/S really thinks it's standalone so, yes, it's possible to have VMs in different time zones. The exception to this is that with VMWare Tools you can tell it to synchronize the clock with with the host. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects for Java on Ubuntu anyone?
That did it. Thanks. On Fri, 2009-02-13 at 16:42 -0800, Richard Nuckolls wrote: I have not used Ubuntu, but try optioning Java with - Dfile.encoding=iso8859-1 If you are were tomcat, this would go in the CATALINA_OPTS environment variable. (setenv.sh) -Rick On Feb 13, 2009, at 2:34 PM, Jeff Powell wrote: The LANG variable issue takes a new twist with Ubuntu Server 8.10. Neither LANG=C (IBM recommended) or LANG=en_US.iso885915 (must use for RedHat) will work. The value marks are wrongly used as field marks. And in case you're wondering no, LANG=en_US.UTF-8 also does not work. Has anyone made UniObjects for java work on Ubuntu? Thanks. Jeff --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObjects for Java on Ubuntu anyone?
The LANG variable issue takes a new twist with Ubuntu Server 8.10. Neither LANG=C (IBM recommended) or LANG=en_US.iso885915 (must use for RedHat) will work. The value marks are wrongly used as field marks. And in case you're wondering no, LANG=en_US.UTF-8 also does not work. Has anyone made UniObjects for java work on Ubuntu? Thanks. Jeff --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Multicast Socket
Has anyone used a multicast socket in basic program? I looked at the socket api and it does not deal with multicast at all. TIA Jeff --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Looking for advice on upgrading from Unidata 6.0 to Unidata 7.1 o n HP9000 HPUX 11
Bruce, If you have device licensing be sure to check into it carefully. With UD 6.1 we had device licensing with 10 connections. This was replaced with a 4 connection scheme when we upgraded to 7.1. Device licensing allows one network attached device to have up to n connections that only count as one license use as long as the user name is the same. Typically this allows one user to have mulitple SBClient screens open but only consume one license. It is also useful for uniobjects connections in the same way. Otherwise our UD7.1 upgrade went fine. We transitioned from a UD6.1/AIX box to a new UD7.1/AIX server and re-compiled the programs after we restored our accounts from tape onto the new machine. HTH Jeff On Wed, 2009-01-21 at 17:45 -0800, Lunt, Bruce wrote: Hi All, We are finally going to upgrade from 6.0 to 7.1 - so that we can use the SOAP to call out to the web - and I was looking for any sites that have experienced this upgrade already. We are using SB+ but other than that we do not do too much that is too exotic or fancy. Any helpful advice would be greatly appreciated! Thanks in advance, Bruce Lunt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Errors with RPC
Another issue we had is session closure due to inactivity. I had a program connected but it quiesced during the lunch hour and then came up with a no connection error after people came back and started to use the system. My solution was to add a keepalive timer that executes a read or subroutine call every 15 minutes. This is handled in a timer thread. In the example below I simply read key APP from file USER.ID. This example is from a web based application. ... Timer c = new Timer(); c.schedule(new KeepAlive(), 90, 90); ... class KeepAlive extends TimerTask { public void run() { try { UniDynArray usrRec = ud.Read(APP, USER.ID); } catch (Exception ex) { Logger.getLogger(Mtr.class.getName()).log(Level.SEVERE, KeepAlive:failed, ex); } } } On Wed, 2009-01-14 at 06:40 +, Symeon Breen wrote: Hi a uniobjects connection will take a normal licence - However if you have device licencing then the first 10 concurrent uniobjects connections from one ip address will take just 1 licence, any further connections will then take a new licence each (e.g. 13 connections takes 4 licences) So you get one error after 485,000 calls - that could be hard to trace - the problem is it is all happening at that split second of the connection so on that split second you may well have been out of licences but how will you know ... Are you opening a new connection for each request or is the session created at the beginning and you then reuse it 485,000 times. If the first it may be worth putting a try round the initial connect to the session and a loop so if it fails first time pause for 100 ms and try again - not sure how to do this in java but in vb.net it would be something like :- For i = 1 To 5 ErrorMessage = String.Empty Try udSession = UniObjects.OpenSession(HostName, UserName, Password, Account, lServiceType) Catch ex As Exception ErrorMessage = ex.ToString End Try If ErrorMessage = String.Empty Then Exit For Else ErrorMessage=ErrorMessage Try i If i 5 Then System.Threading.Thread.Sleep(100) Next This will capture if it is not able to connect for whatever reason (usually licences) and try again, max 5 times . I have put this code in all our web services because i have been getting the same problems. Basically i think u2 is a bit slow at tidying up its licencing if there are a lot of connections coming in and out thick and fast. Rgds Symeon. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Martel, Henry Sent: 13 January 2009 15:56 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Errors with RPC unirpcd is definitely running. After 485,000 calls, we've had our first service error. This was framed by a handful of those same ping errors we've been seeing. 1/8/2009 06:58:03:859 Error: [IBM U2][UniObjects for Java][UniSession Exception][ErrorCode: 81002]No RPC Connection active. Tag: getinventoryline Payload: nSKUS=1~SKU=101NVXL~QTY=4~WAREHOUSECODE=NV~EXCLUSIVEWAREHOUSE=0 The timeout is within 3 sec. We are not using pools to perform the counts. I will be checking the licenses and the network card. Is there a diff between UV Licenses and licenses for rpc? -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 2009-01-13 09:04 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Errors with RPC Hi There are a number of reasons you may be getting this Licences is one -are there any licences left on the u2 host I have seen this error on busy systems where the nic is using half duplex, check your nic and your switch port to ensure full duplex is in use. When you start ud is it starting unirpcd as well - check it is running Are you using pools - are they licenced and are there any left. Your trhreads on the java end are not dying for any reason, i.e you are reseting the app server or something ? How long does it take to happen - i.e. is it a while so thereis a timeout issue At what point does this happen is it in the initial connect or on subsequent access to the api - i.e. is there a databasic or TCL call that is crashing the back end process - if you are using some of the extended u2 functions like the xml api or http api you may need to set your LANG variables differently. Rgds Symeon. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Martel, Henry Sent: 12 January 2009 18:20 To: u2-users@listserver.u2ug.org
RE: [U2] UD license counter
I appreciate all the help this forum provides to me so here's my chance to give back a little. Here is a link where you can find a sanitized version of the web service, desktop gadget and subroutine. Enjoy On Fri, 2008-09-12 at 11:52 -0500, Jeff Powell wrote: But I'll need to sanitize them first. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD license counter
Sorry, The Html link was stripped out. http://ipstulsa-lnx3.ipipes.com On Mon, 2008-09-15 at 09:34 -0500, Jeff Powell wrote: I appreciate all the help this forum provides to me so here's my chance to give back a little. Here is a link where you can find a sanitized version of the web service, desktop gadget and subroutine. Enjoy On Fri, 2008-09-12 at 11:52 -0500, Jeff Powell wrote: But I'll need to sanitize them first. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD license counter
Thanks John. Here's what I did with Kevin's help. 1. Created a subroutine that accepts one parameter and returns the value of the user specified system variable. 2. Wrote a glassfish webservice that calls that subroutine and returns the value. 3. Wrote a java desktop gadget that hits the web service every nnn seconds and displays the value. This gadget can be run on many desktops simultaneously. I'll add logging later the capture max/min/avg etc. Thanks again. Jeff --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD license counter
Sure, But I'll need to sanitize them first. On Fri, 2008-09-12 at 09:47 -0400, Israel, John R. wrote: Jeff, That sounds kinda cool. If you are agreeable, would you send me copies of these so I can look at this? While this will not change what we do here, it sounds very interesting and I am always wanting to learn. John Israel [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Friday, September 12, 2008 8:53 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD license counter Thanks John. Here's what I did with Kevin's help. 1. Created a subroutine that accepts one parameter and returns the value of the user specified system variable. 2. Wrote a glassfish webservice that calls that subroutine and returns the value. 3. Wrote a java desktop gadget that hits the web service every nnn seconds and displays the value. This gadget can be run on many desktops simultaneously. I'll add logging later the capture max/min/avg etc. Thanks again. Jeff --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD license counter
I there a quick way to fetch the current number of licenses used? I want to track usage and set an alarm trigger. TIA AIX5.3 SB+5.3.8 UD 7.1 Server+3 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UD license counter
Thanks Kevin. This worked great. On Thu, 2008-09-11 at 08:15 -0600, Kevin King wrote: Is there a quick way to fetch the current number of licenses used? According to the documentation, SYSTEM(514) will return the number of users logged in, sans phantoms. SYSTEM(51) also purportedly returns information about device licensing, but I've not used either to be able to tell you any more details than this. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] IP address of Users
Bill, There are some differences in our environment. We use SBClient to access UD running on AIX. All of our users usually log in through the same PC every day although their DHCP provided IP addresses will change. Our device licensing isn't configured through the terminal software but instead through the .profile in the user's home directory. Our problem was that we were seeing stale IP addresses with the AIX listuser command as well as in the SB+ USER.ID file. This was causing some messaging services to fail. I've contacted the programmer who wrote this to see if he thinks his code would solve your problem as well. HTH On Mon, 2008-09-08 at 11:15 -0700, Bill Haskett wrote: Jeff: Thanks for the idea. I did that too and use SYSTEM(512) to write the IP address. This IP address is the same as the one on the list-users listing if the checkbox in wIntegrate and AccuTerm is checked to allow device licensing; it's correct if the checkbox isn't checked. Does your code actually reflect a difference between device licensing being checked/unchecked on the client? Are you using Windows? How are you getting the IP address; through U2 or through the O/S? Thanks, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Sunday, September 07, 2008 5:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] IP address of Users Bill, We had a similar issue at my company. I asked a consultant to write a program that updates a record whenever someone logs in. The last login ip is the one that is retrieved. If you'd like more info contact me offline. Jeff On Sun, 2008-09-07 at 14:37 -0700, Bill Haskett wrote: I've been having trouble figuring out the IP address of users on a UD system when Device Licensing is turned on at the client. The IP address of all external users is their internal IP address. For instance. [snipped] As soon as I turn off device licensing on the client software (wIntegrate or AccuTerm) I get the correct IP address; but, of course, device licensing doesn't work and my license usage goes up. Is this a bug? Does IBM know about this? Is there another system variable I can get this information from instead of SYSTEM(512) (Windows only)? Thanks, Bill Haskett Advantos Systems, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] IP address of Users
Bill, We had a similar issue at my company. I asked a consultant to write a program that updates a record whenever someone logs in. The last login ip is the one that is retrieved. If you'd like more info contact me offline. Jeff On Sun, 2008-09-07 at 14:37 -0700, Bill Haskett wrote: I've been having trouble figuring out the IP address of users on a UD system when Device Licensing is turned on at the client. The IP address of all external users is their internal IP address. For instance. 3 Dev (0)- lu Licensed(UDT+CP)/Effective Udt Sql iPhtm Pooled Total ( 24 + 1 ) / 25 3 0 0 0 3 UDTNO USRNBR UID USRNAME USRTYPE TTYIP-ADDRESSTIME DATE 1 2580 197615 myuserphantom pts/1 Console 10:42:05 Aug 29 2008 2 3488 197640 designbai udt pts/2 udcs 14:04:53 Sep 07 2008 3 2108 197615 myuserudt pts/3 192.168.1.101 13:31:04 Sep 07 2008 4 2072 197615 myuserudt pts/4 192.168.1.101 14:07:21 Sep 07 2008 5984 197640 designbai udt pts/5 192.168.0.2 13:40:19 Sep 07 2008 3 Dev (0)- This shows the user on port #5 is coming from 192.168.0.2 when in reality they're coming from some IP address in southern California. 192.168.0.2 is the internal IP address of the client machine making the connection. As soon as I turn off device licensing on the client software (wIntegrate or AccuTerm) I get the correct IP address; but, of course, device licensing doesn't work and my license usage goes up. Is this a bug? Does IBM know about this? Is there another system variable I can get this information from instead of SYSTEM(512) (Windows only)? Thanks, Bill Haskett Advantos Systems, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uniobjects help needed!
May I add my experience here? 1. A uniobjects daemon application timed out and dropped the connection after 1 hour of inactivity. This was resolved by having a periodic tick that performs a command, reads a record or calls a subroutine. I now have a java servlet/service that keeps a persistent connection through a timer thread that ticks every 15 minutes. 2. I would run out of licenses until I realized I must explicitly disconnect the session. Each uniobjects session requires a license unless you have device licensing. 3. On my VB applications I connect only when I need them and then disconnect. Most connections last less than one second so I don't consume a license for very long. 4. Session.IsActive is useless. On Wed, 2008-08-06 at 09:27 +0100, Anthony Youngman wrote: I've looked up the notes on our error and found the following The object invoked has disconnected from its clients (-2147417848) I don't know where that came from but it's the same error that you've got, and I guess we found that somewhere in some documentation on OLE or whatever. So what is happening is that the connection between UniObjects and your VB app has disapppeared (note with us it was our app and Word that stopped talking to each other, both running on the same PC if I've got it right). So it looks like it's local to the affected PC(s), and is a time-out issue. Good luck tracking it down - it took us ages! Have you tried explicitly trapping that error and just retrying the read? You saying UniObjects just dies looks a good clue - it might well have gone to sleep ... we found the failed connection attempt woke Word up again so that the second try worked. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco Sent: 06 August 2008 03:34 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uniobjects help needed! Hello all, I was joking about the voodoo chants when I first posted but several days later and little progress made I am now seriously willing to consider any chants anyone knows. on a more serious note does anyone know if it's possible to talk directly to a uvrpc daemon? (uniobjects) I know you can with smtp and other socket programs if you know the language/syntax, so I think it should be possible with uvrpc (uniobjects). Any suggestions/ideas on how (if possible) to do this would be appreciated! What we are seeing are users (who are ALL using the EXACT same VB 6 program) having problems with writes and receiving back corrupted data (to a universe database using uniobjects). We have turned on logging in uniobjects but I am having some trouble reading the log files (its hard to tell if the corruption is coming to uniobjects or from universe). We have tested the universe programs that the VB app. calls and they work exactly as they should. We have tested the VB 6 apps and they too appear to be working as expected (but obviously something is wrong)/ We have tested/checked/rebooted the entire network (to include the aix machine). What is throwing me is that if the basic program does not find a match to whatever was passed to it, it returns null but sometimes we get back garbage to the VB app, which to me means that the basic program got a valid value and returned a valid response that somewhere in the chain got corrupted. We have even done an iptrace on the aix box to see what it gets/sends as well as on the windows PC(s) but sadly I am not able to fully comprehend what I am seeing. If anyone is willing (and this is asking a lot, so please forgive me) to look at an iptrace I would be incredibly grateful! I have two trace files, 1. one from a windows PC that was not able to edit an order 2. one that logged all the traffic coming/going to the aix machine on the uvrpc port any suggestions/chants/thoughts would be extremely welcome! I hope all this makes sense, if not this is what working 96+ hours in the last 7 days does to you thanks again dougc -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony W. Youngman Sent: Sunday, August 03, 2008 12:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uniobjects help needed! In message [EMAIL PROTECTED], doug chanco [EMAIL PROTECTED] writes Hey, We are having a problem with uniobjects that started a couple of days ago. We have a VB app that uses uniobjects to access an aix system running universe 10.1 and a few days ago we started getting errors where uniobjects would just die, its starting to look like it might be a network issue but so far nothing we can discover. Our Cisco guy is not seeing any errors in the cisco switches, I am not seeing any errors on the aix system (5.2.6). While is may or may not be a universe/uniobjects issue, so far we have been stumped as to what the problem is. We even called an IBM uniobjects engineer
Re: [U2] Linux Telnet client
SBClient will run under wine. I haven't test SUSE but I run fedora. I found that you must remove the spaces from the install directory. On Wed, 2008-08-06 at 17:24 -0500, Baker Hughes wrote: Hey, I've just changed the OS on my laptop to SUSE Linux. I got back hours of my life, just in boot time alone, but I won't rant. Would anyone like to suggest their favorite *nix based telnet client? Must be free or close to it. If it would handle UV device licensing that would be fantastic (and could perhaps have implications in our desktop group, if you know what I mean). Baker the world is so beautiful out of MS prison Hughes --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Green Software - Green Business
Well Susan, my company makes it's money selling products to manufacturers of oil and natural gas equipment. I tried to bring up the subject of telecommuting and was laughed out of the room. My motives were however purely selfish as I don't like pouring $40-$50 a week down the filler tube on my car. We are trying to go paperless. We print thousands of sheets of paper, then scan and shred them once we're done writing on them. Oh well ... going green is not on the radar anytime soon. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] grep for @VM
Try this: grep 12$'\xfd'26 * On Mon, 2008-07-14 at 15:06 -0400, David Beahm wrote: I am trying to find an obscure setting somewhere in a UD database on HP-UX; I know that the character string is [EMAIL PROTECTED] Can anyone tell me how to grep for this combination of alpha and high-ASCII characters so I can resolve a recurring accounting issue? Thanks in advance, David Beahm --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Uniobjects for Java
I usually check the length 0 after I check for null. On Mon, 2008-06-16 at 13:53 -0500, [EMAIL PROTECTED] wrote: Using Java with Uniobjects for Java to call a UniBasic routine. The UniBasic routine has two parameters; part number and result (html code). As long as it is passed a valid part number, it works OK. However, when the part number is not valid it returns an empty string RESULT = '' (two single quotes). The Java class method checks for an empty string and returns null if it finds one *** OpenU2Session(); UniSubroutine uSub = uSession.subroutine(GetInventoryStatus, 2); uSub.setArg(0, partnum); uSub.call(); result = uSub.getArg(1); CloseU2Session(); if(result == ) { return null; } else { return result; } The php action that calls the class method checks for null and behaves accordingly. $result = $U2-GetInventoryStatus($partnumber); if($result) { echo $result; } else { echo No information found for + $partnumber; } The problem is that when the Java routine checks the result from the UniBasic sub, it doesn't seem to see the empty string as an empty string. Does anyone know what is happening here? Is there a better way to indicate an empty string Charles Shaffer Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[Fwd: Re: [U2] UOJ and value-mark and field-mark]
Here is the main class. I use a wrapper class similar to the one you created to provide access to the UOJ library. My environments are RHEL 4.5, Fedora 8, Fedora 9 using console, desktop application, tomcat and glassfish. I use Netbeans as my development environment. I hope this helps. package uojcounter; import asjava.uniclientlibs.UniDynArray; import asjava.uniclientlibs.UniString; import com.ips.controller.unidata; /** * * @author jpowell */ public class Main { /** * @param args the command line arguments */ public static void main(String[] args) { unidata ud=new unidata(your_unidata_server,your_ud_account,joe_user,joes_password); o;?// opens file and keeps reference in a map key=filename, value=unifile ud.newFile(ORDER.LINE); // Write a new record //UniDynArray test=new UniDynArray(); //test.replace(1, 1, F1.1); //test.replace(1, 2, F1.2); //test.replace(2, F2); //test.replace(3, F3); //ud.Write(TEST!REC, test, MTR.IPS); // read from the file UniString str=ud.Read(100T0154145!29, ORDER.LINE); UniDynArray udr=ud.Read(100T0154145!29, ORDER.LINE); System.out.println(UniString: +str.dcount()); System.out.println(UniDynArray:+udr.dcount() ); System.out.println(UniString: F136 +str.dcount(136)); System.out.println(UniDynArray: F1326 +udr.dcount(136) ); ud.CloseFiles(); ud.disconnect(); // TODO code application logic here } } --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UOJ and value-mark and field-mark
Sorry I meant to type LANG=en_US.iso886915. This is a known limitation I learned of in IBM's UOJ class. Note the difference below. In this sample Attribute 136 is MV with 8 @VM marks as viewed in screen edit. Default: LANG=en_US.utf8 [EMAIL PROTECTED] uojCounter]$ java -jar dist/uojCounter.jar UniString: 273 UniDynArray:273 UniString: F136 1 UniDynArray: F136 1 [EMAIL PROTECTED] uojCounter]$ LANG=en_US.iso885915 java -jar dist/uojCounter.jar UniString: 218 UniDynArray:218 UniString: F136 1 UniDynArray: F136 9 On Mon, 2008-06-09 at 23:05 -0700, waivic wrote: Jeff, I try your suggestion: export LANG=iso885915. It doesn't look like working neither. It has the same effect with LANG variable set to C. Any other suggestion? Jeff Powell wrote: Try setting yourLANG variable before executing your program. export LANG=iso885915 This is a Linux only problem with UOJ. It is the same for java apps and servlets. On Mon, 2008-06-02 at 16:17 -0700, waivic wrote: I have a very simple file-TESTS, which only has 4 fields: @ID field, F1, F2 and F3. F1 is a single value field, F2 is a multi-value field and the value is one value-mark-separated list, F3 is a single value field. It has the following sample record in the file: Field Name Value @ID t101 F1 F1V1 F2 F2V1:@VM:F2V2 F3 F3V1 I use the following UniObject for Java code segment to retrieve the record t101 from the file: //uSession is a UniSession Oject uSession.connect(); //Open a file variable to TESTS file. UniFile testFile = uSession.open(TESTS); //Read the record out String key = t101; UniStirng uString = personFile.read(key); System.out.println(bthe full record:b+uString); System.out.println(bthe number of fields in the file:b +uString.dcount()); When I print out the contents of the record, it looks like UOJ converts all the value marks at the field F2 into the field mark. When I use dcount() function to count the number of fields in the output, it returns 5, instead of 4. I think the correct result should be 4 since only 4 fields (@ID field, F1, F2 and F3) in the file. It seems that read() function converts all the value-marks into the field-marks. So the values at the field-F2: F2V1:@VM:F2V2 becomes F2:@FM:F2V2. That is why I got 5 instead of 4 when we use dcount() to count the number of fields in the output. We are running Unidata 7.1 in Red hat Linux server. I already set the environment variable LANG to bCb. I even tried to set LANG to ben_USb. Both times, the UOJ program returned the same result. Does anyone know how this happens? I want to keep the original value-marks and field-marks after using read() function. Please advice. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Correction: Re: [U2] UOJ and value-mark and field-mark
Sorry I meant to type LANG=en_US.iso885915. This is a known limitation I learned of in IBM's UOJ class. Note the difference below. In this sample Attribute 136 is MV with 8 @VM marks as viewed in screen edit. Default: LANG=en_US.utf8 [EMAIL PROTECTED] uojCounter]$ java -jar dist/uojCounter.jar UniString: 273 UniDynArray:273 UniString: F136 1 UniDynArray: F136 1 [EMAIL PROTECTED] uojCounter]$ LANG=en_US.iso885915 java -jar dist/uojCounter.jar UniString: 218 UniDynArray:218 UniString: F136 1 UniDynArray: F136 9 On Mon, 2008-06-09 at 23:05 -0700, waivic wrote: Jeff, I try your suggestion: export LANG=iso885915. It doesn't look like working neither. It has the same effect with LANG variable set to C. Any other suggestion? Jeff Powell wrote: Try setting yourLANG variable before executing your program. export LANG=iso885915 This is a Linux only problem with UOJ. It is the same for java apps and servlets. On Mon, 2008-06-02 at 16:17 -0700, waivic wrote: I have a very simple file-TESTS, which only has 4 fields: @ID field, F1, F2 and F3. F1 is a single value field, F2 is a multi-value field and the value is one value-mark-separated list, F3 is a single value field. It has the following sample record in the file: Field Name Value @ID t101 F1 F1V1 F2 F2V1:@VM:F2V2 F3 F3V1 I use the following UniObject for Java code segment to retrieve the record t101 from the file: //uSession is a UniSession Oject uSession.connect(); //Open a file variable to TESTS file. UniFile testFile = uSession.open(TESTS); //Read the record out String key = t101; UniStirng uString = personFile.read(key); System.out.println(bthe full record:b+uString); System.out.println(bthe number of fields in the file:b +uString.dcount()); When I print out the contents of the record, it looks like UOJ converts all the value marks at the field F2 into the field mark. When I use dcount() function to count the number of fields in the output, it returns 5, instead of 4. I think the correct result should be 4 since only 4 fields (@ID field, F1, F2 and F3) in the file. It seems that read() function converts all the value-marks into the field-marks. So the values at the field-F2: F2V1:@VM:F2V2 becomes F2:@FM:F2V2. That is why I got 5 instead of 4 when we use dcount() to count the number of fields in the output. We are running Unidata 7.1 in Red hat Linux server. I already set the environment variable LANG to bCb. I even tried to set LANG to ben_USb. Both times, the UOJ program returned the same result. Does anyone know how this happens? I want to keep the original value-marks and field-marks after using read() function. Please advice. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wsdl
o;?Symeon, My manual (Version 6.0) don't have any reference to SOAP. Is this UV only? I have Unidata ver 6.1.15. Thanks. On Tue, 2008-06-03 at 15:19 +0100, Symeon Breen wrote: Hi yes - take a look at the unibasic extensions manual for the http and soap client functions. If you want an example I can provide some. Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Sent: 03 June 2008 13:39 To: u2-users@listserver.u2ug.org Subject: [U2] wsdl Are there any implementations of a unibasic program calling web service (jax-ws)? Our desire is to connect a SBClient screen to a web service interface hosted at one of our vendors. TIA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.24.6/1480 - Release Date: 6/3/2008 7:00 AM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] wsdl
Thanks Kevin, I downloaded the 6.1 series from IBM and it is in there. On Tue, 2008-06-03 at 16:08 -0600, Kevin King wrote: You should be able to find some info in the UniBASIC Extensions manual for 6.1. On Tue, Jun 3, 2008 at 2:42 PM, Jeff Powell [EMAIL PROTECTED] wrote: o;?Symeon, My manual (Version 6.0) don't have any reference to SOAP. Is this UV only? I have Unidata ver 6.1.15. Thanks. On Tue, 2008-06-03 at 15:19 +0100, Symeon Breen wrote: Hi yes - take a look at the unibasic extensions manual for the http and soap client functions. If you want an example I can provide some. Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Sent: 03 June 2008 13:39 To: u2-users@listserver.u2ug.org Subject: [U2] wsdl Are there any implementations of a unibasic program calling web service (jax-ws)? Our desire is to connect a SBClient screen to a web service interface hosted at one of our vendors. TIA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.24.6/1480 - Release Date: 6/3/2008 7:00 AM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Downloading and Installing RHEL Desktop 5.1 From Scratch
If you burned the CD correctly this is what you should see on the DVD when you put it in the drive and do a DIR on the drive. Cluster README-ja.html RELEASE-NOTES-en RELEASE-NOTES-ta.html RELEASE-NOTES-U1-or.html ClusterStorage README-kn.html RELEASE-NOTES-en.html RELEASE-NOTES-te.html RELEASE-NOTES-U1-pa.html EULAREADME-ko.html RELEASE-NOTES-es.html RELEASE-NOTES-U1-as.html RELEASE-NOTES-U1-pt_BR.html eula.en_US README-ml.html RELEASE-NOTES-fr.html RELEASE-NOTES-U1-bn.html RELEASE-NOTES-U1-ru.html GPL README-mr.html RELEASE-NOTES-gu.html RELEASE-NOTES-U1-de.html RELEASE-NOTES-U1-si.html images README-or.html RELEASE-NOTES-hi.html RELEASE-NOTES-U1-en RELEASE-NOTES-U1-ta.html isolinuxREADME-pa.html RELEASE-NOTES-it.html RELEASE-NOTES-U1-en.html RELEASE-NOTES-U1-te.html README-as.html README-pt_BR.html RELEASE-NOTES-ja.html RELEASE-NOTES-U1-es.html RELEASE-NOTES-U1-zh_CN.html README-bn.html README-ru.html RELEASE-NOTES-kn.html RELEASE-NOTES-U1-fr.html RELEASE-NOTES-U1-zh_TW.html README-de.html README-si.html RELEASE-NOTES-ko.html RELEASE-NOTES-U1-gu.html RELEASE-NOTES-zh_CN.html README-en README-ta.html RELEASE-NOTES-ml.html RELEASE-NOTES-U1-hi.html RELEASE-NOTES-zh_TW.html README-en.html README-te.html RELEASE-NOTES-mr.html RELEASE-NOTES-U1-it.html RPM-GPG-KEY-redhat-beta README-es.html README-zh_CN.html RELEASE-NOTES-or.html RELEASE-NOTES-U1-ja.html RPM-GPG-KEY-redhat-release README-fr.html README-zh_TW.html RELEASE-NOTES-pa.html RELEASE-NOTES-U1-kn.html Server README-gu.html RELEASE-NOTES-as.html RELEASE-NOTES-pt_BR.html RELEASE-NOTES-U1-ko.html TRANS.TBL README-hi.html RELEASE-NOTES-bn.html RELEASE-NOTES-ru.html RELEASE-NOTES-U1-ml.html VT README-it.html RELEASE-NOTES-de.html RELEASE-NOTES-si.html RELEASE-NOTES-U1-mr.html On Sat, 2008-04-19 at 12:08 -0700, Dave Taylor wrote: Well, here it is Saturday morning and my long-anticipated weekend project of installing Universe on Linux has just come to a screeching halt. I downloaded RHEL 5.1 Desktop and burned the disk1 cd image to a CD-ROM using Windows XPPro. When I install the the CD-ROM on the new machine with only the CD-ROM drive designated as a bootable device, I get a message: Boot Error. System Halted. I tried to install it on my laptop and it failed to install there also. The CD-ROM drive read lite came on in both cases, so I believe that it's reading the CD-ROM but not finding what it expects to find. Using Explorer to view the download or the burned image, I see only one icon representing an unknown file type. I don't see any individual folders or files within the image. To fail this early in the process suggests that I'm doing something very wrong. Any suggestions? tia, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata Training
Kevin at PrecisOnline.com does training. Check out his courses at http://precisonline.com/train.html On Fri, 2008-04-11 at 13:03 -0400, Duffin, Gregory J wrote: Can anyone suggest a company that provides Unidata training, besides IBM? I have tried to get training several times through IBM but they keep canceling the class due to low attendance. Any books that can be recommended would be helpful also. Thank You Greg --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Socket API problem
Nick, Would device licensing be useful in your environment? We have device licensing and with this all outside connections from the same IP address only consume 1 license. We use this scenario to have several uniobject clients (java servlets and applications) run from a server and therefore only using one license per machine rather than per process. Jeff On Thu, 2007-08-02 at 08:46 -0400, Nick Cipollina wrote: All of your suggestions are very good, the problem is that all of these solutions will introduce too much overhead. I know that a lot of the overhead is very, very minimal, but we cannot afford ANY overhead at all. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Thursday, August 02, 2007 6:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Socket API problem Hi Nick, I don't have an answer to your licensing problem, but have you considered running your listener from inetd or a similar superserver? In this setup your inetd daemon (or service on windows) listens on your known port, when a request comes in the superserver starts a UV process to handle the incoming request (received on stdin so get the data with INPUT or GETS) send your response using print. This is slightly slower per request than prestarting all your phantoms but you only use as many licences as your peak load and if you have one of the more advanced inetd versions you can limit the maximum number of simultaneous requests (other requests will be queued by inetd). I have implemented a HTTP server using this setup and other than the uv licensing cost it works well. regards, Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniSubroutine error
Does anyone know what 30102 (unknown) code means? Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniSubroutine error
It was a case sensitive issue with data passed in from the user-program to the subroutine. Thanks for pointing me in the right direction. On Tue, 2007-07-31 at 10:26 -0500, Jeff Powell wrote: Does anyone know what 30102 (unknown) code means? Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Device Licensing
Phil, What happens when you open a dos box (on the 2003 server) and type nslookup your_uv_host_here? Also, have you tried using the IP address of your target host? To open a dos box on win2k3 from the start menu select run and type cmd in the dialog. You should get a console with a black background. It seems to me that your Win2k3 server isn't resolving the host by name. This could be a DNS issue. If so check to see if your domains match between the win2k win2k3 machines. Jeff On Sun, 2007-07-29 at 22:28 +1200, phil walker wrote: Hi all, Okay, I now have the following cases: DynamicConnect and Telnet on PC running Windows 2000 logged in locally - works AccuTerm and Telnet on PC running Windows 2000 logged in locally - works AccuTerm and SSH on PC running Windows 2000 logged in locally - works Accuterm and SSH on PC running Windows 2000 Server logged in via RDP - works DynamicConnect and Telnet on PC running Windows 2000 logged in via RDP - works Accuterm and SSH on PC running Windows 2003 Server Service Pack 1 or 2 - does not work DynamicConnect and Telnet on PC running Windows 2003 Server Service Pack 1 or 2 - does not work Get the following error messages in U2devlic.err file in directory: 11:26:08 06/28/07 pid = 3180 U2GetMachId(): unable to get host information of hostname Error = 131 12:56:16 06/28/07 pid = 1748 U2GetMachId(): unable to get host information of hostname Error = 183 During the uv login process a return is required to continue the login. This is before the license check is done, as if there are no licenses available this is displayed after pressing the return. When System(51) is displayed it shows 0.0.0.0 For the other scenarios which work, no return is required to complete the login process. System(51) displays the correct information and multiple sessions can be established under the same license. Interesting is that I RDP into the box A which is running Windows 2003 Server from my remote office through the corporate firewall and then RDP into box B which is running Windows 2000 and connect via AccuTerm then this works and System(51) gives the information pertaining to box A. However when I try and connect via AccuTerm directly from box A, then it does not. A firewall issue, or a Windows 2003 Server issue. Has anyone got U2 Device Licensing running under Windows 2003 Server or through a firewall? I suspect the U2GetMachId() function is doing something which is getting blocked by something What though?? Any ideas anyone??? Cheers, Phil. As others have posted: Device Licensing works for both U2 databases as long as you have a license which is one of: * Workgroup * Enterprise * Server with device licensing (a recent offering) In order that this will work you need a TELNET client that supports Device Licensing, and as there have been some changes in DL internals over time they should also concurrent in release - ideally (of course) the latest releases or fairly close. IBM supply SBClient, wIntegrate and Dynamic as Telnet clients that work with DL - on wIntegrate and DC you need to remember to check the Use Device Licensing on Unix check box if that is you server platform. DL will also work with UniObjects and ODBC (for example) thought you should read up on the use of subkeys for UO. Some 3rd parties have arrangements with IBM to use the DL software libraries with their software, and they offer DL compatibility with their TELNET clients. It is worth noting the point above though, DL internals have changed over time. You might find that older versions of the TELNET clients may not work correctly froma DL viewpoint with more recent copies of the databases. That being the case then an upgrade from your friendly local TELNET client provider to a current build with updated software should resolve it. Issues which got in the way in the past related mostly to combinations of stty settings in Unix, all (even vaguely) recent versions got the code modified so that's not an issue. There was also an issue more recent) where ODBC sessions (for example) used a different DL user pool to TELNET sessions. So ODBC would allow up to 10 sessions as one license, and TELNET would do the same - but each connection would use a separate slot. In those circumstances (for example) one UO and one TELNET would take 2 licenses (fixed). Always a useful test - try using Dynamic Connect from the current client softwarethat should work fine and act as a check on any 3rd party software. Hoping this answers any queries - please post if any follow-ups. Regards JayJay --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit
RE: [U2] Device Licensing
Phil, What happens when you open a dos box (on the 2003 server) and type nslookup your_uv_host_here? Also, have you tried using the IP address of your target host? To open a dos box on win2k3 from the start menu select run and type cmd in the dialog. You should get a console with a black background. It seems to me that your Win2k3 server isn't resolving the host by name. This could be a DNS issue. If so check to see if your domains match between the win2k win2k3 machines. Jeff On Sun, 2007-07-29 at 22:28 +1200, phil walker wrote: Hi all, Okay, I now have the following cases: DynamicConnect and Telnet on PC running Windows 2000 logged in locally - works AccuTerm and Telnet on PC running Windows 2000 logged in locally - works AccuTerm and SSH on PC running Windows 2000 logged in locally - works Accuterm and SSH on PC running Windows 2000 Server logged in via RDP - works DynamicConnect and Telnet on PC running Windows 2000 logged in via RDP - works Accuterm and SSH on PC running Windows 2003 Server Service Pack 1 or 2 - does not work DynamicConnect and Telnet on PC running Windows 2003 Server Service Pack 1 or 2 - does not work Get the following error messages in U2devlic.err file in directory: 11:26:08 06/28/07 pid = 3180 U2GetMachId(): unable to get host information of hostname Error = 131 12:56:16 06/28/07 pid = 1748 U2GetMachId(): unable to get host information of hostname Error = 183 During the uv login process a return is required to continue the login. This is before the license check is done, as if there are no licenses available this is displayed after pressing the return. When System(51) is displayed it shows 0.0.0.0 For the other scenarios which work, no return is required to complete the login process. System(51) displays the correct information and multiple sessions can be established under the same license. Interesting is that I RDP into the box A which is running Windows 2003 Server from my remote office through the corporate firewall and then RDP into box B which is running Windows 2000 and connect via AccuTerm then this works and System(51) gives the information pertaining to box A. However when I try and connect via AccuTerm directly from box A, then it does not. A firewall issue, or a Windows 2003 Server issue. Has anyone got U2 Device Licensing running under Windows 2003 Server or through a firewall? I suspect the U2GetMachId() function is doing something which is getting blocked by something What though?? Any ideas anyone??? Cheers, Phil. As others have posted: Device Licensing works for both U2 databases as long as you have a license which is one of: * Workgroup * Enterprise * Server with device licensing (a recent offering) In order that this will work you need a TELNET client that supports Device Licensing, and as there have been some changes in DL internals over time they should also concurrent in release - ideally (of course) the latest releases or fairly close. IBM supply SBClient, wIntegrate and Dynamic as Telnet clients that work with DL - on wIntegrate and DC you need to remember to check the Use Device Licensing on Unix check box if that is you server platform. DL will also work with UniObjects and ODBC (for example) thought you should read up on the use of subkeys for UO. Some 3rd parties have arrangements with IBM to use the DL software libraries with their software, and they offer DL compatibility with their TELNET clients. It is worth noting the point above though, DL internals have changed over time. You might find that older versions of the TELNET clients may not work correctly froma DL viewpoint with more recent copies of the databases. That being the case then an upgrade from your friendly local TELNET client provider to a current build with updated software should resolve it. Issues which got in the way in the past related mostly to combinations of stty settings in Unix, all (even vaguely) recent versions got the code modified so that's not an issue. There was also an issue more recent) where ODBC sessions (for example) used a different DL user pool to TELNET sessions. So ODBC would allow up to 10 sessions as one license, and TELNET would do the same - but each connection would use a separate slot. In those circumstances (for example) one UO and one TELNET would take 2 licenses (fixed). Always a useful test - try using Dynamic Connect from the current client softwarethat should work fine and act as a check on any 3rd party software. Hoping this answers any queries - please post if any follow-ups. Regards JayJay --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit
Re: [U2] Does UniDynArray of UOJ behave differently in Unix/Linux?
Yes, I just tried LANG=C, LANG=ja_JP.iso885915 and LANG=en_UK.iso885915 and only LANG=en_US.iso885915 works. On Mon, 2007-07-23 at 22:32 -0700, waivic wrote: I need to set LANG=en_US in order for the codes working in our system. Wai waivic wrote: We have a Unidata 7.1 runing on a Redhat Linux server. I build a subroutine X.SUB1(XL.INPUTS, X.OUTPUT). XL.INPUTS is a dynamic array list; X.OUTPUT is the output. b b When I run the above UniObject codes in True Unix 64 environment, XL.INPUTS correctly get the input values and X.SUB1 is being run correctly. However, when I run the above UniObject codes in Red Hat Linux environment, the XL.INPUTS doesnbt being populated with the correct values from the input UniDynArray-inputArray. I have two questions: 1. Does anyone know the reason why this happens? 2. Do I use the correct way to pass in an array of values to a subroutine with UOJ? Is there any better way to pass in an array of values through UOJ? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Does UniDynArray of UOJ behave differently in Unix/Linux?
Wai, You can set this immediately before you call to the java program in a shell script. I do this regularly. I also set /etc/sysconfig/i18n on some systems to choose this as a system wide default. It does not adversely effect the operation of the system in any way. This is handy since all processes that might use uoj (tomcat, java, etc) will automatically benefit from it. I hope this helps. Jeff On Mon, 2007-07-23 at 22:32 -0700, waivic wrote: I need to set LANG=en_US in order for the codes working in our system. Wai waivic wrote: We have a Unidata 7.1 runing on a Redhat Linux server. I build a subroutine X.SUB1(XL.INPUTS, X.OUTPUT). XL.INPUTS is a dynamic array list; X.OUTPUT is the output. b b When I run the above UniObject codes in True Unix 64 environment, XL.INPUTS correctly get the input values and X.SUB1 is being run correctly. However, when I run the above UniObject codes in Red Hat Linux environment, the XL.INPUTS doesnbt being populated with the correct values from the input UniDynArray-inputArray. I have two questions: 1. Does anyone know the reason why this happens? 2. Do I use the correct way to pass in an array of values to a subroutine with UOJ? Is there any better way to pass in an array of values through UOJ? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Does UniDynArray of UOJ behave differently in Unix/Linux?
On Linux I have found the UOJ needs LANG=en_US.iso885915 On Mon, 2007-07-23 at 00:05 -0700, waivic wrote: We have a Unidata 7.1 runing on a Redhat Linux server. I build a subroutine X.SUB1(XL.INPUTS, X.OUTPUT). XL.INPUTS is a dynamic array list; X.OUTPUT is the output. I need to call X.SUB1 through UniObject for Java, I have the following codes (_uniSession is a UniSession Object): UniSubroutine uSub = _uniSession.subroutine(X.SUB1, 2); UniDynArray inputArray = _uniSession.dynArray(); inputArray.insert(1, 1, bF1V1b); inputArray.insert(1, 2, bF1V2b); inputArray.insert(1, 3, bF1V3b); inputArray.insert(2, 1, bF2V1b); inputArray.insert(2, 2, bF2V2b); inputArray.insert(2, 3, bF2V3b); ... ... UniDynArray returnValue=_uniSession.dynArray(); uSub.setArg(0, inputArray); uSub.setArg(1, returnValue); uSub.call(); b b When I run the above UniObject codes in True Unix 64 environment, XL.INPUTS correctly get the input values and X.SUB1 is being run correctly. However, when I run the above UniObject codes in Red Hat Linux environment, the XL.INPUTS doesnbt being populated with the correct values from the input UniDynArray-inputArray. I have two questions: 1. Does anyone know the reason why this happens? 2. Do I use the correct way to pass in an array of values to a subroutine with UOJ? Is there any better way to pass in an array of values through UOJ? Any suggestion is welcomed. Thanks a lot! Wai --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [Fwd: UniObjects Disconnect Issue]
Michael, I think this is the correct forum. I also use uniobjects for JAVA but unfortunately I don't have v7 so I can't help you either. Jeff On Thu, 2007-07-19 at 17:33 -0400, Michael Sprague wrote: I didn't hear from anyone on this. Does anyone have a suggestion on where else I might find an answer? Perhaps this is the wrong list to post to? Thank you, Mike ___ *Michael J. Sprague / Director, Web Services* Hamilton College http://www.hamilton.edu / 198 College Hill Road / Clinton, NY 13323 [EMAIL PROTECTED] / 315-859-4087 office / 315-794-6831 mobile /Thursday, July 19, 2007 5:33 PM (Thunderbird 2.0.0.4) / Original Message Subject: UniObjects Disconnect Issue Date: Wed, 18 Jul 2007 12:01:37 -0400 From: Michael Sprague [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Hello all, We've been using UniObjects middleware to connect to UniData for developing Web applications. We've always used the middleware that came with v6 of UniData. We have been unable to use the middleware from v7. I was wondering if anyone might be able to identify what we are doing wrong. We are connecting to UniData 7. This code works with the v6 middleware, but does not work with v7 objConn.setHostName(ourhost.ourcollege.edu); objConn.setaccountpath(/valid/path/to/home/); objConn.setUserName(ourusername); objConn.setPassword(ourpassword); objConn.connect(); webgetapp = objConn.subroutine(SUB.ROUT.INE,2); webgetapp.setArg(0,); webgetapp.setArg(1,somevalue); webgetapp.call(); getAppResults = webgetapp.getArg(0) objConn.disconnect(); On v6 middleware, this return the results properly in the getAppResults variable. On v7 middleware, it does this... An exception occurred when executing method disconnect. java.lang.NullPointerException at asjava.uniobjects.UniJava.closeSessionInternal(UniJava.java:225) at asjava.uniobjects.UniSession.disconnect(UniSession.java:535) Any thoughts? We'd eventually like to get our middleware up to a more recent version to take advantage of some new features. -Mike ___ *Michael J. Sprague / Director, Web Services* Hamilton College http://www.hamilton.edu / 198 College Hill Road / Clinton, NY 13323 [EMAIL PROTECTED] / 315-859-4087 office / 315-794-6831 mobile /Wednesday, July 18, 2007 12:00 PM (Thunderbird 2.0.0.4) / --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObjects / Read Timeout
I am running a long select via UniQuery and I'm getting a timeout. Is there a parameter I can change to increase the timeout? This operation will be done during the server's low utilization period. I'm using uniobjects for java on a linux (rhel es4.5) server connecting to unidata on a rs/6000 aix 5.3. Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects / Read Timeout
Tony, Great idea. I have the added luxury that the user will not interact with this program. My goal is to bounce the line items to a sql table during non-business hours then after some digestion serve that up to the user through standard sql queries to the now static data in the tables. I plan to look at this async approach. Perhaps write a scheduler job that will output to a saved list then set a flag or signal through a socket as Kevin King proposed. Thanks for your help. Jeff On Mon, 2007-03-12 at 14:02 -0700, Tony Gravagno wrote: Jeff Powell wrote: I am running a long select via UniQuery and I'm getting a timeout. Is there a parameter I can change to increase the timeout? This operation will be done during the server's low utilization period. I'm using uniobjects for java on a linux (rhel es4.5) server connecting to unidata on a rs/6000 aix 5.3. If it looks like you're going to be pushing timeouts significantly then it might be best to approach this asynchronously. Send the selection to a phantom on the server, generate a list, then use the list to process items from the client. Don't just phantom off the selection. Have a program do the selection, then write a unique tickler item when the selection is done. Your UO code can read for this item for some period of time, provide entertainment for the user between pings (hourglass, progressbar, some other animation). You can control the timeout simply by stopping the server pings and asking the user what they want to do. I've done this for long running reports called from web clients. If it takes more than about 20 seconds, or if there is a flag manually set that indicates a given report will undoubtedly take more than 20 seconds, I don't make the user wait. I give them a page they can check to see if their report is complete. For very long reports you can send an email with a link when a report is complete, or your remote client interface can periodically check pending reports from menus or other places, so that you can inform the user on-screen when a previous request is ready. HTH TG@ removethisNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects / Read Timeout
Thanks Brian. It's set to six minutes (3600). That's the default. Can you tell me what the Max value is? By the way I didn't get this message until after 6 CDT. I think the list is slow today. Thanks again. On Mon, 2007-03-12 at 19:53 +, Brian Leach wrote: You might want to take a look at the unirpcservices file on the server. This is a text file located in the unishared directory. The last entry on each line is a timeout value in 1/10th seconds. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: 12 March 2007 16:17 To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects / Read Timeout I am running a long select via UniQuery and I'm getting a timeout. Is there a parameter I can change to increase the timeout? This operation will be done during the server's low utilization period. I'm using uniobjects for java on a linux (rhel es4.5) server connecting to unidata on a rs/6000 aix 5.3. Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe/UniObjects and Visual Studio
Anthony, Here is a class I created for VB6 to retrieve line item information for a given order. I don't know about using any toolbox items but I do add the resources to the project then create the object. This class is actually used at my company to create a label that is affixed to a product. I hope you find some useful information here. Jeff On Sun, 2007-03-11 at 19:07 -0400, Anthony Dzikiewicz wrote: Hi guys, I am messing with Visual Basic Express edition. I was hoping to use UniObjects against my Universe Database. The examples in the UniObjects Developers Guide are a little outdated. How do I get the UniObjects to appear in the toolbar (if you can do this) ? They refer to Sub Form_Load, which I have seen in older versions of VB, but not VB 2005. Basically what I am looking for is a 'quick fix' for the 5 minute program example in the Developers Guide that has already taken me beyond that time frame. Thanks Anthony VERSION 1.0 CLASS BEGIN MultiUse = -1 'True Persistable = 0 'NotPersistable DataBindingBehavior = 0 'vbNone DataSourceBehavior = 0 'vbNone MTSTransactionMode = 0 'NotAnMTSObject END Attribute VB_Name = ud-access Attribute VB_GlobalNameSpace = False Attribute VB_Creatable = True Attribute VB_PredeclaredId = False Attribute VB_Exposed = False Dim Uni As Object Dim selList As UniSelectList Dim dynArray As UniDynArray Dim dynRec As Object Dim ordFile As UniFile Dim ordLineFile As UniFile Dim relLineFile As UniFile Dim custFile As UniFile Dim catFile As UniFile Dim prodFile As UniFile Dim rs() As CLabelRecord Public Sub GetRecords(stRefNum, Text1 As TextBox) 'On Error GoTo ErrorHandler Set Uni = CreateObject(UV_SESSION_OBJECT) Uni.AccountPath = /ud/YOUR-LIVE-ACCOUNT Uni.HostName = ud-server Uni.UserName = user Uni.Password = password ' UniSession.DataBaseType = 2 iRecCount = 0 iReleaseMode = 0 ' new flogic for scanner ' TUA7$PT$F$1/2 iStringEnd = InStr(1, stRefNum, $) If iStringEnd 0 Then stRefNum = Mid(stRefNum, 1, iStringEnd - 1) Text1.Text = stRefNum Text1.Refresh End If If Uni.Connect = True Then 'If Staging.Value = 1 Then If InStr(1, stRefNum, -) = 0 Then strSql = SELECT ORDER.LINE WITH ORD.NUM= UCase(stRefNum)BY ZONE.IPS BY SEQ.NUM TO 1 Else strSql = SELECT RELEASE.LINE WITH RELEASE.NUM= UCase(stRefNum)BY ZONE.IPS BY SEQ.NUM TO 1 iReleaseMode = 1 End If If Uni.IsActive Then Set ordFile = Uni.OpenFile(ORDER) If ordFile Is Nothing Then MsgBox ORDER not open Set ordLineFile = Uni.OpenFile(ORDER.LINE) If ordLineFile Is Nothing Then MsgBox ORDER.LINE not open Set relLineFile = Uni.OpenFile(RELEASE.LINE) If relLineFile Is Nothing Then MsgBox RELEASE.LINE not open Set custFile = Uni.OpenFile(CUSTOMER) If custFile Is Nothing Then MsgBox CUSTOMER not open Set catFile = Uni.OpenFile(CATEGORY) If catFile Is Nothing Then MsgBox CATEGORY not open Set prodFile = Uni.OpenFile(PRODUCT) If prodFile Is Nothing Then MsgBox PRODUCT not open 'DoMsg Looking up + UCase(Text1.Text) Uni.Command.Text = strSql Uni.Command.Exec ' Build the recordset from records received Set selList = Uni.SelectList(1) Set dynArray = selList.ReadList ' List of records ReDim rs(dynArray.Count) For iLineItemLoop = 1 To dynArray.Count Set rs(iLineItemLoop) = New CLabelRecord LineKey = dynArray.Value(iLineItemLoop, 0) OrderKey = Mid(LineKey, 1, 11) OrderNum = Mid(LineKey, 4, 8) If iReleaseMode = 1 Then relLineFile.RecordId = LineKey relLineFile.Read LineKey = relLineFile.Record.Value(2, 0) End If ordLineFile.RecordId = LineKey ordLineFile.Read ordFile.RecordId = OrderKey ordFile.Read ' Get information from the Order Header rs(iLineItemLoop).CustPoNum = ordFile.Record.Value(12, 0) ' Customer PO Number rs(iLineItemLoop).JobNum = ordFile.Record.Value(133, 0) ' Customer Job Number rs(iLineItemLoop).OrderNum = OrderNum rs(iLineItemLoop).RelNum = stRefNum rs(iLineItemLoop).CustLnNum = ordLineFile.Record.Value(92, 0) rs(iLineItemLoop).CustProdNum = ordLineFile.Record.Value(153, 0) rs(iLineItemLoop).PckQty = ordLineFile.Record.Value(38, 0) rs(iLineItemLoop).UnMeas = ordLineFile.Record.Value(103, 0) rs(iLineItemLoop).ProdNum = ordLineFile.Record.Value(27, 0)
Re: [U2] Installing UniObjects on Linux
Adrian, It may have something to do with my applet security posts. I was advised to use a jar rather than zip in my applet and it helped. I also know that you can't gcj compile the zip. Does that help? FYI I ditched the applet due to finding a better method of validating using java scripts and servlets. I did work but it was not user friendly in IE. Jeff On Thu, 2006-08-10 at 09:48 +1200, Adrian Merrall wrote: Dona, On 8/10/06, Dona Gibbons [EMAIL PROTECTED] wrote: Got it working on linux now. Moved the asjava.zip file into the lib directory of the java jdk folder and determine the classpath to work with it. Now I am trying to get the Unicommand to execute query paragraphs. One of these days I'll remember the class loader problems with zip's exactly. Sad or worrying because this exact issue came up a month or so back, my memory must be going. One of the class loaders will process jar files only, not zip files. I'm pretty sure this is Tomcat not the jre but if you fall into this problem, simply rename the zip as a jar and it will work. Regards, Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Printqueue question
I am looking for some suggestions on how to get an email notification from AIX when a print queue goes down rather than splashing an error message all over the user's SB+ screen. Has anyone done this before? I have an elaborate cron job set up to check the queues, parse the output and send a message if there is a problem. This just isn't fast enough anymore, I don't want too many crons sucking down system resources and it confuses the users when their SB+ screen looks strange. Any suggestions would be greatly appreciated Thanks, Jeff --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Please Post a VB 2005 Sample
I'm not sure what you need but here is a sample of reading a MV and writing either a new record or an additional MV. This is a VB6 example for UniData HTH VERSION 5.00 Object = {3ED50B81-0667-11D4-BE19-00104B2A91CE}#1.0#0; uniobjects.dll Begin VB.Form Form1 Caption = Form1 ClientHeight= 4245 ClientLeft = 60 ClientTop = 450 ClientWidth = 4680 LinkTopic = Form1 ScaleHeight = 4245 ScaleWidth = 4680 StartUpPosition = 3 'Windows Default Begin VB.CommandButton Command1 Caption = Command1 Height = 495 Left= 720 TabIndex= 5 Top = 3240 Width = 1575 End Begin VB.TextBox Text4 Height = 495 Left= 720 TabIndex= 4 Text= T0102513-1 Top = 2400 Width = 3855 End Begin VB.TextBox Text3 Height = 495 Left= 720 TabIndex= 3 Text= Test Image Top = 1680 Width = 3855 End Begin VB.TextBox Text2 Height = 495 Left= 720 TabIndex= 2 Text= http://domain.com/your-image-location; Top = 960 Width = 3855 End Begin VB.TextBox Text1 Height = 495 Left= 720 TabIndex= 0 Text= 100!POD!033 Top = 240 Width = 3855 End Begin VB.Label Label4 Caption = Ref. # Height = 255 Left= 120 TabIndex= 8 Top = 2520 Width = 495 End Begin VB.Label Label3 Caption = Desc. Height = 255 Left= 120 TabIndex= 7 Top = 1800 Width = 495 End Begin VB.Label Label2 Caption = Link Height = 255 Left= 120 TabIndex= 6 Top = 1080 Width = 495 End Begin UNIOBJECTSLibCtl.UnioaifCtrl Uni Left= 3960 OleObjectBlob = UniTest.frx: Top = 3600 End Begin VB.Label Label1 Caption = Key Height = 255 Left= 120 TabIndex= 1 Top = 360 Width = 375 End End Attribute VB_Name = Form1 Attribute VB_GlobalNameSpace = False Attribute VB_Creatable = False Attribute VB_PredeclaredId = True Attribute VB_Exposed = False Dim file As UniFile Dim rec As UniDynArray Dim MVIndex As Integer Private Sub Command1_Click() If Text1.Text = Or Text2.Text = Or Text3.Text = Or Text4.Text = Then MsgBox All fields required. Return End If myDate = Format(Now, dd/mm/yy) 'Uni.AccountPath = /ud/TEST ' Testing account Uni.AccountPath = /ud/IPS ' Production account Uni.HostName = prelude Uni.UserName = om ' Ossie's ghost provides good slave labor Uni.Password = omm' We can easily identify runaway processes by owner Uni.DataBaseType = 2 Uni.Connect If Uni.IsActive Then Set file = Uni.OpenFile(OIS.IMAGE) If file Is Nothing Then Uni.Disconnect PukeAndDie File Open Error End If file.RecordId = Text1.Text file.Read If file.Record Is Nothing Or file.Error 0 Then ' New Record Set rec = Uni.DynamicArray rec.Value(1, 1).Ins Text2.Text rec.Value(2, 1).Ins Text3.Text rec.Value(3, 1).Ins DateNow rec.Value(4, 1).Ins DateNow rec.Value(5, 1).Ins OM rec.Value(6, 1).Ins Text4.Text rec.Value(7, 1).Ins Y file.Record = rec Else ' Record exists. Add new multivalue MVIndex = file.Record.Field(1).Count + 1 file.Record.Value(1, MVIndex) = Text2.Text file.Record.Value(2, MVIndex) = Text3.Text file.Record.Value(3, MVIndex) = DateNow file.Record.Value(4, MVIndex) = DateNow file.Record.Value(5, MVIndex) = OM file.Record.Value(6, MVIndex) = Text4.Text file.Record.Value(7, MVIndex) = Y End If file.Write If file.Error 0 Then MsgBox File Error End If file.CloseFile Uni.Disconnect Else PukeAndDie Connection Failed End If End Sub Sub PukeAndDie(MsgText) MsgBox MsgText End End Sub --- u2-users mailing list
[U2] Solution to UniObjects security in an applet
Thank you to everyone who helped on this issue. My applet is now working. For those who may need to do this in the future I've summarized the issues below. Problem 1:Proxy server starting then dying without a whimper. Rename asjava.zip to asjava.jar - Thanks John Hester Problem 2:java.security.AccessControlException: access denied (java.net.SocketPermission 127.0.0.1:31448 connect,resolve) Applet was trying to connect to localhost instead of proxyserver. The client, proxy and web server were originally all on the same machine hence the typo in the connection. Problem 3:asjava.uniobjects.UniSessionException: The RPC failed Changed UOJ version asjava.zip from 1.1.1 to 2.0.1 Problem 4:java.security.AccessControlException: access denied (java.util.PropertyPermission file.encoding read) Added the following line to the client's java.policy file in the active JRE. permission java.util.PropertyPermission file.encoding, read; I wish there was a way to do #4 through software but in my case this works since I'll be pre-configure the client units for this application. Thanks again, Jeff --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects security in an applet
Wendy, The applet was trying to connect to localhost (thanks John H.). I changed the settings there and now I'm talking to my proxy. I now have a problem with my Proxy configuration. I am getting a exception on applets and java applications alike. asjava.uniobjects.UniSessionException: The RPC failed Here is an entry from my uniproxy log 06.06.15-21.35.42-C1539168Error: addConnection() The requested item does NOT exist. My uniproxy.config. This is an adaptation from Ch.3 or UOJ dev. Guide. PROXY_PORT=31448 ADMIN_PORT=31458 ADMIN_ACCESS_TOKEN=password1 BUFFER_SIZE=4096 DEBUG_LEVEL=0 MAX_CONNECTIONS=75 MAX_MULTIPLEXED_SERVERS=12 NAME_LOG=testLog PATH_LOG=/opt/udproxy/ NETWORK_TIMEOUT=12 ACCESS_TOKEN=password2 ACCESS_TOKEN_SERVER=localhost ACCESS_TOKEN_SERVER=localhosts_real_name ACCESS_TOKEN_SERVER=client1 ACCESS_TOKEN_SERVER=client2.workgroup.domain.com ACCESS_SERVER=my_ud_server I've tried reducing everything down to just an ACCESS_TOKEN but that gets the same results. The documentation states that any client providing the access token should be authorized for any server if there is only an access_token defined. On Fri, 2006-06-16 at 05:45 +0200, Wendy Smoak wrote: Same machine as what? An (unsigned) applet can only connect back to the server from which it was loaded. If you have a separate web server and database server, the proxy needs to be running on the web server. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/