You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by bogdan_voloshincu <bo...@yahoo.com> on 2010/11/10 14:29:45 UTC
Help cdbimport Oracle
I need to import Oracle database schema and it doesn't works.
I set up the classpath, it reconize the Schema XE but, doesn't generate
tables information.
Can somebody help me ?
my ant target is :
<cdbimport map="src/resources/riMap.map.xml"
overwriteExisting="true"
schemaName="XE"
adapter="org.apache.cayenne.dba.oracle.OracleAdapter"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:XE"
username="root"
password="root"/>
<echo message="Generare Clase"/>
<cgen map="src/resources/riMap.map.xml"
destDir="build"
makepairs="true"
includeEntities="*"/>
</target>
--
View this message in context: http://cayenne.195.n3.nabble.com/Help-cdbimport-Oracle-tp1876015p1876015.html
Sent from the Cayenne - User mailing list archive at Nabble.com.
Re: Help cdbimport Oracle
Posted by Andrus Adamchik <an...@objectstyle.org>.
Glad to see you made it work. Yeah, different DB's have specific definitions of "schema", etc.
Andrus
On Nov 10, 2010, at 3:21 PM, bogdan_voloshincu wrote:
>
> i make some tests and i find the reason why my target couldn't import my
> Oracle schema :
>
> Inside of my target, instead of :schemaName="XE" I use my UserName and it
> worked;
>
> <target name="generate" depends="sett,clean,create.dir">
>
> <echo message="Import schema"/>
> <cdbimport map="src/resources/riMap.map.xml"
> overwriteExisting="true"
> schemaName="ROOT"
> adapter="org.apache.cayenne.dba.oracle.OracleAdapter"
> driver="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@localhost:1521:XE"
> username="root"
> password="root"/>
> </target>
Re: Help cdbimport Oracle
Posted by bogdan_voloshincu <bo...@yahoo.com>.
i make some tests and i find the reason why my target couldn't import my
Oracle schema :
Inside of my target, instead of :schemaName="XE" I use my UserName and it
worked;
<target name="generate" depends="sett,clean,create.dir">
<echo message="Import schema"/>
<cdbimport map="src/resources/riMap.map.xml"
overwriteExisting="true"
schemaName="ROOT"
adapter="org.apache.cayenne.dba.oracle.OracleAdapter"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:XE"
username="root"
password="root"/>
</target>
--
View this message in context: http://cayenne.195.n3.nabble.com/Help-cdbimport-Oracle-tp1876015p1878426.html
Sent from the Cayenne - User mailing list archive at Nabble.com.
Re: Help cdbimport Oracle
Posted by Andrus Adamchik <an...@objectstyle.org>.
You see no errors, and no tables are created?
Strange. We recently had a similar report about SQLServer / Modeler reengineering, so I am not discounting a possibility that Cayenne may ignore some entities for some inconceivable reason. Just don't know what that might be yet (beyond DB permissions and user user errors). Needless to say, it all works in my tests.
Andrus
On Nov 10, 2010, at 8:29 AM, bogdan_voloshincu wrote:
> I need to import Oracle database schema and it doesn't works.
> I set up the classpath, it reconize the Schema XE but, doesn't generate
> tables information.
> Can somebody help me ?
>
>
> my ant target is :
>
>
>
> <cdbimport map="src/resources/riMap.map.xml"
> overwriteExisting="true"
> schemaName="XE"
> adapter="org.apache.cayenne.dba.oracle.OracleAdapter"
> driver="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@localhost:1521:XE"
> username="root"
> password="root"/>
>
> <echo message="Generare Clase"/>
> <cgen map="src/resources/riMap.map.xml"
> destDir="build"
> makepairs="true"
> includeEntities="*"/>
> </target>
>
> --
> View this message in context: http://cayenne.195.n3.nabble.com/Help-cdbimport-Oracle-tp1876015p1876015.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.
>