query 1 « Database « Spring Q&A





1. In Java/Spring, how do you setup the hashmap to append the query string?    stackoverflow.com

in spring-config/applicationContext-mapping.xml: I have this code fragment:

<bean id="unused-url-quick" class="java.util.HashMap">
 <constructor-arg>
 <map>
          <entry key="/page.html" value="/otherpage.html"/>
          ...

2. How to execute query with IN clause in spring?    stackoverflow.com

I have following code :

try {
            MapSqlParameterSource parameters = new MapSqlParameterSource();
          ...

3. Why request.getRemoteAddr() returns ipv4 or ipv6 depending on context (post query or ajax query)    stackoverflow.com

I've donne a web app with Spring/GWT that uses Flash to upload files. When I send an ajax request with GWT and try to get the user ip address, I get an ...

4. Spring persistence layer for dynamic queries    stackoverflow.com

I have legacy app having its own persistent layer. I cannot call it a framework but it does its job although very complicated and not componentised so gets very difficult to ...

5. CouchDB Ektorp Select Query    stackoverflow.com

I am examining example Blog example of CouchDB. I use Ektorp at Spring for CouchDB. I wanted to implement it into my application. I have users at my couch db when ...

6. Item Reader with multiple query strings    forum.springsource.org

Item Reader with multiple query strings Hello, I am looking for an implementation of an item reader that takes multiple query strings as part of the input. The queries would potentially ...

7. Too many queries too fast, what now?    forum.springsource.org

In general these kind of exceptions have to do with no or wrong transaction management, which leads connections dangling until they time out. So check your tx configuration/usge.

8. how to execute two queries consecutively    forum.springsource.org

how to execute two queries consecutively Hello, I have two queries which should be executed consecutively. I'm trying to do this: 1). 2). and then to use ...

9. multiple databases query (with a twist)    forum.springsource.org

multiple databases query (with a twist) I'm looking at Spring and iBatis as the basis for a new project. My requirements are two fold. firstly i need to provide CRUD functionality ...





10. Multiple Query Results in a single DTO    forum.springsource.org

Multiple Query Results in a single DTO Hi all. I am still relatively new to Spring and many of it's finer features especially a lot of its helpful tricks. I've come ...

11. using last successful run date for query in next run    forum.springsource.org

I am using JdbcPagingItemReader for processing entries in my database. There is a timestamp column in the table I am querying and I want the JdbcPagingItemReader in the next run to ...

12. How to change a query?    forum.springsource.org

I have a table that contains some foreign keys that refer to other tables. In the the list of the records I would like to show a field of the referenced ...

13. Myln Trac Query Can't Use Type Or Priority    forum.springsource.org

I'm just getting started with STS (for Grails development) and Mylyn. I've been able to connect Mylyn to trac and create a query. But I the query screen has type and ...

14. query.getResultList() returns a list with identical objects    forum.springsource.org

query.getResultList() returns a list with identical objects Hi to all, I do a simple select query. The returning list contains the exact number of records/objects as if I do the same ...

15. Db query    forum.springsource.org

Apr 4th, 2011, 03:59 PM #1 gosiaisean View Profile View Forum Posts Private Message Junior Member Join Date Mar 2011 Posts 11 Db query Hi. Im not sure where to post ...

16. Flight reservation system query    forum.springsource.org

Flight reservation system query Hello, I am working on a flight reservation system wherein i have a form to display the outgoing and return flights for user selected destinations. For example: ...





17. An query about design Issue    forum.springsource.org

An query about design Issue Hi, I am trying to implement an application using Spring. The application is an simple application in which 3*3 grid is shown to the user. User ...

18. Driving Query pattern and composites    forum.springsource.org

Driving Query pattern and composites Actually it is not a composite, it is a wrapper object, an account with orders. I am a bit blank on how I would implement the ...

19. why query all data first    forum.springsource.org

why query all data first I have two classes, they are parent/children relationship. When I want to build list of parent, the findAll method of parent and children is invoked. This ...

20. best practice for insert queries    forum.springsource.org

hello, just wanted to see what other spring developers use for insert queries. I know there is MappingSqlQuery for mapping to objects, and UpdateQuery for update queries. I was thinking about ...

21. Execution of query    forum.springsource.org

22. advise on spring db query    forum.springsource.org

I am looking to use Spring Batch to read Flat file, one of the column values in each line in the file will be used to fetch additional data from the ...

23. dinamic query    forum.springsource.org

Is there any support for a method that extracts the query string from an annotated method parameter? I want to use this method to let the client construct query strings at ...

24. ACL and query for domain objects    forum.springsource.org

ACL and query for domain objects Hi all, currently I'm trying to understand how to use the provided ACL package in acegi. What would be the best way to filter on ...

25. XML reader query    forum.springsource.org

Hello All, I have the following input file for xml: Code: POJO will have ...

26. Could not execute query..    forum.springsource.org

Could not execute query.. Hello, I have a problem with the display of my database ... I am currently developing a web application with Maven and Spring, I split my project ...

27. How to add Repository method name to generated Query ?    forum.springsource.org

How to add Repository method name to generated Query ? Hi all, we use Spring Data JPA with Hibernate to create data-repositories. We use the generation of Queries by convention from ...

28. Problem in getting query result in hashmap    forum.springsource.org

Problem in getting query result in hashmap i am trying to get all record in hashmap, while iterating and putting in hashmap, i am getting error i have 'std' table where ...

29. Query multiple SQLs in single connection - HOW?    forum.springsource.org

Hi, I've a requirement as NOT to use pl/sql stored procedure and to execute several SQL queries in single connection. I saw JdbcTemplate has a method batchUpdate(String[] sql), but I need ...

30. 2 queries against different databases    forum.springsource.org

I have a method with the following calls to the DAO layer: Code: auditDao.capture(user, time, entity, oldValue, newValue); // maps to an insert statement carDao.insert(car); In the DAO, I use iBatis. ...

31. query regarding .MessageGroupStoreReaper...    forum.springsource.org

Hi, I was going on through the official manual of spring integration with context to aggregator and I also go through the topics of message store and .MessageGroupStoreReaper, please if you ...

32. Query regarding poller ....!!    forum.springsource.org

Nov 15th, 2011, 04:16 AM #1 SARAL SAXENA View Profile View Forum Posts Private Message Senior Member Join Date Sep 2011 Posts 154 Query regarding poller ....!! Hi, I have one ...

33. query for not losing the message    forum.springsource.org

query for not losing the message Hi, I have a query , I am currently developing an application in which my I will read the data from the queue and will ...

34. spring 3.0.5 query timeout    forum.springsource.org

Hi All, I have a requirement that while executing a query, if the query takes more than certain limit time, then an exception must be thrown. Please let me know, how ...

35. Ignoring fields in update query when not present    forum.springsource.org

Ignoring fields in update query when not present I have a form to update a table, but not all fields are editable on the form, say for example username if I ...

36. Quick question: using multiple query keywords in query method names    forum.springsource.org

Hi all, Quick high-level question. Can I use query keywords on more than one property in query method names? For example: Code: List findByEmailLikeAndStatusIn(String email, Set statuses, Pageable pageable); My intention ...

37. Wildcard Query    forum.springsource.org

Wildcard Query Hi, I'm trying to migrate an existing project to Spring Data JPA. We have the following implementation of a Query Method: Code: @Override public List findBooksByCriteria(String title, String isbn, ...

38. dynamic queries    forum.springsource.org

dynamic queries hi, I'm trying to implement some dynamic queries in springs dao framework. What i'm essentially trying to do is supply some parameters for other things than real sql parameters. ...

39. Using mapping declaration or named query?    forum.springsource.org

Using mapping declaration or named query? I need to do the follow query, I guess I can use mapping declaration or named query. Which way is better off? Is there performance ...

40. Using mapping declaration or named query?    forum.springsource.org

Using mapping declaration or named query? I need to do the follow query, I guess I can use mapping declaration or named query. Which way is better off? Is there performance ...

41. help with the named query    forum.springsource.org

help with the named query I defined a named query in my .bhm.xml file

42. help with the named query    forum.springsource.org

help with the named query I defined a named query in my .bhm.xml file

43. Returning an Object and a Value from Query - Help    forum.springsource.org

Returning an Object and a Value from Query - Help Please help me with this simple problem. a Project contains set of Tasks... See my mapping files below: Project.hbm.xml contains: Code: ...

44. "Select ... where ... in" queries    forum.springsource.org

Is there a way to execute an SQL query of the form Code: select x,y,z from t where x in (?) as a MappingSqlQuery or something similar? I would like to ...

45. Spring Query API    forum.springsource.org

Spring Query API Hi All, I have been thinking for some time about what I believe would be a useful extension to the Spring framework, specifically to the DAO and ORM ...

46. Query string - Depending on passed values    forum.springsource.org

Query string - Depending on passed values Hi, I've got a function like this: Code: public List getList(String a, String a, Date c) { String query = "from de.model.sap.Table1 t1 where ...

47. UI Decorators query    forum.springsource.org

UI Decorators query I'm working on a J2EE (Spring + Hibernate) accounting application which has a fairly complex domain model including classes with nested properties & collections. Eg (getters/setters excluded for ...

48. Query. setMaxResults(1).uniqueResult() - how in spring ?    forum.springsource.org

Query. setMaxResults(1).uniqueResult() - how in spring ? I wanna achieve something like this : Query q = session.createQuery("............"); ABC obj = (ABC) q.setMaxResults(1).uniqueResult(); The problem is HibenateTemplate doesn't have any api ...

49. Turning query in to CSV data    forum.springsource.org

I would probably say that JasperReports is overkill for just CSV data. If you need other formats that JR is great. Creating CSV data is actually quite easy and you could ...

50. Named query definition & configuration problem    forum.springsource.org

Named query definition & configuration problem Since I have a few complicated queries, I thought it would be better to use named query method and definite them outside of Java DAO ...

51. Query the database views    forum.springsource.org

Query the database views Is accessing the database view are same as tables using hibernate3 and springframework ?. I get a null values populated . The hibernate mapping was done using ...

52. Error named queries    forum.springsource.org

53. new to Spring few queries    forum.springsource.org

new to Spring few queries HI All ! I am very very new to Spring Frame work, previously i worked on struts just planning to apply an architecture like struts-spring-hibernate/ibatis kind ...

54. Whic method to call for where query ?    forum.springsource.org

I am using Hibernate and Spring. I need to write a query with where cluase. Ex: select * from Testtable where id=123 Could some tell which method I have to call ...

55. no query string in handler    forum.springsource.org

no query string in handler Hi- Here's another newbie Spring web question: I'm using Spring MVC and subclassing AbstractController for my handlers. Surprisingly, for an HTTP POST, parameters encoded into the ...

56. Named Queries... Best practices w/ Spring    forum.springsource.org

Using named queries is a best practice IMO when the queries are non-obvious. I've been to and fro about where to put them. I usually put them in the most relevant ...

57. To pass null values to JdbcTempalte.query    forum.springsource.org

To pass null values to JdbcTempalte.query I working with Oracle 10g and I had an exception getJdbcTempate.query(sql, new Object[]{null}, rewMapper); java.sql.SQLException: Wrong column type at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179) at ...

