[ojb-users] [Fwd: Help with OBJ]

[Thomas M. <tho...@ho...>]

-------- Original Message --------
Subject: Help with OBJ
Date: Fri, 14 Jun 2002 10:21:31 -0400
From: "Warmuz, Peter" <Pet...@ci...>
To: "'th...@us...'" <th...@us...>

Hi Thomas,

How are you?  Through word of mouth and through great reviews I have heard
about the object/relational bridge.  So I decided to that I just might use
it for my one of projects here at work.  As not too many of us like to
playing with SQL statements.  So.. off I went to explore the
object/relational bridge.

However, I'm having a problem and I'm hoping you could assist me.

I created a use case that is very similar to UCListAllProducts in the first
tutorial.  Now I can connect to an Oracle database and receive all my
records(ie. products; in my scenario team group names).  Now my Collection
variable gets populated with the information using the following syntax.
	Collection allTeamCodes = broker.getCollectionByQuery(query);

All good up to this point;

So now I go into the while loop and try to extract the information

         java.util.Iterator iter = allTeamCodes.iterator();

         while (iter.hasNext())
         {
           System.out.println(iter.next());
         }

And this is what happens:

The list of available team groups
java.sql.SQLException: ORA-00911: invalid character

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
	at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)[ojb.broker.acc
esslayer.JdbcAccess] ERROR: SQLException during the execution of
materializeObject: ORA-00911: invalid character

ORA-00911: invalid character


	at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
	at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:2672)
	at
oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(Oracle
PreparedStatement.java:3989)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:623)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java:527)
	at
ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess.java:349)
	at
ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(PersistenceBrokerImpl.
java:1086)
	at
ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(PersistenceBro
kerImpl.java:1204)
	at
ojb.broker.accesslayer.IndirectionHandler.materializeSubject(IndirectionHand
ler.java:202)
	at
ojb.broker.accesslayer.IndirectionHandler.getRealSubject(IndirectionHandler.
java:187)
	at
ojb.broker.accesslayer.IndirectionHandler.invoke(IndirectionHandler.java:159
)
	at $Proxy0.toString(Unknown Source)
	at java.lang.String.valueOf(String.java:1947)
	at java.io.PrintStream.print(PrintStream.java:426)
	at java.io.PrintStream.println(PrintStream.java:563)
	at survey.UCListAllTeamGroups.apply(UCListAllTeamGroups.java:23)
	at survey.Application.run(Application.java:34)
	at survey.Application.main(Application.java:27)
ojb.broker.PersistenceBrokerSQLException
	at
ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess.java:372)
	at
ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(PersistenceBrokerImpl.
java:1086)[DEFAULT] ERROR: null

	at
ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(PersistenceBro
kerImpl.java:1204)
	at
ojb.broker.accesslayer.IndirectionHandler.materializeSubject(IndirectionHand
ler.java:202)
	at
ojb.broker.accesslayer.IndirectionHandler.getRealSubject(IndirectionHandler.
java:187)
	at
ojb.broker.accesslayer.IndirectionHandler.invoke(IndirectionHandler.java:159
)
	at $Proxy0.toString(Unknown Source)
	at java.lang.String.valueOf(String.java:1947)
	at java.io.PrintStream.print(PrintStream.java:426)
	at java.io.PrintStream.println(PrintStream.java:563)
	at survey.UCListAllTeamGroups.apply(UCListAllTeamGroups.java:23)
	at survey.Application.run(Application.java:34)
	at survey.Application.main(Application.java:27)
ojb.broker.PersistenceBrokerSQLException
	at
ojb.broker.accesslayer.JdbcAccess.materializeObject(JdbcAccess.java:372)
	at
ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(PersistenceBrokerImpl.
java:1086)
	at
ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(PersistenceBro
kerImpl.java:1204)
	at
ojb.broker.accesslayer.IndirectionHandler.materializeSubject(IndirectionHand
ler.java:202)
	at
ojb.broker.accesslayer.IndirectionHandler.getRealSubject(IndirectionHandler.
java:187)
	at
ojb.broker.accesslayer.IndirectionHandler.invoke(IndirectionHandler.java:159
)
	at $Proxy0.toString(Unknown Source)
	at java.lang.String.valueOf(String.java:1947)
	at java.io.PrintStream.print(PrintStream.java:426)
	at java.io.PrintStream.println(PrintStream.java:563)
	at survey.UCListAllTeamGroups.apply(UCListAllTeamGroups.java:23)
	at survey.Application.run(Application.java:34)
	at survey.Application.main(Application.java:27)



Now since I couldn't get out the information this why I try casting to my
TeamGroup class the iterator but this is what happens;

The list of available team groups
java.lang.ClassCastException: $Proxy0
	at survey.UCListAllTeamGroups.apply(UCListAllTeamGroups.java:24)
	at survey.Application.run(Application.java:34)
	at survey.Application.main(Application.java:27)


So what's is the proxy that I need to use to cast my data?

Attached with this email is the source code that I am using.  If you could
shed an light on this problem; this would be greatly appreciated! Thank you

  <<OJB.properties>>  <<repository.xml>>  <<repository_internal.xml>>
<<repository_user.xml>>  <<AbstractUseCase.java>>  <<Application.java>>
<<TeamGroup.java>>  <<UCListAllTeamGroups.java>>  <<UseCase.java>>
____________________________________________________
Peter Warmuz
CPSE - PC Developer
Java/EJB/JSP/Unix/C++

pet...@ci... 	750 Lawrence Avenue West
P: (416) 784-2355		East Building 3rd floor
F: (416) 784-7712		Toronto, ON M68 1B8