topic Unknown database error running Junit test in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/unknown-database-error-running-junit-test/m-p/231203#M184333 <HTML><HEAD></HEAD><BODY><SPAN>I have several versions of Alfresco installed.&nbsp; I only have one running at a time.&nbsp; They all use the same mysql database so each has a schema called "alfresco&lt;version&gt;" for example alfresco222, alfresco31, etc.</SPAN><BR /><BR /><SPAN>I just created a JUnit Test class much like org.alfresco.repo.props.PropertyValueComponentTest.java that I found in the svn head. See code below.</SPAN><BR /><BR /><SPAN>When I run it I get the stack trace below, essentially saying, "Unknown database 'alfresco' ".</SPAN><BR /><BR /><SPAN>My custom-repository-context.xml specifies:</SPAN><BR /><SPAN>db.driver=org.gjt.mm.mysql.Driver</SPAN><BR /><SPAN>db.url=jdbc:mysql://localhost/alfresco222</SPAN><BR /><BR /><SPAN>I really don't know where it is getting this database name ("alfresco") from.</SPAN><BR /><BR /><SPAN>Can anyone help me out?</SPAN><BR /><BR /><SPAN>JUnit class:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />package ca.edmontonpublicschools.boxes.versatile.soap;<BR /><BR />import junit.framework.TestCase;<BR />import org.alfresco.util.ApplicationContextHelper;<BR />import org.springframework.context.ApplicationContext;<BR /><BR />public class VersatileSOAPInterfaceTest extends TestCase {<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; protected ApplicationContext ctx = ApplicationContextHelper.getApplicationContext();<BR /><BR />&nbsp;&nbsp;&nbsp;public void testGetBoxByBoxNumber() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fail("Not yet implemented");<BR />&nbsp;&nbsp;&nbsp;}<BR />}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Stack Trace:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />junit.framework.AssertionFailedError: Exception in constructor: testGetBoxByBoxNumber (org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection<BR />Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection<BR />Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:497)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:349)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:255)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:214)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:394)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:297)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepositoryBootstrap.java:134)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1160)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1122)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:92)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:77)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.ApplicationContextHelper.getApplicationContext(ApplicationContextHelper.java:55)<BR />&nbsp;&nbsp;&nbsp;at ca.edmontonpublicschools.boxes.versatile.soap.VersatileSOAPInterfaceTest.&lt;init&gt;(VersatileSOAPInterfaceTest.java:9)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Constructor.newInstance(Constructor.java:513)<BR />&nbsp;&nbsp;&nbsp;at junit.framework.TestSuite.createTest(TestSuite.java:131)<BR />&nbsp;&nbsp;&nbsp;at junit.framework.TestSuite.addTestMethod(TestSuite.java:114)<BR />&nbsp;&nbsp;&nbsp;at junit.framework.TestSuite.&lt;init&gt;(TestSuite.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestLoader.getTest(JUnit3TestLoader.java:102)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestLoader.loadTests(JUnit3TestLoader.java:59)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:445)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)<BR />Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown database 'alfresco')<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)<BR />&nbsp;&nbsp;&nbsp;… 42 more<BR />Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'alfresco'<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Connection.createNewIO(Connection.java:2644)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Connection.&lt;init&gt;(Connection.java:1531)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)<BR />&nbsp;&nbsp;&nbsp;… 45 more<BR />)<BR />&nbsp;&nbsp;&nbsp;at junit.framework.Assert.fail(Assert.java:47)<BR />&nbsp;&nbsp;&nbsp;at junit.framework.TestSuite$1.runTest(TestSuite.java:263)<BR />&nbsp;&nbsp;&nbsp;at junit.framework.TestCase.runBare(TestCase.java:127)<BR />&nbsp;&nbsp;&nbsp;at junit.framework.TestResult$1.protect(TestResult.java:106)<BR />&nbsp;&nbsp;&nbsp;at junit.framework.TestResult.runProtected(TestResult.java:124)<BR />&nbsp;&nbsp;&nbsp;at junit.framework.TestResult.run(TestResult.java:109)<BR />&nbsp;&nbsp;&nbsp;at junit.framework.TestCase.run(TestCase.java:118)<BR />&nbsp;&nbsp;&nbsp;at junit.framework.TestSuite.runTest(TestSuite.java:208)<BR />&nbsp;&nbsp;&nbsp;at junit.framework.TestSuite.run(TestSuite.java:203)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)<BR />&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Tue, 22 Sep 2009 20:49:02 GMT tfrith 2009-09-22T20:49:02Z Unknown database error running Junit test https://connect.hyland.com/t5/alfresco-archive/unknown-database-error-running-junit-test/m-p/231203#M184333 I have several versions of Alfresco installed.&nbsp; I only have one running at a time.&nbsp; They all use the same mysql database so each has a schema called "alfresco&lt;version&gt;" for example alfresco222, alfresco31, etc.I just created a JUnit Test class much like org.alfresco.repo.props.PropertyValueCom Tue, 22 Sep 2009 20:49:02 GMT https://connect.hyland.com/t5/alfresco-archive/unknown-database-error-running-junit-test/m-p/231203#M184333 tfrith 2009-09-22T20:49:02Z Re: Unknown database error running Junit test https://connect.hyland.com/t5/alfresco-archive/unknown-database-error-running-junit-test/m-p/231204#M184334 <HTML><HEAD></HEAD><BODY><SPAN>"alfresco" is the default value.&nbsp;&nbsp;&nbsp; So unless you provide your own value then that's the value it will use.</SPAN><BR /><BR /><SPAN>It sounds like your "custom-repository-context.xml is not on the classpath for your Junit test.</SPAN></BODY></HTML> Tue, 22 Sep 2009 21:59:36 GMT https://connect.hyland.com/t5/alfresco-archive/unknown-database-error-running-junit-test/m-p/231204#M184334 mrogers 2009-09-22T21:59:36Z