58. nested queries    forum.springsource.org

59. Query component - interface question    forum.springsource.org

Query component - interface question Hi all, I need to build a query component which will be reused in a variety of situations. Let's just say that there are many possible ...

60. whats the return type of the foll query    forum.springsource.org

Hi all, I have a query like this. query = "select avg(cert.rating) FROM CertAgentImpl cert" what would be the return type of the hibernateTemplate.find(query); will it be List itself ? in ...

61. Syntax for SpringJDBC query with function    forum.springsource.org

Query below didnt work. What is the correct syntax for constructing query with SQL function? upper(?) seems to cause error... ================= select u.uri_id, u.uri_title, u.uri from sc_uri u where upper(u.uri_title) like ...

62. Spring framework queries...    forum.springsource.org

Spring framework queries... Hi All, Am studying spring after getting inspiration from Rod's "without EJB" book. Currently am working on struts with EJB.Few of my queries are, 1.We don't have a ...

63. Native query with 2.0-m4 and JPADaoSupport?    forum.springsource.org

Native query with 2.0-m4 and JPADaoSupport? With 2.0-m3, I used getEntityManager() in my DAO (that extends JPADaoSupport) to get an EntityManager to work with. In 2.0-m4, getEntityManager() is removed so I'm ...

64. Named Query not known    forum.springsource.org

