DataLoad Community

RHALFORD · Joined: 29 Mar 2007 Posts: 5

Anyone tried record and playback yet with Release 12?

According to Oracle support you use ?record=collect and it generated an FRD file in $FORMS_TRACE_DIR called collect_<pid>

I've been though the trace file and its more at a debug level than record/playback.

There is reference on metalink to using record=forms tracegroup=light in the forms runtime paramters profile, but this doesn't seem to produce anything.

Anyone know of a working set up for either ICX: Forms Launcher or $FORMS_TRACE_DIR?

DataLoad · Posted: Fri Apr 06, 2007 2:08 pm Post subject:

Yes, we have been testing record and playback with R12 and found it to work well. The setup is largely the same as for 11i but there are some detail differences and we are currently documenting these. The DataLoad User Guide and web site will be updated shortly with these instructions.

The main change that is required to your R12 install is to change the forms protocol to be Socket rather than Servlet (HTTP/HTTPS). The latter is the standard in R12 but Forms Playback only works when Forms is run in Socket mode. However, Oracle fully support socket mode, provide scripts to switch to this mode and the switchover is a straightforward and quick change that only affects the server. Indeed, there are situations where Socket is the preferred protocol anyway because it is lighter on network traffic that the HTTP/HTTPS protocols, so unless you need the additional security of HTTPS or some of the additional architecture options provided by HTTP/HTTPS then Socket may well be the preferred approach.

Regards,

Jonathan Stuart,
DataLoad Support.

RHALFORD · Joined: 29 Mar 2007 Posts: 5

Hi, Thanks
The only problem is that I don't think changing to socket will be an option though. Certainly servlets are the Oracle preferred solution.

Although switching between the socket/servlet mode is straightforwards at the server end (just run a script) it does mean updating each client too.

From the look of the servlet output the info is all there, just with a whole heap of other info too, so filtering the output file could be possible. I havn't looked at playback at all yet though.

DataLoad · Posted: Wed Apr 18, 2007 3:04 am Post subject:

It may well be possible to get playback to work with servlet mode, we just haven't tested this yet. Servlets are Oracle's default soluton now and certain architecture options only work with servlets, but socket mode is equally supported and Oracle document that this is a better option in some scenarios.

Changing from socket to servlet mode should just mean a change on the server and not clients too. What change are you think of that is required on the client?

Thanks,

Jonathan

RHALFORD · Joined: 29 Mar 2007 Posts: 5

Sorry I havn't got back for a bit. The metalink articles on servlet to sock specify a change to the set up of the client PC java set up. I'm not sure if this is still applicable to a non JInitiator environment though.

I have spoken to the dba team though about this, and in addition going to socket mode is not an optional avaliable to us.

I think the main issue we have now is all the extra information that R12 logs in the fld file that DL Professional doesn't seem to like. I it looks like all the info expected is being recorded, but with a whole heap of additional stuff.

DataLoad · Posted: Tue Aug 28, 2007 2:49 pm Post subject:

DataLoad V4.3.9.0 was released today and this contains full R12 compatibility, including updated setup instructions. Forms Playback works fine in both socket and servlet (HTTP) mode but the setup required is different compared to 11i and the new setup instructions will need to be followed to get forms playback to work in R12:

http://www.dataload.net/help/recplay/setup.htm

Jonathan[/url]