Spring erro ao iniciar

1 resposta
A

Sempre que tento levantar o Tomcat esta dando alguns erros

Configuracao do dataSource no applicationContext
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" destroy-method="close">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://localhost:3306/basedados?autoReconnect=true" />
		<property name="username"><value>root</value></property>
		<property name="password"><value></value></property>
	</bean>
<property name="hibernateProperties">
			<props>
				<!-- prop key="hibernate.default_schema">operadora1</prop-->
				<!-- Mysql	-->	
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> 
				
				<!-- Use the C3P0 connection pool. -->
				<!-- <prop key="hibernate.c3p0.min_size">3</prop>-->
				<!-- <prop key="hibernate.c3p0.max_size">5</prop>-->
				<prop key="hibernate.c3p0.timeout">1800</prop>

				<prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
				<prop key="hibernate.cache.use_query_cache">false</prop>
				<prop key="hibernate.cache.use_minimal_puts">false</prop>
				<prop key="hibernate.max_fetch_depth">0</prop>
				 
				<prop key="hibernate.show_sql">true</prop>
				
				<prop key="hibernate.autocommit">true</prop>
				<!-- Refresh database on each build of SessionFactory and drop it on close. -->
			</props>
		</property>

ERROS:

SEVERE: The url cannot be null
14/03/2007 23:46:26 org.hibernate.cfg.SettingsFactory buildSettings
WARNING: Could not obtain connection metadata
java.sql.SQLException: The url cannot be null
	at java.sql.DriverManager.getConnection(DriverManager.java:502)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:291)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:277)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:259)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:241)
	at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)
INFO: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
14/03/2007 23:46:27 org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase]
14/03/2007 23:46:27 org.springframework.jdbc.support.SQLErrorCodesFactory getErrorCodes
WARNING: Error while extracting database product name - falling back to empty error codes
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 java.sql.SQLException: The url cannot be null
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: The url cannot be null
java.sql.SQLException: The url cannot be null
	at java.sql.DriverManager.getConnection(DriverManager.java:502)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:291)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:277)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:259)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:241)
SEVERE: Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Initialization of bean failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [08001]; error code [0]; The url cannot be null; nested exception is java.sql.SQLException: The url cannot be null
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [08001]; error code [0]; The url cannot be null; nested exception is java.sql.SQLException: The url cannot be null
java.sql.SQLException: The url cannot be null
	at java.sql.DriverManager.getConnection(DriverManager.java:502)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)

1 Resposta

A

Feito resolvi heheheehhehe
Sabia que o problema era simples, o negocio é que a aplicação sempre funcionou normal, hoje fui starta e deu esse erro, mudei o applicationContext para o codigo abaixo e funfo

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName"><value>org.gjt.mm.mysql.Driver</value></property> <property name="url" value="jdbc:mysql://localhost:3306/basedados" /> <property name="username"><value>root</value></property> <property name="password"><value></value></property> <property name="poolPreparedStatements"><value>true</value></property> <property name="maxActive"><value>10</value></property> <property name="maxIdle"><value>10</value></property> </bean>

Criado 15 de março de 2007
Ultima resposta 15 de mar. de 2007
Respostas 1
Participantes 1