Pessoal estou usando um banco em memória como ferramente de aprendizado,porém não estou conseguindo verificar os dados que inserir no banco virutal
Segue o erro do console.
Set 23, 2014 8:07:52 PM org.apache.catalina.core.AprLifecycleListener init
INFORMAÇÕES: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre1.8.0_20/bin/server;C:/Program Files/Java/jre1.8.0_20/bin;C:/Program Files/Java/jre1.8.0_20/lib/amd64;C:\ProgramData\Oracle\Java\javapath;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\EasyPHP-DevServer-13.1VC11\binaries\php\php_runningversion;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Windows Live\Shared;C:\WINDOWS\system32;C:\WINDOWS;;C:\eclipse;;.
Set 23, 2014 8:07:52 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
ADVERTÊNCIA: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source’ to ‘org.eclipse.jst.jee.server:contas’ did not find a matching property.
Set 23, 2014 8:07:53 PM org.apache.coyote.AbstractProtocol init
INFORMAÇÕES: Initializing ProtocolHandler [“http-bio-8080”]
Set 23, 2014 8:07:53 PM org.apache.coyote.AbstractProtocol init
INFORMAÇÕES: Initializing ProtocolHandler [“ajp-bio-8009”]
Set 23, 2014 8:07:53 PM org.apache.catalina.startup.Catalina load
INFORMAÇÕES: Initialization processed in 1826 ms
Set 23, 2014 8:07:53 PM org.apache.catalina.core.StandardService startInternal
INFORMAÇÕES: Starting service Catalina
Set 23, 2014 8:07:53 PM org.apache.catalina.core.StandardEngine startInternal
INFORMAÇÕES: Starting Servlet Engine: Apache Tomcat/7.0.55
Set 23, 2014 8:07:55 PM org.apache.catalina.util.SessionIdGenerator createSecureRandom
INFORMAÇÕES: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [1,079] milliseconds.
Set 23, 2014 8:08:03 PM org.apache.catalina.core.ApplicationContext log
INFORMAÇÕES: No Spring WebApplicationInitializer types detected on classpath
Set 23, 2014 8:08:03 PM org.apache.coyote.AbstractProtocol start
INFORMAÇÕES: Starting ProtocolHandler [“http-bio-8080”]
Set 23, 2014 8:08:03 PM org.apache.coyote.AbstractProtocol start
INFORMAÇÕES: Starting ProtocolHandler [“ajp-bio-8009”]
Set 23, 2014 8:08:03 PM org.apache.catalina.startup.Catalina start
INFORMAÇÕES: Server startup in 10175 ms
20:12:39,046 INFO DispatcherServlet:479 - FrameworkServlet ‘spring mvc’: initialization started
20:12:39,108 INFO XmlWebApplicationContext:513 - Refreshing WebApplicationContext for namespace ‘spring mvc-servlet’: startup date [Tue Sep 23 20:12:39 GMT-03:00 2014]; root of context hierarchy
20:12:39,238 INFO XmlBeanDefinitionReader:316 - Loading XML bean definitions from ServletContext resource [/WEB-INF/spring-context.xml]
Set 23, 2014 8:12:39 PM org.apache.catalina.core.ApplicationContext log
INFORMAÇÕES: Initializing Spring FrameworkServlet 'spring mvc’
20:12:40,600 INFO RequestMappingHandlerMapping:197 - Mapped “{[/form],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}” onto public java.lang.String br.com.caelum.contas.controller.ContaController.formulario()
20:12:40,601 INFO RequestMappingHandlerMapping:197 - Mapped “{[/listaContas],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}” onto public org.springframework.web.portlet.ModelAndView br.com.caelum.contas.controller.ContaController.lista()
20:12:40,602 INFO RequestMappingHandlerMapping:197 - Mapped “{[/adicionaConta],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}” onto public java.lang.String br.com.caelum.contas.controller.ContaController.adciona(br.com.caelum.contas.modelo.Conta)
20:12:40,604 INFO RequestMappingHandlerMapping:197 - Mapped “{[/tabelas],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}” onto public java.lang.String br.com.caelum.contas.controller.InfraController.criaBanco() throws java.sql.SQLException
20:12:40,605 INFO RequestMappingHandlerMapping:197 - Mapped “{[/olaMundoSpring],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}” onto public java.lang.String br.com.caelum.contas.controller.OlaMundoController.execute()
20:12:41,267 INFO DispatcherServlet:498 - FrameworkServlet ‘spring mvc’: initialization completed in 2215 ms
conectando …
Classe controler
package br.com.caelum.contas.controller;
import java.util.List;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.portlet.ModelAndView;
import br.com.caelum.contas.dao.ContaDAO;
import br.com.caelum.contas.modelo.Conta;
@Controller
public class ContaController {
@RequestMapping("/form")
public String formulario() {
return "formulario";
}
@RequestMapping("/adicionaConta")
public String adciona(Conta conta) {
ContaDAO dao = new ContaDAO();
dao.adiciona(conta);
return "conta-adicionada";
}
@RequestMapping("/listaContas")
public ModelAndView lista() {
ContaDAO dao = new ContaDAO();
List<Conta> contas = dao.lista();
ModelAndView mv = new ModelAndView("conta/lista");
mv.addObject("todascontas", contas);
return mv;
}
}
spring-context.xml
[code]
<?xml version="1.0" encoding="UTF-8"?><context:component-scan base-package="br.com.caelum.contas" />
<mvc:annotation-driven />
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/views/" />
<property name="suffix" value=".jsp" />
</bean>
<bean id="conversionService"
class="org.springframework.context.support.ConversionServiceFactoryBean">
<property name="converters">
<list>
<bean class="br.com.caelum.contas.StringToEnumConverterFactory"/>
</list>
</property>
</bean>
[code]
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectionFactory {
public Connection getConnection() throws SQLException {
System.out.println("conectando ...");
try {
Class.forName("org.hsqldb.jdbcDriver");
} catch (ClassNotFoundException e) {
throw new SQLException(e);
}
return DriverManager.getConnection("jdbc:hsqldb:file:contas.db","sa", "");
}
}