• Post Reply Bookmark Topic Watch Topic
  • New Topic

Oracle and apache OJB issues  RSS feed

 
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!