Re: Newbie (almost) at a standstill

Fri, 02 Apr 2004 04:06:30 -0800

repository.xml wasn't copied in rc5, was a problem, has been fixed in rc6. If you want to patch manually, change the ant copy in build.xml to copy respositor*.xml instead of repository_*.xml =)

DB profiles are not copied on purpose, you need to copy the relevant settings into build.properties yourself. The build.properties contains all of the variables -- including jcdAlias and jdbcRuntimeDriver (in build.properties they are "default" and "org.hsqldb.jdbcDriver" respectively). You can C&P the properties out of profiles if you want to. I deemed that copying all the profiles over was overkill as ojb-blank is supposed to try to be minimal to help people get started.

The setting of the variables in repositor*.xml is done via ant property substitution from the values in build.properties.

-Brian

On Apr 2, 2004, at 6:19 AM, [EMAIL PROTECTED] wrote:

A status report on my problems.

I went back to square one and managed to get things to work. However, in
the process I found some glitches. Maybe they are finger trouble on my
part, maybe they are omissions in the code or the documentation.


1. The variable ${jcdAlias} is used in repository_database.xml, but
nothing sets it. I also cannot find where it is picked up from.
2. Repository.xml is not included in obj-blank.jar
3. The various DB profiles are not included in ojb-blank.jar
4. JdbcRuntimeDriver has to be added to build.properties before doing
the ant build step.

I now have PB working, but I cannot get ODMG to work. I am using rc5 and
keep getting NPEs from query.create(), sometimes with associated syntax
'errors'. My table already exists and contains about 6M rows. The code,
which is intended merely to verify basic connectivity, is below


select betid from Entity => NPE with no other diagnostic
select count(*) from Entity => NPE with 'unxexpected token "(" found,
expected "from"'
select betid as b from entity => NPE with 'unexpected token "as" ...'
select betid b from Entity => NPE with 'unexpected token "b" ...'

/*
 * Created on 31-Mar-04
 * CVS version $Header:$
 */
package com.gsk;

import junit.framework.TestCase;

import org.apache.ojb.broker.PersistenceBroker;
import org.apache.ojb.broker.PersistenceBrokerFactory;
import org.apache.ojb.broker.query.Criteria;
import org.apache.ojb.broker.query.Query;
import org.apache.ojb.broker.query.QueryByCriteria;
import org.apache.ojb.odmg.OJB;
import org.odmg.Database;
import org.odmg.Implementation;
import org.odmg.OQLQuery;

/**
 * @author rxm1676
 * @company GSK
 */
public class EntityTest extends TestCase {
      PersistenceBroker broker = null;
      Implementation odmg = null;
      Database db = null;
      /**
       * Constructor for EntityTest.
       * @param arg0
       */
      public EntityTest(String arg0) {
            super(arg0);
      }

/*
* @see TestCase#setUp()
*/
protected void setUp() throws Exception {
super.setUp();
broker = PersistenceBrokerFactory.defaultPersistenceBroker();
odmg = OJB.getInstance();
db = odmg.newDatabase();
db.open("default", Database.OPEN_READ_WRITE);
}

      /*
       * @see TestCase#tearDown()
       */
      protected void tearDown() throws Exception {
            super.tearDown();
            if (broker != null) {
                  broker.close();
                  broker = null;
            }
            if (db != null) {
                  db.close();
                  db = null;
            }
      }

/**
 * Establishes a connection to the DB and counts the number
 * of items in the Entity table using the PB
 *
 */
public void estPBConnection()
{
      Criteria c = new Criteria();
      Query q = new QueryByCriteria(Entity.class, c);
      int count = broker.getCount(q);
      System.out.println("Count: "+String.valueOf(count));
}

/**
* Basic test on the ODMG interface.
*
*/
public void testODMG()
{
try {
OQLQuery query = odmg.newOQLQuery();
if (query==null) {
System.err.println("newOQLQuery() returned null");
fail();
}
query.create("select betid from Entity where betid<5");
Object obj = query.execute();
System.out.println("Class of the result is "+obj.getClass());
} catch (Exception e) {
System.err.println("Caught exception"+e);
e.printStackTrace();
fail();
}

}
}




