org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is net.ucanaccess.jdbc.UcanaccessSQLException: invalid authorization specification - not found: nchapuis


Solutions on the web1

Solution icon of web
Could not get JDBC Connection; nested exception is net.ucanaccess.jdbc.UcanaccessSQLException: invalid authorization specification - not found: nchapuis

Stack trace

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
JDBC Connection; nested exception is net.ucanaccess.jdbc.UcanaccessSQLException:
invalid authorization specification - not found: nchapuis
	at org.springframework.jdbc.core.metadata.TableMetaDataProviderFactory.createMetaDataProvider(TableMetaDataProviderFactory.java:103)
	at org.springframework.jdbc.core.metadata.TableMetaDataContext.processMetaData(TableMetaDataContext.java:205)
	at org.springframework.jdbc.core.simple.AbstractJdbcInsert.compileInternal(AbstractJdbcInsert.java:276)
	at org.springframework.jdbc.core.simple.AbstractJdbcInsert.compile(AbstractJdbcInsert.java:263)
	at org.springframework.jdbc.core.simple.AbstractJdbcInsert.checkCompiled(AbstractJdbcInsert.java:309)
	at org.springframework.jdbc.core.simple.AbstractJdbcInsert.doExecuteAndReturnKey(AbstractJdbcInsert.java:382)
	at org.springframework.jdbc.core.simple.SimpleJdbcInsert.executeAndReturnKey(SimpleJdbcInsert.java:138)
	at fr.darkweb.druet.dao.UserDao.add(UserDao.java:30)
	at fr.darkweb.druet.business.crud.UserCrud.userAdd(UserCrud.java:15)
	at fr.darkweb.druet.controller.ControllerTest.testGet(ControllerTest.java:31)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:175)
	at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:446)
	at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:434)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:120)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:97)
	at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:109)
	at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:156)
	at com.caucho.server.webapp.AccessLogFilterChain.doFilter(AccessLogFilterChain.java:95)
	at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:289)
	at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:838)
	at com.caucho.network.listen.TcpSocketLink.dispatchRequest(TcpSocketLink.java:1346)
	at com.caucho.network.listen.TcpSocketLink.handleRequest(TcpSocketLink.java:1302)
	at com.caucho.network.listen.TcpSocketLink.handleRequestsImpl(TcpSocketLink.java:1286)
	at com.caucho.network.listen.TcpSocketLink.handleRequests(TcpSocketLink.java:1194)
	at com.caucho.network.listen.TcpSocketLink.handleAcceptTaskImpl(TcpSocketLink.java:993)
	at com.caucho.network.listen.ConnectionTask.runThread(ConnectionTask.java:117)
	at com.caucho.network.listen.ConnectionTask.run(ConnectionTask.java:93)
	at com.caucho.network.listen.SocketLinkThreadLauncher.handleTasks(SocketLinkThreadLauncher.java:169)
	at com.caucho.network.listen.TcpSocketAcceptThread.run(TcpSocketAcceptThread.java:61)
	at com.caucho.env.thread2.ResinThread2.runTasks(ResinThread2.java:173)
	at com.caucho.env.thread2.ResinThread2.run(ResinThread2.java:118)
Caused by: org.springframework.jdbc.support.MetaDataAccessException: Could
not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException:
Could not get JDBC Connection; nested exception is net.ucanaccess.jdbc.UcanaccessSQLException:
invalid authorization specification - not found: nchapuis
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:293)
	at org.springframework.jdbc.core.metadata.TableMetaDataProviderFactory.createMetaDataProvider(TableMetaDataProviderFactory.java:63)
	... 39 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could
not get JDBC Connection; nested exception is net.ucanaccess.jdbc.UcanaccessSQLException:
invalid authorization specification - not found: nchapuis
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:280)
	... 40 more
Caused by: net.ucanaccess.jdbc.UcanaccessSQLException: invalid authorization
specification - not found: nchapuis
	at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:200)
	at com.caucho.sql.DriverConfig.createDriverConnection(DriverConfig.java:709)
	at com.caucho.sql.ManagedConnectionImpl.initDriverConnection(ManagedConnectionImpl.java:277)
	at com.caucho.sql.ManagedConnectionImpl.<init>(ManagedConnectionImpl.java:147)
	at com.caucho.sql.ManagedFactoryImpl.createManagedConnection(ManagedFactoryImpl.java:153)
	at com.caucho.env.dbpool.ConnectionPool.createConnection(ConnectionPool.java:1006)
	at com.caucho.env.dbpool.ConnectionPool.allocatePoolConnection(ConnectionPool.java:848)
	at com.caucho.env.dbpool.ConnectionPool.allocateConnection(ConnectionPool.java:740)
	at com.caucho.env.dbpool.ConnectionPool.allocateConnection(ConnectionPool.java:714)
	at com.caucho.sql.UserDataSource.getConnection(UserDataSource.java:75)
	at com.caucho.sql.DBPool.getConnection(DBPool.java:808)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	... 41 more
Caused by: net.ucanaccess.jdbc.UcanaccessSQLException: invalid authorization
specification - not found: nchapuis
	at net.ucanaccess.jdbc.UcanaccessConnection.<init>(UcanaccessConnection.java:112)
	at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:194)
	... 53 more
Caused by: java.sql.SQLInvalidAuthorizationSpecException: invalid authorization
specification - not found: nchapuis
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:185)
	at net.ucanaccess.jdbc.DBReference.getHSQLDBConnection(DBReference.java:306)
	at net.ucanaccess.jdbc.UcanaccessConnection.<init>(UcanaccessConnection.java:109)
	... 54 more
Caused by: org.hsqldb.HsqlException: invalid authorization specification
- not found: nchapuis
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.rights.UserManager.get(Unknown Source)
	at org.hsqldb.rights.UserManager.getUser(Unknown Source)
	at org.hsqldb.Database.connect(Unknown Source)
	at org.hsqldb.DatabaseManager.newSession(Unknown Source)
	... 61 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

5 times, 1 week ago
2 times, 3 months ago
Samebug visitor profile picture
Unknown user
Once, 4 months ago
2 times, 4 months ago
24 times, 5 months ago
92 more bugmates