Vicki Amin

I didn't realize that you were facing errors during the zipping process since you mentioned in your post that you get the error while generating the report.

I have used this snippet of code earlier in projects where we have zipped up decent sized excel files (data represented as objects) - upto 30 megs with a max heap size set to 512 megs. Is this something similiar that you have on your end?

ByteArrayOutputStream baOS = new ByteArrayOutputStream(); GZIPOutputStream gzOS = new GZIPOutputStream(baOS); ObjectOutputStream zipedObjectOS = new ObjectOutputStream(gzOS); zipedObjectOS.writeObject(<objectToBeZipped>); zipedObjectOS.flush(); zipedObjectOS.close();

How are you exporting it to Excel? One of the workarounds would be (in case your excel is not too complicated) be to write the data to the file system in a CSV format and then push it using a servlet to the browser with application/vnd.ms-excel as the MIME type. This way you would not be utilizing a lot of heap memory. In case the excel size is huge; you could consider zipping it up before you push it to the browser.

String query = "begin ? := storedc_procname(?); end;"; // register the type of the out param - an Oracle specific type stmt.registerOutParameter(1, OracleTypes.CURSOR); // set the in param stmt.setString(2, <stringparameter>); // execute and retrieve the result set stmt.execute(); ResultSet rs = (ResultSet)stmt.getObject(1); // print the results while (rs.next()) { // Assuming 1st return parm is a String, 2nd is a Float and 3rd is a Date System.out.println(rs.getString(1) + "\t" + rs.getFloat(2) + "\t" + rs.getDate(3).toString()); }

Try this

