hello all,
i am getting a problem with dbunit:operation.The below description tells how
i deploy the database in to my reposistory.
i deploy oracle database in to my repositotry with ojdbc14.jar with version
10.2.0.1.0.
with the below command:
mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc14 -Dversi
on=10.2.0.1.0 -Dpackaging=jar -Dfile=C:\apache-maven-2.0.9\ojdbc14.jar.
and it shows build successfully.
now make a modification in pom.xml like this:
<dbunit.dataTypeFactoryName>org.dbunit.ext.oracle.OracleDataTypeFactory</dbunit.dataTypeFactoryName>
<dbunit.operation.type>CLEAN_INSERT</dbunit.operation.type>
<dbunit.schema>TRAINING</dbunit.schema>
<hibernate.dialect>org.hibernate.dialect.Oracle9Dialect</hibernate.dialect>
<jdbc.groupId>com.oracle</jdbc.groupId>
<jdbc.artifactId>ojdbc14</jdbc.artifactId>
<jdbc.version>10.2.0.1.0</jdbc.version>
<jdbc.driverClassName>oracle.jdbc.OracleDriver</jdbc.driverClassName>
<jdbc.url><![CDATA[jdbc:oracle:thin:@172.17.3.130:1521:MIRACLE]]></jdbc.url>
<jdbc.username>training</jdbc.username>
<jdbc.password>training</jdbc.password>
and in the configuration i didn't change any thing i kept as below only:
<configuration>
<dataTypeFactoryName>${dbunit.dataTypeFactoryName}</dataTypeFactoryName>
<driver>${jdbc.driverClassName}</driver>
<username>${jdbc.username}</username>
<password>${jdbc.password}</password>
<url>${jdbc.url}</url>
<src>src/test/resources/sample-data.xml</src>
<type>${dbunit.operation.type}</type>
<schema>${dbunit.schema}</schema>
<skip>${maven.test.skip}</skip>
</configuration>
when i try to run the project it's giving an error like:
create sequence hibernate_sequence;
[INFO] [compiler:testCompile]
[INFO] Nothing to compile - all classes are up to date
[INFO] [dbunit:operation {execution: test-compile}]
[INFO]
------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO]
------------------------------------------------------------------------
[INFO] Error executing database operation: CLEAN_INSERT
Embedded error: Items_Master
[INFO]
------------------------------------------------------------------------
[INFO] For more information, run Maven with the -e switch
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 10 seconds
[INFO] Finished at: Wed Nov 19 18:13:21 IST 2008
[INFO] Final Memory: 23M/254M
[INFO]
------------------------------------------------------------------------
please give me a suggestion as soon as possible i need to work on this.
thanking you in advance.
------------------------------------------------------------------------------------------------------
Michael Duergner wrote:
>
> You installed the library with version 10.2.0.2.0 and your project is
> looking for version 10.2.0.1.0 according to the information you posted.
>
> On Tue, Nov 18, 2008 at 5:37 PM, grd prasad
> <[EMAIL PROTECTED]>wrote:
>
>>
>> hello all,
>>
>> i tried to deploy the oracle in my own repository and i tried as like
>> below
>> please check them and make it correct and give me a breif solution how to
>> deploy the oracle into my own repository.
>>
>> for -Dpackaging=jar -Dfile i gave the path of ojdbc12.jar like below
>> -Dpackaging=jar -Dfile=C:/apache-maven-2.0.9/ojdbc14.jar
>>
>> and i run the below command in command line
>>
>> mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc14
>> -Dversi
>> on=10.2.0.2.0 -Dpackaging=jar -Dfile=C:/apache-maven-2.0.9/ojdbc14.jar
>>
>> it was giving an error's like
>>
>> [INFO] Scanning for projects...
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] Building AppFuse Struts 2 Application
>> [INFO] task-segment: [install]
>> [INFO]
>> ------------------------------------------------------------------------
>> Downloading:
>> http://repo1.maven.org/maven2/oracle/ojdbc14/10.2.0.1.0/ojdbc14-10.
>> 2.0.1.0.pom
>> Downloading:
>> http://static.appfuse.org/repository/oracle/ojdbc14/10.2.0.1.0/ojdb
>> c14-10.2.0.1.0.pom<http://static.appfuse.org/repository/oracle/ojdbc14/10.2.0.1.0/ojdbc14-10.2.0.1.0.pom>
>> Downloading:
>> http://repo1.maven.org/maven2/oracle/ojdbc14/10.2.0.1.0/ojdbc14-10.
>> 2.0.1.0.jar
>> Downloading:
>> http://static.appfuse.org/repository/oracle/ojdbc14/10.2.0.1.0/ojdb
>> c14-10.2.0.1.0.jar<http://static.appfuse.org/repository/oracle/ojdbc14/10.2.0.1.0/ojdbc14-10.2.0.1.0.jar>
>> [INFO]
>> ------------------------------------------------------------------------
>> [ERROR] BUILD ERROR
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] Failed to resolve artifact.
>>
>> Missing:
>> ----------
>> 1) oracle:ojdbc14:jar:10.2.0.1.0
>>
>> Try downloading the file manually from the project website.
>>
>> Then, install it using the command:
>> mvn install:install-file -DgroupId=oracle -DartifactId=ojdbc14
>> -Dversion=1
>> 0.2.0.1.0 -Dpackaging=jar -Dfile=/path/to/file
>>
>> Alternatively, if you host your own repository you can deploy the file
>> there:
>>
>> mvn deploy:deploy-file -DgroupId=oracle -DartifactId=ojdbc14
>> -Dversion=10.
>> 2.0.1.0 -Dpackaging=jar -Dfile=/path/to/file -Durl=[url]
>> -DrepositoryId=[id]
>>
>> Path to dependency:
>> 1) org.appfuse.tutorial:tutorial-struts2:war:2.0.2
>> 2) oracle:ojdbc14:jar:10.2.0.1.0
>>
>> ----------
>> 1 required artifact is missing.
>>
>> for artifact:
>> org.appfuse.tutorial:tutorial-struts2:war:2.0.2
>>
>> from the specified remote repositories:
>> appfuse (http://static.appfuse.org/repository),
>> central (http://repo1.maven.org/maven2)
>>
>>
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] For more information, run Maven with the -e switch
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] Total time: 7 seconds
>> [INFO] Finished at: Tue Nov 18 20:44:35 IST 2008
>> [INFO] Final Memory: 15M/254M
>> [INFO]
>> ------------------------------------------------------------------------
>>
>>
>> after that i tried like this also
>>
>> mvn deploy:deploy-file -DgroupId=oracle -DartifactId=ojdbc14
>> -Dversion=10.
>> 2.0.1.0 -Dpackaging=jar -Dfile=C:/apache-maven-2.0.9/ojdbc14.jar
>> -Durl=[jdbc:oracle:thin:@172.17.3.130:1521:MIRACLE] -DrepositoryId=[id]
>>
>> what i have given in the above deploy file is correct or wrong and i dont
>> know what to give the repository id. please correct it and give me the
>> command with explanation. I need to work with oracle database.
>>
>> please can any one help me in deploy the oracle in my own repository.
>>
>>
>> Thanking you in advance..
>>
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Can%27t-we-use-oracle-database-with-out-install-tp20539704s2369p20563244.html
>> Sent from the AppFuse - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>
>
> --
> Mit freundlichen Grüßen / With kind regards
>
> Michael Dürgner
>
>
--
View this message in context:
http://www.nabble.com/Can%27t-we-use-oracle-database-with-out-install-tp20539704s2369p20584008.html
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
