search

Conal-Tuohy / ands-la-trobe

Automatically exported from code.google.com/p/ands-la-trobe
1 stars 1 forks source link

"database does not exist" error when uploading access database #19

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
I tried to upload an Access DB but received the following stacktrace: 

org.tdar.core.exception.TdarRecoverableRuntimeException: Unexpected expection 
while opening input dataset or dumping data at 
org.tdar.db.conversion.converters.DatasetConverter$Base.execute(DatasetConverter
.java:142) at 
org.tdar.core.service.DatasetService.convertDataFile(DatasetService.java:219) 
at 
org.tdar.core.service.DatasetService$$FastClassByCGLIB$$8831f2c2.invoke(<generat
ed>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) at 
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoi
npoint(Cglib2AopProxy.java:688) at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveM
ethodInvocation.java:150) at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Transa
ctionInterceptor.java:110) at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveM
ethodInvocation.java:172) at 
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.inter
cept(Cglib2AopProxy.java:621) at 
org.tdar.core.service.DatasetService$$EnhancerByCGLIB$$5c304c8a.convertDataFile(
<generated>) at 
org.tdar.struts.action.DatasetController.processUploadedFile(DatasetController.j
ava:447) at 
org.tdar.struts.action.AbstractInformationResourceController.handleUploadedFiles
(AbstractInformationResourceController.java:244) at 
org.tdar.struts.action.DatasetController.save(DatasetController.java:480) at 
org.tdar.struts.action.DatasetController.save(DatasetController.java:52) at 
org.tdar.struts.action.AbstractResourceController.save(AbstractResourceControlle
r.java:307) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
a:43) at java.lang.reflect.Method.invoke(Method.java:616) at 
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvoca
tion.java:452) at 
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionIn
vocation.java:291) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:254) at 
com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(Defau
ltWorkflowInterceptor.java:176) at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt
erInterceptor.java:98) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationIn
terceptor.java:263) at 
org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doInte
rcept(AnnotationValidationInterceptor.java:68) at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt
erInterceptor.java:98) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(Convers
ionErrorInterceptor.java:133) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(Parameters
Interceptor.java:207) at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt
erInterceptor.java:98) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(Parameters
Interceptor.java:207) at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt
erInterceptor.java:98) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(Static
ParametersInterceptor.java:190) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterce
ptor.java:314) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDriven
Interceptor.java:100) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterc
eptor.java:142) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterc
eptor.java:166) at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt
erInterceptor.java:98) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigI
nterceptor.java:164) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(Parameters
Interceptor.java:207) at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt
erInterceptor.java:98) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInter
ceptor.java:75) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor
.java:94) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.ja
va:176) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.
java:190) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(Except
ionMappingInterceptor.java:187) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
org.tdar.struts.interceptor.AuthenticationInterceptor.intercept(AuthenticationIn
terceptor.java:63) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) at 
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:485) at 
org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperatio
ns.java:77) at 
org.apache.struts2.dispatcher.ng.filter.StrutsExecuteFilter.doFilter(StrutsExecu
teFilter.java:88) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206) at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.jav
a:129) at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
 at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206) at 
org.apache.struts2.dispatcher.ng.filter.StrutsPrepareFilter.doFilter(StrutsPrepa
reFilter.java:82) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206) at 
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInter
nal(OpenSessionInViewFilter.java:198) at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilte
r.java:76) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206) at 
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestCont
extFilter.java:83) at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilte
r.java:76) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206) at 
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:164) 
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141) at 
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90
) at 
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.jav
a:417) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206) at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2
33) at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1
91) at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109
) at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Pr
otocol.java:588) at 
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at 
java.lang.Thread.run(Thread.java:636) Caused by: 
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC 
Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: 
Cannot create PoolableConnectionFactory (FATAL: database "tdardata" does not 
exist) at 
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtil
s.java:80) at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381) at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427) at 
org.tdar.db.model.PostgresDatabase.dropTable(PostgresDatabase.java:124) at 
org.tdar.db.model.PostgresDatabase.dropTable(PostgresDatabase.java:119) at 
org.tdar.db.model.PostgresDatabase$$FastClassByCGLIB$$ab4c7b06.invoke(<generated
>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) at 
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.inter
cept(Cglib2AopProxy.java:617) at 
org.tdar.db.model.PostgresDatabase$$EnhancerByCGLIB$$39979376.dropTable(<generat
ed>) at 
org.tdar.db.conversion.converters.AccessDatabaseConverter.dumpData(AccessDatabas
eConverter.java:70) at 
org.tdar.db.conversion.converters.DatasetConverter$Base.execute(DatasetConverter
.java:135) ... 101 more Caused by: org.apache.commons.dbcp.SQLNestedException: 
Cannot create PoolableConnectionFactory (FATAL: database "tdardata" does not 
exist) at 
org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDat
aSource.java:1549) at 
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:13
88) at 
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
 at 
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUt
ils.java:111) at 
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtil
s.java:77) ... 111 more Caused by: org.postgresql.util.PSQLException: FATAL: 
database "tdardata" does not exist at 
org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFacto
ryImpl.java:464) at 
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactor
yImpl.java:112) at 
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) 
at 
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java
:125) at 
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java
:30) at 
org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.j
ava:22) at 
org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java
:30) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at 
org.postgresql.Driver.makeConnection(Driver.java:393) at 
org.postgresql.Driver.connect(Driver.java:267) at 
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectio
nFactory.java:38) at 
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionF
actory.java:582) at 
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSourc
e.java:1556) at 
org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDat
aSource.java:1545) ... 115 more

Original issue reported on code.google.com by Conal.Tuohy on 14 Jul 2011 at 7:08

GoogleCodeExporter commented 9 years ago

Original comment by Conal.Tuohy on 14 Jul 2011 at 7:09

GoogleCodeExporter commented 9 years ago 
Created the tdardata database manually.

Original comment by Conal.Tuohy on 14 Jul 2011 at 7:21