|---------+---------------------------->
|         |           "Armin Waibel"   |
|         |           <[EMAIL PROTECTED]|
|         |           g>               |
|         |                            |
|         |                            |
|         |           30-Mar-2004 11:18|
|         |           Please respond to|
|         |           "OJB Users List" |
|         |           <[EMAIL PROTECTED]|
|         |           he.org>          |
|         |                            |
|---------+---------------------------->
---------------------------------------------------------------------- ---------------------------------------------------|
| |
| |
| |
| To: "OJB Users List" <[EMAIL PROTECTED]> |
| |
| cc: |
| Subject: Re: Newbie at a standstill |
---------------------------------------------------------------------- ---------------------------------------------------|



Hi Raphael,

from your stack trace I can see you manipulate many of the default jdbc
settings:

Caused by: org.apache.ojb.broker.accesslayer.LookupException: Could not 
borrow connection from pool -
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor:
[EMAIL PROTECTED]
  jcd-alias=BETConnection
  default-connection=true
  dbms=oracle
  jdbc-level=2.0
  driver=oracle.jdbc.driver.OracleDriver
  protocol=jdbc
  sub-protocol=oracle:thin
  [EMAIL PROTECTED]:1521:TOOLS
  user=bet
  password=*****
  eager-release=true

only set true in JBoss <3.2.2 (but recommended to use 3.2.2 or higher)


  ConnectionPoolDescriptor={whenExhaustedAction=2, validationQuery=a
query,

OJB try to perform a validation query "a query", this will fail (not SQL
compatible ;-)). Maybe this is the problem you have.


maxIdle=2, maxActive=1, maxWait=3, removeAbandoned=true,
numTestsPerEvictionRun=5, testWhileIdle=true,
minEvictableIdleTimeMillis=4,
testOnReturn=true, logAbandoned=true, removeAbandonedTimeout=8,
timeBetweenEvictionRunsMillis=6, testOnBorrow=true}


again, I recommend to use default settings first and only change
settings step by step.


batchMode=true 

I recommend to set batch-mode false to avoid side-effects. You can try
to enable it when all stuff is working fine.


useAutoCommit=AUTO_COMMIT_IGNORE_STATE 

Again default is '1', you set '0'. But in managed enviroments you need
to set '0'. Do you try to run OJB in a managed environment? This
wouldn't be a good starting point for a newbie ;-)

ahh, now I see in your repository_database.xml what you have done. You
picked up a jdbc-connection-descriptor used for junit testing and set
you DB properties. This will not work, because the used properties don't
be valid.

Did you see

http://db.apache.org/ojb/getting-started.html

http://db.apache.org/ojb/platforms.html

As Brian said before, recommended to use this way first to setup your
environment. In build.properties you can set your DB. In the profiles
directory you can find "templates" for all supported databases. Pick the
oracle file and set your properties.

regards,
Armin

ignoreAutoCommitExceptions=true

[EMAIL PROTECTED] wrote:
I have done the 'ant build' and it makes no difference. If in the db.open
()
I change to the "default" db alias the system appears not to see my
parameters at all. It has username and password set to null. There is
clearly something terribly obvious that I am just not understanding about
setting up OJB.

[org.apache.ojb.odmg.DatabaseImpl] ERROR: Open database failed: Borrow
broker from pool failed, using PBKey org.apache.ojb.broker.PBKey:
jcdAlias=default, user=null, password=null
Borrow broker from pool failed, using PBKey org.apache.ojb.broker.PBKey:
jcdAlias=default, user=null, password=null
org.apache.ojb.broker.PBFactoryException: Borrow broker from pool failed,
using PBKey org.apache.ojb.broker.PBKey: jcdAlias=default, user=null,
password=null
at

org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPe rsistenceBroker(Unknown


Source)
      at

org.apache.ojb.broker.PersistenceBrokerFactory.createPersistenceBroker( Unknown


Source)
      at org.apache.ojb.odmg.DatabaseImpl.open(Unknown Source)
      at com.gsk.bet.ConnectionTest.setUp(ConnectionTest.java:33)

As a background, I should explain that I am reasonably familiar with
Torque. I am in the process of evaluating whether to go with OJB, which
seems on paper to have some advantages over Torque, or whether to use
Torque also for this project. I really want database independence, so I
would prefer to use OJB.





