SQL 3 « Database « Spring Q&A





1. MSSQL problems    forum.springsource.org

MSSQL problems Hi Guys, I've just been taking a look around Roo and am impressed so far. I've had an issue though with MSSQL drivers (often a problem). When I deploy ...

2. How to implement the SQL Data Source Partitioning    forum.springsource.org

Hi Everybody, I need help in implementing SQL Data Source Partitioning given in the Usecases of the Spring-source documentation site. If anybody knows how to implement the partition using Data source., ...

3. SQL in finders    forum.springsource.org

Hi Ronald, Interesting, can you let me know which DB and ORM provider you are using in your sample? As always, a small Roo script would help us pin down the ...

4. Sql Logging    forum.springsource.org

Hi, I am using SpringBlazeDs Integration with hibernate and I would like to know if any one has used JDBC Logger(http://jdbclogger.sourceforge.net/) to print SQL statements with values. I have integrated it ...

5. Sql query variables    forum.springsource.org

Sql query variables Hi, I want to know if I can do something like this in a class that extends SimpleJdbcDaoSupport: String sql = "INSERT INTO db1.t1 SET id = @id ...

6. Groovy/Grails with SQL Server - help?    forum.springsource.org

Groovy/Grails with SQL Server - help? Can anybody help a newbie with this? I'm trying to use Groovy and Grails to access a SQL Server database. I have downloaded the Microsoft ...

7. nested exception is java.lang.NoClassDefFoundError: javax/sql/DataSource    forum.springsource.org

Aug 3rd, 2009, 07:47 AM #1 mimzkhan View Profile View Forum Posts Private Message Junior Member Join Date Aug 2009 Posts 4 nested exception is java.lang.NoClassDefFoundError: javax/sql/DataSource Hi all, I have ...

8. SQL in xml    forum.springsource.org

SQL in xml public static final String INSERT_DRUG = "INSERT into Drugs( brand_Name,label_Name, gen_Name, product_Id,gcn_SeqNbr, hicl_SeqNbr,formulary_Tier," + "multiSource_Ind,genPrice_Cd,hic3,hic3_Desc,hICL,r xRequired_Ind,maintenance_Ind,innovator_Indicator, " + "genericTherapeuti_ClassCd,genericTherapeutic_Clas sDesc,standardTherapeutic_Class,stdtdTherapeutic_C lassDesc," + "genTherapeutic_DrugCode,genTherapeutic_Descriptio n,manufacturer_Name,manufacturer_Id,genNamed_DrugI ndicator," + "genNamed_DrugDescription)" + ...

9. SQL - depend on DatabaseVendor    forum.springsource.org





10. Passing sql query dynamically    forum.springsource.org

Passing sql query dynamically Having a requirement like this...need to pass the sql query dyncamically to spring batch. Currently hardcoding the sql query in the spring batch configuration file , but ...

11. How to pass a value from ksh wrapper script to a SQL insert    forum.springsource.org

How to pass a value from ksh wrapper script to a SQL insert Hello, I am parsing the base directory name from the full directory path which needs to be inserted ...

12. Late binding of a JobParameter value for SQL insert    forum.springsource.org

Late binding of a JobParameter value for SQL insert Hi, I am trying to do a database table insert of a value passed as a JobParameter value passed to the CommandLineJobRunner. ...

13. Storing sql statements in one .properties file    forum.springsource.org

Storing sql statements in one .properties file We are migrating our current existing code off from Struts (finally!) to Spring. We currently have a couple of *.properties files where we keep ...

14. Design for overriding SQL statements at runtime    forum.springsource.org

Design for overriding SQL statements at runtime Can I run a design idea past the gurus in this forum? We have a requirement to be able to change SQL statements used ...

15. log sql w/ log4j    forum.springsource.org

Nov 24th, 2009, 01:19 PM #1 philswenson View Profile View Forum Posts Private Message Junior Member Join Date Nov 2009 Posts 8 log sql w/ log4j I'm evaluating the spring framework. ...

16. Real World Example Project using SQL Server 2008 and WebSphere App Server V7    forum.springsource.org

Hi, Roo is great. It simplifies a lot of things. But has anyone done / implemented the wedding sample using a real world example using SQL Server 2008 (non-integrated authentication) for ...





17. SQL Query with null values    forum.springsource.org

SQL Query with null values I have a web form with many select box and text inputs, when the user can fill in some or all of them. How can i ...

18. catalog issue with MSSQL    forum.springsource.org

Hi Shri, You may be able to use the @JoinTable annotation, which does have a 'catalog' attribute. https://www.hibernate.org/hib_docs/e...JoinTable.html Try using it on the LineItem entity, since it owns the FK. Otherwise, ...

19. Executing Multiple SQL Statements    forum.springsource.org

Hi All I have to render a page with a number of filters. The filter data has to be fetched from the database. Is there any way, in SPRING, where I ...

20. TestNg Integration Test can't load SQL resource    forum.springsource.org

TestNg Integration Test can't load SQL resource Hi all, I'm having some trouble trying to put together a TestNG integration test. I'm trying to connect to an HSQLDB database to load ...

21. JDBC Configuration with MSSQL    forum.springsource.org

JDBC Configuration with MSSQL I'm trying to do a very simple test with roo (ten minute sample but using MSSQL as the database instead of HYPERSONIC_INMEMORY). My first issue is trying ...

22. Grails with SQL Server data source    forum.springsource.org

Grails with SQL Server data source This is not a question but a comment to anyone looking for help to set up a data source from a Grails application to SQL ...

23. Word docs into Sql Server 2005    forum.springsource.org

I have to save .doc files into my database (rather than saving the URL/UNC). The table is something like this: id_doc int PK doc varbinary(MAX) aka BLOB I get the word ...

24. How to log sql query    forum.springsource.org

25. Using parameterized sql with Itemreader    forum.springsource.org

Using parameterized sql with Itemreader Hi, I am doing a prototype with springbatch on websphere using mysql. The sql for the itemreader is a parameterized sql. This works if it the ...

26. Problem with connection SQL Server 2008    forum.springsource.org

Problem with connection SQL Server 2008 Hi all I want to attache my Roo project With SQLServer 2008 For This I use persistence setup --provider HIBERNATE --database MSSQL The i change ...

27. problem with sql query    forum.springsource.org

problem with sql query Hi all, I just want to get rows from a Table using a JdbcCursorItemReader, but i have a problem with sql statement. I have this

28. different sql statements in a writer    forum.springsource.org

different sql statements in a writer Hi all, i have the following: 1)Read from a DB 2)Proccess those rows 3)Write in a DB And the files that i have are: 1)LeerBBDDJob.xml ...

