Questions tagged [query-by-example]

97 questions
0
votes
2 answers

How to fetch data using example object in JPA 2

I'm using Hibernate 3.5.6 and JPA 2. Here is my code: public List searchRoutesEndingAt(GeoLocation destinationLocation, int destinationRangeInMeters, RouteUserPref routeUserPref) { Query query =…
sumitarora
  • 580
  • 4
  • 18
0
votes
1 answer

SQL syntax: filter by text with space at the end

Trying to build a SQL statement in which I can filter reports by a narrative field containing the word bike. Need to include those reports containing bike and bikeway, but omit those only containing bikeway. Seems like I need to filter by bike…
0
votes
1 answer

Is there a simple way to do Query By Example in iBATIS?

I had hoped this was baked into the most recent release, but if it is, I can't find the docs via a simple Google search. Failing that, I'd prefer a simple library, but I'll settle for a tutorial. Thanks.
Hank Gay
  • 70,339
  • 36
  • 160
  • 222
0
votes
1 answer

Suggestion Database Query API

Working on a proprietary Bioinformatics software that manipulate domain objects, I have to enhance the API so that external parties can access (CRUD) data stored in the internal DB. The data are grouped by type (such as molecule, oligo and enzyme)…
YeenFei
  • 3,180
  • 18
  • 26
0
votes
1 answer

Hibernate: queries by example and many-to-one relationships

Let's say those are my entities: Table1.java @Entity public class Table1 { // Many to one private Table2 table2; // Raw attributes // ... } Table2.java @Entity public class Table2 { // Many to one private Table3…
sp00m
  • 47,968
  • 31
  • 142
  • 252
0
votes
1 answer

Access 2007: Can this query be created using "Query By Example"?

I'm sure this I can write this in VBA, but the question is: can I do this in Access 2007's Query By Example? Those who will maintain my work are more familiar with Query By Example than VBA. Requirements: I have two tables, a header table and a…
Kevin Rettig
  • 167
  • 1
  • 8
-1
votes
2 answers

content management system and document management system

If you want to look at the differences in the content management system and the document management system in the real world, what is the best example? Thanks for your attention. I’m looking forward to your reply.
1 2 3 4 5 6
7