[code]
init:
deps-jar:
compile:
run:
[TopLink Config]: 2007.12.02 11:08:22.750--ServerSession(19230370)--The alias name for the entity class [class lib.bd.Produtos] is being defaulted to: Produtos.
[TopLink Info]: 2007.12.02 11:08:38.796--ServerSession(19230370)--TopLink, version: Oracle TopLink Essentials - 2006.8 (Build 060830)
[TopLink Config]: 2007.12.02 11:08:42.000--ServerSession(19230370)--Connection(22566565)--connecting(DatabaseLogin(
platform=>MySQL4Platform
user name=> "root"
datasource URL=> "jdbc:mysql://localhost/kastiberg"
))
[TopLink Config]: 2007.12.02 11:08:42.171--ServerSession(19230370)--Connection(19267322)--Connected: jdbc:mysql://localhost/kastiberg
User: root@localhost
Database: MySQL Version: 5.0.41-community-nt
Driver: MySQL-AB JDBC Driver Version: mysql-connector-java-5.1.0 ( $Date: 2007-04-05 23:56:05 +0200 (Thu, 05 Apr 2007) $, $Revision: 6376 $ )
[TopLink Config]: 2007.12.02 11:08:42.171--ServerSession(19230370)--Connection(25616143)--connecting(DatabaseLogin(
platform=>MySQL4Platform
user name=> "root"
datasource URL=> "jdbc:mysql://localhost/kastiberg"
))
[TopLink Config]: 2007.12.02 11:08:42.328--ServerSession(19230370)--Connection(10884088)--Connected: jdbc:mysql://localhost/kastiberg
User: root@localhost
Database: MySQL Version: 5.0.41-community-nt
Driver: MySQL-AB JDBC Driver Version: mysql-connector-java-5.1.0 ( $Date: 2007-04-05 23:56:05 +0200 (Thu, 05 Apr 2007) $, $Revision: 6376 $ )
[TopLink Config]: 2007.12.02 11:08:42.328--ServerSession(19230370)--Connection(23667197)--connecting(DatabaseLogin(
platform=>MySQL4Platform
user name=> "root"
datasource URL=> "jdbc:mysql://localhost/kastiberg"
))
[TopLink Config]: 2007.12.02 11:08:42.375--ServerSession(19230370)--Connection(27742346)--Connected: jdbc:mysql://localhost/kastiberg
User: root@localhost
Database: MySQL Version: 5.0.41-community-nt
Driver: MySQL-AB JDBC Driver Version: mysql-connector-java-5.1.0 ( $Date: 2007-04-05 23:56:05 +0200 (Thu, 05 Apr 2007) $, $Revision: 6376 $ )
[TopLink Config]: 2007.12.02 11:08:42.375--ServerSession(19230370)--Connection(26790717)--connecting(DatabaseLogin(
platform=>MySQL4Platform
user name=> "root"
datasource URL=> "jdbc:mysql://localhost/kastiberg"
))
[TopLink Config]: 2007.12.02 11:08:42.453--ServerSession(19230370)--Connection(11688861)--Connected: jdbc:mysql://localhost/kastiberg
User: root@localhost
Database: MySQL Version: 5.0.41-community-nt
Driver: MySQL-AB JDBC Driver Version: mysql-connector-java-5.1.0 ( $Date: 2007-04-05 23:56:05 +0200 (Thu, 05 Apr 2007) $, $Revision: 6376 $ )
[TopLink Config]: 2007.12.02 11:08:42.453--ServerSession(19230370)--Connection(27058272)--connecting(DatabaseLogin(
platform=>MySQL4Platform
user name=> "root"
datasource URL=> "jdbc:mysql://localhost/kastiberg"
))
[TopLink Config]: 2007.12.02 11:08:42.484--ServerSession(19230370)--Connection(20785379)--Connected: jdbc:mysql://localhost/kastiberg
User: root@localhost
Database: MySQL Version: 5.0.41-community-nt
Driver: MySQL-AB JDBC Driver Version: mysql-connector-java-5.1.0 ( $Date: 2007-04-05 23:56:05 +0200 (Thu, 05 Apr 2007) $, $Revision: 6376 $ )
[TopLink Config]: 2007.12.02 11:08:42.484--ServerSession(19230370)--Connection(4677928)--connecting(DatabaseLogin(
platform=>MySQL4Platform
user name=> "root"
datasource URL=> "jdbc:mysql://localhost/kastiberg"
))
[TopLink Config]: 2007.12.02 11:08:42.500--ServerSession(19230370)--Connection(6278953)--Connected: jdbc:mysql://localhost/kastiberg
User: root@localhost
Database: MySQL Version: 5.0.41-community-nt
Driver: MySQL-AB JDBC Driver Version: mysql-connector-java-5.1.0 ( $Date: 2007-04-05 23:56:05 +0200 (Thu, 05 Apr 2007) $, $Revision: 6376 $ )
[TopLink Config]: 2007.12.02 11:08:42.515--ServerSession(19230370)--Connection(1683934)--connecting(DatabaseLogin(
platform=>MySQL4Platform
user name=> "root"
datasource URL=> "jdbc:mysql://localhost/kastiberg"
))
[TopLink Config]: 2007.12.02 11:08:42.531--ServerSession(19230370)--Connection(2804837)--Connected: jdbc:mysql://localhost/kastiberg
User: root@localhost
Database: MySQL Version: 5.0.41-community-nt
Driver: MySQL-AB JDBC Driver Version: mysql-connector-java-5.1.0 ( $Date: 2007-04-05 23:56:05 +0200 (Thu, 05 Apr 2007) $, $Revision: 6376 $ )
[TopLink Info]: 2007.12.02 11:08:42.937--ServerSession(19230370)--file:/C:/Kastibergue2/build/classes-Kastibergue2PU login successful
[TopLink Warning]: 2007.12.02 11:08:43.125--ServerSession(19230370)--Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'produtos' already existsError Code: 1050
Call:CREATE TABLE produtos (id INTEGER NOT NULL, totalEmEstoque INTEGER, numDoProduto INTEGER NOT NULL, totalVendido DOUBLE, Quantidade INTEGER, precoDeCompra DOUBLE, produto TEXT(64000), totalDeCompra DOUBLE, valorProduto DOUBLE, PRIMARY KEY (id))
Query:DataModifyQuery()
[TopLink Warning]: 2007.12.02 11:09:27.812--UnitOfWork(13878947)--Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'id' cannot be nullError Code: 1048
Call:INSERT INTO produtos (id, totalEmEstoque, numDoProduto, totalVendido, Quantidade, precoDeCompra, produto, totalDeCompra, valorProduto) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [null, 1, 1, 1.0, 1, 1.0, dimas, 1.0, 1.0]
Query:InsertObjectQuery(lib.bd.Produtos[id=null])
[color=red] javax.persistence.RollbackException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'id' cannot be nullError Code: 1048
Call:INSERT INTO produtos (id, totalEmEstoque, numDoProduto, totalVendido, Quantidade, precoDeCompra, produto, totalDeCompra, valorProduto) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [null, 1, 1, 1.0, 1, 1.0, dimas, 1.0, 1.0]
Query:InsertObjectQuery(lib.bd.Produtos[id=null])
at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit(EntityTransactionImpl.java:109)
at oracle.toplink.essentials.internal.ejb.cmp3.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:45)[/color]
[color=blue] at GUI.main.persist(main.java:335)
at GUI.main.AdicionaProdutoActionPerformed(main.java:284)
at GUI.main.access$100(main.java:36)
at GUI.main$2.actionPerformed(main.java:104)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
[/color]
[color=red]Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'id' cannot be nullError Code: 1048
Call:INSERT INTO produtos (id, totalEmEstoque, numDoProduto, totalVendido, Quantidade, precoDeCompra, produto, totalDeCompra, valorProduto) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [null, 1, 1, 1.0, 1, 1.0, dimas, 1.0, 1.0]
Query:InsertObjectQuery(lib.bd.Produtos[id=null])
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:331)
at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:176)
at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:190)
at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:457)
at oracle.toplink.essentials.queryframework.InsertObjectQuery.executeCommit(InsertObjectQuery.java:74)
at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.performUserDefinedWrite(DatabaseQueryMechanism.java:635)
at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.performUserDefinedInsert(DatabaseQueryMechanism.java:599)
at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.insertObjectForWriteWithChangeSet(DatabaseQueryMechanism.java:495)
at oracle.toplink.essentials.queryframework.WriteObjectQuery.executeCommitWithChangeSet(WriteObjectQuery.java:130)
at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:283)
at oracle.toplink.essentials.queryframework.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:67)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536)
at oracle.toplink.essentials.queryframework.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:123)
at oracle.toplink.essentials.queryframework.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:95)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2218)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
at oracle.toplink.essentials.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:254)
at oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:175)
at oracle.toplink.essentials.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:2638)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1030)
at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:357)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1112)
at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:82)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:842)
at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit(EntityTransactionImpl.java:90)
... 30 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'id' cannot be null
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
[/color]
[color=blue]at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
[/color]
[color=red]at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Util.getInstance(Util.java:336)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1016)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2436)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1402)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1694)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1608)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1593)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:632)
... 63 more
Exception in thread "AWT-EventQueue-0" java.lang.IllegalStateException:
Exception Description: No transaction is currently active
at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.rollback(EntityTransactionImpl.java:125)
[/color]
[color=blue] at GUI.main.persist(main.java:339)
at GUI.main.AdicionaProdutoActionPerformed(main.java:284)
at GUI.main.access$100(main.java:36)
at GUI.main$2.actionPerformed(main.java:104)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
[/color]
