query 2 « Database « Spring Q&A





1. Generic Query...Application layer question    forum.springsource.org

Generic Query...Application layer question Hi all, I have just read, that I can create generic queries (the example was for use with order by's, just what I would like), now I ...

2. RmiServiceExporter.setServicePort query    forum.springsource.org

RmiServiceExporter.setServicePort query Hi Guys, Can someone explain what is the significance of the setServicePort() method? I have an interface that is exposed over RMI as follows: Code:

3. merging queries from multiple databases    forum.springsource.org

merging queries from multiple databases general question about merging data spread across multiple databases.... say we have data about a resource (a server) which is partially defined in a CMDB (DB2 ...

4. EJBQL query error on Glassfish    forum.springsource.org

EJBQL query error on Glassfish Hi, I have error executing EJBQL query if loadTimeWeaver is set to GlassFishLoadTimeWeaver, part of exception is at org.springframework.orm.jpa.JpaTemplate$9.doInJpa( JpaTemplate.java:307) at org.springframework.orm.jpa.JpaTemplate.execute(Jp aTemplate.java:191) ... 75 more ...

5. Query metrics with Spring    forum.springsource.org

Query metrics with Spring Hi All, I am using Spring 1.2.8 + Hibernate 3.2.2. I have written DAOs using the orm.hibernate3.HibernateTemplate class to execute queries and am also using the TransactionProxyFactoryBean ...

6. Query with display    forum.springsource.org

Query with display Hi all, I have two lists "A" and "B" The query is that I want to ...

7. How to debug the query with real value?    forum.springsource.org

How to debug the query with real value? I have some quite long query to be executed. It becomes very difficult to debug the query since I don't get the query ...

8. slow query when error occurs    forum.springsource.org

Hi, I have a problem when I use the JdbcDaoSupport-class. Here's the class that inherits from the DaoSupport-class: Code: SumItemDao extends JdbcDaoSupport{ ... } Now when I run a sql-query, for ...

9. Query timeouts    forum.springsource.org

Query timeouts Hi All, From reading various articles on the forum, I realize we can put query timeouts on Hibernate criteria/query objects. But I noticed that this timeout in seconds is ...





10. polymorphic query    forum.springsource.org

polymorphic query Hi, i'm traying to run a polymorpich query but Expediente ------> Iniciador ^ | ---------------- | | Alumno (name) Otro (denominacion) I' need to make a query to fetch ...

11. Query for a null value    forum.springsource.org

I have a database and need to do the following: select * from myTable where field1 is NULL I'm using the query functions which take an SQL string and array of ...

12. strange error when executing query    forum.springsource.org

Nov 5th, 2007, 10:41 AM #1 domurtag View Profile View Forum Posts Private Message Senior Member Join Date Oct 2006 Posts 156 strange error when executing query Hi, I have a ...

13. NPE when using HSQLDialect and externalized named queries    forum.springsource.org

Nov 30th, 2007, 12:16 PM #1 jgreyling View Profile View Forum Posts Private Message Junior Member Join Date Nov 2007 Posts 2 NPE when using HSQLDialect and externalized named queries Ok, ...

14. Queries Logging Strategy    forum.springsource.org

Queries Logging Strategy Hello Guys, I want to log all the SQL queries and parameters performed on an application. Im using SimpleJDBCTemplate to execute the queries. What do you think of ...

15. Error in named query    forum.springsource.org

Error in named query Hi, I encounter the following deployment error: org.hibernate.HibernateException: Errors in named queries: spGenMgmtRuleSql Do you know if there is anything wrong in my following hibernate-mapping definition? I'm ...

16. About dynamic query:)    forum.springsource.org

i have a question that for account A whose permission allows listing all regions' record, but for account B can just only listing the "south" region. how can i do this ...





17. Problem with Dynamic queries    forum.springsource.org

Hi!, I have a problem : I have a generic table with varchar columns. Sometimes I'll execute querys with conditions for example like this TO_INTEGER(column) <100. How can I do this ...

18. Named query    forum.springsource.org

19. How To Used Named Query?    forum.springsource.org

Hi, Can we put queries in a separate xml file, not in .hbm files, and read them in DAO layer? Can you please give a example? I tried to find solution ...

20. How to get original query string after url redirected?    forum.springsource.org

How to get original query string after url redirected? We are using Acegi to secure our web service. Suppose a web page that need user log, e.g. with URL http://localhost:8080/myweb/page1.jsp?param1=123 When ...

21. How to implement dynamic queries on an inputsource    forum.springsource.org

We use a HibernateCursorInputSource. How should we implement a more dynamic queryString? Should we subclass the HibernateCursorInputSource and override the queryString? Geir Code: ...

22. Delete using inner query    forum.springsource.org

I'm using spring jdbctemplate to delete few records depending on inner query results.It gives DataAccessException. Here is my query delete from message where message_seq in ( select m.message_seq from m where ...

23. setRollbackOnly() for cancelling database query.    forum.springsource.org

setRollbackOnly() for cancelling database query. Hi, I am new to spring and was trying to see if there is a way to implement the following functionality using Spring Transaction management. I ...

24. Weird Result with JDBCTemplace.query    forum.springsource.org

Weird Result with JDBCTemplace.query Hello, I'm using JDBCTemplate.query to make some query on a FoxPro 3.0 tables. The query works fines except for one value where I have no result ... ...

25. query in xml file    forum.springsource.org

You might want to consider using Apache iBATIS with Spring (Spring offers support for this with SqlMapClientTemplate, etc. - see the org.springframework.orm.ibatis package. iBATIS gives you the functionality you're looking for ...

26. Can't get save queries fired    forum.springsource.org

Hello, my problem seems simple : I do : hibernateTemplate.save(myobject); hibernateTemplate.flush(); But no SQL query logged by hibernate whereas log4j properly configured (as it does log for simple select queries) ... ...

27. query about AnnotationTransactionAttributeSource    forum.springsource.org

query about AnnotationTransactionAttributeSource Hi, I am trying to resolve a problem with this error being thrown: Cannot create JDBC driver of class '' for connect URL 'null' I have asked about ...

28. Search form: problem to transmit queries    forum.springsource.org

Search form: problem to transmit queries Hello, If there's someone who can help me on this difficulties. Thank you very much If you are considering my questions. I would like to ...

29. Redirect with Query String    forum.springsource.org

Redirect with Query String After a user creates a new Something, I want to redirect them to the page viewSomething?somethingId=1234. It's easy enough to do this in my SimpleFormController: return new ...

30. Bad behavior deleting query results    forum.springsource.org

Bad behavior deleting query results Hi folks, I'm using Hibernate3.2 and spring 2.5.5. when a try to execute a query, delete the objects fetched by my query, save an object and ...

31. Project re-architecture query    forum.springsource.org

Project re-architecture query Hi, I currently have a Jboss (4.0.3)/Hibernate/Cocoon based project I would like to re-architect the porject using the Spring framework. Jboss handles hibernate (hibernate.har) whilst coocon is deployed ...

32. Distributed ehcache - queries    forum.springsource.org

Distributed ehcache - queries I have already posted this on ehcache mailing list - thought maybe some of you guys might have some ideas.. I am having some problems with ehcache ...

33. Query about retrying    forum.springsource.org

Query about retrying Hi, As is the case right now, and do let me know if I am wrong, in a chunk if one of the items fails, the processing for ...

34. Setting for named query    forum.springsource.org

Hi, How can I pass my research group ( 'Foo', 'Bar', 'Baz') in my named query? In hbm.xml file, i have a named query

35. Case sensitive query    forum.springsource.org

Hi. I have this method for users authentication process: Code: But the problems is this query is ...

36. Dynamic query tips    forum.springsource.org

Dynamic query tips Hi Just starting with JPA, and I'm writing a query where some of the 'where' clause params are optional, so I'm building up the query string something like ...

37. Query API question (OMG) ?    forum.springsource.org

39. Need help understanding query args/data model mapping when using SimpleFormController    forum.springsource.org

Need help understanding query args/data model mapping when using SimpleFormController Hi folks. I'm tearing my hair out over this problem. I've spent countless hours trying to figure this out, but I ...

40. KeyCollector only for hardcoded queries?    forum.springsource.org

KeyCollector only for hardcoded queries? Hey SBatchy crowd, I would like to use "DrivingQueryItemReader" to provide me key by key from the result set.. well - as designed. However it depends ...

41. Empty query string arg causes form field to display a comma    forum.springsource.org

Empty query string arg causes form field to display a comma Hi there. I have a case where a form gets redisplayed after a validation error. The URL contains a query ...

42. design query    forum.springsource.org

design query HI All, I am using Mule as ESB with Spring MVC. We have three sets of projects namely Service, common and web. All these are maven project and we ...

43. Handler Mapping Query :)    forum.springsource.org

Handler Mapping Query :) Hello All, Can we have multiple Handler Mappers handling the same URL and delegating to the same controller ?? example: ...

