Amit Basnak

Friends

When the query returns more than 1500 records , I want to chunk up the requests into multiple requests of 1500 each. How can we achieve this using Hibernate ScrollableResults or similar for native SQL query used in createSQLQuery ?

I have tried using simple technique but need more input on how we can use Hibernate ScrollableResults for Native SQL batch select records
public List<EmployeeDetails> processRecordsInBatches() throws Exception { Session s = getSession(); Transaction tx = null; final int BATCH_SIZE = 1500; List<EmployeeDetails> result = null; ScrollableResults allEntities = null; try { tx = beginTransaction(s); if ( ++BATCH_SIZE % 1500 == 0 ){ Query query = s.createSQLQuery("select c.employee_id AS EmployeeId, 99 AS assignedProjectId, c.employee_name AS employeeName, " + " from employee.employee_details c" ) ; query.setInteger("employeeId", employeeId ); query.setString("assignedProjectId", assignedProjectId); query.setString("employee_name", employee_name); log.info(query); query.setResultTransformer(new ResultTransformer() { @Override public Object transformTuple(Object[] tuple, String[] aliases) { EmployeeDetails details = new EmployeeDetails(); details.setEmployeeId((Integer)tuple[0]); details.assignedProjectId((Integer)tuple[1]); details.setEmployeeName((Integer)tuple[2]); return details; } @Override public List transformList(List list) { return list; } }); result = query.list(); s.flush(); s.clear(); } commitTransaction(tx); log.info(result); } catch (Exception ex) { log.error(ex); } finally { closeSession(s); } return result; }

I have the following function that searches forward relative to the cursor position.
It not found it performs another search from the begining of the whole text.

function forwardSearch(element, currentIndex) { var rSearchTerm = new RegExp(/(\[.*?\])/); var ind = element.val().substr(currentIndex).search(rSearchTerm) currentIndex = (ind == -1 ? 0 : currentIndex); ind = (ind == -1 ? element.val().search(rSearchTerm) : ind); currentIndex = (ind == -1 ? 0 : currentIndex); var lasInd = (element.val().substr(currentIndex).search(rSearchTerm) == -1 ? 0 : element.val().substr(currentIndex).indexOf(']')); var input = element.get(0); if (input.setSelectionRange) { input.focus(); input.setSelectionRange(ind + currentIndex, lasInd + 1 + currentIndex); } else if (input.createTextRange) { var range = input.createTextRange(); range.collapse(true); range.moveEnd('character', lasInd + 1 + currentIndex); range.moveStart('character', ind + currentIndex); range.select(); } }

In this basically I have to add an extra parameter in this function to search forward or backwards relative to the cursor position.
Searching backward have exactly the inverse logic implemented in forwardSearch.
Please suggest to implement backward search .

Thanks for the Reply.

Here is the actual Scenario
My application received the data from a backend in the form of a class object ie.

public class FlowObject {
private String id;
private List<FlowStep> flowlSteps;
private List<String> audRefs;

}

Now FlowStep class as mentioned above is
public class FlowStep {

private String id;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}

}

--------------------------
Now since Backbone code is NOT ready Im writing the dummy implementation of FlowObject Class at my Side whose data gets copied to my local Class FlowCopy
Thats why I need to write both FlowObject and FlowCopy Classes

FlowObject Class is as below
import java.util.ArrayList; import java.util.Arrays; import java.util.List; public class FlowObject { private String id; private List<FlowStep> flowlSteps; private List<String> audRefs; public String getId() { return id; } public void setId(String id) { this.id = id; } public List<FlowStep> getFlowSteps() { return flowlSteps; } public void setFlowSteps(List<FlowStep> flowlSteps) { this.flowlSteps= flowlSteps; } public List<String> getAudRefs() { return audRefs; } public void setAudRefs(List<String> audRefs) { this.audRefs = audRefs; } }

FlowStep Class is as below

public class FlowStep { private String id; public String getId() { return id; } public void setId(String id) { this.id = id; } }
FlowCopy Class is as below
public class FlowCopy { private String id; private List<FlowStep> flowSteps; private List<String> audRefs; public String getId() { return id; } public void setId(String id) { this.id = id; } public List<FlowStep> getFlowSteps() { return flowSteps; } public void setFlowlSteps(List<FlowStep> flowSteps) { this.flowSteps= flowSteps; } public List<String> getAudRefs() { return audRefs; } public void setAudRefs(List<String> audRefs) { this.audRefs = audRefs; } }

Now my intention is to Copy the Custom FlowObject Class to a list of FlowCopy which will be used in application

