• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to specify schema owners in Torque?

 
John Creuziger
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
First, I'm new to the site and pretty new to Java.....apologies in advance if I misuse any terminology!

I've connected successfully to an Oracle9i database using Maven and Torque. Now, I'm getting a "table or view undefined" exception. Easy enough, I figured I'd just specify the schema owner in schema.xml thus:

<table name="HRS1.EMPLOYEE" description="employee" javaName="Employee">
<column name="EMAIL_ADDRESS" required="true" type="VARCHAR2" size="90" description="email address" />
</table>

The generated program in this case comes out as HRS1.EMPLOYEE.class

Of course, the compiler barfs all over that when I try to deploy....I thought the javaName property would solve, but that didn't work.

I realized I could do things on the database side, but that would require begging the DBAs and I'd rather avoid that if possible.

Thanks,

John
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
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!