Named Query not known Hello, In my hbm.xml file, I have the following query In my java class, I'm calling the above query using ...

65. elp on my query project T_T    forum.springsource.org

May 22nd, 2006, 04:49 AM #1 Chesa View Profile View Forum Posts Private Message Junior Member Join Date May 2006 Posts 26 elp on my query project T_T userForm.jsp <%@ include ...

66. Insert query JUnit test case    forum.springsource.org

Insert query JUnit test case I have a method saveConfig(ImportConfiguration importConfiguration)in DAO. This method will be running either Update or Insert based on the seq id. If the seq id is ...

67. JUnit test case failed for select query    forum.springsource.org

Jun 7th, 2006, 10:41 AM #1 gsomasekhar View Profile View Forum Posts Private Message Junior Member Join Date Jun 2006 Posts 5 JUnit test case failed for select query The below ...

68. Queries and Result Sets    forum.springsource.org

Queries and Result Sets I am a newbie to Spring (using spring 1.2.7) and I am trying to use a SqlQuery/MappingSqlQuery to execute a query. The problem is that the query ...

69. Query result is empty if hbm file is not referenced    forum.springsource.org

Query result is empty if hbm file is not referenced In the application that I am developing, I am using a class (CountryManager) that is defined in a jar file. This ...

70. custom property editor query    forum.springsource.org

