Java.sql.SQLException: commit called with AutoCommit true!?

Front-end
#1

Srs.

Estou postando o código abaixo. Acho que a tabela do Banco de Dados referente a esse erro está “setada” com a propriedade autocommit true. Certo?


**  JDO  iniciado com sucesso **
**  Mon Aug 22 11:46:40 BRT 2005 **
DriverName=org.firebirdsql.jdbc.FBDriver
URL=jdbc:firebirdsql:ibsql.sggc.t5.com.br:/web/sites/sggc.t5.com.br/data/sggc.gdb
MinPool=2
MaxPool=20
Criando EN (1)
java.sql.SQLException: commit called with AutoCommit true!
	at org.firebirdsql.jdbc.FBConnection.commit(FBConnection.java:450)
	at com.sun.forte4j.persistence.internal.connection.ConnectionImpl.commit(ConnectionImpl.java:127)
	at com.sun.forte4j.persistence.internal.runtime.jdo.PersistenceManagerFactoryImpl.getDBName(PersistenceManagerFactoryImpl.java:769)
	at com.sun.forte4j.persistence.internal.runtime.jdo.PersistenceManagerFactoryImpl.getFromPool(PersistenceManagerFactoryImpl.java:673)
	at com.sun.forte4j.persistence.internal.runtime.jdo.PersistenceManagerFactoryImpl.getPersistenceManager(PersistenceManagerFactoryImpl.java:584)
	at com.sun.forte4j.persistence.PersistenceManagerFactoryImpl.getPersistenceManager(PersistenceManagerFactoryImpl.java:749)
	at com.sun.forte4j.persistence.PersistenceManagerFactoryImpl.getPersistenceManager(PersistenceManagerFactoryImpl.java:660)
	at en.model.EscolaNaval.<init>(EscolaNaval.java:186)
	at en.model.Global.setar(Global.java:49)
	at en.model.Global.<init>(Global.java:29)
	at en.model.Global.<clinit>(Global.java:18)
	at en.model.Util.montaMenu(Util.java:516)
	at org.apache.jsp.menu_jsp._jspService(menu_jsp.java:142)
	at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
	at org.apache.jasper.servlet.JspServletWrapper.service(Unknown Source)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
	at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
	at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
	at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown Source)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
	at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
	at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:261)
	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360)
	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604)
	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:562)
	at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
	at java.lang.Thread.run(Thread.java:595)
#2

A tabela não, a conexão com o seu banco de dados é que está.

#3

Maurício,

Como assim?

#4

Toda conexão feita pelo java é autoCommit por default. Vc não precisa chamar o commit explicitamente, que parece ser o que esta acontecendo.

de uma olhadinha nas docs da interface connection.

[]'s

#5

Gente,

O problema é q esse erro só começou a acontecer depois que eu troquei o meu banco de dados. Eis a questão. Me cadastrei na hostgold e coloque i meu banco de dados lá. A princío e erro era de senha e login. Me sugeriram para baixar o banco de dados deles(criado por default) para o meu site. Alterei a estrutura do banco de dps deles e coloquei de volta no servidor, aí me apareceu o erro que eu postei! Estranho.

#6

Quando eu coloco o banco de dados que eu criei na minha máquina no servidor dá o sequinte erro:

2005-08-22 14:30:29 StandardContext[]: **     Inicializando JDO      **
**  JDO  iniciado com sucesso **
**  Mon Aug 22 14:30:29 BRT 2005 **
DriverName=interbase.interclient.Driver
URL=jdbc:firebirdsql:ibsql.sggc.t5.com.br:/web/sites/sggc.t5.com.br/data/celula.gdb
MinPool=2
MaxPool=20
Criando EN (1)
com.sun.forte4j.persistence.JDOCanRetryException: Failed to get a connection.
NestedException: com.sun.forte4j.persistence.JDOFatalException
NestedException: org.firebirdsql.jdbc.FBSQLException: Resource Exception. Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
Reason: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
	at com.sun.forte4j.persistence.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:337)
	at com.sun.forte4j.persistence.internal.runtime.jdo.PersistenceManagerFactoryImpl.getDBName(PersistenceManagerFactoryImpl.java:758)
	at com.sun.forte4j.persistence.internal.runtime.jdo.PersistenceManagerFactoryImpl.getFromPool(PersistenceManagerFactoryImpl.java:673)
	at com.sun.forte4j.persistence.internal.runtime.jdo.PersistenceManagerFactoryImpl.getPersistenceManager(PersistenceManagerFactoryImpl.java:584)
	at com.sun.forte4j.persistence.PersistenceManagerFactoryImpl.getPersistenceManager(PersistenceManagerFactoryImpl.java:749)
	at com.sun.forte4j.persistence.PersistenceManagerFactoryImpl.getPersistenceManager(PersistenceManagerFactoryImpl.java:660)

Ouse seja, eu saio da frigideria para cair no fogo.

#7