AW: [Objectbridge-developers] OJB - Oracle java.lang.NullPointerE xception

[Mahler T. <tho...@it...>]

Hi Jerome,

You must uncomment the JDBC-ConnectionDescriptor in the xml Repository =
!!!
It should look like:

    <JdbcConnectionDescriptor id=3D"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>

HTH

Thomas


> -----Urspr=FCngliche Nachricht-----
> Von: Jerome Boulon [mailto:jb...@vi...]
> Gesendet: Mittwoch, 3. Oktober 2001 23:20
> An: OJB
> Betreff: [Objectbridge-developers] OJB - Oracle
> java.lang.NullPointerException
>=20
>=20
> Hi,
>=20
> I've setup OJB to run with Oracle like this :
>=20
> 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;
>=20
> in src/test/ojb/repository.xml :
>    <!--JdbcConnectionDescriptor id=3D"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-->
>=20
> I've deleted entries for others database
> and run build.sh all. Everything build well;
>=20
> but when I run tutorial2.sh , I've got this :
>=20
> +++++++++++++++++++++++++++++++++
>=20
> Welcome to the OJB ODMG tutorial application
>=20
>=20
> [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.getPreparedSelectByPkState
> ment(SqlGenerator.java:357)
>=20
>         at
> ojb.broker.accesslayer.StatementsForClass.getSelectByPKkStmt(S
> tatementsForClass.java:266)
>=20
>         at
> ojb.broker.accesslayer.StatementManager.getSelectByPKStatement
> (StatementManager.java:213)
>=20
>         at
> ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess
> .java:241)
>         at
> ojb.broker.PersistenceBrokerImpl.getDBObject(PersistenceBroker
> Impl.java:798)
>         at
> ojb.broker.PersistenceBrokerImpl.getObjectByIdentity(Persisten
> ceBrokerImpl.java:927)
>=20
>         at
> ojb.broker.PersistenceBrokerImpl.getObjectByExample(Persistenc
> eBrokerImpl.java:901)
>=20
>         at
> ojb.broker.PersistenceBrokerImpl.getObjectByQuery(PersistenceB
> rokerImpl.java:947)
>=20
>         at
> ojb.broker.util.SequenceManagerDefaultImpl.getNextId(SequenceM
> anagerDefaultImpl.java:112)
>=20
>         at
> ojb.broker.util.SequenceManagerDefaultImpl.getUniqueId(Sequenc
> eManagerDefaultImpl.java:140)
>=20
>         at
> ojb.broker.metadata.ClassDescriptor.getAutoIncrementValue(Clas
> sDescriptor.java:736)
>=20
>         at
> ojb.broker.metadata.ClassDescriptor.getKeyValues(ClassDescript
> or.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.getPreparedSelectByPkState
> ment(SqlGenerator.java:357)
>=20
>         at
> ojb.broker.accesslayer.StatementsForClass.getSelectByPKkStmt(S
> tatementsForClass.java:266)
>=20
>         at
> ojb.broker.accesslayer.StatementManager.getSelectByPKStatement
> (StatementManager.java:213)
>=20
>         at
> ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess
> .java:241)
>         at
> =
ojb.broker.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:271)
>         at
> ojb.broker.util.SequenceManagerDefaultImpl.getNextId(SequenceM
> anagerDefaultImpl.java:122)
>=20
>         at
> ojb.broker.util.SequenceManagerDefaultImpl.getUniqueId(Sequenc
> eManagerDefaultImpl.java:140)
>=20
>         at
> ojb.broker.metadata.ClassDescriptor.getAutoIncrementValue(Clas
> sDescriptor.java:736)
>=20
>         at
> ojb.broker.metadata.ClassDescriptor.getKeyValues(ClassDescript
> or.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)
>         .......
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>=20
>=20
> I'm using classes12.zip from Oracle with Oracle 8.1.6 and not=20
> the OCI driver,
>=20
> All tables were created in the database and select give me=20
> the right result.
>=20
> What's wrong with this setup ?
>=20
>     Thanks.
>=20
>=20
>=20
> _______________________________________________
> Objectbridge-developers mailing list
> Obj...@li...
> https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
>=20