public List<FlowCopy> getFlow( List<FlowObject > obj ){ List<FlowCopy> flowRes = new ArrayList<FlowCopy>(obj.size()); for (FlowObject object:obj) { FlowCopy callFlow = new FlowCopy(); callFlow.setId(object.getId()); callFlow.setAudioRefs(object.getAudRefs()); callFlow.setCallSteps(object.getFlowSteps()); flowRes .add(callFlow); } return flowRes ; }

The above method does work , Please suggest

Friends

Not sure if this is a forum to discuss about Spring Certification nevertheless I am planning to appear for a Core Spring Certification now there are two version one for spring2.5 and another for 3.x , I do have experience in 2.x version but not 3.x and 3.x is different than 2.x version.
Please suggest considering its value in the IT and projects that are made in the companies is it worth to go for spring 3.x certification ?
Many Thanks
Amit

What you wrote is correct. However with 6+ yrs of exp , I do get interview calls mostly for a role of a Technical lead / project lead .
I personally feel that having worked on two very good Object Oriented languages , it should give me a broader vision.
Big companies companies wont have much issues with Java + C++ experience and that too in the same project.
However those companies that just concerntrate on a single technologies that may just concentrate on a single technology .
Thanks for your comment.
Amit

Friends

I have been working in the BFSI domain over 6 yrs . My current project of 4.5 yrs uses various technologies like Front End in Struts+ Spring , Middleware in C++ and backend in Pro*C , Oracle 10g. I was mainly responsible for C++ development from the scratch and as my experience grew , handled Front End Modules developed in Struts + Spring and Ajax .
Now on my resume for this project I have used both C++ and Java technologies . When a company approaches me they mainly call me for C++ interviews.
I dont want to stick to a perticular technology for long and want utilize my java skills as well.
What is required is they need to look at both C++ and java skills not just a one technology.
Please provide your inputs on how companies look at when I have used both C++ and Java technologies.
Thanks
Amit

Thanks for the reply
well yes , also on compensation basis , I came to know that I would get transfered to Cincinati Ohio on L1 . I know that living expenses of the cincinaty are on a lesser side than other US cities so just want t know if its Ok to go there on L1 and save some money .
Also whats the duration of the L1 visa

does it depend on company to company ? from google i do know that L1 visa holders are paid less than H1B holders. still I would like to know if its worth going to US on L1 .

Friends

Please let me know the duration of L1 visa and if it can get renewed , also the wages , salaries that one can get on L1 visa.
for H1B visa , people get around 48 K per year and how about L1 Visa holders ?

Thanks

Natalie

Well The company here I work for has a very good working culture. All people help each other. It doesnt mater if someone is a fresher or not. everybody does have some difficulties and problems in coding in some stage of work so everyone understands it and tries to help in abest possible way. Even I can take help from senior project manager also on my problems. No issues

Amit

I understand that in Makefile -ldl needs to be replaced by -ldld
I did a grep for ldl and here is what I have
here are the files that contains ldl

$ find ./ -exec grep -l ldl {} \;
./.sh_history
./systinet/server_cpp65/lib/libwasp.la
./systinet/server_cpp65/lib/libwasp_wsdl.la
./systinet/server_cpp65/lib/libwasp_dii.la
./systinet/server_cpp65/lib/libwasp_security.la
./systinet/server_cpp65/lib/libwasp_stl.la
./systinet/server_cpp65/lib/libwasp_validator.la
./systinet/server_cpp65/lib/mod_13_wasp.la
./systinet/server_cpp65/lib/mod_wasp.la
./systinet/server_cpp65/share/waspc/src/STLSupport/aclocal.m4
./systinet/server_cpp65/share/waspc/src/STLSupport/configure
./systinet/server_cpp65/share/waspc/src/STLSupport/config.guess
./systinet/server_cpp65/share/waspc/src/STLSupport/ltmain.sh
./systinet/server_cpp65/share/doc/waspc/demos/basic/arrays/.libs/libwaspdem��o_arrays.la
./systinet/server_cpp65/share/doc/waspc/demos/basic/arrays/libwaspdemo_arra��ys.la
./systinet/server_cpp65/share/doc/waspc/demos/uddi/v2/library/aclocal.m4
./systinet/server_cpp65/share/doc/waspc/demos/uddi/v2/library/configure
./systinet/server_cpp65/share/doc/waspc/demos/uddi/v2/library/config.guess
./systinet/server_cpp65/share/doc/waspc/demos/uddi/v2/library/ltmain.sh
./systinet/server_cpp65/share/doc/waspc/demos/uddi/v2/library/libtool
./systinet/server_cpp65/share/doc/waspc/demos/uddi/v3/library/aclocal.m4
./systinet/server_cpp65/share/doc/waspc/demos/uddi/v3/library/configure
./systinet/server_cpp65/share/doc/waspc/demos/uddi/v3/library/config.guess
./systinet/server_cpp65/share/doc/waspc/demos/uddi/v3/library/ltmain.sh
./systinet/server_cpp65/share/doc/waspc/demos/uddi/v3/library/libtool
./systinet/server_cpp65/share/doc/waspc/demos/aclocal.m4
./systinet/server_cpp65/share/doc/waspc/demos/configure
./systinet/server_cpp65/share/doc/waspc/demos/config.guess
./systinet/server_cpp65/share/doc/waspc/demos/ltmain.sh
./systinet/server_cpp65/share/doc/waspc/demos/libtool
./systinet/server_cpp65/share/doc/waspc/doc/waspc/html/js/searchData.js
./systinet/server_cpp65/include/waspc/config/configAuto.h

