This is because those tables are used for insertion only. /Dave
Sorry I can't give anymore insight to this. >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 14:10:09 -0400 > >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]> _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
