MySQL 2 « Database « Spring Q&A





1. MySQL wait_timeout issue    forum.springsource.org

MySQL wait_timeout issue Hi, I'm developing a web application running in a Tomcat server, which uses Spring and Hibernate. The DB is MySQL. MySQL have a feature that makes stale any ...

2. MS SQL Server -> MySQL    forum.springsource.org

MS SQL Server -> MySQL I'm trying change the MS SQL Server database to MySQL in my client's application, usually this has been quite easy, just tweak some SQL, but now ...

3. problem subselect mysql    forum.springsource.org

Apr 1st, 2008, 07:11 PM #1 totoliso View Profile View Forum Posts Private Message Senior Member Join Date Jan 2007 Posts 155 problem subselect mysql Hi, i have problems with a ...

4. Mysql 4.1 & weblogic 9.1 - Failed to Generate Wrapper Class    forum.springsource.org

Mysql 4.1 & weblogic 9.1 - Failed to Generate Wrapper Class Hi all, we have an application that has been running succesfully on Tomcat for while. Now, one of our clients ...

5. Problem with org.springframework.jdbc.object.StoredProcedure and MySQL    forum.springsource.org

Jul 2nd, 2008, 04:54 PM #1 fmi2 View Profile View Forum Posts Private Message Junior Member Join Date Aug 2007 Posts 8 Problem with org.springframework.jdbc.object.StoredProcedure and MySQL Hi guys I have ...

6. Problem connecting to MySQL    forum.springsource.org

7. Database hangs after a Mysql exception    forum.springsource.org

Aug 29th, 2008, 04:04 AM #1 monzonj View Profile View Forum Posts Private Message Junior Member Join Date Jul 2008 Posts 25 Database hangs after a Mysql exception Hi! Im having ...

8. CNFE when loading mysql jdbc driver    forum.springsource.org

Sep 1st, 2008, 10:04 PM #1 rjrojas View Profile View Forum Posts Private Message Junior Member Join Date Sep 2008 Location Reading, PA, USA Posts 9 CNFE when loading mysql jdbc ...

9. contacts example mysql version    forum.springsource.org

contacts example mysql version hi all,I want to replace hsqldb with mysql in contacts example.so I first created a database named springacls,then I got a sql script from spring-security-acl-2.0.3.jar and modified ...





10. MySQL - Java data types mapping    forum.springsource.org

Hi I'm confused when creating a Hibernate's persistent class. MySQL's unsigned int value ranges from 0 to 4,294,967,295. Java's int value ranges from -2,147,483,648 to of 2,147,483,647. Java's long value ranges ...

11. Connection Mysql    forum.springsource.org

Connection Mysql Hi, I'm working with mysql and DBCP and I have the following error: Communications link failure Last packet sent to the server was 0 ms ago Code: Your login ...

12. How to fetch data from mysql    forum.springsource.org

I'm not going to show you or post any code as to how to do this. However, I will assist with the theory behind getting this to work. As you may ...

13. [Spring+ mysql]    forum.springsource.org

[Spring+ mysql] Hello to all, I am doing a project in spring. The project must interface with a database mysql. String url = "jdbc:mysql://localhost:3306/"; String dbName = "database"; String driverName = ...

14. how to store data to mysql by using two submit buttons    forum.springsource.org

how to store data to mysql by using two submit buttons I am using two submit buttons Save and NewUser in same Spring controller I have username field in jsp. This ...

15. HELP!!!! how to implement the exmpl step_by_step by using MySQL database    forum.springsource.org

What is it exactly that you are finding difficult? There are MySQL DDL files in the core jar file, and a mysql properties file in the samples distro that should make ...

16. spring+hybernate problem in updating data to mysql database    forum.springsource.org

Dec 4th, 2008, 12:29 AM #1 jampani View Profile View Forum Posts Private Message Junior Member Join Date Nov 2008 Posts 10 spring+hybernate problem in updating data to mysql database The ...





17. context initialization failed passing params via url to mysql    forum.springsource.org

