Dear,

I'm using Oracle database and ojdbc14  driver.
I didn't use "-s" option I don't know this option ,what it's used for ?
Could I know the privileges required for the database user.
I have given the database user the following roles :
Connect
Resource
DBA
Select_Catalog_Role
Execute_Catalof_Role

And I also have given it the following privileges :
Alter any procedure
Create any procedure
Create Materialized view
Create Procedure
Create table
Select any  dictionary
Select any table
Unlimited tablespace

I would be grateful if you would further help me.


-----Original Message-----
From: Richard Cyganiak [mailto:[email protected]] 
Sent: Tuesday, September 06, 2011 3:17 PM
To: Hend Eleraky
Cc: [email protected]
Subject: Re: [d2rq-dev] Problem in generating mapping file.

Hi Hend,

What database engine and what JDBC driver are you using? Are you using the -s 
option of generate_mapping?

Possible reasons include:

- database has no tables in it
- database schema selected with -s has no tables
- JDBC driver doesn't support listing of tables
- user has insufficient privileges to list tables
- user has insufficient privileges to access INFORMATION_SCHEMA schema

Best,
Richard


On 6 Sep 2011, at 13:40, Hend Eleraky wrote:

> Dear,
> I would like to report a problem that I face when I try to generate a mapping 
> file to my database using "generate-mapping.bat".
> The problem is that I can't find mappings for my  database tables in the 
> generated file I only could find the database connection description , I 
> tried to set many privileges for the database user but still had the same 
> problem.
> If you could help me in this problem I would be grateful.
>  
> Thanks,
>  
> Hend  Eleraky
> Software Engineer
> ICT Sector
> Bibliotheca Alexandrina
> P.O. Box 138, Chatby
> Alexandria 21526, Egypt
>  
> ------------------------------------------------------------------------------
> Special Offer -- Download ArcSight Logger for FREE!
> Finally, a world-class log management solution at an even better 
> price-free! And you'll get a free "Love Thy Logs" t-shirt when you
> download Logger. Secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsisghtdev2dev_______________________________________________
> d2rq-map-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel


------------------------------------------------------------------------------
Doing More with Less: The Next Generation Virtual Desktop 
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops?   How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/
_______________________________________________
d2rq-map-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel

Reply via email to