Get the count of a particular value in the a table via Java services


In wavemaker 6.3.3 , I entered a java code for getting the count of a particular value in the table.
The error is coming while i just entering the executeQuery() function.

Plz help... Urgent

The code which I entered is shown below.

import com.wavemaker.runtime.RuntimeAccess;
import java.util.List;
import java.util.ArrayList;
import org.hibernate.Session;
import org.hibernate.SQLQuery;
import com.bondingregister.BondingRegister;
public class SerialNoValidation extends com.wavemaker.runtime.javaservice.JavaServiceSuperClass {
/* Pass in one of FATAL, ERROR, WARN, INFO and DEBUG to modify your log level;
* recommend changing this to FATAL or ERROR before deploying. For info on these levels, look for tomcat/log4j documentation
public SerialNoValidation() {

public String sampleJavaOperation() {
String result = null;
try {
log(INFO, "Starting sample operation");
result = "Hello World";
log(INFO, "Returning " + result);
} catch(Exception e) {
log(ERROR, "The sample java service operation has failed", e);
return result;

Piramidale's picture

wm.List - Copy row displayed content to clipboard with a click (JS-generated contents)


Hi all,
my goal is to obtain, on a long press, the copy of the wm.List element text content and let user choose how to share it (ex. email, SMS, ecc.).

I can use "onLongClick" event on wm-List widget to launch a custom function, but i have know how to get the entire row content and copy it to the clipboard.

In the following code i have inserted "?????????" to show the missing code.

share: function(inSender) {
    var Content = this.my_list.selectedItem.?????????;

Thank you!

Using NextReports in WaveMaker for Reporting


I am fairly new to wavemaker, coming from the microsoft C# world. I am very impressed with WaveMaker and currently trying to incorporate reporting in a couple projects. In the process of evaluating Jasper and BIRT, I found a product called NextReports:

I have been able to do a couple of simple reports with it using relatively small amount of code. However, I lack any experience with Jasper and BIRT.

I was wondering if anyone had any experience with NextReports and would like to comment.

Greatly appreciated,

Error al instalar las system dependencies bundle, mientras se cargan al servidor


Voy a describir el problema lo mas detalladamente posible.

Al terminar de instalar por consola, en Ubuntu server 12.04 LTS.

Searching Word documents stored in database


Hi All

I really need help with the following. I am currently developing a recruitment database application for my company internally. I want to know what I need to do in order to perform searches on Word docs stored within the application i.e. to search through the candidates resumes.I have seen other applications that uses boolean searches.

I want to know what I must do to use this type of feature within Wavemaker.

Any advise will be greatly appreciated.

Piramidale's picture

HQL - Filtering inside Relationships (ex. CASE Inside SELECT)


please, consider this situation:


- id_a
- col_a1
- col_a2
- col_a3

- id_b
- col_b1
- col_b2
- col_b3
- col_b4

name: MyRelation
type: One-to-many (from "TABLE A" to "TABLE B")

Then, there is an "wm.List" widget (binded to a ServiceVariable that is binded to an HQL query) that need to show:

• Need 1 -> "TABLE A" rows, filtered by "col_a1" value.

Can't manually set tenantid via Java service


Greetings and Merry Christmas!

Using a Java service, I cannot set the tenantid when inserting a new user record.

In my app, I want allow a new user to not only setup a new user account from the login page, but also I want to establish the new tenantid for what will be their company account.

I have tried to accomplish this by using a Java service to create a new tenant table entry, grab the new tenantid and then use that tenantid to populate the tenantid field in the new user record. Here's the way it works:

1. New user enters info and clicks the register button.

Dramia's picture

Software caused connection abort: socket write error


Hi everyone !

I have a Web application which rather work fine.
But sometimes, I catch this error : "Software caused connection abort: socket write error" when my application try to use my DB for any request. And all my application has block.
To unblock him, I must to reload my application in my tomcat manager. (And after, that work fine until the next "Software caused connection abort: socket write error"...)

I would to know if someone know where this error come from (Java, MySQL, server, ... ?).

Any help or tips are welcome !

DownloadResponse class not causing client OS to display save prompt


Hey Guys,

At my wits end again.

In my app, I am uploading files from the client to the app and storing them in the database. All that works great. My issue is in the effort to then download the files from the database back to the client.

I actually have this working in a test app, but when moving over to my actual project, I had to make a few tweaks related to the BLOB handling. Anyway, everything seems to be working as desired, that is the Java code runs error free and my logging suggests that the database is being read to get the file info.

[SOLVED] Jar Files and Pop-up GUIs


Hey Guys,

I have a question regarding jar files and GUI displays in WaveMaker. I have a jar file that when the save button is clicked; the java service is called to activate it and what it does is it checks the information input into the application and if the individual isn't in the database, it pops up a window so that the user can input the individuals information and store it into the database so that the jar file can process the information and store it properly.
The problem I am having is I need this application to display the window on the client and not the server.

HttpSession not the same


Hi all,

Small issue with Session :
- I'm storring a Hashtable in a session attribute.
- adding new element to the Hashtable with a method "addA" (java service call by the client)
- deleting an element "removeA"(java service call by the client)

The problem is that I'm not retriving the same session object when addA and removeA are called. This mean that I cannot access to my hashtable where I store my session object. This is an example with the content of the hashtable and the sessionId depending on the called method :

[SOLVED] Help with Java Code to call activate a jar file


Hey Guys,

What would be the best way to call a jar file? I have a jar file that is a calculation program and when I click my save button on my application it stores the input data to the database and then calls the jar file that does the calculations and updates the database for me.
I have the jar file already placed in my ...\...\application\lib folder, service variable created to call the java service and the java service named and ready to go but no matter what code I use, I cant get the java code to be accepted by Wavemaker.

Very poor performance transferring / displaying result of JavaService in DojoGrid


I have a project with a big dojo grid which is dependent on an user entry and also dependent on the user's role (also can depend on some date values but I skip that to make the problem easier). This logic is implemented through a JavaService which is used by a ServiceVariable to populate the DojoGrid. The problem is that it takes a significant amount of time after the JavaService returns to actually display the data in the grid.

I attached an example project with an example database. I use MS SQL Server so you may have to adjust some (the table names) of the SQL script.

Need example if using TypedServiceReturn read(TypeDefinition , Object , PropertyOptions , PagingOptions )


Hello all!

Please show me example of using method

public TypedServiceReturn read(TypeDefinition rootType, Object o, PropertyOptions propertyOptions, PagingOptions pagingOptions)

I need to load all rows from table by this method.
For example:

List<Customer> resTable = null;
Customer servicedb = (Customer)RuntimeAccess.getInstance().getServiceBean("mydb");


TypedServiceReturn  tsr =, new Customer(), null, null);

resTable = tsr.getReturnValue().getResult();


Syndicate content