This raises a good question. What if I need to connect to three different databases. Do I need to create an instance of the internal tables in each of these databases?
-Jeff > -----Original Message----- > From: Ujwal Oswal [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 09, 2002 12:50 PM > To: 'OJB Users List' > Subject: RE: OJB- ODMG Help > > > 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.AbstractPoolableConnectionF > actory] 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(AS400JDB > CStatement.jav > a:903) > at > com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JD > BCPreparedStat > ement.java:186) > at > com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS40 > 0JDBCConnectio > n.java:1166) > at > org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepa > reStatement(Un > known Source) > at > org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getSe > lectByPKStmt(U > nknown Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getSelectBy > PKStatement(Un > known Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccess.materializeObject(Unknown > Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObje > ct(Unknown > Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObject > ByIdentity(Unk > nown Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObject > ByExample(Unkn > own Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObject > ByQuery(Unknow > n Source) > at > org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextS > equence(Unknow > n Source) > at > org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl.ge > tUniqueId(Unkn > own Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getUnique > Id(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.getCollec > tionByQuery(Un > known Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuery(Un > known Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuery(Un > 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.getSelectBy > PKStatement(Un > known Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccess.materializeObject(Unknown > Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObje > ct(Unknown > Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObject > ByIdentity(Unk > nown Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObject > ByExample(Unkn > own Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObject > ByQuery(Unknow > n Source) > at > org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextS > equence(Unknow > n Source) > at > org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl.ge > tUniqueId(Unkn > own Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getUnique > Id(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.getCollec > tionByQuery(Un > known Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuery(Un > known Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuery(Un > 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.getSelectBy > PKStatement(Un > known Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccess.materializeObject(Unknown > Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObje > ct(Unknown > Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObject > ByIdentity(Unk > nown Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObject > ByExample(Unkn > own Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObject > ByQuery(Unknow > n Source) > at > org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextS > equence(Unknow > n Source) > at > org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl.ge > tUniqueId(Unkn > own Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getUnique > Id(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.getCollec > tionByQuery(Un > known Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuery(Un > known Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuery(Un > 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]> > > > >
