maven-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From qwerty <leire_4...@live.com>
Subject [help]mvn clean install -Pdb,mysql -Dimpex.dba.password=[dbapassword]
Date Tue, 17 Sep 2013 03:16:54 GMT
Hi!

In the tutorial of kuali rice the 3rd step was:
mvn clean install -Pdb,mysql -Dimpex.dba.password=[dbapassword] 

I got this errors:
[INFO]
------------------------------------------------------------------------
[INFO] JDBC Connection Information
[INFO]
------------------------------------------------------------------------
[INFO] URL: jdbc:mysql://localhost/rice
[INFO] Username: RICE
[INFO] Password: ****
[INFO] Driver: com.mysql.jdbc.Driver
[INFO]
------------------------------------------------------------------------
[INFO] Executing rice-impex-master.sql .........[ERROR] Failed to execute: 
CREATE VIEW KRIM_GRP_MBR_V AS 
SELECT g.NMSPC_CD
, g.grp_nm
, g.GRP_ID
, p.PRNCPL_NM
, p.PRNCPL_ID
, mg.GRP_NM AS mbr_grp_nm
, mg.GRP_ID AS mbr_grp_id
FROM KRIM_GRP_MBR_T gm
LEFT JOIN krim_grp_t g
ON g.GRP_ID = gm.GRP_ID
LEFT OUTER JOIN krim_grp_t mg
ON mg.GRP_ID = gm.MBR_ID
AND gm.MBR_TYP_CD = 'G'
LEFT OUTER JOIN krim_prncpl_t p
ON p.PRNCPL_ID = gm.MBR_ID
AND gm.MBR_TYP_CD = 'P'
LEFT OUTER JOIN krim_entity_nm_t en
ON en.ENTITY_ID = p.ENTITY_ID
AND en.DFLT_IND = 'Y'
AND en.ACTV_IND = 'Y'
ORDER BY nmspc_cd, grp_nm, prncpl_nm


 
 



Table 'rice.krim_grp_t' doesn't exist

[ERROR] Failed to execute: 
CREATE VIEW KRIM_GRP_MBR_V AS 
SELECT g.NMSPC_CD
, g.grp_nm
, g.GRP_ID
, p.PRNCPL_NM
, p.PRNCPL_ID
, mg.GRP_NM AS mbr_grp_nm
, mg.GRP_ID AS mbr_grp_id
FROM KRIM_GRP_MBR_T gm
LEFT JOIN krim_grp_t g
ON g.GRP_ID = gm.GRP_ID
LEFT OUTER JOIN krim_grp_t mg
ON mg.GRP_ID = gm.MBR_ID
AND gm.MBR_TYP_CD = 'G'
LEFT OUTER JOIN krim_prncpl_t p
ON p.PRNCPL_ID = gm.MBR_ID
AND gm.MBR_TYP_CD = 'P'
LEFT OUTER JOIN krim_entity_nm_t en
ON en.ENTITY_ID = p.ENTITY_ID
AND en.DFLT_IND = 'Y'
AND en.ACTV_IND = 'Y'
ORDER BY nmspc_cd, grp_nm, prncpl_nm


 
 



Table 'rice.krim_grp_t' doesn't exist
[INFO]
------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO] 
[INFO] Rice DB ........................................... SUCCESS [1.170s]
[INFO] Rice Sql .......................................... SUCCESS [1.130s]
[INFO] Rice Impex ........................................ SUCCESS [0.787s]
[INFO] Rice Impex Master ................................. FAILURE [44.893s]
[INFO] Rice Impex Server ................................. SKIPPED
[INFO] Rice Impex Server Demo ............................ SKIPPED
[INFO] Rice Impex Server Bootstrap ....................... SKIPPED
[INFO] Rice Impex Client ................................. SKIPPED
[INFO] Rice Impex Client Demo ............................ SKIPPED
[INFO] Rice Impex Client Bootstrap ....................... SKIPPED
[INFO]
------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 49.909s
[INFO] Finished at: Tue Sep 17 11:14:39 PHT 2013
[INFO] Final Memory: 33M/366M
[INFO]
------------------------------------------------------------------------
[ERROR] Failed to execute goal
org.kuali.maven.plugins:maven-impex-plugin:1.1.14:import (install) on
project rice-impex-master: Error executing SQL: Table 'rice.krim_grp_t'
doesn't exist -> [Help 1]
org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute
goal org.kuali.maven.plugins:maven-impex-plugin:1.1.14:import (install) on
project rice-impex-master: Error executing SQL
	at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:217)
	at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
	at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
	at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
	at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
	at
org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
	at
org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
	at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
	at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
	at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
	at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
	at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:601)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
Caused by: org.apache.maven.plugin.MojoExecutionException: Error executing
SQL
	at
org.apache.torque.mojo.AbstractSQLExecutorMojo.executeMojo(AbstractSQLExecutorMojo.java:353)
	at org.apache.torque.mojo.BaseMojo.execute(BaseMojo.java:110)
	at
org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)
	at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
	... 19 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'rice.krim_grp_t' doesn't exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
	at org.kuali.db.SQLExecutor.execSQL(SQLExecutor.java:249)
	at org.kuali.db.SQLExecutor.runStatements(SQLExecutor.java:346)
	at org.kuali.db.SQLExecutor.runTransaction(SQLExecutor.java:220)
	at org.kuali.db.SQLExecutor.execute(SQLExecutor.java:190)
	at
org.apache.torque.mojo.AbstractSQLExecutorMojo.executeMojo(AbstractSQLExecutorMojo.java:351)
	... 22 more
[ERROR] 
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please
read the following articles:
[ERROR] [Help 1]
http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
[ERROR] 
[ERROR] After correcting the problems, you can resume the build with the
command
[ERROR]   mvn <goals> -rf :rice-impex-master

Please help me
Thanks in advance :)



--
View this message in context: http://maven.40175.n5.nabble.com/help-mvn-clean-install-Pdb-mysql-Dimpex-dba-password-dbapassword-tp5770840.html
Sent from the Maven - Users mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org


Mime
View raw message