So there is no Makefile yet which has ldl in it.
Also the configure file which is used to build Makefile has the following

# if libdl is installed we need to link against it
echo "$as_me:$LINENO: checking for dlopen in -ldl" >&5
echo $ECHO_N "checking for dlopen in -ldl... $ECHO_C" >&6
if test "${ac_cv_lib_dl_dlopen+set}" = set; then
echo $ECHO_N "(cached) $ECHO_C" >&6
else
ac_check_lib_save_LIBS=$LIBS
LIBS="-ldl $LIBS"

if test $ac_cv_lib_dl_dlopen = yes; then
lt_cv_dlopen="dlopen" lt_cv_dlopen_libs="-ldl"
else


lt_cv_dlopen="dyld"
lt_cv_dlopen_libs=
lt_cv_dlopen_self=yes


fi
---------------------------------------------------------------------------��------------------------------------------------


For -ldld


if test $ac_cv_lib_svld_dlopen = yes; then
lt_cv_dlopen="dlopen" lt_cv_dlopen_libs="-lsvld"
else
echo "$as_me:$LINENO: checking for dld_link in -ldld" >&5
echo $ECHO_N "checking for dld_link in -ldld... $ECHO_C" >&6
if test "${ac_cv_lib_dld_dld_link+set}" = set; then
echo $ECHO_N "(cached) $ECHO_C" >&6
else
ac_check_lib_save_LIBS=$LIBS
LIBS="-ldld $LIBS"
-------------------------------------------
Also if I configure al over again like

CXX=/opt/aCC/bin/aCC LD=/opt/aCC/bin/aCC -L /usr/lib/pa20_64 -ldld

the files in my /usr/lib/pa20_64 directory are
libdl.1
libdl.sl
libdld.1
libdld.sl

there is no libdl.a file in pa20_64

Thanks for all your help and time
Amit

I do have the said library at: /usr/lib/pa20_64/libdl.1
but adding it to the Make file did not work.

Guy and Ernest Friedman-Hill

I managed to get rid of those errors now what I got so far is
I did run configure script again with the parameters as
/opt/systinet/server_cpp65/share/doc/waspc/demos> ./configure CXX=/opt/aCC/bin/aCC LD=/opt/aCC/bin/aCC

and it was successul and I used aCC compiler as the linker instead of system default (/usr/ccs/bin/ld) now doing make Im getting the following error
$ make all
No suffix list.
Making all in basic
No suffix list.
Making all in arrays
cd ../.. && make am--refresh
No suffix list.
No suffix list.
/bin/sh ../../libtool --mode=link /opt/aCC/bin/aCC -g -o
arrays client.o arrays.lo arraysStructs.lo
/opt/systinet/server_cpp65/lib/libwasp.la
/opt/systinet/server_cpp65/lib/libwasp_stl.la
/opt/aCC/bin/aCC -g -o arrays client.o .libs/arrays.o
.libs/arraysStructs.o /opt/systinet/server_cpp65/lib/libwasp_stl.sl
/opt/systinet/server_cpp65/lib/libwasp.sl -lm -ldl -lpthread -Wl,+b
-Wl,/opt/systinet/server_cpp65/lib -Wl,+s
/usr/ccs/bin/ld: Can't find library: "dl"
*** Error exit code 1
Stop.
*** Error exit code 1
Stop.
*** Error exit code 1
Stop.


/usr/ccs/bin/ld: Can't find library: "dl" => checked dl library is not present on the HP-UX system . also having specified aCC compiler as linker while running ./configure , the error shows still is uses system default linker /usr/ccs/bin/ld. Im not sure why .

