[Error] Spring MVC file upload 오류 - 해결

 

파일 생성 및 저장은 되었는데

에러 문구 발생.

확인 필요.

파일은 정상 저장됨.

 

	<!-- Postgresql jdbc setting
			<bean id="dataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource" >
			<property name="driverClass" value="org.postgresql.Driver" />
			<property name="url" value="$jdbc:postgresql://localhost:5432/****" />
			<property name="username" value="****" />
			<property name="password" value="****" />
	</bean> -->

 

C:\upload\20221022
폴더가 생성되었습니다
ERROR: com.assignment.exception.CommonExceptionAdvice - Exception ......nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection: DataSource returned null from getConnection(): org.springframework.jdbc.datasource.SimpleDriverDataSource@22e880a9
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection: DataSource returned null from getConnection(): org.springframework.jdbc.datasource.SimpleDriverDataSource@22e880a9
ERROR: com.assignment.exception.CommonExceptionAdvice - {exception=org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection: DataSource returned null from getConnection(): org.springframework.jdbc.datasource.SimpleDriverDataSource@22e880a9
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection: DataSource returned null from getConnection(): org.springframework.jdbc.datasource.SimpleDriverDataSource@22e880a9}

 

 

구문 변경 시

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="org.postgresql.Driver"></property>
		<property name="url" value="$jdbc:postgresql://localhost:5432/****" />
			<property name="username" value="****" />
			<property name="password" value="****" />
	</bean>

 

이미 폴더가 존재합니다
ERROR: com.assignment.exception.CommonExceptionAdvice - Exception ......nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: No suitable driver found for $jdbc:postgresql://localhost:5432/****
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: No suitable driver found for $jdbc:postgresql://localhost:5432/****
ERROR: com.assignment.exception.CommonExceptionAdvice - {exception=org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: No suitable driver found for $jdbc:postgresql://localhost:5432/****
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: No suitable driver found for $jdbc:postgresql://localhost:5432/****}

 

driver 를 못 찾았다는 에러로 변경됨.

db 못 찾음.

확인 필요.

 

+

해결함

 

https://devel-log.tistory.com/37

[Error] Java Spring MVC + Mybatis + PostgreSQL - CannotGetJdbcConnectionException : DB연동 오류