Jump to content


Member Since 03 Nov 2006
Offline Last Active Apr 19 2011 12:42 PM

Posts I've Made

In Topic: Client.Get()

24 March 2010 - 10:06 AM

Two suggestions, though I have't worked these through myself so they may turn out to be impractical, and at best are a bit hackish. They would also likely mandate a client side change to stop security messages on the client computer.

1 - Use the SYSTEM GUI ASYNC command to initiate an ftp pull on the client machine from the server

2 - Use the SYSTEM GUI ASYNC with a web facing http address where the files are available. This 'should' launch a browser where the download bar would indicate download progress - you could put the files behind some security filter so the web server would prompt for username / password and possibly maintain some session state and therefore only ask for credentials for the first download during the session.


In Topic: File Viewer for files with long record lengths

15 October 2009 - 11:36 AM

I found a solution for this that works for me - using Oracle's dbms_xmlgen.getxml to format the query results produces nice pretty printed xml that under most circumstances will work under the 240 char lenght restriction and also has the benefit of printing the full column names for the table, rather than truncating them to the length of the relevant column, as the standard output does.

In Topic: Oracle segment sizes

20 July 2009 - 09:50 AM


Thanks for the reply - I haven't been on the board for a while. It turns out that scaling up the process from a trial with a subset of the data involved we are only looking at a one or two hour operation - that is with the size allocation roughly matching the existing sizes for the relevant structures with a reasonable size for additional extents. It is slightly more manual that just inheriting the defaults, but I imagine the amount of data we are dealing with is small by Oracle standards, so even in the default scenario where we could be creating thousands of small extents for a large table to occupy it probably wouldn't be too much of an issue (these are snapshots for reporting, not OLTP). Thanks for your help.

In Topic: Application Framework

03 July 2009 - 12:31 PM

This is a good example,

If your class is packaged on the .war with the class below, under the SSO,you can call this class in PROIV and re-use its DAO methods in PROIV logic.

import javax.sql.DataSource;import org.springframework.jdbc.core.JdbcTemplate;public class ExecuteDBStatement { private JdbcTemplate jdbcTemplate; public void setDataSource(DataSource dataSource) { this.jdbcTemplate = new JdbcTemplate(dataSource); } public void doExecute() { this.jdbcTemplate.execute("create table mytable (id integer, name varchar(100))"); }}

Thanks Matthews will have to look further into this. Haven't been on the board for a few weeks.


In Topic: Application Framework

22 June 2009 - 09:34 AM

Armchair, Matthews,

Thanks for your replies. Matthews thanks for the level of detail - it is very helpful to get a picture of the plumbing of a flexible framework such as the one you have outlined. We are currently dealing with a large legacy ProIV app and this newer application may at some point require and interface into it, so the SSOs using Spring could turn out to be relevant.