All the 64 bit libraries of HP-UX are under /usr/lib/pa20_64 directory .

Any idea How do I get rid of the error ??

Thanks for your time

Amit

Ernest Friedman-Hill
Thanks for the reply
I performed the WSDL compilation from the directory /systinet/server_cpp65/share/doc/waspc/demos/interop/java
And it successfully generated the file barnImpl.h under the above path.
Again I tried to did make and got the errors which I am posting here
Error 419: "../interop/java/impl.h", line 14 # 'Barn_BarnServiceImpl' is used as a type, but has not been defined as a type.
class BarnServerImpl : public Barn_BarnServiceImpl {
^^^^^^^^^^^^^^^^^^^^
Error 376: "../interop/java/impl.h", line 14 # Class name expected.
class BarnServerImpl : public Barn_BarnServiceImpl {
^^^^^^^^^^^^^^^^^^^^
Error 419: "../interop/java/impl.h", line 16 # 'Barn_CowArray' is used as a type, but has not been defined as a type.
Barn_CowArray *cows;
^^^^^^^^^^^^^
Error 20: "../interop/java/impl.h", line 18 # '[' expected before '*'.
Barn_Cow *findCowWithID (Barn_CowArray *where, WASP_LongLong id);
^
Error 19: "../interop/java/impl.h", line 18 # Unexpected 'WASP_LongLong'.
Barn_Cow *findCowWithID (Barn_CowArray *where, WASP_LongLong id);
^^^^^^^^^^^^^
Error 24: "../interop/java/impl.h", line 18 # '(' expected instead of ';'.
Barn_Cow *findCowWithID (Barn_CowArray *where, WASP_LongLong id);
^
Error 22: "../interop/java/impl.h", line 19 # Syntax error.
Barn_Cow *cloneCow (Barn_Cow *cow);
^
Error 419: "../interop/java/impl.h", line 25 # 'Barn_ArrayOflong' is used as a type, but has not been defined as a type.
virtual void slaughterCows (Barn_ArrayOflong * p0);
^^^^^^^^^^^^^^^^
Error 20: "../interop/java/impl.h", line 26 # ':' expected before '*'.
virtual Barn_ArrayOfdouble * actualMilkYield (Barn_ArrayOflong * p0);
^
Error 172: "../interop/java/impl.h", line 26 # Undeclared variable 'Barn_ArrayOflong'.
virtual Barn_ArrayOfdouble * actualMilkYield (Barn_ArrayOflong * p0);
^^^^^^^^^^^^^^^^
Error 335: "../interop/java/impl.h", line 26 # ANSI C and C++ do not allow named bitfield with zero width.
virtual Barn_ArrayOfdouble * actualMilkYield (Barn_ArrayOflong * p0);
^^^^^^^^^^^^^^^^^^
Error 334: "../interop/java/impl.h", line 26 # Bitfield width cannot be larger than the size of its type '<no type>'.
virtual Barn_ArrayOfdouble * actualMilkYield (Barn_ArrayOflong * p0);
^^^^^^^^^^^^^^^^^^
Error 699: "../interop/java/impl.h", line 26 # Error limit reached; halting compilation.
virtual Barn_ArrayOfdouble * actualMilkYield (Barn_ArrayOflong * p0);
^^^^^^^^^^^^^^^^^^
*** Error exit code 2
---------------------------------------------------------------------------
impl.h file which is giving problems looks OK to me

#ifndef __WASP_DEMO_BARN_SERVICE_H
#define __WASP_DEMO_BARN_SERVICE_H

#include <waspc/config/config.h>

#include <waspc/util/exceptions.h>

// Generated code includes
#include "../java/barnImpl.h"

class BarnServerImpl : public Barn_BarnServiceImpl {

Barn_CowArray *cows;

Barn_Cow *findCowWithID (Barn_CowArray *where, WASP_LongLong id);
Barn_Cow *cloneCow (Barn_Cow *cow);

public:
BarnServerImpl();
virtual ~BarnServerImpl();

virtual void slaughterCows (Barn_ArrayOflong * p0);
virtual Barn_ArrayOfdouble * actualMilkYield (Barn_ArrayOflong * p0);
virtual Barn_ArrayOfCow * cowsForSlaughter ();
virtual Barn_ArrayOfCow * getCows (Barn_ArrayOflong * p0);
virtual double barnRating ();
virtual Barn_Cow * theBestCow ();
virtual Barn_ArrayOfCow * getAllCows ();

};

#endif // __WASP_DEMO_BARN_SERVICE_H

Is it that the JNI package installed which is required for building that module is missing thats why its throwing such errors ?

Thanks
Amit