Problem with MySQL when starting ORS from MVN
|
|
rivercode
|
Hi,
Sorry, if you got this twice...slight glitch when posting. I am having a problem with the Java beans connection to MySQL when trying to start ORS directly from mvn, using: marketcetera-platform/source/ors$ mvn -Pexecute exec:java My gut is that it is something simple with MySQL config, I have overlooked something...any advice please ? Thank you. Here is the log: [DEBUG] Adding project dependency artifact: junit to classpath [DEBUG] joining on thread Thread[org.marketcetera.ors.DBInit.main(),5,org.marketcetera.ors.DBInit] [DEBUG] Setting accessibility to true in order to invoke main(). 14:07:02,390 [org.marketcetera.ors.DBInit.main()] INFO FileSystemXmlApplicationContext - Refreshing org.springframework.context.support.FileSystemXmlApplicationContext@1980630: display name [org.springframework.context.support.FileSystemXmlApplicationContext@1980630]; startup date [Mon Dec 01 14:07:02 EST 2008]; root of context hierarchy 14:07:02,515 [org.marketcetera.ors.DBInit.main()] INFO XmlBeanDefinitionReader - Loading XML bean definitions from URL [file:src/test/sample_data/conf/ors_base.xml] 14:07:02,796 [org.marketcetera.ors.DBInit.main()] INFO FileSystemXmlApplicationContext - Bean factory for application context [org.springframework.context.support.FileSystemXmlApplicationContext@1980630]: org.springframework.beans.factory.support.DefaultListableBeanFactory@1c20eb7 14:07:02,828 [org.marketcetera.ors.DBInit.main()] INFO DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1c20eb7: defining beans [propertiesFiles]; root of factory hierarchy 01 Dec 2008 14:08:03,250 ERROR [org.marketcetera.ors.DBInit.main()] marketcetera.persist.PersistTestBase (PersistTestBase.java:72) - FailedSetup: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'initSchema' defined in class path resource [ors_initdb_create_admin_vendor.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.marketcetera.persist.ExecuteSQLFromFile]: Constructor threw exception; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database! Related cause: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'JdbcDriver' defined in class path resource [ors_db.xml]: Unsatisfied dependency expressed through constructor argument with index 1 of type [int]: Ambiguous constructor argument types - did you specify the correct bean references as constructor arguments? |
||||||||||||||||
toli
|
Chris,
When you run ORS from code, it looks at the src/test/sample_data/conf/default.properties file to get all the JDBC connection info, specifically at this line: metc.jdbc.url=jdbc:mysql://localhost:3306/marketcetera?logSlowQueries=true Do you have the MySQL instance running on 3306? If you are reusing the instance from the Windows installer, then it's setup to run on 8882, so you can modify the default.properties file to point to that port if you are not running MySQL separately. If that doesn't help, can you tell me what version of code you are running from (0.9? 0.5)? And send me your ors.xml file thanks On Mon, Dec 1, 2008 at 12:15 PM, rivercode <[hidden email]> wrote: > > Hi, > > Sorry, if you got this twice...slight glitch when posting. > > I am having a problem with the Java beans connection to MySQL when trying to > start ORS directly from mvn, using: > > marketcetera-platform/source/ors$ mvn -Pexecute exec:java > > My gut is that it is something simple with MySQL config, I have overlooked > something...any advice please ? Thank you. Here is the log: > > > [DEBUG] Adding project dependency artifact: junit to classpath > [DEBUG] joining on thread > Thread[org.marketcetera.ors.DBInit.main(),5,org.marketcetera.ors.DBInit] > [DEBUG] Setting accessibility to true in order to invoke main(). > > 14:07:02,390 [org.marketcetera.ors.DBInit.main()] INFO > FileSystemXmlApplicationContext - Refreshing > org.springframework.context.support.FileSystemXmlApplicationContext@1980630: > display name > [org.springframework.context.support.FileSystemXmlApplicationContext@1980630]; > startup date [Mon Dec 01 14:07:02 EST 2008]; root of context hierarchy > > 14:07:02,515 [org.marketcetera.ors.DBInit.main()] INFO > XmlBeanDefinitionReader - Loading XML bean definitions from URL > [file:src/test/sample_data/conf/ors_base.xml] > > 14:07:02,796 [org.marketcetera.ors.DBInit.main()] INFO > FileSystemXmlApplicationContext - Bean factory for application context > [org.springframework.context.support.FileSystemXmlApplicationContext@1980630]: > org.springframework.beans.factory.support.DefaultListableBeanFactory@1c20eb7 > > 14:07:02,828 [org.marketcetera.ors.DBInit.main()] INFO > DefaultListableBeanFactory - Pre-instantiating singletons in > org.springframework.beans.factory.support.DefaultListableBeanFactory@1c20eb7: > defining beans [propertiesFiles]; root of factory hierarchy > > 01 Dec 2008 14:08:03,250 ERROR [org.marketcetera.ors.DBInit.main()] > marketcetera.persist.PersistTestBase > (PersistTestBase.java:72) - > FailedSetup: org.springframework.beans.factory.BeanCreationException: Error > creating bean with name 'initSchema' defined in class path resource > [ors_initdb_create_admin_vendor.xml]: Instantiation of bean failed; nested > exception is org.springframework.beans.BeanInstantiationException: > > Could not instantiate bean class > [org.marketcetera.persist.ExecuteSQLFromFile]: Constructor threw exception; > nested exception is java.sql.SQLException: Connections could not be acquired > from the underlying database! > > > Related cause: > org.springframework.beans.factory.UnsatisfiedDependencyException: Error > creating bean with name 'JdbcDriver' defined in class path resource > [ors_db.xml]: Unsatisfied dependency expressed through constructor argument > with index 1 of type [int]: Ambiguous constructor argument types - did you > specify the correct bean references as constructor arguments? > > -- > View this message in context: http://n2.nabble.com/Problem-with-MySQL-when-starting-ORS-from--MVN-tp1600421p1600421.html > Sent from the m-etc-dev mailing list archive at Nabble.com. > > > _______________________________________________ > m-etc-dev mailing list > [hidden email] > http://lists.marketcetera.org/mailman/listinfo/m-etc-dev_lists.marketcetera.org > -- Toli Kuznets http://www.marketcetera.com: Open-Source Trading Platform download.run.trade. _______________________________________________ m-etc-dev mailing list [hidden email] http://lists.marketcetera.org/mailman/listinfo/m-etc-dev_lists.marketcetera.org |
||||||||||||||||
|
rivercode
|
Toli,
I am using Windows with the default MySQL install from the MarketCetera instance. Changing the port to 8882 in src/test/sample_data/conf/default.properties fixed it. Thanks. BTW, I changed it first in /ors/src/main/sample_data/conf/ors_default.properties, assuming this was the file as opposed to the "test" sub-diretory. Cheers, Chris
|
||||
|
toli
|
Excellent, glad to hear you got it to work.
> BTW, I changed it first in > /ors/src/main/sample_data/conf/ors_default.properties, assuming this was the > file as opposed to the "test" sub-diretory. The "src/main" are the configs that get "shipped". For development/testing the convention is to use the configs in the src/test subtree. We'll add that to documentation, thanks for bringing this up. > > Cheers, > Chris > > > > toli wrote: >> >> Chris, >> >> When you run ORS from code, it looks at the >> src/test/sample_data/conf/default.properties file to get all the JDBC >> connection info, specifically at this line: >> metc.jdbc.url=jdbc:mysql://localhost:3306/marketcetera?logSlowQueries=true >> >> >> Do you have the MySQL instance running on 3306? If you are reusing the >> instance from the Windows installer, then it's setup to run on 8882, >> so you can modify the default.properties file to point to that port if >> you are not running MySQL separately. >> >> If that doesn't help, can you tell me what version of code you are >> running from (0.9? 0.5)? And send me your ors.xml file >> >> thanks >> >> >> On Mon, Dec 1, 2008 at 12:15 PM, rivercode <[hidden email]> wrote: >>> >>> Hi, >>> >>> Sorry, if you got this twice...slight glitch when posting. >>> >>> I am having a problem with the Java beans connection to MySQL when trying >>> to >>> start ORS directly from mvn, using: >>> >>> marketcetera-platform/source/ors$ mvn -Pexecute exec:java >>> >>> My gut is that it is something simple with MySQL config, I have >>> overlooked >>> something...any advice please ? Thank you. Here is the log: >>> >>> >>> [DEBUG] Adding project dependency artifact: junit to classpath >>> [DEBUG] joining on thread >>> Thread[org.marketcetera.ors.DBInit.main(),5,org.marketcetera.ors.DBInit] >>> [DEBUG] Setting accessibility to true in order to invoke main(). >>> >>> 14:07:02,390 [org.marketcetera.ors.DBInit.main()] INFO >>> FileSystemXmlApplicationContext - Refreshing >>> org.springframework.context.support.FileSystemXmlApplicationContext@1980630: >>> display name >>> [org.springframework.context.support.FileSystemXmlApplicationContext@1980630]; >>> startup date [Mon Dec 01 14:07:02 EST 2008]; root of context hierarchy >>> >>> 14:07:02,515 [org.marketcetera.ors.DBInit.main()] INFO >>> XmlBeanDefinitionReader - Loading XML bean definitions from URL >>> [file:src/test/sample_data/conf/ors_base.xml] >>> >>> 14:07:02,796 [org.marketcetera.ors.DBInit.main()] INFO >>> FileSystemXmlApplicationContext - Bean factory for application context >>> [org.springframework.context.support.FileSystemXmlApplicationContext@1980630]: >>> org.springframework.beans.factory.support.DefaultListableBeanFactory@1c20eb7 >>> >>> 14:07:02,828 [org.marketcetera.ors.DBInit.main()] INFO >>> DefaultListableBeanFactory - Pre-instantiating singletons in >>> org.springframework.beans.factory.support.DefaultListableBeanFactory@1c20eb7: >>> defining beans [propertiesFiles]; root of factory hierarchy >>> >>> 01 Dec 2008 14:08:03,250 ERROR [org.marketcetera.ors.DBInit.main()] >>> marketcetera.persist.PersistTestBase >>> (PersistTestBase.java:72) - >>> FailedSetup: org.springframework.beans.factory.BeanCreationException: >>> Error >>> creating bean with name 'initSchema' defined in class path resource >>> [ors_initdb_create_admin_vendor.xml]: Instantiation of bean failed; >>> nested >>> exception is org.springframework.beans.BeanInstantiationException: >>> >>> Could not instantiate bean class >>> [org.marketcetera.persist.ExecuteSQLFromFile]: Constructor threw >>> exception; >>> nested exception is java.sql.SQLException: Connections could not be >>> acquired >>> from the underlying database! >>> >>> >>> Related cause: >>> org.springframework.beans.factory.UnsatisfiedDependencyException: Error >>> creating bean with name 'JdbcDriver' defined in class path resource >>> [ors_db.xml]: Unsatisfied dependency expressed through constructor >>> argument >>> with index 1 of type [int]: Ambiguous constructor argument types - did >>> you >>> specify the correct bean references as constructor arguments? >>> >>> -- >>> View this message in context: >>> http://n2.nabble.com/Problem-with-MySQL-when-starting-ORS-from--MVN-tp1600421p1600421.html >>> Sent from the m-etc-dev mailing list archive at Nabble.com. >>> >>> >>> _______________________________________________ >>> m-etc-dev mailing list >>> [hidden email] >>> http://lists.marketcetera.org/mailman/listinfo/m-etc-dev_lists.marketcetera.org >>> >> >> >> >> -- >> Toli Kuznets >> http://www.marketcetera.com: Open-Source Trading Platform >> download.run.trade. >> >> _______________________________________________ >> m-etc-dev mailing list >> [hidden email] >> http://lists.marketcetera.org/mailman/listinfo/m-etc-dev_lists.marketcetera.org >> >> > > -- > View this message in context: http://n2.nabble.com/Problem-with-MySQL-when-starting-ORS-from--MVN-tp1600421p1600662.html > Sent from the m-etc-dev mailing list archive at Nabble.com. > > > _______________________________________________ > m-etc-dev mailing list > [hidden email] > http://lists.marketcetera.org/mailman/listinfo/m-etc-dev_lists.marketcetera.org > -- Toli Kuznets http://www.marketcetera.com: Open-Source Trading Platform download.run.trade. _______________________________________________ m-etc-dev mailing list [hidden email] http://lists.marketcetera.org/mailman/listinfo/m-etc-dev_lists.marketcetera.org |
||||||||||||||||
| Free Embeddable Forum Powered by Nabble | Help |