|---------+--------------------------------->
|         |           "Brian McCallister"   |
|         |           <[EMAIL PROTECTED]|
|         |           ompany.com>           |
|         |                                 |
|         |                                 |
|         |           29-Mar-2004 17:34     |
|         |           Please respond to "OJB|
|         |           Users List"           |
|         |           <[EMAIL PROTECTED]|
|         |           g>                    |
|         |                                 |
|---------+--------------------------------->

----------------------------------------------------------------------- --------------------------------------------------|

|
|
|
|
|
|
| To: "OJB Users List" <[EMAIL PROTECTED]>
|
|
|
| cc:
|
| Subject: Re: Newbie at a standstill
|

----------------------------------------------------------------------- --------------------------------------------------|




Are you using the ant build? The ojb-blank project template does a
property replace in the build -- the required database information is
in the build.properties and is copied into the generated
repository_database.xml that goes in build/ when compilation is run.

-Brian

On Mar 29, 2004, at 11:24 AM, [EMAIL PROTECTED] wrote:


I am trying to get OJB working and am getting absolutely nowhere, so I
appeal to the list for some help.

The environment is OJB rc5, Eclipse IDE, Sun JDK1.4.2, Oracle 9,
NT4.0. The
running of the code is controlled by JUnit.

I can connect to the DB both with sqlplus and jdbc. I cannot actually
get
OJB to connect. Clearly I am missing something, but I cannot discover
what.
By fiddling around  with the XML I can generate various sorts of
errors. In
all cases the url that the system is using appears to be entirely
palusible.

Here are the code, the repository_database.xml and the output:

Code:

/*
* Created on 26-Mar-2004
* CVS version $Header:$
*/
package com.gsk.bet;

import java.util.*;
import java.sql.*;
import junit.framework.*;
import org.apache.ojb.broker.*;
import org.apache.ojb.broker.query.*;
import org.odmg.*;
import org.apache.ojb.odmg.*;
import com.gsk.bet.Entity;
/**
* @author rxm1676
* @company GSK
*/
public class ConnectionTest extends TestCase {
     PersistenceBroker broker;
     Database db = null;
     Implementation odmg = null;

public void setUp() {

           try {
                 Class c =
Class.forName("oracle.jdbc.driver.OracleDriver"
);
                 broker =
PersistenceBrokerFactory.defaultPersistenceBroker();
                 odmg = OJB.getInstance();
                 db = odmg.newDatabase();
                 db.open("BETConnection", Database.OPEN_READ_WRITE);
           } catch (Exception ex) {
                 System.out.println(ex);
           }

}

     public void tearDown() {
           if (broker != null) {
                 broker.close();
           }
           if (db != null) {
                 try {
                       db.close();
                 } catch (ODMGException ex2) {
                 }
           }

}

     /**
      * Null test. Just checks that OJB is properly installed, that
it can
see both the
      * XML and the bean classes, and that we can get a Broker and an
ODMG
instance.
      *
      */
     public void testConnection() {
     }


/**
* Ensure that we can actually talk to the DB from this machine
*
*/
public void testRawJDBC()
{
  try {
     Connection con = DriverManager.getConnection
     ("jdbc:oracle:thin:@ukt01368.ggr.co.uk:1521:TOOLS", "bet",
"xxxx");
     PreparedStatement sth = con.prepareStatement("select * from
entity
where betid<10");
     ResultSet res = sth.executeQuery();
     System.out.println("Excuted raw query");
     while (res.next()) {
           Entity ent = new Entity();
           ent.setBetid(res.getInt("BETID"));
           ent.setEntityType(res.getString("ENTITYTYPE"));
           ent.setDescriptor(res.getString("DESCRIPTOR"));
           System.out.println("raw retrieval of "+ent);
     }
     res.close();
     con.close();
  } catch (Exception e) {
     System.out.println("Caught raw exception " + e);
 }
}
     /**
      *
      * @author rxm1676
      * @company GSK
      */
     public void testODMGFetchSingle() {
           Transaction tx = odmg.newTransaction();
           try {

                 OQLQuery query = odmg.newOQLQuery();
                 query.create(
                       "select betid, entityType, descriptor from " +
                       Entity.class.getName() + " where betid = 1");
                 DList results = (DList)query.execute();
                 for (Iterator iter = results.iterator();
iter.hasNext();)
{
                       tx.begin();
                       Entity res = (Entity)iter.next();
                       System.out.println("Retrieved " + res);
                       tx.commit();
                 }
           } catch (QueryInvalidException qie) {
                 System.out.println(qie);
                 tx.abort();
           } catch (QueryException qe) {
                 System.out.println(qe);
                 tx.abort();
           }

}

     /**
      * Retrieve a single object using the PersistenceBroker
      * @author rxm1676
      * @company GSK
      */
     public void testPBFetchSingle()
     {
           Entity example = new Entity();
           example.setBetid(1);
           Query  q = QueryFactory.newQueryByExample(example);
           Entity res = (Entity)broker.getObjectByQuery(q);
           System.out.println("PB fetched "+res);
     }
}

Database_repopsitory.xml

<!-- @version $Id: repository_database.xml,v 1.17 2003/11/27 16:42:12


arminw Exp $ -->

<!--
Define here all used connections.
One defined connection should be defined as the default one,
by set default-connection="true" - this could be done at runtime too.

It is possible to set user/password at
runtime or let login different users at runtime using the same
database. Use different PBKey with same jcdAlias name but
different user/password.

Ditto it is possible to add jdbc-connection-descriptor at runtime
using the MetadataManager.
-->