29. Property 'sql' is required    forum.springsource.org

Property 'sql' is required I have a class as follows Code: Class Proc { private Map in; // corresponding getter setter methods } Config Code:

30. SQL exception translation    forum.springsource.org

Jul 29th, 2010, 03:51 PM #1 trebor1970 View Profile View Forum Posts Private Message Junior Member Join Date Jul 2010 Posts 1 SQL exception translation I'm using SpringDM 2.0.0.M1 & Spring ...

31. Enabling show sql does not seem to work!    forum.springsource.org

Enabling show sql does not seem to work! Hi I am unit testing my dataaccess code and I want to see sql generated by hibernate. I have defined show sql property ...

32. Making MSSQL[JTDS] work with DBRE in rooM3    forum.springsource.org

Making MSSQL[JTDS] work with DBRE in rooM3 Hi All, I tried out DBRE with MYSQL and worked beautifully. Now I need to RE an MSSQL based database. After commands: > persistence ...

33. java.sql.BatchUpdateException    forum.springsource.org

java.sql.BatchUpdateException Hello, In my service method I move a unique value from one object to the other. But I get a unique constraint violation because the value in the database has ...

34. Problem getting sql parameter values with log4j    forum.springsource.org

Problem getting sql parameter values with log4j I am using: - Spring 3.0.1 - Log4j 1.12.15 - Oracle 10j I need to see the values that my Spring application is sending ...

35. atomikos SQLSERVER jtds com.atomikos.datasource.pool.CreateConnectionExcep tion    forum.springsource.org

Oct 4th, 2010, 11:29 AM #1 amberbee1999 View Profile View Forum Posts Private Message Junior Member Join Date Jun 2006 Posts 5 atomikos SQLSERVER jtds com.atomikos.datasource.pool.CreateConnectionExcep tion Hi I am looking ...

36. SQLFunction not working with Microsoft SQL Server JDBC Driver    forum.springsource.org

SQLFunction not working with Microsoft SQL Server JDBC Driver Hi, In my web application I am changing over from JTurbo driver to the MS SQL Server JDBC driver 3.0 - JTurbo ...

37. Why is autowired sql client not reading database statements?    forum.springsource.org

Why is autowired sql client not reading database statements? Hi, I'm using Spring 3.0, Tomcat 6.0.26, Java 1.6, and iBatis 2.3 (SQL ORM package). In my @Configuration class, I have ... ...

38. MS SQL Server persistent_logins ERROR    forum.springsource.org

Oct 19th, 2010, 02:10 PM #1 sasa.bolic View Profile View Forum Posts Private Message Junior Member Join Date Oct 2010 Posts 2 MS SQL Server persistent_logins ERROR I am trying to ...

39. How can I get the job execution id from within an 'sql property    forum.springsource.org

Code: select process_name from all_processes where job_execution_id = ??; ...

40. SQL exception handling    forum.springsource.org

SQL exception handling hello, I am facing an understanding problem with the way spring is handling hibernate exceptions. What I want is to generate user friendly messages using the exceptions thrown ...

41. Bind sql statement parameters with log4j.xml    forum.springsource.org

I posted some issue at the Hibernate forum, but I'm now wondering if I would not get more (that is some :-) support at the Spring forum instead. Here is the ...

42. List of reserved SQL keywords    forum.springsource.org

Please can someone direct me to a list of SQL keywords that are reserved in Roo. I keep getting, for example: Reserved SQL keyword 'primary' is not permitted as symbol name ...