hibernate criteria for ipaddress subnet

vkaluv · **Joined:** Mon Jul 14, 2008 7:38 pm **Posts:** 2

hi everyone,

I have a situation where i have to search in database for an IP_ADDRESS column, which contains 1000's of ipaddress. An example of ip address is 157.198.156.45 in this ip address the third octet is called C subnet.

So, the condition here is that i have to write a hibernate criteria so, that we have to count the no.of C subnets and their corresponding ipaddress.

for example: set of ip address: 1.2.3.4, 1.2.3.6, 1.2.3.8, 1.8.3.7, 1.0.5.8, 2.3.5.9, 8.9.7.9

if this is the column name then the output should be:

C subnets no.of corresponding address
------------- --------------------------------
3 --------------> 4
5 --------------> 2
7 --------------> 1

thanks in advance

Cameron McKenzie · **Posted:** Fri Jul 25, 2008 3:04 am

Maybe you could just use a very flexible MatchMode?

Quote:

static MatchMode ANYWHERE
Match the pattern anywhere in the string
static MatchMode END
Match the end of the string to the pattern
static MatchMode EXACT
Match the entire string to the pattern
static MatchMode START
Match the start of the string to the pattern

Then create a sample object with the octet you're searching for in the example class. Here's a code snippet from the Hibernate tutorials on my website:

Code:

User user = new User();
user.setPassword("PASS");
Example example = Example.create(user);
example.enableLike(MatchMode.ANYWHERE);
example.ignoreCase();
example.excludeProperty("verified");

How to Use the Criteria API in you Hibernate Applications: A Simple Tutorial