   <!-- this connection was used as the default one within OJB -->
   <jdbc-connection-descriptor
           jcd-alias="@JCD_ALIAS@"
           default-connection="false"
           platform="@DBMS_NAME@"
           jdbc-level="@JDBC_LEVEL@"
           driver="@DRIVER_NAME@"
           protocol="@URL_PROTOCOL@"
           subprotocol="@URL_SUBPROTOCOL@"
           dbalias="@URL_DBALIAS@"
           username="@USER_NAME@"
           password="@USER_PASSWD@"
       eager-release="false"
           batch-mode="false"
       useAutoCommit="1"
       ignoreAutoCommitExceptions="false"

       <connection-pool
           maxActive="21"
           validationQuery="" />

<sequence-manager className
="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
<attribute attribute-name="grabSize" attribute-value="20"/>
<attribute attribute-name="autoNaming"
attribute-value="true"/>
<attribute attribute-name="globalSequenceId"
attribute-value
="false"/>
<attribute attribute-name="globalSequenceStart"
attribute-value
="10000"/>
</sequence-manager>
</jdbc-connection-descriptor>

  <!-- Datasource example -->
   <!-- jdbc-connection-descriptor
       jcd-alias="default"



default-connection="false"

platform="Hsqldb"



jdbc-level="2.0"

jndi-datasource-name="java:DefaultDS"


username="sa"

           password=""
           eager-release
="false" 
       batch-mode="false"
       useAutoCommit="0"



ignoreAutoCommitExceptions="false" 

       <sequence-manager className
="org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl">


<attribute attribute-name="autoNaming"

attribute-value="true"/>


</sequence-manager>

</jdbc-connection-descriptor -->



   <!--
       NOTE: This is a test descriptor used within
       the junit test suite, do not change any value.
       A test db connections used for junit tests.
       This connection matches a hsql database called 'OJB_FarAway'
       If you do not use the test suite, you could delete
       this descriptor.
       This descriptor was used to check multiple database
       use.
   -->
   <jdbc-connection-descriptor
       jcd-alias="farAway"
       platform="Hsqldb"
       jdbc-level="2.0"
       driver="org.hsqldb.jdbcDriver"
       protocol="jdbc"
       subprotocol="hsqldb"
       dbalias="../OJB_FarAway"
       username="sa"
       password=""
       batch-mode="false"

       <connection-pool
           maxActive="6"
           whenExhaustedAction="0"
           validationQuery="select count(*) from OJB_HL_SEQ"
       />

       <sequence-manager className
="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
           <attribute attribute-name="grabSize" attribute-value="5"/>
       </sequence-manager>
   </jdbc-connection-descriptor>

   <!--
       NOTE: This is a test descriptor used within
       the junit test suite, do not change any value.
       If you do not use the test suite, you could
       delete this descriptor.
       In the the test directory under

org.apache.ojb.broker.metadata.MetadataTest#testReadConnectionDescrip to
r
this descriptor will be evaluated.
-->
<jdbc-connection-descriptor
jcd-alias="BETConnection"
default-connection="true"
platform="oracle"
jdbc-level="2.0"
driver="oracle.jdbc.driver.OracleDriver"
protocol="jdbc"
subprotocol="oracle:thin"
dbalias="@ukt01368.ggr.co.uk:1521:TOOLS"
username="bet"
password="xxxx"
eager-release="true"
batch-mode="true"
useAutoCommit="0"
ignoreAutoCommitExceptions="true"

