Page 1 of 1
using JadLoad to automate extraction of schemas
Posted: Fri Aug 07, 2009 2:42 pm
by ConvertFromOldNGs
by CarlRanson >> Tue, 6 May 2003 23:54:40 GMT
Hi All
Is there any trick that can be used to get JadLoadB to extract a schema as part of a script. Preferably via a parameter file, but a full schema extract would do.
We are tying to automate our load process and want schema files for a sanity check at the end.
any ideas?
CR
Re: using JadLoad to automate extraction of schemas
Posted: Fri Aug 07, 2009 2:42 pm
by ConvertFromOldNGs
by
allistar >> Wed, 7 May 2003 10:33:13 GMT
Hi Carl,
From what I know this is not possible (at least not pre Jade 6). I have a suspicion that there is the ability to extract partial and full schemas programatically. It's a featute we are hanging out for too.
Regards,
Allistar.
------------------------------------------------------------------
Allistar Melville
Software Developer, Analyst
allistar@silvermoon.co.nz
Auckland, NEW ZEALAND
Silvermoon Software
Specialising in JADE development and consulting
Visit us at:
http://www.silvermoon.co.nz ------------------------------------------------------------------
Re: using JadLoad to automate extraction of schemas
Posted: Fri Aug 07, 2009 2:42 pm
by ConvertFromOldNGs
by Patwos >> Thu, 8 May 2003 5:04:43 GMT
Hi Carl/Allistar,
I just did a quick keyword search in Parsys for "programmatically extract" and found a couple of requests for this feature. They are duplicates of 9254 and when I search for #9254 it looks like it has 9 other duplicates.
From the details in Parsys, it looks like the guys at Jade have already put this into their Jade 6 release - I've copied/pasted their reply here to save you some time:
"The extractBatch method ,Class Schema, can be executed from jadloadb to extract a patch,a specific schema or list of schemas, or to extract using information from a file."
That probably doesn't help for now, but it's nice to know its coming in the next release of Jade.
Thanks,
Pat.
Re: using JadLoad to automate extraction of schemas
Posted: Fri Aug 07, 2009 2:43 pm
by ConvertFromOldNGs
by CarlRanson >> Thu, 8 May 2003 22:53:42 GMT
Nice one.
Thanks Pat.
Re: using JadLoad to automate extraction of schemas
Posted: Fri Aug 07, 2009 2:43 pm
by ConvertFromOldNGs
by cnwrbb1 >> Fri, 6 Jun 2003 12:40:26 GMT
The extractBatch method is available in 5.2.08.175. I used the following (which I can invoke from thin client to run on the app server - make sure directories are relative to this box):
extractBatch(param : String input;
command : String output;
args : ArgsArray output;
result : Integer output;
returnVal : Integer output) serverExecution;
vars
begin
create args transient;
command := app.getJadeInstallDirAppServer & "\jadloadb";
args.add(" ini=" & app.getIniFileNameAppServer);
args.add(" path=" & app.dbPath);
args.add(" server=multiUser");
args.add(" schema=JadeSchema");
args.add(" app=Jade");
args.add(" executeSchema=JadeSchema");
args.add(" executeClass=Schema");
args.add(" executeMethod=extractBatch");
args.add(" executeParam=" & '"' & param & '"');
args.add(" executeTransient=true");
returnVal := node.createExternalProcess(app.getJadeInstallDir, command, args, null, false, true, result);
end;
ArgsArray is a subclass of StringArray with a longer member. oo err.
As much of the param systax that I am aware of is:
Command, <schema file name or mul name for M or E or Q>,<ddb filename not M or E or Q>,<param file name for F> or <patch number for P or Q>,<schema name> or <schema name list for M>
e.g. E,c:\temp\myschemas.mul
M,c:\temp\selected.mul,scm1,scm2
A,c:\temp\scm1.scm,c:\temp\scm1.ddb,scm1
I have successfully used the A (All) and P (parameter file) options:
param := "A," & scmFileName & "," & ddbFileName & "," & schemaName;
param := "F," & scmFileName & "," & ddbFileName & "," & paramFile & "," & schemaName;
Re: using JadLoad to automate extraction of schemas
Posted: Fri Aug 07, 2009 2:43 pm
by ConvertFromOldNGs
by johnmunro >> Thu, 22 Jan 2004 10:23:49 GMT
Is there a way of telling it to encrypt the schemas it extracts?
Re: using JadLoad to automate extraction of schemas
Posted: Fri Aug 07, 2009 2:43 pm
by ConvertFromOldNGs
by
cnwrbb1 >> Thu, 22 Jan 2004 21:35:56 GMT
Is there a way of telling it to encrypt the schemas it extracts?
Don't know ... I have requested comprehensive batchExtract documentation, PAR #26125.
- Rob
Re: using JadLoad to automate extraction of schemas
Posted: Fri Aug 07, 2009 2:43 pm
by ConvertFromOldNGs
by JADE Support >> Thu, 22 Jan 2004 22:01:16 GMT
The extractBatch option was deliberately not documented as it was a work in progress. Use of this undocumented facility in the 5.2 release is not supported.
The officially released version of this feature is now now available in the JADE 6 release. You can read the documentation for this in the Extracting Schemas as a Non-GUI Client Application section of the JADE 6 UserGuide.pdf documentation.
As regards the question on extracting encrypted schemas, you can add the following to your jadclient command line on Windows to encrypt the schema:
"<encrypt>"
Note that the quotes around the chevrons are required when running this on a Windows environment as the chevrons have special meaning in a Windows command line.
This option was inadvertently omitted from the 6.0.17 documentation and this has now been addressed by the JADE Product Information team.
Thanks,
Brian Johnstone,
JADE Support.
Re: using JadLoad to automate extraction of schemas
Posted: Fri Aug 07, 2009 2:43 pm
by ConvertFromOldNGs
by encos_dev >> Tue, 13 May 2003 0:02:13 GMT
I know this is a crude fix, but we solved this problem by having a scripting program launch the development environment & do the extract (via it taking control of the mouse & keyboard). It works 99% of the time & allows us to do daily builds.
Hanging out for Jade 6 & the jadloadb extract feature.