Strange. I haven;t created any internal tables even for Persistent broker but I was able to perform queries get data etc.
uo -----Original Message----- From: David Raphael [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 2:03 PM To: [EMAIL PROTECTED] Subject: RE: OJB- ODMG Help Yes, the internal 8 tables need to be there for ODMG. If just PB than I believe you only need 2 tables. It is in the documentation. http://jakarta.apache.org/ojb/platforms.html Since OJB only supports one database connection per broker *right now, you have to use one database instance for everything (at least per broker). I hope that I am accurate on this, correct me if I am wrong. Cheers, David >From: Ujwal Oswal <[EMAIL PROTECTED]> >Reply-To: "OJB Users List" <[EMAIL PROTECTED]> >To: 'OJB Users List' <[EMAIL PROTECTED]> >Subject: RE: OJB- ODMG Help >Date: Mon, 9 Sep 2002 12:49:44 -0400 > >Should the Internal OJB tables be in your database. I am using existing >table from our database for performing queries. I havent created any >internal tables. > >uo > >-----Original Message----- >From: Matthew Baird [mailto:[EMAIL PROTECTED]] >Sent: Monday, September 09, 2002 12:20 PM >To: OJB Users List >Subject: RE: OJB- ODMG Help > > >you probably didn't put the OJB core schema tables into your database. I >noticed, after Armin's refactoring, that even though I don't use the >sequence managers at all it still tries to get some sequences. I haven't >really had time to look into this issue yet. > >m > >-----Original Message----- >From: Ujwal Oswal [mailto:[EMAIL PROTECTED]] >Sent: Mon 9/9/2002 9:16 AM >To: 'OJB Users List' >Cc: >Subject: RE: OJB- ODMG Help > > > >Here it is. > > > >BOOT] INFO: OJB.properties: file:/C:/eclipse/workspace/OJB/OJB.properties ><file:/C:/eclipse/workspace/OJB/OJB.properties> >[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: >Already >created persistence broker instances: 0 >[org.apache.ojb.broker.util.sequence.SequenceManagerFactory] INFO: Use >sequence manager class: class >org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl >Now Running @@@@@@@@@@@ >[org.apache.ojb.broker.accesslayer.AbstractPoolableConnectionFactory] INFO: ># Create connection pool for JdbcDescriptorKey 669007219 # >[org.apache.ojb.broker.accesslayer.AbstractConnectionFactory] INFO: # >Already created connections: 1 returning : S103273D >[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: >Already >created persistence broker instances: 1 >[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: >Already >created persistence broker instances: 2 >[org.apache.ojb.broker.accesslayer.AbstractConnectionFactory] INFO: # >Already created connections: 2 returning : S103273D >[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: >Already >created persistence broker instances: 3 >[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: [SQL0204] >OJB_HL_SEQ in TSL50LIBXS type *FILE not found. >java.sql.SQLException: [SQL0204] OJB_HL_SEQ in TSL50LIBXS type *FILE not >found. > at >com.ibm.as400.access.JDError.throwSQLException(JDError.java:351) > at >com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.ja v >a:903) > at >com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedSta t >ement.java:186) > at >com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnecti o >n.java:1166) > at >org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(U n >known Source) > at >org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getSelectByPKStmt( U >nknown Source) > at >org.apache.ojb.broker.accesslayer.StatementManager.getSelectByPKStatement(U n >known Source) > at >org.apache.ojb.broker.accesslayer.JdbcAccess.materializeObject(Unknown >Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(Unknown >Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(Un k >nown Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByExample(Unk n >own Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery(Unkno w >n Source) > at >org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextSequence(Unkno w >n Source) > at >org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl.getUniqueId(Unk n >own Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getUniqueId(Unknown >Source) > at org.apache.ojb.odmg.collections.DListImpl.generateNewId(Unknown >Source) > at org.apache.ojb.odmg.collections.DListImpl.<init>(Unknown >Source) > at java.lang.Class.newInstance0(Native Method) > at java.lang.Class.newInstance(Unknown Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(U n >known Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(U n >known Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(U n >known Source) > at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) > at test.odmg.TestOdmg.showUsers(TestOdmg.java:123) > at test.odmg.TestOdmg.main(TestOdmg.java:100) >[org.apache.ojb.broker.accesslayer.JdbcAccess] ERROR: >PersistenceBrokerException during the execution of materializeObject: null >null >org.apache.ojb.broker.PersistenceBrokerSQLException > at >org.apache.ojb.broker.accesslayer.StatementManager.getSelectByPKStatement(U n >known Source) > at >org.apache.ojb.broker.accesslayer.JdbcAccess.materializeObject(Unknown >Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(Unknown >Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(Un k >nown Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByExample(Unk n >own Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery(Unkno w >n Source) > at >org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextSequence(Unkno w >n Source) > at >org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl.getUniqueId(Unk n >own Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getUniqueId(Unknown >Source) > at org.apache.ojb.odmg.collections.DListImpl.generateNewId(Unknown >Source) > at org.apache.ojb.odmg.collections.DListImpl.<init>(Unknown >Source) > at java.lang.Class.newInstance0(Native Method) > at java.lang.Class.newInstance(Unknown Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(U n >known Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(U n >known Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(U n >known Source) > at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) > at test.odmg.TestOdmg.showUsers(TestOdmg.java:123) > at test.odmg.TestOdmg.main(TestOdmg.java:100) >[org.apache.ojb.broker.util.sequence.SequenceGenerator] ERROR: Can not get >next org.apache.ojb.broker.util.sequence.HighLowSequence for next scope of >keys >null >org.apache.ojb.broker.PersistenceBrokerSQLException > at >org.apache.ojb.broker.accesslayer.StatementManager.getSelectByPKStatement(U n >known Source) > at >org.apache.ojb.broker.accesslayer.JdbcAccess.materializeObject(Unknown >Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(Unknown >Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(Un k >nown Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByExample(Unk n >own Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery(Unkno w >n Source) > at >org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextSequence(Unkno w >n Source) > at >org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl.getUniqueId(Unk n >own Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getUniqueId(Unknown >Source) > at org.apache.ojb.odmg.collections.DListImpl.generateNewId(Unknown >Source) > at org.apache.ojb.odmg.collections.DListImpl.<init>(Unknown >Source) > at java.lang.Class.newInstance0(Native Method) > at java.lang.Class.newInstance(Unknown Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(U n >known Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(U n >known Source) > at >org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(U n >known Source) > at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) > at test.odmg.TestOdmg.showUsers(TestOdmg.java:123) > at test.odmg.TestOdmg.main(TestOdmg.java:100) > >-----Original Message----- >From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] ><mailto:[EMAIL PROTECTED]> ] >Sent: Monday, September 09, 2002 12:00 PM >To: OJB Users List >Subject: Re: OJB- ODMG Help > > >Could you post the stack trace. > >Armin >----- Original Message ----- >From: "Ujwal Oswal" <[EMAIL PROTECTED]> >To: "'OJB Users List'" <[EMAIL PROTECTED]> >Sent: Monday, September 09, 2002 5:49 PM >Subject: RE: OJB- ODMG Help > > > > My Null Pointer exception is gone after I commented all the AWT code. > > The new problem I am having is It says "File not found" when I execute >the > > query. > > > > How do I check what query is being fired. > > > > tks > > ujwal > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] ><mailto:[EMAIL PROTECTED]> ] > > Sent: Monday, September 09, 2002 11:02 AM > > To: OJB Users List > > Subject: Re: OJB- ODMG Help > > > > > > Everything seems OK. > > Try: Open a new database on every method call and close it after use. > > See below. > > This 'strange' behaviour (Charles explain) will be fixed with the next > > version of OJB. > > > > regards, > > Armin > > > > > [org.apache.ojb.odmg.TransactionImpl] WARN: TransactionImpl created > > with > > > null DatabaseImpl. > > > > Transaction found no opened database. > > > > > public class TestOdmg extends Frame implements ActionListener > > > { > > > private Implementation odmg = null; > > > private Vector useCases; > > > private static String databaseName; > > > private TextArea textarea; > > > private Button exit; > > > private MenuBar menubar = null; > > > private Menu menu = null; > > > private MenuItem newUser = null; > > > private MenuItem showUser = null; > > > private MenuItem exitApp = null; > > > > > > static > > > { > > > try > > > { > > > databaseName = > > > ((PersistenceBrokerConfiguration) > > PersistenceBrokerFactory > > > .getConfigurator() > > > .getConfigurationFor(null)) > > > .getRepositoryFilename(); > > > } > > > catch (ConfigurationException e) > > > { > > > databaseName = "repository.xml"; > > > } > > > > > > } > > > > > > public TestOdmg() > > > { > > > textarea = new TextArea(); > > > exit = new Button ("Exit"); > > > exit.addActionListener(this); > > > menubar = new MenuBar(); > > > menu = new Menu("User"); > > > newUser = new MenuItem ("New User"); > > > newUser.addActionListener(this); > > > showUser = new MenuItem ("Show User"); > > > showUser.addActionListener(this); > > > exitApp = new MenuItem ("Exit"); > > > exitApp.addActionListener(this); > > > > > > odmg = OJB.getInstance(); > > > Database db = odmg.newDatabase(); > > > file://open <file://open> database > > > try > > > { > > > db.open(databaseName, Database.OPEN_READ_WRITE); > > > } > > > catch (ODMGException ex) > > > { > > > ex.printStackTrace(); > > > } > > > > > > menu.add(newUser); > > > menu.add(showUser); > > > menu.add(exitApp); > > > menubar.add(menu); > > > setMenuBar(menubar); > > > add(textarea,"Center"); > > > add(exit, "South"); > > > > > > setSize(400,400); > > > this.show(); > > > } > > > > > > public static void main(String[] args) > > > { > > > TestOdmg app = new TestOdmg(); > > > } > > > > > > private void showUsers() > > > { > > > User user = null; > > > System.out.println("Now Running @@@@@@@@@@@"); > > > int total = 0; > > > > > > try > > > { > > // open new DB > > #### Database db = odmg.newDatabase(); > > db.open(...); > > > // 1. open a transaction > > > Transaction tx = odmg.newTransaction(); > > > tx.begin(); > > > > > > // 2. get an OQLQuery object from the ODMG facade > > > OQLQuery query = odmg.newOQLQuery(); > > > > > > // 3. set the OQL select statement > > > query.create("select allusers from " + > > User.class.getName()); > > > > > > // 4. perform the query and store the result in a > > persistent > > > Collection > > > DList allUsers = (DList) query.execute(); > > > tx.commit(); > > > > > > // 5. now iterate over the result to print each product > > > java.util.Iterator iter = allUsers.iterator(); > > > > > > while (iter.hasNext()) > > > { > > > total++; > > > user = (User) iter.next(); > > > textarea.appendText("User Id : "+user.getUserId()+ " > > User > > > Name "+ user.getUserName ()); > > > textarea.append("\n"); > > > } > > > > > > textarea.appendText("Total Users : "+ total); > > > } > > > catch (Throwable t) > > > { > > > t.printStackTrace(); > > > } > > finally > > { > > // close on every call > > ### db.close(); > > } > > > > > } > > > > > > public void actionPerformed (ActionEvent ae) { > > > if (ae.getSource() instanceof Button) { > > > System.exit(0);; > > > } > > > else if (ae.getSource() instanceof MenuItem) { > > > if ("New User".equals(ae.getActionCommand())) { > > > System.out.println ("New User"); > > > // AddUser adduser = new AddUser(this,broker); > > > // adduser.show(); > > > } > > > else if ("Show User".equals(ae.getActionCommand())) > > > { > > > showUsers(); > > > } > > > else if ("Exit".equals(ae.getActionCommand())) { > > > System.exit(0);; > > > } > > > } > > > } > > > } > > > > > > Ujwal > > > > > > > > > > > > -- > > To unsubscribe, e-mail: >< mailto:[EMAIL PROTECTED] ><mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: >< mailto:[EMAIL PROTECTED] ><mailto:[EMAIL PROTECTED]> > > > > > >-- >To unsubscribe, e-mail: < mailto:[EMAIL PROTECTED] ><mailto:[EMAIL PROTECTED]> > >For additional commands, e-mail: < mailto:[EMAIL PROTECTED] ><mailto:[EMAIL PROTECTED]> > > > _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