       <object-cache class
="org.apache.ojb.broker.cache.ObjectCacheEmptyImpl">
           <attribute attribute-name="cacheKey1" attribute-value
="cacheValue1"/>
           <attribute attribute-name="cacheKey2" attribute-value
="cacheValue2"/>
       </object-cache>

       <connection-pool
           maxActive="1"
           maxIdle="2"
           maxWait="3"
           minEvictableIdleTimeMillis="4"
           numTestsPerEvictionRun="5"
           testOnBorrow="true"
           testOnReturn="true"
           testWhileIdle="true"
           timeBetweenEvictionRunsMillis="6"
           whenExhaustedAction="2"
           validationQuery="a query"
           logAbandoned="true"
           removeAbandoned="true"
           removeAbandonedTimeout="8"
       />

<sequence-manager className
="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
<attribute attribute-name="key1" attribute-value="value1"/>
<attribute attribute-name="key2" attribute-value="value2"/>
</sequence-manager>
</jdbc-connection-descriptor>


Output:

Excuted raw query
raw retrieval of BET ID: 1 EntityType: Protein Descriptor;null
raw retrieval of BET ID: 2 EntityType: Protein Descriptor;null
raw retrieval of BET ID: 3 EntityType: Protein Descriptor;null
raw retrieval of BET ID: 4 EntityType: Protein Descriptor;null
raw retrieval of BET ID: 5 EntityType: Protein Descriptor;null
raw retrieval of BET ID: 6 EntityType: Protein Descriptor;null
raw retrieval of BET ID: 7 EntityType: Protein Descriptor;null
raw retrieval of BET ID: 8 EntityType: Protein Descriptor;null
raw retrieval of BET ID: 9 EntityType: Protein Descriptor;null
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR:
PersistenceBrokerException during the execution of the query: Used
ConnectionManager instance could not obtain a connection
Used ConnectionManager instance could not obtain a connection
org.apache.ojb.broker.PersistenceBrokerException: Used
ConnectionManager
instance could not obtain a connection
at
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStateme nt
(Unknown

Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
Source)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unk no
wn
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQue ry
(Unknown

Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery (U
nknown

Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unk no
wn
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQue ry
(Unknown

Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQue ry
(Unknown

Source)
at
com.gsk.bet.ConnectionTest.testPBFetchSingle(ConnectionTest.java:127)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. ja
va:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces so
rImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remot eT
estRunner.java:392)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTest Ru
nner.java:276)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTes tR
unner.java:167)
Caused by: org.apache.ojb.broker.accesslayer.LookupException: Could not
borrow connection from pool -
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor:
[EMAIL PROTECTED]
jcd-alias=BETConnection
default-connection=true
dbms=oracle
jdbc-level=2.0
driver=oracle.jdbc.driver.OracleDriver
protocol=jdbc
sub-protocol=oracle:thin
[EMAIL PROTECTED]:1521:TOOLS
user=bet
password=*****
eager-release=true
ConnectionPoolDescriptor={whenExhaustedAction=2, validationQuery=a
query,
maxIdle=2, maxActive=1, maxWait=3, removeAbandoned=true,
numTestsPerEvictionRun=5, testWhileIdle=true,
minEvictableIdleTimeMillis=4,
testOnReturn=true, logAbandoned=true, removeAbandonedTimeout=8,
timeBetweenEvictionRunsMillis=6, testOnBorrow=true}
batchMode=true
useAutoCommit=AUTO_COMMIT_IGNORE_STATE
ignoreAutoCommitExceptions=true

sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDescriptor@ 1e
3118a


sequenceManagerClass=class
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
Properties={key2=value2, key1=value1}
]
]
at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConn ec
tionFromPool(Unknown

Source)
at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.looku pC
onnection(Unknown

Source)
at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection (U
nknown

Source)
... 26 more
Caused by: java.util.NoSuchElementException: Could not create a
validated
object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericOb je
ctPool.java:851)
... 29 more




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]






---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]









---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]









---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]







---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to