context initialization failed passing params via url to mysql I'm trying to pass a few parameters to mysql via like this: Code: ...

18. Cannot load JDBC driver class 'com.mysql.jdbc.Driver'    forum.springsource.org

Dec 27th, 2008, 12:34 AM #1 nickleli View Profile View Forum Posts Private Message Junior Member Join Date Jan 2007 Posts 9 Cannot load JDBC driver class 'com.mysql.jdbc.Driver' hey everyone, i'm ...

19. Spring Hangs when calling Mysql Procs    forum.springsource.org

Spring Hangs when calling Mysql Procs Any Mysql procedure I execute via a SimpleJdbcCall just hangs indefinitely. No error output. The code I am using works just fine when hitting SQL ...

20. Need help with Spring + ibatis + mysql connection pool    forum.springsource.org

Jan 13th, 2009, 06:35 AM #1 petedao View Profile View Forum Posts Private Message Junior Member Join Date Jan 2009 Posts 1 Need help with Spring + ibatis + mysql connection ...

21. Stuck with MySQL Dialect    forum.springsource.org

Dear all, When i tried to execute these lines : Code: String query = "select * from rel_type"; SQLQuery sQLQuery = session.createSQLQuery(query); List relationshipTypes = sQLQuery.list(); An error is thrown : ...

22. call identity fails on MySQL    forum.springsource.org

Feb 13th, 2009, 06:24 AM #1 mauroyb0 View Profile View Forum Posts Private Message Junior Member Join Date Jul 2007 Posts 8 call identity fails on MySQL Hi there, I'm facing ...

23. MySQL Schema on 5.0.67    forum.springsource.org

Hi, i use MySQL Server 5.0.67 on ubuntu. When i create springbatch schema i got: ERROR 1071 (42000) at line 3: Specified key was too long; max key length is 767 ...

24. PetClinic MySQL setup doesn't allow for case-sensitivity    forum.springsource.org

PetClinic MySQL setup doesn't allow for case-sensitivity I'm looking at the PetClinic sample app for JPA usage. When I tried to configure it for MySQL, I discovered that some of the ...

25. jpetstore mysql connection problem (Unknown database)    forum.springsource.org

jpetstore mysql connection problem (Unknown database) I'm trying to get the jpetstore example to work with mysql. I've created a database called jpetstore with the given schema and data. It's working ...

26. mysql database error pls guide    forum.springsource.org

mysql database error pls guide Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mahahind/public_html/admin.php on line 11 Warning: Cannot modify header information - headers already sent by ...

27. Problem accessing a MySQL database    forum.springsource.org

Problem accessing a MySQL database Hi folks. Sorry for bothering with this stupid question, but i am googling for quite a while now and my books are not of any help ...

28. No Exception / Error while accessing MySQL    forum.springsource.org

No Exception / Error while accessing MySQL Hi Folks. I was a little astonished. I searched an error accessing a MySQL database. Since it was a new Spring / MySQL installation, ...

29. Data source creation and MySQL driver problem    forum.springsource.org

Data source creation and MySQL driver problem I am having problems connecting to a MySQL data source inside of FuseESB 4 (SMX4). I have a typical app design, which needs to ...

30. Error in SQL syntax using MYSQL    forum.springsource.org

Error in SQL syntax using MYSQL All I have the following select statements Code: ...

31. Trying to initialize two data sources for MySQL and Oracle    forum.springsource.org

Exception in thread "main" java.lang.IllegalArgumentException: Property 'dataSource' is required at org.springframework.jdbc.support.JdbcAccessor.afterPropertiesSet(JdbcAccessor.java:134) at org.springframework.jdbc.core.JdbcTemplate.(JdbcTemplate.java:164) at com.foo.parser.Parser.start(Parser.java:70) at com.foo.parser.Application.main(Application.java:13)

32. not work simple sql SELECT query with using named parameters on MySql    forum.springsource.org

Sep 17th, 2009, 09:53 AM #1 a_subscriber View Profile View Forum Posts Private Message Senior Member Join Date Aug 2009 Posts 167 not work simple sql SELECT query with using named ...

33. readonly on mysql with spring example step-by-step    forum.springsource.org

readonly on mysql with spring example step-by-step I am attempting to understand spring by starting with the step-by-step mvc example which is included. Instead of using hsql I used mysql. I ...

34. Help required for connecting to mysql    forum.springsource.org

Help required for connecting to mysql Hi all, i am new to the springs framework i have created a small application which should perform basic operations on my mysql database i ...

35. setMaxResults not allowed with MYSQL    forum.springsource.org

MYSQL is rejecting query.setMaxResults() I am using hibernate entityManager 3.4.0.ga and MYSQL 5.1 Has anyone come accross this problem, any fix? I have tried putting the 'LIMIT' keyword in the select ...

36. PROPAGATION_NOT_SUPPORTED & MySQL    forum.springsource.org

PROPAGATION_NOT_SUPPORTED & MySQL Hey, I am using Spring with HibernateTransactionManager and working on MySQL. I have setup all methods start with list* to run in non-transacional way and as readyOnly:

37. Problem connecting to MYSQL    forum.springsource.org

Jan 14th, 2010, 11:58 PM #1 desai3sweta View Profile View Forum Posts Private Message Junior Member Join Date Jan 2010 Posts 8 Problem connecting to MYSQL Hi Ben, The script is ...

38. using mysql    forum.springsource.org

Hi, My web service is using hypersonic database in jboss and let application server handles connection configuration Now I want to swicth to mysql. Is it better to ...

39. database.url for MySQL    forum.springsource.org

If I am not mistaken, the escaping of colons is actually done automatically by the Java Properties class. It works well for me with the escaped colons though. Is there anything ...

40. Need help adding mysql support    forum.springsource.org

Mar 4th, 2010, 12:43 PM #1 loulou2u View Profile View Forum Posts Private Message Junior Member Join Date Apr 2009 Posts 18 Need help adding mysql support I have got a ...

41. Missing artifact com.mysql.jdbc    forum.springsource.org

Whe I run persistence setup with MYSQL database I get the following error: 24.03.10 13:41:11 MEZ: Missing artifact com.mysql.jdbc:com.springsource.com.mysql.jdbc:jar :5.1.6:compile So this resource might not be available in the repository, right? ...

42. Failure to unregister the MySQL JDBC Driver    forum.springsource.org

Failure to unregister the MySQL JDBC Driver After upgrading to Apache Tomcat/6.0.26 I've encountered a problem when closing the application: Code: 05-04-2010 16:48:01 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc SEVERE: A web application registered the ...

43. Mysql connection close error    forum.springsource.org

Mysql connection close error Hi all, I am currently using two datasources. One for accessing my local database where my application is running and one for accessing the database of a ...

44. Authorisation based on MySQL data?    forum.springsource.org

Authorisation based on MySQL data? hey, I've been given a MySQL database linked to a web project. This database has a table called Users which is a list of the users ...

45. Integration Test Error - 1.1.0M1, STS 2.3.3M1, MySQL    forum.springsource.org

Integration Test Error - 1.1.0M1, STS 2.3.3M1, MySQL Hi, I have found a problem with running tests from STS in M1 with MySQL and using a "field reference --notNull" Executing this ...

46. Eclipselink and Mysql UTF8 problem    forum.springsource.org

Eclipselink and Mysql UTF8 problem Hi I am using ejb3 with glassfish and in the persistance layer I am using eclipselink and mysql , my mysql schema and tables' collation are ...

47. 'Version' field in mysql    forum.springsource.org

In phpadmin, I do not see any field such as 'version', however scaffolding controllers request for a 'version' column from db and I observed that it exist when I connect with ...

48. Tests randomly fail for simple projects that use MYSQL db but work in HYPERSONIC_IN_M    forum.springsource.org

Tests randomly fail for simple projects that use MYSQL db but work in HYPERSONIC_IN_M I was noticing that my tests would fail, with "java.lang.AssertionError: Data on demand for 'Thing' failed to ...

