Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle and apache OJB issues

 
Nico Melville
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there,

I'm an absolute newbie to apache OJB but I am trying to set it up with an Oracle (v8) database. The trouble is, I am getting an error message saying:

"org.apache.ojb.broker.PBFactoryException: There was no default-PBKey specified"

I'm sure this is a problem with my <jdbc-connector-descriptor> in repository.xml but I can't find any examples that use an Oracle database. At the moment i have:

<jdbc-connection-descriptor
jcd-alias="daodb"
default-connection="true"
jdbc-level="2.0"
platform="Oracle"
driver="oracle.jdbc.driver.OracleDriver"
protocol="jdbc"
subprotocol="Train02"
dbalias="pics"
/>

Its really the protocol/subprotocol sections that i am not sure about. What should they hold? "Train02" is my oracle host name and pics is the name of the database.
Why is there no reference to the port number?
How does this relate to the thin driver (e.g. jdbc racle:thin:@Train02:1521 ics)?

Also - i wasn't sure what jdbc-level (1.0/2.0/3.0) should be used with this driver?

Any advice (even if its to tell me that i am way off track!) would be much appreciated.

Nico.
 
Brett Ryan
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It sounds like you don't have the repository db in your classpath. Make sure you are either running from within the resources dir (build/resources if using the ojb-blank project template), or you have the resources in your classpath.

As for the rest, I haven't used oracle8, but it doesn't sound like a configuration issue.
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic