Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) 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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!