50. spring vs seam for ExtJS/JBoss/EJB3/MySQL    forum.springsource.org

spring vs seam for ExtJS/JBoss/EJB3/MySQL I am working on a web application that uses ExtJS for the front end and EJB for the middle tier. We use JBoss Portal for the ...

51. Reconnect mysql    forum.springsource.org

Reconnect mysql Sometimes I seem to lose connection to my mysql-database and then a connection is thrown and the program stops executing as it is now. I would like to try ...

52. Spring with MySql.    forum.springsource.org

Aug 12th, 2004, 02:23 AM #1 nitz_tech View Profile View Forum Posts Private Message Junior Member Join Date Aug 2004 Posts 5 Spring with MySql. Hello, I am facing problem configuring ...

53. MYSQL IBatis datetime problem    forum.springsource.org

MYSQL IBatis datetime problem Hello everyone, I hope someone can help me here. I am using spring and ibatis. I am trying to do a simple insert into mysql table. Here ...

54. Need help with setting up PetClinic with MySQL    forum.springsource.org

Need help with setting up PetClinic with MySQL Hello all, I'm a newbie to Spring/Hibernate and have downloaded the petclinic project. I decided to use it with MySQL database and hence, ...

55. DBRE with MYSQL doesn't generate fields    forum.springsource.org

DBRE with MYSQL doesn't generate fields I am trying to use DBRE with a legacy MYSQL DB (version 5.1) and the generated Java files don't have any fields. First I run ...

56. PetClinic JDBC problem > Cannot load JDBC driver class 'com.mysql.jdbc.Driver'    forum.springsource.org

Nov 6th, 2010, 04:35 AM #1 hamo View Profile View Forum Posts Private Message Junior Member Join Date Nov 2010 Posts 2 PetClinic JDBC problem > Cannot load JDBC driver class ...

57. Jpetstore using MySQL    forum.springsource.org

Jpetstore using MySQL I am studying JPetStore sample project for Spring 3 and tried to change the default db to mysql. What I did is: 1. Adding mysql-connector-java into the POM; ...

58. Jpetstore using MySQL - Error, Help Please    forum.springsource.org

Jpetstore using MySQL - Error, Help Please I am studying JPetStore sample project for Spring 3 and tried to change the default db to mysql. What I did is: 1. Adding ...

59. Problem with connection to MySql    forum.springsource.org

Nov 17th, 2010, 12:33 AM #1 jjbueno View Profile View Forum Posts Private Message Junior Member Join Date Nov 2010 Posts 3 Problem with connection to MySql Hi all, I have ...

60. DBRE and MySQL: Do I need to manually add the relationships    forum.springsource.org

DBRE and MySQL: Do I need to manually add the relationships I've created a simple mvc app by reverse engineering a MySQL database. It seems to have successfully identified that the ...

61. missing springsource mysql jar    forum.springsource.org

missing springsource mysql jar [fixed] I fired up roo yesterday without a problem. I navigate to the project directory on the command line (linux) and type mvn jetty:run I find it ...

62. DBRE, mysql and generated catalog name    forum.springsource.org

DBRE, mysql and generated catalog name Hi, when I do database reverse engineer, I get in my java and aj generated classes the catalog value that matches the name of the ...

63. Mysql indexes and Dbre    forum.springsource.org

I seem to have an error in dbre for mysql if I have non clustered indexes in my tables. The generated code seems to ignore foreign keys and uses indexes for ...

64. Relationships and MySQL domain reverse engineering    forum.springsource.org

Relationships and MySQL domain reverse engineering Hi guys, I've been using Roo since 1.0.0 and decided for my new projects I want to use the database as the domain model and ...

65. mysql FK    forum.springsource.org

mysql FK Hey, 1. roo is amazing 2. I am running a mysql server and I have foreign keys between my tables e.g. Code: create table p_osoby (id_osoby INT AUTO_INCREMENT NOT ...