Error Org Hibernate Util Jdbcexceptionreporter No Database Selected
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the hibernate not releasing connections workings and policies of this site About Us Learn more about Stack
No Database Selected Mysql
Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Spring Roo Database.properties file up vote 3 down vote favorite 1 Hi I am unable to connect to database in spring roo project. My error is ERROR org.hibernate.util.JDBCExceptionReporter - No database selected org.hibernate.exception.GenericJDBCException: could not execute query; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query My Database.properties file database.password=test@ database.url=jdbc\:mysql\://yahoo.com:3306 database.username=arv_aaa database.schemaNames=ar@1 database.driverClassName=com.mysql.jdbc.Driver hibernate spring-roo share|improve this question edited Apr 15 '11 at 10:28 skaffman 277k63618655 asked Apr 14 '11 at 20:46 user506129 2226 @user506129: please check the edit I made. the database.url looks strange –Mat Apr 14 '11 at 20:49 add a comment| 1 Answer 1 active oldest votes up vote 5 down vote Just fix the following line: database.url=jdbc\:mysql\://yahoo.com:3306 And add some data base the following way: database.url=jdbc\:mysql\://yahoo.com:3306/mydb Hope this helps! share|improve this answer answered Apr 14 '11 at 20:50 Constantiner 13.4k21932 1 Problem is solved I am using the mysql server IP instead of url. It works now thank you –user506129 Apr 16 '11 at 8:56 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse
posts ] Previous topic | Next topic Author Message jruffin Post subject: reverse engineer many-to-many hiccupPosted: Sat Feb 21, 2009 2:26 pm Regular Joined: Sat Nov 06, 2004 5:20 pmPosts: 54Location: Collierville, TN I'm using ANT (Hibernate 3.3.1 & Tools 3.2.4) to reverse engineer a MySQL 5.0.51 DB. The mapping and java files appear to be generated fine. I have a many-to-many between http://stackoverflow.com/questions/5669460/spring-roo-database-properties-file GROUP and ROLE. I have a join table GROUPROLE. The Group.hbm.xml mapping file shows the relationship: Code:
and to http://spring.io/questions for a curated list of stackoverflow tags that Pivotal engineers, and the community, monitor. Announcement Announcement Module http://forum.spring.io/forum/spring-projects/data/41569-hibernate-not-releasing-connections Collapse No announcement yet. Hibernate not releasing connections Page Title Module Move Remove Collapse X Conversation Detail Module Collapse Posts Latest Activity Search Forums Page of 2 http://jasig.275507.n4.nabble.com/Error-creating-table-RegisteredServiceImpl-td260755.html Filter Time All Time Today Last Week Last Month Show All Discussions only Photos only Videos only Links only Polls only Filtered by: Clear All new posts no database thehl Senior Member Join Date: Aug 2006 Posts: 221 #1 Hibernate not releasing connections Feb 18th, 2008, 10:14 AM I am running a number of queries against my database in a loop against an informix database. Here's what I'm seeing in the log... Code: 25405 WARN org.hibernate.util.JDBCExceptionReporter | SQL Warning: 0, SQLState: 01I04 25405 WARN no database selected org.hibernate.util.JDBCExceptionReporter | Database selected 25405 DEBUG com.acs.gs.juror.util.ConfigurationParameters | Value:D for key:JJJ| EJ_POSTPONE|TO_DATE_CAPS_IND 25421 DEBUG com.acs.gs.juror.util.ConfigurationParameters | Value:D for key:JJJ| EJ_POSTPONE|TO_DATE_CAPS_IND 25483 DEBUG com.acs.gs.juror.util.ConfigurationParameters | Value:D for key:JJJ| EJ_POSTPONE|TO_DATE_CAPS_IND 45483 WARN org.hibernate.util.JDBCExceptionReporter | SQL Error: 0, SQLState: n ull 45483 ERROR org.hibernate.util.JDBCExceptionReporter | Cannot get a connection, pool error Timeout waiting for idle object 45483 WARN org.hibernate.util.JDBCExceptionReporter | SQL Error: 0, SQLState: n ull 45483 ERROR org.hibernate.util.JDBCExceptionReporter | Cannot get a connection, pool error Timeout waiting for idle object 45483 WARN com.acs.gs.eJuror.web.struts.services.impl.BaselineEJurorExceptionHa ndler | execute() 45498 ERROR com.acs.gs.eJuror.web.struts.services.impl.BaselineEJurorExceptionHa ndler | Exception Encountered in Web Layer : Hibernate operation: Cannot open co nnection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot get a connection, pool error Timeout waiting for idle object; neste d exception is org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a conn ection, pool error Timeout waiting for idle object org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; err or code [0]; Cannot get a co
this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Error creating table RegisteredServiceImpl Hi, Still trying to get services manager hooked up to a db. I switched to trying mysql. The following is my bean in deployerConfigContext.xml.