custom property editor query Im a little bit confused after reading the docs and is challanged with a problem... I have a "Class One" with variable "Class B". The "Class B" ...

71. Where to process query in a form ?    forum.springsource.org

Where to process query in a form ? Hi ! obviously a stupid question but I'm really new to Spring (a few days) and everything isn't completely clear in my mind. ...

72. Simple form controller's form view query    forum.springsource.org

Simple form controller's form view query Hi, I have a simple form controller that handles user authentication. Its form view displays a form, where users provide username and password. I want ...

73. Audit log the "select" executed in a query    forum.springsource.org

Audit log the "select" executed in a query Hi, My name is Aitor. Im working with spring Framework (spring+ibatis) and I need to get the details of the last query executed. ...

74. Calling Stored Prcedure with Named Query    forum.springsource.org

Calling Stored Prcedure with Named Query Hi all, Iam working on an application where spring with hibernate is used. Iam using hibernate classes that are provided in springs. I have a ...

75. Query form result on same page    forum.springsource.org

Query form result on same page Hey all, newbie here... I have a page, with a form that queries a DB for a customer id. I want to display the customer's ...

76. Advice interceptor - get query executed    forum.springsource.org

Hello, I'm working with SpringFramework+iBatis. I need to get the data an the query executed from a DAO object. From the advice object I get the data returned by the query, ...

77. Migrating queries that use ResultReader    forum.springsource.org

Oct 21st, 2006, 06:12 PM #1 gpitteloud View Profile View Forum Posts Private Message Member Join Date Oct 2006 Posts 75 Migrating queries that use ResultReader Hi all, Being about to ...

78. A query on web forum    forum.springsource.org

Hi, This is a bit related to the forum and I just wondered how's it happening. Down at the bottom of this forum there are 349 threads (http://forum.springframework.org/forumdisplay.php?f=25), well 350 now. ...

79. Tag Form rendered with query string    forum.springsource.org

Nov 20th, 2006, 11:27 AM #1 moacsjr View Profile View Forum Posts Private Message Junior Member Join Date Apr 2005 Location Belo Horizonte, MG - Brasil Posts 25 Tag Form rendered ...

81. Spring/Hib adding .value, .offset, .count, and .hash to query    forum.springsource.org

Nov 24th, 2006, 05:03 PM #1 amccall View Profile View Forum Posts Private Message Junior Member Join Date Nov 2006 Posts 2 Spring/Hib adding .value, .offset, .count, and .hash to query ...