44. Query with like    forum.springsource.org

Query with like Hi... I'm trying to make a query with a SQL "like" but simpleJdbcTemplate is not returning results... (it should return two results) This is my code: Code: Map

45. One data object over multiple queries    forum.springsource.org

Hi, I'd like to perform several queries and fill a single instance of a data object with the results from all these queries (use the same object in each RowMapper). Since ...

46. Exception using JdbcTemplates query method    forum.springsource.org

Exception using JdbcTemplates query method Exception in thread "main" java.lang.NoClassDefFoundError at org.springframework.jdbc.core.ArgPreparedStatement Setter.cleanupParameters(ArgPreparedStatementSette r.java:58) at org.springframework.jdbc.core.JdbcTemplate$1.doInP reparedStatement(JdbcTemplate.java:604) at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:537) at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:587) at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:616) at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:624) at org.springframework.jdbc.core.JdbcTemplate.query(J ...

47. ageci not load query    forum.springsource.org

48. Select query with multiple input values    forum.springsource.org

Select query with multiple input values Hi, i am new to spring. i have a simple select query for getting data from the database. Currently i am using the following code ...

49. Matching null values in query    forum.springsource.org

Matching null values in query Hi, I am using JdbcTemplate to execute a query: String query = SELECT COUNT(*) FROM xyz WHERE alpha = ? AND beta = ? I then ...

50. Query about Spring DM behavior    forum.springsource.org

Query about Spring DM behavior Hi, Since a couple of days, I am facing an issue with Spring DM (v1.1.2), running in Equinox (3.2.2). I have 2 bundles, say A and ...

51. complicated query, unique items, group by    forum.springsource.org

invalid SELECT expression [s] for query with grouping [GROUP BY s.viewer]. Only aggregates, GROUP BY items or constructor expressions of these are allowed in the SELECT clause of a GROUP BY ...

52. Not sure how to write this query...    forum.springsource.org

Not sure how to write this query... Hi all, Using Spring / JPA & Hibernate, with my DAOS using the getJPATemplate() method of querying my db I'm stuck designing a particular ...

53. discriminator value with a query    forum.springsource.org

54. Query For Map    forum.springsource.org

Query For Map Hi All, I am trying to retrieve a result set which is a HashMap but i want to use LinkedHashmap. If i used HashMap, the join query results ...

55. Server hangs after loading the query    forum.springsource.org

i am using spring with hibernate. iam updating the status and iam using the query as hibernateTemplate.load(CLASS.class,new Integer(value),LockMode.UPGRADE); ft.setStatus("true"); hibernateTemplate.save(ft); after loading the query, my server is hanging ..its not excuting ...

56. Help on how to dynamiclly create this query    forum.springsource.org

Help on how to dynamiclly create this query Hi folks, I have a small application which I need to search three options in my seach UI screen. However I am not ...

57. How to use inner join queries in ParameterizedRowMapper?    forum.springsource.org

How to use inner join queries in ParameterizedRowMapper? Hi, i have following two queries, how i can get list of them, and what should be return type,as those are coming from ...

58. query lockes    forum.springsource.org

query lockes I have implemented a class that extends Thread and that i have defined as a bean in the application-context.xml file. This bean has associated a dao, that I have ...

59. query lockes    forum.springsource.org

query lockes I have implemented a daemon that each x seconds does a query to a db table. For this I implemented the daemon extending Thread java class and I implemented ...

60. How to: Parameterized IbatisPagingItemReader query?    forum.springsource.org

How to: Parameterized IbatisPagingItemReader query? Back again with another newbie question. I've a multi steps job: One step reads in from a database a value in need to use in queries ...

61. Query difference    forum.springsource.org

Query difference I have two queries that do the same thing, It just appears that one is a lot faster then the other. One takes 5000 msec, and the other about ...

62. Progress bar during query    forum.springsource.org

63. Query regarding license for com.springsource.** bundles.    forum.springsource.org

Hi, I have a query regarding the bundles like tomcat, apache commons etc. which have been made available in springsource enterprise repository. Are these bundles available under the same license as ...

64. error in query execution    forum.springsource.org

error in query execution Code: package project1; package project1; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Types; public class runquery { public static void main (String[] args) throws InterruptedException ...

65. Capturing No Data Found in ItemReader Database Query    forum.springsource.org

Capturing No Data Found in ItemReader Database Query Hello, I was hoping someone could provide me a bit of guidance on the best way to implement something. We have several batch ...

66. Query execution taking too long.    forum.springsource.org

Query execution taking too long. It is taking 261 ms to execute this query. Please suggest any modifications. oid in table vorders has index on oid Code: JdbcTemplate jdbcTemplate = getJdbcTemplate(); ...

67. getSimpleJdbcTemplate().query() deprecated    forum.springsource.org

68. Named query not known Exception    forum.springsource.org

Named query not known Exception i have used spring+hibernate+JPA org.springframework.orm.hibernate3.HibernateSystem Exception: Named query not known: repairPendingObserveBlockCode; nested exception is org.hibernate.MappingException: Named query not known: repairPendingObserveBlockCode org.springframework.orm.hibernate3.SessionFactoryU tils.convertHibernateAccessException(SessionFactor yUtils.java:676) org.springframework.orm.hibernate3.HibernateAccess or.convertHibernateAccessException(HibernateAccess or.java:412) ...

69. Why finders return Query    forum.springsource.org

Hi, what was the reason for the finders generated using say: finder add --finderName findUsersByCode --class foo.bar.User to return a Query rather than a list of User - List I dont ...

70. Chunk Processing - Listener Query    forum.springsource.org

Chunk Processing - Listener Query Hi folks, well done on the excellent work so far... I'm looking to adopt chunk processing inside one of my Spring Batch Jobs. I need to ...

71. Active Directory: Authenticating only via bind instead of query    forum.springsource.org

Active Directory: Authenticating only via bind instead of query Hi, I want to authenticate the useres of my webapplication against our internal active directory. I have the applicationContext-security set up as ...

72. Group-by query    forum.springsource.org

Group-by query Hi everyone, I'm struggling for a long time with a Hibernate query. It is a group-by query but I can't succeed in fetching the whole object (since I have ...

73. Facing issue, when try to create search query    forum.springsource.org

Facing issue, when try to create search query Hi All, When i try to create search function, query is creating as below as per the console. select this_.USERNAME as USERNAME1_0_, this_.ADDRESS ...

74. SpringJDBC Select Query In Clause More than 500    forum.springsource.org

SpringJDBC Select Query In Clause More than 500 Hi All, I am trying to solve the following issue, I have the following sql query. String sql = select * from db ...

75. want to write my own query    forum.springsource.org

hi all...i want to write my own query not that are created by scaffold controller..i don know where should i write those queries..i tried to write in entity class but it ...

77. How to optimized large query?    forum.springsource.org

How to optimized large query? Hi, I'm using spring 3, JDK 6. I have a very large data to extract After around 2000 data extracted I have this error Code: Exception ...

78. M2 Development build query    forum.springsource.org

I have downloaded the latest code 1.1.0.M2 [rev 5c7907b] from git today and tested it out. I found a few issues with it. Just wanted to know if I can log ...

79. Post query data restructuring    forum.springsource.org

Post query data restructuring Hi, I have an entity called CalendarEvent. Each CalendarEvent have a start date and end date. I'm trying to group my CalendarEvent by date. So for this ...

80. When i am Using another Query it throws me java.lang.ClassCastException    forum.springsource.org

When i am Using another Query it throws me java.lang.ClassCastException Hello, this would be my 3rd post, in this community :3. here is my problem whenever i use hql : "from ...

81. getSimpleJdbcTemplate.query problem    forum.springsource.org

getSimpleJdbcTemplate.query problem Hello, I'm developing a batch based on Spring Batch 2.0.3 and spring-jdbc 2.5.6, I made a Dao including a method that retrieves, using getSimpleJdbcTemplate a list of objects from ...

82. could not execute query - please help.    forum.springsource.org

could not execute query - please help. Hi, WithSpring 3.0 and JPA, I encountered the following error when I tried to add this portlet onto the page. Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: ...

83. DB Connection problem: everything freezes after 8 queries    forum.springsource.org

DB Connection problem: everything freezes after 8 queries Hello, I have the following problem: My application stops responding and puts a web browser into infinite "contacting localhost" after 8 Queries. I ...

84. JUnit test query    forum.springsource.org

Aug 23rd, 2010, 10:11 AM #1 dexter316 View Profile View Forum Posts Private Message Junior Member Join Date Aug 2010 Posts 3 JUnit test query Sorry for cross posting (In in ...

85. Query related to Spring Cntroller    forum.springsource.org

Hi, I am very much new to spring MVC. I have some doubt related to the controller. I have few URLs which ends with .do in my application. Like: http://host/locale_context/action.do http://host/locale_context/login.do ...

86. Getting query string output after query execution    forum.springsource.org

Hi all! I am new to Spring, and having implemented several query methods, have begun to wonder if it is possible to output the query after it has been executed. For ...

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

Sep 29th, 2010, 08:00 AM #1 amar4kintu View Profile View Forum Posts Private Message Junior Member Join Date Sep 2010 Posts 19 no persistent classes found for query class Hello friends, ...

88. How to disable count query?    forum.springsource.org

How to disable count query? I have to use an older version of JPA and the Hibernate EntityManager (3.4.0.GA), rather than the current 3.5.5.Final. Because of this, the createQuery method does ...

89. query on mutiple handlermapping configuration    forum.springsource.org

query on mutiple handlermapping configuration We are using spring MVC 2.5 and currently have a dispatcher servlet using SimpleUrlHandlerMapping. And we are trying to add a new addon servlet using import ...

90. queries per page - how many?    forum.springsource.org

Hi, Until now, I have only had to run 1-3 queries per page. Is is reasonable to run say 50 queries for one page? I know I could just run a ...

91. Wiered behaviour while executing select query    forum.springsource.org

First time when i execute a query using spring jdbc template it returns one record, but on second time execution immediatley after the first exection the same query fails by throwing ...

92. redirect problem with encoded query string    forum.springsource.org

redirect problem with encoded query string Hello I use SpringMVC 3.04 My Application help users to post links on social site. The posted link is sent as a query string parameter ...