[Objectbridge-developers] OJB - Oracle java.lang.NullPointerException

[Jerome B. <jb...@vi...>]

Hi,

I've setup OJB to run with Oracle like this :

in src/test/setup/sql1.txt :
;for Oracle
d oracle.jdbc.driver.OracleDriver;
o dbc:oracle:thin:@192.168.x.x:1521:sid scott tiger;

in src/test/ojb/repository.xml :
   <!--JdbcConnectionDescriptor id="default">
      <dbms.name>oracle</dbms.name>
      <driver.name>oracle.jdbc.driver.OracleDriver</driver.name>
      <url.protocol>jdbc</url.protocol>
      <url.subprotocol>oracle:thin</url.subprotocol>
      <url.dbalias>@192.168.x.x:1521:sid</url.dbalias>
      <user.name>scott</user.name>
      <user.passwd>tiger</user.passwd>
   </JdbcConnectionDescriptor-->

I've deleted entries for others database
and run build.sh all. Everything build well;

but when I run tutorial2.sh , I've got this :

+++++++++++++++++++++++++++++++++

Welcome to the OJB ODMG tutorial application


[0] List all product entries
[1] Enter a new product
[2] Delete a product entry
[3] Quit Application
type in number to select a use case
1
please enter a new product
enter name: 1
enter price: 1
enter available stock: 1
new product has no valid _id yet: 0
null
java.lang.NullPointerException
        at
ojb.broker.metadata.ClassDescriptor.getScheme(ClassDescriptor.java:160)
        at
ojb.broker.accesslayer.SqlGenerator.getPreparedSelectByPkStatement(SqlGenerator.java:357)

        at
ojb.broker.accesslayer.StatementsForClass.getSelectByPKkStmt(StatementsForClass.java:266)

        at
ojb.broker.accesslayer.StatementManager.getSelectByPKStatement(StatementManager.java:213)

        at
ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess.java:241)
        at
ojb.broker.PersistenceBrokerImpl.getDBObject(PersistenceBrokerImpl.java:798)
        at
ojb.broker.PersistenceBrokerImpl.getObjectByIdentity(PersistenceBrokerImpl.java:927)

        at
ojb.broker.PersistenceBrokerImpl.getObjectByExample(PersistenceBrokerImpl.java:901)

        at
ojb.broker.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:947)

        at
ojb.broker.util.SequenceManagerDefaultImpl.getNextId(SequenceManagerDefaultImpl.java:112)

        at
ojb.broker.util.SequenceManagerDefaultImpl.getUniqueId(SequenceManagerDefaultImpl.java:140)

        at
ojb.broker.metadata.ClassDescriptor.getAutoIncrementValue(ClassDescriptor.java:736)

        at
ojb.broker.metadata.ClassDescriptor.getKeyValues(ClassDescriptor.java:712)
        at ojb.broker.Identity.<init>(Identity.java:75)
        at
test.ojb.tutorial2.UCEnterNewProduct.apply(UCEnterNewProduct.java:52)
        at test.ojb.tutorial2.Application.run(Application.java:99)
        at test.ojb.tutorial2.Application.main(Application.java:66)
null
java.lang.NullPointerException
        at
ojb.broker.metadata.ClassDescriptor.getScheme(ClassDescriptor.java:160)
        at
ojb.broker.accesslayer.SqlGenerator.getPreparedSelectByPkStatement(SqlGenerator.java:357)

        at
ojb.broker.accesslayer.StatementsForClass.getSelectByPKkStmt(StatementsForClass.java:266)

        at
ojb.broker.accesslayer.StatementManager.getSelectByPKStatement(StatementManager.java:213)

        at
ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess.java:241)
        at
ojb.broker.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:271)
        at
ojb.broker.util.SequenceManagerDefaultImpl.getNextId(SequenceManagerDefaultImpl.java:122)

        at
ojb.broker.util.SequenceManagerDefaultImpl.getUniqueId(SequenceManagerDefaultImpl.java:140)

        at
ojb.broker.metadata.ClassDescriptor.getAutoIncrementValue(ClassDescriptor.java:736)

        at
ojb.broker.metadata.ClassDescriptor.getKeyValues(ClassDescriptor.java:712)
        at ojb.broker.Identity.<init>(Identity.java:75)
        at
test.ojb.tutorial2.UCEnterNewProduct.apply(UCEnterNewProduct.java:52)
        at test.ojb.tutorial2.Application.run(Application.java:99)
        at test.ojb.tutorial2.Application.main(Application.java:66)
        .......
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


I'm using classes12.zip from Oracle with Oracle 8.1.6 and not the OCI driver,

All tables were created in the database and select give me the right result.

What's wrong with this setup ?

    Thanks.