CallableStatement cs; try { // Call a procedure with no parameters cs = connection.prepareCall("{call myproc}"); cs.execute(); // Call a procedure with one IN parameter cs = connection.prepareCall("{call myprocin(?)}"); // Set the value for the IN parameter cs.setString(1, "a string"); // Execute the stored procedure cs.execute(); // Call a procedure with one OUT parameter cs = connection.prepareCall("{call myprocout(?)}"); // Register the type of the OUT parameter cs.registerOutParameter(1, Types.VARCHAR); // Execute the stored procedure and retrieve the OUT value cs.execute(); String outParam = cs.getString(1); // OUT parameter // Call a procedure with one IN/OUT parameter cs = connection.prepareCall("{call myprocinout(?)}"); // Register the type of the IN/OUT parameter cs.registerOutParameter(1, Types.VARCHAR); // Set the value for the IN/OUT parameter cs.setString(1, "a string"); // Execute the stored procedure and retrieve the IN/OUT value cs.execute(); outParam = cs.getString(1); // OUT parameter } catch (SQLException e) { }

Hi Deepa,

How about passing the XML message as a JMS ByteMessage?

String inputXMLMessage = "<some XML Message in text format>"; BytesMessage byteMessage = session.createBytesMessage(); byteMessage.writeBytes(inputXMLMessage .getBytes()); MessageProducer producer = session.createProducer(queue); producer.send(byteMessage);

Regards

Hi Deepa,

How about passing the XML message as a JMS ByteMessage?

String inputXMLMessage = "<some XML Message in text format>"; BytesMessage byteMessage = session.createBytesMessage(); byteMessage.writeBytes(inputXMLMessage .getBytes()); MessageProducer producer = session.createProducer(queue); producer.send(byteMessage);

Regards

Hi,

Try this; using portal tag libs.

< wps:navigation> < wps:navigationLoop> < %if (wpsSelectionModel.isNodeSelected(wpsNavNode)){ pageName = com.ibm.wps.model.LocaleHelper.getTitle((com.ibm.portal.Localized)wpsNavNode, request); }%> < /wps:navigationLoop> < /wps:navigation>
and this is the taglib declaration
< %@ taglib uri="/WEB-INF/tld/portal.tld" prefix="wps" %>

or

Context ctx = new InitialContext(); NavigationSelectionModelHome home = (NavigationSelectionModelHome) ctx.lookup("portal:service/model/NavigationSelectionModel"); if (home != null) { NavigationSelectionModel model = home.getNavigationModelProvider().getNavigationModel(aRequest, aResponse); model.getSelectedNode().getContentNode().getTitle(); }

Hi Steve,

Thanks for the prompt reply. That actually makes a lot of sense. Would you know of any connection param's that I can use to reduce the round trips? One more question; would doing a simple results.nextElement(); also involve a round trip to the server?

Regards,
Vicki.

Hi Ranchers,

I am running the below code to retrieve some results from an LDAP server and iterate through them. The problem is that the LDAP query itself takes just 0.25 seconds but the iteration is taking around 9 seconds. Any clue as to what I might be doing wrong over here?

Vector vector=new Vector(); Attributes match = new BasicAttributes(); match.put(new BasicAttribute("uid")); String[] IDs = {"ou", "o"}; SearchControls constraints = new SearchControls(); try { /* get the intial context */ ctx = getInitialContext(); /* set the search filters and scope */ MY_FILTER = "<some filter>"; constraints.setSearchScope(SearchControls.SUBTREE_SCOPE); constraints.setReturningAttributes(IDs); /* Execute the search - takes 0.25 seconds*/ long startQuery=System.currentTimeMillis(); NamingEnumeration results = ctx.search(MY_SEARCHBASE, MY_FILTER, constraints); long endQuery=System.currentTimeMillis(); System.out.println("Time spent for iteration -> "+(endQuery-startQuery)); /* Iterate through the results - takes 9 seconds */ long startIteration = System.currentTimeMillis(); while(results.hasMoreElements()) { results.nextElement(); } long endIteration = System.currentTimeMillis(); System.out.println("Time spent for iteration -> "+(endIteration-startIteration)); } catch(NamingException e) { e.printStackTrace(); }

Regards,
Vicki.

Hi,

Try and see if the JNDI name exists. You need to search for the IBMUTC.ear file in the installation directory of WAS and install it. You can now access your JNDI browser from <a href="http://<yourwebspheremachine>/UTC/index.jsp." target="_blank" rel="nofollow">http://yourwebspheremachine/UTC/index.jsp. Do a lookup for the JNDI name and see if its present.

Regards,
Vicki.
[ July 31, 2008: Message edited by: Vicki Amin ]

Hi Pankaj,

Try this. File>Export> Select the WAR file option and select the web project you want to export as a WAR file.

Regards,
Vicki.

I am now able to read the ACL's stored in the default ACL tables using the following bean definiations...

<bean id="aclManager" class="org.acegisecurity.acl.AclProviderManager"> <property name="providers"> <list> <ref local="aclProvider" /> </list> </property> </bean> <bean id="aclProvider" class="org.acegisecurity.acl.basic.BasicAclProvider"> <property name="basicAclDao"> <ref local="userAclService" /> </property> </bean> <bean id="userAclService" class="org.acegisecurity.acl.basic.jdbc.JdbcDaoImpl"> <property name="dataSource"> <ref bean="dataSource"/> </property> </bean>

The next step is to somehow use the aclManager bean in the following bean...

<bean id='securityInterceptor' class='org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor'> <property name='authenticationManager' ref='authenticationManager'/> <property name='accessDecisionManager' ref='accessDecisionManager'/> <property name='objectDefinitionSource'> <value> com.affy.BookBean.setValue=ROLE_MANAGER com.affy.BookBean.changeValue=ROLE_WORKER,ROLE_MANAGER </value> </property> </bean>

Any help here is appreciated!!

- Vicki.

Hi,

I am using Acegi 1.0.5. I want to load and use the ACL's dynamically at runtime from the ACL tables acl_object_identity, acl_permission which are standard Acegi tables.

I am able to load the ACL's from the database using the following bean definitions.

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="org.hsqldb.jdbcDriver"/>
<property name="url" value="jdbc:hsqldb:hsql://localhost:9001"/>
<property name="username" value="sa"/>
<property name="password" value=""/>
</bean>

<bean id="userAclService" class="org.acegisecurity.acl.basic.jdbc.JdbcDaoImpl">
<property name="dataSource">
<ref bean="dataSource"/>
</property>
</bean>

The next step is to replace/modify the following bean definition where the ACL's are clearly hard coded.

<bean id='securityInterceptor' class='org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor'>
<property name='authenticationManager' ref='authenticationManager'/>
<property name='accessDecisionManager' ref='accessDecisionManager'/>
<property name='objectDefinitionSource'>
<value>
com.affy.BookBean.setValue=ROLE_MANAGER
com.affy.BookBean.changeValue=ROLE_WORKER,ROLE_MANAGER
</value>
</property>
</bean>

Any ideas how do I get this done?

Regards,
Vicki.

try explicitly putting the log4j.xml file in the classpath.

congratulations
can you send the pdf for test 252.
my mail id is vicki.amin at gmail.com
thanks a ton