You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Gu...@cellzome.com on 2003/05/05 18:50:29 UTC
Upgrading problem 0.9.9 -> 1.0rc3
Hi,
after weeks post-ponning the OJB upgrade I've finally managed to get some
time to do it ... and guess what ... I'm already running in my first
problems: I try to insert a really simple object, and it seems that OJB has
some problem with the high-low sequence manager:
[org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO: Rollback
was called, do rollback on current connection
oracle.jdbc.driver.OracleConnection@18b81e3
java.lang.ClassCastException
at
oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:2367)
at
oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:2462)
at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Unknown
Source)
at
org.apache.ojb.broker.platforms.PlatformOracleImpl.setObjectForStatement(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown
Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(Unknown
Source)
at
org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(Unknown
Source)
at org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(Unknown
Source)
at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(Unknown
Source)
at org.apache.ojb.broker.Identity.init(Unknown Source)
at org.apache.ojb.broker.Identity.<init>(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
at
com.cellzome.session.persistence.PersistenceApplicationTest.test(PersistenceApplicationTest.java:62)
I've checked the repository.xml file and the class descriptor is the same
than the one in the documentation. The table is present in the database
(with the new version field). Turning on debugging doesn't give more info
... Does some one have an idea ?
Thanx,
Guillaume
Re: Upgrading problem 0.9.9 -> 1.0rc3 (Oracle)
Posted by Rudolf Janz <ru...@gmx.net>.
Hi,
> after weeks post-ponning the OJB upgrade I've finally managed to get some
> time to do it ... and guess what ... I'm already running in my first
> problems: I try to insert a really simple object, and it seems that OJB has
> some problem with the high-low sequence manager:
> [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO: Rollback
> was called, do rollback on current connection
> oracle.jdbc.driver.OracleConnection@18b81e3
> java.lang.ClassCastException
> at
> oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:2367)
Sorry for the late answer. I faced the same problem last week.
There were two errors related to this. The first one was that, maxKey
is defined as INTEGER in repository_internal.xml,although it is a long
variable in the classe, simply change it to BIGINT.
The second problem I found the problem to be the use of int in the HighLowSequence
for grabSize. The type of the column the Oracle JDBC driver expects is Long
but it receives an Integer object. So one solution would be to define
the table OJB_HL_SEQ in a way so that the Oracle driver recognizes the
column correctly as JDBC type INTEGER and not BIGINT. I do not know if
this is possible at all. As far as I see, NUMBER(x) columns are always
considered to be JDBC type BIGINT by Oracle JDBC driver. Is this
right?
My workaround was to create a custom HighLowSequence to use only longs
(I already use a slightly modified SequenceManagerHighLowImpl, so this
was not much work). This works. All our persistence classes use Long
anyway(generated by reverse-db).
Of course I would be interested in a better solution. One thing I do
not understand what caused the problem. Because in 0.9.9
HighLowSequence was using ints for grabsize with no problem. How could
the change of type for maxKey and the addition of version field change
this. I looked a little bit at the code, but did not see any code
change that would cause the problem. Does anybody know what is going
on?
Rudolf Janz
> Hi,
> at
> oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:2462)
> at
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Unknown
> Source)
> at
> org.apache.ojb.broker.platforms.PlatformOracleImpl.setObjectForStatement(Unknown
> Source)
> at
> org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown
> Source)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
> Source)
> at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
> Source)
> at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown
> Source)
> at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown
> Source)
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
> Source)
> at
> org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(Unknown
> Source)
> at
> org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong(Unknown
> Source)
> at
> org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId(Unknown
> Source)
> at
> org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(Unknown
> Source)
> at
> org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(Unknown
> Source)
> at org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(Unknown
> Source)
> at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(Unknown
> Source)
> at org.apache.ojb.broker.Identity.init(Unknown Source)
> at org.apache.ojb.broker.Identity.<init>(Unknown Source)
> at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown
> Source)
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
> Source)
> at
> com.cellzome.session.persistence.PersistenceApplicationTest.test(PersistenceApplicationTest.java:62)
> I've checked the repository.xml file and the class descriptor is the same
> than the one in the documentation. The table is present in the database
> (with the new version field). Turning on debugging doesn't give more info
> ... Does some one have an idea ?
> Thanx,
> Guillaume
Re: Upgrading problem 1.0rc2 -> 1.0rc3
Posted by Jakob Braeuchi <jb...@gmx.ch>.
hi edson,
sorry, this is my fault when looking for things like 'min(distinct
codigo)' :(
but i'm working on a fix.
jakob
Edson Carlos Ericksson Richter wrote:
>Yes, this solved my problem.
>
>min( codigo ) worked in RC2, but not in RC3. Changed my code to min(codigo),
>then it work in RC3...
>
>I don't know why spaces make differences... :(
>
>Thanks,
>
>Edson Richter
>
>----- Original Message -----
>From: "Jakob Braeuchi" <jb...@gmx.ch>
>To: "OJB Users List" <oj...@db.apache.org>
>Sent: Tuesday, May 06, 2003 3:32 PM
>Subject: Re: Upgrading problem 1.0rc2 -> 1.0rc3
>
>
>hi edson,
>
>do you have an idea where the 'min' comes from ?
>one problem i fount is that
>
>'min( codigo )' will fail whereas 'min(codigo)' should work
>
>hth
>jakob
>
>
>
>
>Edson Carlos Ericksson Richter wrote:
>
>
>
>>After update from 1.0rc2 to 1.0rc3 I get bellow exception.
>>Appear that my "column" attribute in field descriptor is not being
>>recognized by ReportQueryByCriteria.
>>
>>My upgrade procedure:
>>
>>1) Unzip db-ojb-1.0.rc3 and put all /lib/*.jar in my classpath;
>>2) Modified FieldDescriptor with FIX for setAccess problem;
>>3) Used the new o.a.o.broker.util.collections.RemovalAwareList as
>>
>>
>collection
>
>
>>descriptor;
>>4) Overwrite my ojb.properties, repository.dtd and repository_internal.xml
>>with new versions. Adjust ojb.properties to use PropertyImpl.
>>
>>The code is like
>>
>> String pkName = "codigo"; // CO_USUARIO field
>> Criteria criteria = new Criteria();
>> fieldsChave = new String [] { pkName }; // searches by CO_USUARIO
>>field
>> ReportQueryByCriteria rChave, rOrder;
>>
>> rChave = new ReportQueryByCriteria( this.clazz, fieldsChave, null );
>> criteria.addIn( pkName, rChave );
>>
>> Collection all = getByCriteria( criteria );
>>
>>The Generated SQL (I've captured directly in SapDB JDBC Driver) code is:
>>
>>(SELECT A0.CO_USUARIO,A0.NO_USUARIO,A0.DS_USERNAME,A0.DS_PASSWORD FROM
>>MGR.TB_USUARIO A0 WHERE A0.CO_USUARIO IN (SELECT min( codigo ) FROM
>>MGR.TB_USUARIO A0)
>>
>>Can someone help-me?
>>
>>Thanks,
>>
>>Edson Richter
>>
>>[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: [-4005]
>>(at 145): Unknown column name:CODIGO
>>com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at 145): Unknown
>>column name:CODIGO
>> at
>>com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
>> at
>>com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
>> at
>>com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
>> at
>>com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSap
>>
>>
>D
>
>
>>B.java:1528)
>> at
>>com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
>> at
>>com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.j
>>
>>
>a
>
>
>>va:224)
>> at
>>com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSap
>>
>>
>D
>
>
>>B.java:175)
>> at
>>com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.ja
>>
>>
>v
>
>
>>a:96)
>> at
>>com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:6
>>
>>
>7
>
>
>>2)
>> at
>>com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:347)
>> at
>>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(U
>>
>>
>n
>
>
>>known Source)
>> at
>>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Un
>>
>>
>k
>
>
>>nown Source)
>> at
>>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unk
>>
>>
>n
>
>
>>own Source)
>> at
>>org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
>>Source)
>> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
>>Source)
>> at
>>org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
>>Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unk
>>
>>
>n
>
>
>>own Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery
>>
>>
>(
>
>
>>Unknown Source)
>> at
>>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getByCriteria(GeneralBrokerI
>>
>>
>m
>
>
>>pl.java:299)
>> at
>>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getFirst(GeneralBrokerImpl.j
>>
>>
>a
>
>
>>va:149)
>> at br.com.mgr.useCases.NavegavelUC.getFirst(NavegavelUC.java:108)
>> at
>>br.com.mgr.formularios.componentes.barraNavegacao.NavegacaoToolBar.setNaveg
>>
>>
>a
>
>
>>vel(NavegacaoToolBar.java:493)
>> at
>>br.com.mgr.plugins.pessoaFJ.PanelPessoaFJGenerico.<init>(PanelPessoaFJGener
>>
>>
>i
>
>
>>co.java:42)
>> at
>>br.com.mgr.plugins.pessoaFJ.PessoaFJPlugin.getSwingUI(PessoaFJPlugin.java:1
>>
>>
>0
>
>
>>6)
>> at
>>br.com.mgr.plugins.PluginManager.getSwingUI(PluginManager.java:74)
>> at br.com.mgr.formularios.MainForm.openUrl(MainForm.java:194)
>> at
>>br.com.mgr.formularios.MainForm.actionPerformed(MainForm.java:190)
>> at
>>javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
>> at
>>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButt
>>
>>
>o
>
>
>>n.java:1839)
>> at
>>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:
>>
>>
>4
>
>
>>20)
>> at
>>javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
>> at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
>> at
>>javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
>> at
>>javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basi
>>
>>
>c
>
>
>>MenuItemUI.java:943)
>> at java.awt.Component.processMouseEvent(Component.java:5099)
>> at java.awt.Component.processEvent(Component.java:4896)
>> at java.awt.Container.processEvent(Container.java:1569)
>> at java.awt.Component.dispatchEventImpl(Component.java:3614)
>> at java.awt.Container.dispatchEventImpl(Container.java:1627)
>> at java.awt.Component.dispatchEvent(Component.java:3476)
>> at
>>java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
>> at
>>java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
>> at
>>
>>
>java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
>
>
>> at java.awt.Container.dispatchEventImpl(Container.java:1613)
>> at java.awt.Window.dispatchEventImpl(Window.java:1606)
>> at java.awt.Component.dispatchEvent(Component.java:3476)
>> at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
>> at
>>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.j
>>
>>
>a
>
>
>>va:201)
>> at
>>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.jav
>>
>>
>a
>
>
>>:151)
>> at
>>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
>> at
>>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
>> at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
>>com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at 145): Unknown
>>column name:CODIGO
>> at
>>com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
>> at
>>com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
>> at
>>com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
>> at
>>com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSap
>>
>>
>D
>
>
>>B.java:1528)
>> at
>>com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
>> at
>>com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.j
>>
>>
>a
>
>
>>va:224)
>> at
>>com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSap
>>
>>
>D
>
>
>>B.java:175)
>> at
>>com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.ja
>>
>>
>v
>
>
>>a:96)
>> at
>>com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:6
>>
>>
>7
>
>
>>2)
>> at
>>com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:347)
>> at
>>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(U
>>
>>
>n
>
>
>>known Source)
>> at
>>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Un
>>
>>
>k
>
>
>>nown Source)
>> at
>>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unk
>>
>>
>n
>
>
>>own Source)
>> at
>>org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
>>Source)
>> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
>>Source)
>> at
>>org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
>>Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unk
>>
>>
>n
>
>
>>own Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery
>>
>>
>(
>
>
>>Unknown Source)
>> at
>>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getByCriteria(GeneralBrokerI
>>
>>
>m
>
>
>>pl.java:299)
>> at
>>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getFirst(GeneralBrokerImpl.j
>>
>>
>a
>
>
>>va:149)
>> at br.com.mgr.useCases.NavegavelUC.getFirst(NavegavelUC.java:108)
>> at
>>br.com.mgr.formularios.componentes.barraNavegacao.NavegacaoToolBar.setNaveg
>>
>>
>a
>
>
>>vel(NavegacaoToolBar.java:493)
>> at
>>br.com.mgr.plugins.pessoaFJ.PanelPessoaFJGenerico.<init>(PanelPessoaFJGener
>>
>>
>i
>
>
>>co.java:42)
>> at
>>br.com.mgr.plugins.pessoaFJ.PessoaFJPlugin.getSwingUI(PessoaFJPlugin.java:1
>>
>>
>0
>
>
>>6)
>> at
>>br.com.mgr.plugins.PluginManager.getSwingUI(PluginManager.java:74)
>> at br.com.mgr.formularios.MainForm.openUrl(MainForm.java:194)
>> at
>>br.com.mgr.formularios.MainForm.actionPerformed(MainForm.java:190)
>> at
>>javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
>> at
>>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButt
>>
>>
>o
>
>
>>n.java:1839)
>> at
>>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:
>>
>>
>4
>
>
>>20)
>> at
>>javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
>> at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
>> at
>>javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
>> at
>>javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basi
>>
>>
>c
>
>
>>MenuItemUI.java:943)
>> at java.awt.Component.processMouseEvent(Component.java:5099)
>> at java.awt.Component.processEvent(Component.java:4896)
>> at java.awt.Container.processEvent(Container.java:1569)
>> at java.awt.Component.dispatchEventImpl(Component.java:3614)
>> at java.awt.Container.dispatchEventImpl(Container.java:1627)
>> at java.awt.Component.dispatchEvent(Component.java:3476)
>> at
>>java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
>> at
>>java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
>> at
>>
>>
>java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
>
>
>> at java.awt.Container.dispatchEventImpl(Container.java:1613)
>> at java.awt.Window.dispatchEventImpl(Window.java:1606)
>> at java.awt.Component.dispatchEvent(Component.java:3476)
>> at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
>> at
>>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.j
>>
>>
>a
>
>
>>va:201)
>> at
>>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.jav
>>
>>
>a
>
>
>>:151)
>> at
>>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
>> at
>>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
>> at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
>>rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException: [-4005]
>>
>>
>(at
>
>
>>145): Unknown column name:CODIGO
>> at
>>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Un
>>
>>
>k
>
>
>>nown Source)
>> at
>>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unk
>>
>>
>n
>
>
>>own Source)
>> at
>>org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
>>Source)
>> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
>>Source)
>> at
>>org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
>>Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unk
>>
>>
>n
>
>
>>own Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
>>
>>
>w
>
>
>>n Source)
>> at
>>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery
>>
>>
>(
>
>
>>Unknown Source)
>> at
>>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getByCriteria(GeneralBrokerI
>>
>>
>m
>
>
>>pl.java:299)
>> at
>>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getFirst(GeneralBrokerImpl.j
>>
>>
>a
>
>
>>va:149)
>> at br.com.mgr.useCases.NavegavelUC.getFirst(NavegavelUC.java:108)
>> at
>>br.com.mgr.formularios.componentes.barraNavegacao.NavegacaoToolBar.setNaveg
>>
>>
>a
>
>
>>vel(NavegacaoToolBar.java:493)
>> at
>>br.com.mgr.plugins.pessoaFJ.PanelPessoaFJGenerico.<init>(PanelPessoaFJGener
>>
>>
>i
>
>
>>co.java:42)
>> at
>>br.com.mgr.plugins.pessoaFJ.PessoaFJPlugin.getSwingUI(PessoaFJPlugin.java:1
>>
>>
>0
>
>
>>6)
>> at
>>br.com.mgr.plugins.PluginManager.getSwingUI(PluginManager.java:74)
>> at br.com.mgr.formularios.MainForm.openUrl(MainForm.java:194)
>> at
>>br.com.mgr.formularios.MainForm.actionPerformed(MainForm.java:190)
>> at
>>javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
>> at
>>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButt
>>
>>
>o
>
>
>>n.java:1839)
>> at
>>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:
>>
>>
>4
>
>
>>20)
>> at
>>javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
>> at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
>> at
>>javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
>> at
>>javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basi
>>
>>
>c
>
>
>>MenuItemUI.java:943)
>> at java.awt.Component.processMouseEvent(Component.java:5099)
>> at java.awt.Component.processEvent(Component.java:4896)
>> at java.awt.Container.processEvent(Container.java:1569)
>> at java.awt.Component.dispatchEventImpl(Component.java:3614)
>> at java.awt.Container.dispatchEventImpl(Container.java:1627)
>> at java.awt.Component.dispatchEvent(Component.java:3476)
>> at
>>java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
>> at
>>java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
>> at
>>
>>
>java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
>
>
>> at java.awt.Container.dispatchEventImpl(Container.java:1613)
>> at java.awt.Window.dispatchEventImpl(Window.java:1606)
>> at java.awt.Component.dispatchEvent(Component.java:3476)
>> at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
>> at
>>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.j
>>
>>
>a
>
>
>>va:201)
>> at
>>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.jav
>>
>>
>a
>
>
>>:151)
>> at
>>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
>> at
>>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
>> at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
>>Caused by: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at
>>145): Unknown column name:CODIGO
>> at
>>com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
>> at
>>com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
>> at
>>com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
>> at
>>com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSap
>>
>>
>D
>
>
>>B.java:1528)
>> at
>>com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
>> at
>>com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.j
>>
>>
>a
>
>
>>va:224)
>> at
>>com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSap
>>
>>
>D
>
>
>>B.java:175)
>> at
>>com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.ja
>>
>>
>v
>
>
>>a:96)
>> at
>>com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:6
>>
>>
>7
>
>
>>2)
>> at
>>com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:347)
>> at
>>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(U
>>
>>
>n
>
>
>>known Source)
>> ... 46 more
>>[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR:
>>PersistenceBrokerException during the execution of the query: [-4005] (at
>>145): Unknown column name:CODIGO
>>[-4005] (at 145): Unknown column name:CODIGO
>>
>>
>>
>>---
>>Outgoing mail is certified Virus Free.
>>Checked by AVG anti-virus system (http://www.grisoft.com).
>>Version: 6.0.476 / Virus Database: 273 - Release Date: 24/4/2003
>>
>>
>>
>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.476 / Virus Database: 273 - Release Date: 24/4/2003
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
>
Re: Upgrading problem 1.0rc2 -> 1.0rc3
Posted by Edson Carlos Ericksson Richter <ed...@mgrinformatica.com.br>.
Yes, this solved my problem.
min( codigo ) worked in RC2, but not in RC3. Changed my code to min(codigo),
then it work in RC3...
I don't know why spaces make differences... :(
Thanks,
Edson Richter
----- Original Message -----
From: "Jakob Braeuchi" <jb...@gmx.ch>
To: "OJB Users List" <oj...@db.apache.org>
Sent: Tuesday, May 06, 2003 3:32 PM
Subject: Re: Upgrading problem 1.0rc2 -> 1.0rc3
hi edson,
do you have an idea where the 'min' comes from ?
one problem i fount is that
'min( codigo )' will fail whereas 'min(codigo)' should work
hth
jakob
Edson Carlos Ericksson Richter wrote:
>After update from 1.0rc2 to 1.0rc3 I get bellow exception.
>Appear that my "column" attribute in field descriptor is not being
>recognized by ReportQueryByCriteria.
>
>My upgrade procedure:
>
>1) Unzip db-ojb-1.0.rc3 and put all /lib/*.jar in my classpath;
>2) Modified FieldDescriptor with FIX for setAccess problem;
>3) Used the new o.a.o.broker.util.collections.RemovalAwareList as
collection
>descriptor;
>4) Overwrite my ojb.properties, repository.dtd and repository_internal.xml
>with new versions. Adjust ojb.properties to use PropertyImpl.
>
>The code is like
>
> String pkName = "codigo"; // CO_USUARIO field
> Criteria criteria = new Criteria();
> fieldsChave = new String [] { pkName }; // searches by CO_USUARIO
>field
> ReportQueryByCriteria rChave, rOrder;
>
> rChave = new ReportQueryByCriteria( this.clazz, fieldsChave, null );
> criteria.addIn( pkName, rChave );
>
> Collection all = getByCriteria( criteria );
>
>The Generated SQL (I've captured directly in SapDB JDBC Driver) code is:
>
>(SELECT A0.CO_USUARIO,A0.NO_USUARIO,A0.DS_USERNAME,A0.DS_PASSWORD FROM
>MGR.TB_USUARIO A0 WHERE A0.CO_USUARIO IN (SELECT min( codigo ) FROM
>MGR.TB_USUARIO A0)
>
>Can someone help-me?
>
>Thanks,
>
>Edson Richter
>
>[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: [-4005]
>(at 145): Unknown column name:CODIGO
>com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at 145): Unknown
>column name:CODIGO
> at
>com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSap
D
>B.java:1528)
> at
>com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.j
a
>va:224)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSap
D
>B.java:175)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.ja
v
>a:96)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:6
7
>2)
> at
>com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:347)
> at
>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(U
n
>known Source)
> at
>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Un
k
>nown Source)
> at
>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unk
n
>own Source)
> at
>org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
>Source)
> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
>Source)
> at
>org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
>Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unk
n
>own Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery
(
>Unknown Source)
> at
>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getByCriteria(GeneralBrokerI
m
>pl.java:299)
> at
>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getFirst(GeneralBrokerImpl.j
a
>va:149)
> at br.com.mgr.useCases.NavegavelUC.getFirst(NavegavelUC.java:108)
> at
>br.com.mgr.formularios.componentes.barraNavegacao.NavegacaoToolBar.setNaveg
a
>vel(NavegacaoToolBar.java:493)
> at
>br.com.mgr.plugins.pessoaFJ.PanelPessoaFJGenerico.<init>(PanelPessoaFJGener
i
>co.java:42)
> at
>br.com.mgr.plugins.pessoaFJ.PessoaFJPlugin.getSwingUI(PessoaFJPlugin.java:1
0
>6)
> at
>br.com.mgr.plugins.PluginManager.getSwingUI(PluginManager.java:74)
> at br.com.mgr.formularios.MainForm.openUrl(MainForm.java:194)
> at
>br.com.mgr.formularios.MainForm.actionPerformed(MainForm.java:190)
> at
>javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
> at
>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButt
o
>n.java:1839)
> at
>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:
4
>20)
> at
>javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
> at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
> at
>javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
> at
>javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basi
c
>MenuItemUI.java:943)
> at java.awt.Component.processMouseEvent(Component.java:5099)
> at java.awt.Component.processEvent(Component.java:4896)
> at java.awt.Container.processEvent(Container.java:1569)
> at java.awt.Component.dispatchEventImpl(Component.java:3614)
> at java.awt.Container.dispatchEventImpl(Container.java:1627)
> at java.awt.Component.dispatchEvent(Component.java:3476)
> at
>java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
> at
>java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
> at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
> at java.awt.Container.dispatchEventImpl(Container.java:1613)
> at java.awt.Window.dispatchEventImpl(Window.java:1606)
> at java.awt.Component.dispatchEvent(Component.java:3476)
> at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
> at
>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.j
a
>va:201)
> at
>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.jav
a
>:151)
> at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
> at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
> at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
>com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at 145): Unknown
>column name:CODIGO
> at
>com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSap
D
>B.java:1528)
> at
>com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.j
a
>va:224)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSap
D
>B.java:175)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.ja
v
>a:96)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:6
7
>2)
> at
>com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:347)
> at
>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(U
n
>known Source)
> at
>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Un
k
>nown Source)
> at
>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unk
n
>own Source)
> at
>org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
>Source)
> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
>Source)
> at
>org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
>Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unk
n
>own Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery
(
>Unknown Source)
> at
>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getByCriteria(GeneralBrokerI
m
>pl.java:299)
> at
>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getFirst(GeneralBrokerImpl.j
a
>va:149)
> at br.com.mgr.useCases.NavegavelUC.getFirst(NavegavelUC.java:108)
> at
>br.com.mgr.formularios.componentes.barraNavegacao.NavegacaoToolBar.setNaveg
a
>vel(NavegacaoToolBar.java:493)
> at
>br.com.mgr.plugins.pessoaFJ.PanelPessoaFJGenerico.<init>(PanelPessoaFJGener
i
>co.java:42)
> at
>br.com.mgr.plugins.pessoaFJ.PessoaFJPlugin.getSwingUI(PessoaFJPlugin.java:1
0
>6)
> at
>br.com.mgr.plugins.PluginManager.getSwingUI(PluginManager.java:74)
> at br.com.mgr.formularios.MainForm.openUrl(MainForm.java:194)
> at
>br.com.mgr.formularios.MainForm.actionPerformed(MainForm.java:190)
> at
>javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
> at
>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButt
o
>n.java:1839)
> at
>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:
4
>20)
> at
>javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
> at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
> at
>javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
> at
>javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basi
c
>MenuItemUI.java:943)
> at java.awt.Component.processMouseEvent(Component.java:5099)
> at java.awt.Component.processEvent(Component.java:4896)
> at java.awt.Container.processEvent(Container.java:1569)
> at java.awt.Component.dispatchEventImpl(Component.java:3614)
> at java.awt.Container.dispatchEventImpl(Container.java:1627)
> at java.awt.Component.dispatchEvent(Component.java:3476)
> at
>java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
> at
>java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
> at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
> at java.awt.Container.dispatchEventImpl(Container.java:1613)
> at java.awt.Window.dispatchEventImpl(Window.java:1606)
> at java.awt.Component.dispatchEvent(Component.java:3476)
> at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
> at
>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.j
a
>va:201)
> at
>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.jav
a
>:151)
> at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
> at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
> at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
>rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException: [-4005]
(at
>145): Unknown column name:CODIGO
> at
>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Un
k
>nown Source)
> at
>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unk
n
>own Source)
> at
>org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
>Source)
> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
>Source)
> at
>org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
>Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unk
n
>own Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkno
w
>n Source)
> at
>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery
(
>Unknown Source)
> at
>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getByCriteria(GeneralBrokerI
m
>pl.java:299)
> at
>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getFirst(GeneralBrokerImpl.j
a
>va:149)
> at br.com.mgr.useCases.NavegavelUC.getFirst(NavegavelUC.java:108)
> at
>br.com.mgr.formularios.componentes.barraNavegacao.NavegacaoToolBar.setNaveg
a
>vel(NavegacaoToolBar.java:493)
> at
>br.com.mgr.plugins.pessoaFJ.PanelPessoaFJGenerico.<init>(PanelPessoaFJGener
i
>co.java:42)
> at
>br.com.mgr.plugins.pessoaFJ.PessoaFJPlugin.getSwingUI(PessoaFJPlugin.java:1
0
>6)
> at
>br.com.mgr.plugins.PluginManager.getSwingUI(PluginManager.java:74)
> at br.com.mgr.formularios.MainForm.openUrl(MainForm.java:194)
> at
>br.com.mgr.formularios.MainForm.actionPerformed(MainForm.java:190)
> at
>javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
> at
>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButt
o
>n.java:1839)
> at
>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:
4
>20)
> at
>javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
> at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
> at
>javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
> at
>javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basi
c
>MenuItemUI.java:943)
> at java.awt.Component.processMouseEvent(Component.java:5099)
> at java.awt.Component.processEvent(Component.java:4896)
> at java.awt.Container.processEvent(Container.java:1569)
> at java.awt.Component.dispatchEventImpl(Component.java:3614)
> at java.awt.Container.dispatchEventImpl(Container.java:1627)
> at java.awt.Component.dispatchEvent(Component.java:3476)
> at
>java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
> at
>java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
> at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
> at java.awt.Container.dispatchEventImpl(Container.java:1613)
> at java.awt.Window.dispatchEventImpl(Window.java:1606)
> at java.awt.Component.dispatchEvent(Component.java:3476)
> at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
> at
>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.j
a
>va:201)
> at
>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.jav
a
>:151)
> at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
> at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
> at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
>Caused by: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at
>145): Unknown column name:CODIGO
> at
>com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSap
D
>B.java:1528)
> at
>com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.j
a
>va:224)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSap
D
>B.java:175)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.ja
v
>a:96)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:6
7
>2)
> at
>com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:347)
> at
>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(U
n
>known Source)
> ... 46 more
>[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR:
>PersistenceBrokerException during the execution of the query: [-4005] (at
>145): Unknown column name:CODIGO
>[-4005] (at 145): Unknown column name:CODIGO
>
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.476 / Virus Database: 273 - Release Date: 24/4/2003
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.476 / Virus Database: 273 - Release Date: 24/4/2003
Force Feeding OJB.properties / metadata*.xml, Tomcat/Cocoon
Posted by onno <on...@onnos.com>.
Hiya :)
we are trying to deploy our app using webstart but it can't find
OJB.properties nor any of the user.xml files
(they are inside the signed jar). We are aware of this problem before for
several other reason and hence
we use Rachel to load all such sources, however is it possible to 'start'
OJB with an InputStream specifically rather then it
looking for those files itself (ie Log4J for example in default can work
with Webstart neither).
Something like
(OJB).setProperties(InputStream x)
and later the same for the xml
(OJB).setMeta(InputStream x)
InputStream or String or anything really that we can 'feed' it ourselves.
(would be handy as well to
autogenerate parts of the code and even keep the files on the server)
Also we are having the same problems with PB: Borrow broker from pool
failed.
Reading through the docs / mail it seems we need to tell it to use a
ManagedPool, also how do we 'release' the broker (ie
we also have a servlet which gets created for each 'special' request which
creates a Broker , it does kill the connection but we think we need to
somehow give the broker back as well. Using a global Broker for the servlet
(acceptable in our case since
it will be used by 1 person only) threw quite a few errors, and Thomas also
said in an email that it is proper to do so - speed isn't crucial here,
stability is). In that same line we found that in JBoss several other
OJB.properties need to be adjusted , is this the same for Tomcat (with
Cocoon) ? Lots of simple Yes/No questions though :)
Re: Upgrading problem 1.0rc2 -> 1.0rc3
Posted by Jakob Braeuchi <jb...@gmx.ch>.
hi edson,
do you have an idea where the 'min' comes from ?
one problem i fount is that
'min( codigo )' will fail whereas 'min(codigo)' should work
hth
jakob
Edson Carlos Ericksson Richter wrote:
>After update from 1.0rc2 to 1.0rc3 I get bellow exception.
>Appear that my "column" attribute in field descriptor is not being
>recognized by ReportQueryByCriteria.
>
>My upgrade procedure:
>
>1) Unzip db-ojb-1.0.rc3 and put all /lib/*.jar in my classpath;
>2) Modified FieldDescriptor with FIX for setAccess problem;
>3) Used the new o.a.o.broker.util.collections.RemovalAwareList as collection
>descriptor;
>4) Overwrite my ojb.properties, repository.dtd and repository_internal.xml
>with new versions. Adjust ojb.properties to use PropertyImpl.
>
>The code is like
>
> String pkName = "codigo"; // CO_USUARIO field
> Criteria criteria = new Criteria();
> fieldsChave = new String [] { pkName }; // searches by CO_USUARIO
>field
> ReportQueryByCriteria rChave, rOrder;
>
> rChave = new ReportQueryByCriteria( this.clazz, fieldsChave, null );
> criteria.addIn( pkName, rChave );
>
> Collection all = getByCriteria( criteria );
>
>The Generated SQL (I've captured directly in SapDB JDBC Driver) code is:
>
>(SELECT A0.CO_USUARIO,A0.NO_USUARIO,A0.DS_USERNAME,A0.DS_PASSWORD FROM
>MGR.TB_USUARIO A0 WHERE A0.CO_USUARIO IN (SELECT min( codigo ) FROM
>MGR.TB_USUARIO A0)
>
>Can someone help-me?
>
>Thanks,
>
>Edson Richter
>
>[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: [-4005]
>(at 145): Unknown column name:CODIGO
>com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at 145): Unknown
>column name:CODIGO
> at
>com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapD
>B.java:1528)
> at
>com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.ja
>va:224)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapD
>B.java:175)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.jav
>a:96)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:67
>2)
> at
>com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:347)
> at
>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(Un
>known Source)
> at
>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Unk
>nown Source)
> at
>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unkn
>own Source)
> at
>org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
>Source)
> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
>Source)
> at
>org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
>Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
>own Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(
>Unknown Source)
> at
>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getByCriteria(GeneralBrokerIm
>pl.java:299)
> at
>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getFirst(GeneralBrokerImpl.ja
>va:149)
> at br.com.mgr.useCases.NavegavelUC.getFirst(NavegavelUC.java:108)
> at
>br.com.mgr.formularios.componentes.barraNavegacao.NavegacaoToolBar.setNavega
>vel(NavegacaoToolBar.java:493)
> at
>br.com.mgr.plugins.pessoaFJ.PanelPessoaFJGenerico.<init>(PanelPessoaFJGeneri
>co.java:42)
> at
>br.com.mgr.plugins.pessoaFJ.PessoaFJPlugin.getSwingUI(PessoaFJPlugin.java:10
>6)
> at
>br.com.mgr.plugins.PluginManager.getSwingUI(PluginManager.java:74)
> at br.com.mgr.formularios.MainForm.openUrl(MainForm.java:194)
> at
>br.com.mgr.formularios.MainForm.actionPerformed(MainForm.java:190)
> at
>javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
> at
>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButto
>n.java:1839)
> at
>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:4
>20)
> at
>javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
> at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
> at
>javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
> at
>javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basic
>MenuItemUI.java:943)
> at java.awt.Component.processMouseEvent(Component.java:5099)
> at java.awt.Component.processEvent(Component.java:4896)
> at java.awt.Container.processEvent(Container.java:1569)
> at java.awt.Component.dispatchEventImpl(Component.java:3614)
> at java.awt.Container.dispatchEventImpl(Container.java:1627)
> at java.awt.Component.dispatchEvent(Component.java:3476)
> at
>java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
> at
>java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
> at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
> at java.awt.Container.dispatchEventImpl(Container.java:1613)
> at java.awt.Window.dispatchEventImpl(Window.java:1606)
> at java.awt.Component.dispatchEvent(Component.java:3476)
> at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
> at
>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
>va:201)
> at
>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
>:151)
> at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
> at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
> at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
>com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at 145): Unknown
>column name:CODIGO
> at
>com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapD
>B.java:1528)
> at
>com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.ja
>va:224)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapD
>B.java:175)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.jav
>a:96)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:67
>2)
> at
>com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:347)
> at
>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(Un
>known Source)
> at
>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Unk
>nown Source)
> at
>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unkn
>own Source)
> at
>org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
>Source)
> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
>Source)
> at
>org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
>Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
>own Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(
>Unknown Source)
> at
>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getByCriteria(GeneralBrokerIm
>pl.java:299)
> at
>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getFirst(GeneralBrokerImpl.ja
>va:149)
> at br.com.mgr.useCases.NavegavelUC.getFirst(NavegavelUC.java:108)
> at
>br.com.mgr.formularios.componentes.barraNavegacao.NavegacaoToolBar.setNavega
>vel(NavegacaoToolBar.java:493)
> at
>br.com.mgr.plugins.pessoaFJ.PanelPessoaFJGenerico.<init>(PanelPessoaFJGeneri
>co.java:42)
> at
>br.com.mgr.plugins.pessoaFJ.PessoaFJPlugin.getSwingUI(PessoaFJPlugin.java:10
>6)
> at
>br.com.mgr.plugins.PluginManager.getSwingUI(PluginManager.java:74)
> at br.com.mgr.formularios.MainForm.openUrl(MainForm.java:194)
> at
>br.com.mgr.formularios.MainForm.actionPerformed(MainForm.java:190)
> at
>javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
> at
>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButto
>n.java:1839)
> at
>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:4
>20)
> at
>javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
> at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
> at
>javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
> at
>javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basic
>MenuItemUI.java:943)
> at java.awt.Component.processMouseEvent(Component.java:5099)
> at java.awt.Component.processEvent(Component.java:4896)
> at java.awt.Container.processEvent(Container.java:1569)
> at java.awt.Component.dispatchEventImpl(Component.java:3614)
> at java.awt.Container.dispatchEventImpl(Container.java:1627)
> at java.awt.Component.dispatchEvent(Component.java:3476)
> at
>java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
> at
>java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
> at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
> at java.awt.Container.dispatchEventImpl(Container.java:1613)
> at java.awt.Window.dispatchEventImpl(Window.java:1606)
> at java.awt.Component.dispatchEvent(Component.java:3476)
> at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
> at
>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
>va:201)
> at
>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
>:151)
> at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
> at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
> at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
>rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException: [-4005] (at
>145): Unknown column name:CODIGO
> at
>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Unk
>nown Source)
> at
>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unkn
>own Source)
> at
>org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
>Source)
> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
>Source)
> at
>org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
>Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
>own Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
>n Source)
> at
>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(
>Unknown Source)
> at
>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getByCriteria(GeneralBrokerIm
>pl.java:299)
> at
>br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getFirst(GeneralBrokerImpl.ja
>va:149)
> at br.com.mgr.useCases.NavegavelUC.getFirst(NavegavelUC.java:108)
> at
>br.com.mgr.formularios.componentes.barraNavegacao.NavegacaoToolBar.setNavega
>vel(NavegacaoToolBar.java:493)
> at
>br.com.mgr.plugins.pessoaFJ.PanelPessoaFJGenerico.<init>(PanelPessoaFJGeneri
>co.java:42)
> at
>br.com.mgr.plugins.pessoaFJ.PessoaFJPlugin.getSwingUI(PessoaFJPlugin.java:10
>6)
> at
>br.com.mgr.plugins.PluginManager.getSwingUI(PluginManager.java:74)
> at br.com.mgr.formularios.MainForm.openUrl(MainForm.java:194)
> at
>br.com.mgr.formularios.MainForm.actionPerformed(MainForm.java:190)
> at
>javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
> at
>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButto
>n.java:1839)
> at
>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:4
>20)
> at
>javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
> at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
> at
>javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
> at
>javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basic
>MenuItemUI.java:943)
> at java.awt.Component.processMouseEvent(Component.java:5099)
> at java.awt.Component.processEvent(Component.java:4896)
> at java.awt.Container.processEvent(Container.java:1569)
> at java.awt.Component.dispatchEventImpl(Component.java:3614)
> at java.awt.Container.dispatchEventImpl(Container.java:1627)
> at java.awt.Component.dispatchEvent(Component.java:3476)
> at
>java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
> at
>java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
> at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
> at java.awt.Container.dispatchEventImpl(Container.java:1613)
> at java.awt.Window.dispatchEventImpl(Window.java:1606)
> at java.awt.Component.dispatchEvent(Component.java:3476)
> at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
> at
>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
>va:201)
> at
>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
>:151)
> at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
> at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
> at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
>Caused by: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at
>145): Unknown column name:CODIGO
> at
>com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapD
>B.java:1528)
> at
>com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.ja
>va:224)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapD
>B.java:175)
> at
>com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.jav
>a:96)
> at
>com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:67
>2)
> at
>com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:347)
> at
>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(Un
>known Source)
> ... 46 more
>[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR:
>PersistenceBrokerException during the execution of the query: [-4005] (at
>145): Unknown column name:CODIGO
>[-4005] (at 145): Unknown column name:CODIGO
>
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.476 / Virus Database: 273 - Release Date: 24/4/2003
>
>
Upgrading problem 1.0rc2 -> 1.0rc3
Posted by Edson Carlos Ericksson Richter <ed...@mgrinformatica.com.br>.
After update from 1.0rc2 to 1.0rc3 I get bellow exception.
Appear that my "column" attribute in field descriptor is not being
recognized by ReportQueryByCriteria.
My upgrade procedure:
1) Unzip db-ojb-1.0.rc3 and put all /lib/*.jar in my classpath;
2) Modified FieldDescriptor with FIX for setAccess problem;
3) Used the new o.a.o.broker.util.collections.RemovalAwareList as collection
descriptor;
4) Overwrite my ojb.properties, repository.dtd and repository_internal.xml
with new versions. Adjust ojb.properties to use PropertyImpl.
The code is like
String pkName = "codigo"; // CO_USUARIO field
Criteria criteria = new Criteria();
fieldsChave = new String [] { pkName }; // searches by CO_USUARIO
field
ReportQueryByCriteria rChave, rOrder;
rChave = new ReportQueryByCriteria( this.clazz, fieldsChave, null );
criteria.addIn( pkName, rChave );
Collection all = getByCriteria( criteria );
The Generated SQL (I've captured directly in SapDB JDBC Driver) code is:
(SELECT A0.CO_USUARIO,A0.NO_USUARIO,A0.DS_USERNAME,A0.DS_PASSWORD FROM
MGR.TB_USUARIO A0 WHERE A0.CO_USUARIO IN (SELECT min( codigo ) FROM
MGR.TB_USUARIO A0)
Can someone help-me?
Thanks,
Edson Richter
[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: [-4005]
(at 145): Unknown column name:CODIGO
com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at 145): Unknown
column name:CODIGO
at
com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
at
com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
at
com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapD
B.java:1528)
at
com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.ja
va:224)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapD
B.java:175)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.jav
a:96)
at
com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:67
2)
at
com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:347)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(Un
known Source)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Unk
nown Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unkn
own Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
Source)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
own Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(
Unknown Source)
at
br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getByCriteria(GeneralBrokerIm
pl.java:299)
at
br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getFirst(GeneralBrokerImpl.ja
va:149)
at br.com.mgr.useCases.NavegavelUC.getFirst(NavegavelUC.java:108)
at
br.com.mgr.formularios.componentes.barraNavegacao.NavegacaoToolBar.setNavega
vel(NavegacaoToolBar.java:493)
at
br.com.mgr.plugins.pessoaFJ.PanelPessoaFJGenerico.<init>(PanelPessoaFJGeneri
co.java:42)
at
br.com.mgr.plugins.pessoaFJ.PessoaFJPlugin.getSwingUI(PessoaFJPlugin.java:10
6)
at
br.com.mgr.plugins.PluginManager.getSwingUI(PluginManager.java:74)
at br.com.mgr.formularios.MainForm.openUrl(MainForm.java:194)
at
br.com.mgr.formularios.MainForm.actionPerformed(MainForm.java:190)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButto
n.java:1839)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:4
20)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
at
javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
at
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basic
MenuItemUI.java:943)
at java.awt.Component.processMouseEvent(Component.java:5099)
at java.awt.Component.processEvent(Component.java:4896)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3614)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3476)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3476)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
va:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
:151)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at 145): Unknown
column name:CODIGO
at
com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
at
com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
at
com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapD
B.java:1528)
at
com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.ja
va:224)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapD
B.java:175)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.jav
a:96)
at
com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:67
2)
at
com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:347)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(Un
known Source)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Unk
nown Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unkn
own Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
Source)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
own Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(
Unknown Source)
at
br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getByCriteria(GeneralBrokerIm
pl.java:299)
at
br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getFirst(GeneralBrokerImpl.ja
va:149)
at br.com.mgr.useCases.NavegavelUC.getFirst(NavegavelUC.java:108)
at
br.com.mgr.formularios.componentes.barraNavegacao.NavegacaoToolBar.setNavega
vel(NavegacaoToolBar.java:493)
at
br.com.mgr.plugins.pessoaFJ.PanelPessoaFJGenerico.<init>(PanelPessoaFJGeneri
co.java:42)
at
br.com.mgr.plugins.pessoaFJ.PessoaFJPlugin.getSwingUI(PessoaFJPlugin.java:10
6)
at
br.com.mgr.plugins.PluginManager.getSwingUI(PluginManager.java:74)
at br.com.mgr.formularios.MainForm.openUrl(MainForm.java:194)
at
br.com.mgr.formularios.MainForm.actionPerformed(MainForm.java:190)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButto
n.java:1839)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:4
20)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
at
javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
at
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basic
MenuItemUI.java:943)
at java.awt.Component.processMouseEvent(Component.java:5099)
at java.awt.Component.processEvent(Component.java:4896)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3614)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3476)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3476)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
va:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
:151)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException: [-4005] (at
145): Unknown column name:CODIGO
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Unk
nown Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unkn
own Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
Source)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
own Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(
Unknown Source)
at
br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getByCriteria(GeneralBrokerIm
pl.java:299)
at
br.com.mgr.brokers.ojbBroker.GeneralBrokerImpl.getFirst(GeneralBrokerImpl.ja
va:149)
at br.com.mgr.useCases.NavegavelUC.getFirst(NavegavelUC.java:108)
at
br.com.mgr.formularios.componentes.barraNavegacao.NavegacaoToolBar.setNavega
vel(NavegacaoToolBar.java:493)
at
br.com.mgr.plugins.pessoaFJ.PanelPessoaFJGenerico.<init>(PanelPessoaFJGeneri
co.java:42)
at
br.com.mgr.plugins.pessoaFJ.PessoaFJPlugin.getSwingUI(PessoaFJPlugin.java:10
6)
at
br.com.mgr.plugins.PluginManager.getSwingUI(PluginManager.java:74)
at br.com.mgr.formularios.MainForm.openUrl(MainForm.java:194)
at
br.com.mgr.formularios.MainForm.actionPerformed(MainForm.java:190)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButto
n.java:1839)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:4
20)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
at
javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
at
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Basic
MenuItemUI.java:943)
at java.awt.Component.processMouseEvent(Component.java:5099)
at java.awt.Component.processEvent(Component.java:4896)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3614)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3476)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3476)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
va:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
:151)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
Caused by: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4005] (at
145): Unknown column name:CODIGO
at
com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
at
com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
at
com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapD
B.java:1528)
at
com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.ja
va:224)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapD
B.java:175)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.jav
a:96)
at
com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:67
2)
at
com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:347)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(Un
known Source)
... 46 more
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR:
PersistenceBrokerException during the execution of the query: [-4005] (at
145): Unknown column name:CODIGO
[-4005] (at 145): Unknown column name:CODIGO
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.476 / Virus Database: 273 - Release Date: 24/4/2003