3

When I Execute the below command:

mvn -X validate -Pks-db,oracle -Dks.impex.url=jdbc:oracle:thin:@kuali.localdomain:1521:DB11G -Dks.impex.dba.password=Oracle123

I get the below exception:

Failed to execute goal org.codehaus.mojo:sql-maven-plugin:1.4:execute (validate-dba-config) on project ks-bundled-db: ORA-01017: invalid username/password; logon denied -> [Help 1] org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.codehaus.mojo:sql-maven-plugin:1.4:execute (validate-dba-config) on project ks-bundled-db: ORA-01017: invalid username/password; logon denied

Jens
  • 67,715
  • 15
  • 98
  • 113
Gaurav Bhaskar
  • 195
  • 2
  • 4
  • 18

1 Answers1

3

According to this document, you should be supplying the user name as well; their example is:

mvn validate -Pks-db,oracle -Dks.impex.url=jdbc:oracle:thin:@localhost:1521:XE -Dks.impex.dba.username="SYS AS SYSDBA" -Dks.impex.dba.password=<SYS password>

So you need to add to your command:

-Dks.impex.dba.username="SYS AS SYSDBA"

It isn't clear what you have set in your properties file or which value is needed/used; but it may be picking up your KSBUNDLED username, or the legacy MASTER name.

Alex Poole
  • 183,384
  • 11
  • 179
  • 318
  • Thanks Alex. It really worked for me.Though i changed below wherever it was required: KSBUNDLED KSBUNDLED – Gaurav Bhaskar Jan 19 '16 at 17:29
  • @ICTApplication - it seems to be looking for property ks.impex.dba.username rather than ks.impex.username for this. I may be reading that document wrongly though. Glad it worked out though. – Alex Poole Jan 19 '16 at 17:33
  • Now i am running this to load the dataset, i hope it must go well, i will keep you posted. Thanks for prompt help and answer---- mvn -X clean install -Pks-db,oracle -Dks.impex.url=jdbc:oracle:thin:@kuali.localdomain:1521:DB11G -Dks.impex.dba.username="SYS AS SYSDBA" -Dks.impex.dba.password=Oracle123 – Gaurav Bhaskar Jan 19 '16 at 17:54