82. Database query vs Set iteration    forum.springsource.org

Database query vs Set iteration Hi All, Assume a model with a user who has lots of subscriptions. The user class hence has a Set called subscriptions which holds all the ...

83. Dynamic Query    forum.springsource.org

Dynamic Query Hello All, Here is my problem, I have a screen where customer can enter either one of the given fields like Product Number, Description, Manufacturer and then i build ...

84. Query client side database    forum.springsource.org

Query client side database can some one help me with this problem. How can I query client side database through the internet from a server application that run on the internet. ...

85. AbstractTransactionalSpringContextTests query    forum.springsource.org

Hi, I'm using AbstractTransactionalSpringContextTests so that the tests will be rolled back automatically. However, I have noticed that if there are not null columns in the db, the tests do not ...

86. forcing a form 'submit' via query string    forum.springsource.org

87. DataFieldMaxValueIncrementer query??    forum.springsource.org

DataFieldMaxValueIncrementer query?? This is from Spring's API docs. Please let me know if want to use class MySQLMaxValueIncrementer for the purpose of generating the key,do i need to manually create the ...

88. Named Param query problem    forum.springsource.org

Hi , I want to use "findByNamedParam" but if we have multiple param then is there some way to add as map or somthing instead of giving two arrays one of ...

89. fastest path to XML from query results    forum.springsource.org

Can anybody suggest the fastest way to get the results of a SQL query published as web accessible XML? Nominally, I'm using Oracle with Ibatis and Spring. I know that Oracle ...

90. How to find the query pertaining to the StatementID    forum.springsource.org

How to find the query pertaining to the StatementID Hi I posted this before , but i havent got reply. Iam wondering may be iam not very clear in my question. ...

91. Dynamic query Design    forum.springsource.org

Dynamic query Design Hi, the project I'm working, will user db4o as DB system. this works good and verry fast, but know i have a Problem. the main page all users ...

92. query problem    forum.springsource.org

query problem Hi, i have this mappings Code: @Entity @Inheritance(strategy=InheritanceType.JOINED) @org.hibernate.annotations.Entity(dynamicInsert= true, dynamicUpdate=true) @Table(name="CODIGOS") @AttributeOverride(name="id",column=@Column(name="CODIGO_ID")) public abstract class Codigo extends EntidadBase { } Code: @Entity @org.hibernate.annotations.Entity(dynamicInsert= true, dynamicUpdate=true) @Table(name="CODIGOS_FIUBA") @PrimaryKeyJoinColumn(name="CODIGO_FIUBA_ID") public ...

93. Filter URL patterns including query strings    forum.springsource.org

94. JP QL query not returning expected results    forum.springsource.org

JP QL query not returning expected results I'm using Spring JPA and toplink. I've written a JP QL query to retrieve some information from the database however its not returning the ...

95. Problem with many-to-many and insert query    forum.springsource.org

Problem with many-to-many and insert query Hi I have some problems with my many-to-many association. I have a table person, a table language and a table persons_languages In my java object, ...

96. query on tiles-example    forum.springsource.org

In tiles-example , tiles-servlet.xml Code: /WEB-INF/defs/definitions.xml but this bean was never used for configuration of any other beans can any one please ...

97. The complex query VO    forum.springsource.org

The complex query VO Presented: a solution to the complex query ORM problem. The source is included in the first three responses. The dilemma is complex queries that are the bane ...

98. Generic queries HibernateDAO    forum.springsource.org

Generic queries HibernateDAO I'm trying to figure out the right way to do generic hibernate queries in Spring. I'm just starting out with this, so please be forgiving about any very ...

99. Help executing callable query    forum.springsource.org

Help executing callable query Hello, Can anybody help me execute following callable query: Code: BEGIN ? := case MY_FUNC(?, ?) when true then '1' else '0' end; END; I'm using oracle ...

100. no persistent classes found for query class    forum.springsource.org

Jul 12th, 2007, 06:00 AM #1 Esil2008 View Profile View Forum Posts Private Message Member Join Date Jun 2007 Location Marseille - France Posts 78 no persistent classes found for query ...