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
[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.jav
a:903)
at
com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStat
ement.java:186)
at
com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnectio
n.java:1166)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(Un
known Source)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getSelectByPKStmt(U
nknown Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.getSelectByPKStatement(Un
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(Unk
nown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByExample(Unkn
own Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery(Unknow
n Source)
at
org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextSequence(Unknow
n Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl.getUniqueId(Unkn
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(Un
known Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(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.getSelectByPKStatement(Un
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(Unk
nown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByExample(Unkn
own Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery(Unknow
n Source)
at
org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextSequence(Unknow
n Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl.getUniqueId(Unkn
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(Un
known Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(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.getSelectByPKStatement(Un
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(Unk
nown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByExample(Unkn
own Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery(Unknow
n Source)
at
org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextSequence(Unknow
n Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl.getUniqueId(Unkn
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(Un
known Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
known Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(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]]
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]]
> 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 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]>
> For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
<<winmail.dat>>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
