[
https://issues.apache.org/jira/browse/STORM-1344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jungtaek Lim resolved STORM-1344.
---------------------------------
Resolution: Fixed
Assignee: Paul Poulosky
Fix Version/s: 1.0.3
1.1.0
2.0.0
Thanks [~ppoulosk], I merged into master, 1.x, 1.0.x branches.
> storm-jdbc build error "object name already exists: USER_DETAILS in statement"
> ------------------------------------------------------------------------------
>
> Key: STORM-1344
> URL: https://issues.apache.org/jira/browse/STORM-1344
> Project: Apache Storm
> Issue Type: Bug
> Components: storm-jdbc
> Affects Versions: 1.0.0
> Environment: os X, jdk7
> Reporter: Longda Feng
> Assignee: Paul Poulosky
> Priority: Critical
> Fix For: 2.0.0, 1.1.0, 1.0.3
>
> Time Spent: 2h 20m
> Remaining Estimate: 0h
>
> ```
> [ERROR] Failed to execute goal org.codehaus.mojo:sql-maven-plugin:1.5:execute
> (create-db) on project storm-jdbc: object name already exists: USER_DETAILS
> in statement [ /** * Licensed to the Apache Software Foundation (ASF) under
> one * or more contributor license agreements. See the NOTICE file *
> distributed with this work for additional information * regarding copyright
> ownership. The ASF licenses this file * to you under the Apache License,
> Version 2.0 (the * "License"); you may not use this file except in compliance
> * with the License. You may obtain a copy of the License at * *
> http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable
> law or agreed to in writing, software * distributed under the License is
> distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY
> KIND, either express or implied. * See the License for the specific language
> governing permissions and * limitations under the License. */
> [ERROR] create table user_details (id integer, user_name varchar(100),
> create_date date)]
> [ERROR] -> [Help 1]
> org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute
> goal org.codehaus.mojo:sql-maven-plugin:1.5:execute (create-db) on project
> storm-jdbc: object name already exists: USER_DETAILS in statement [ /** *
> Licensed to the Apache Software Foundation (ASF) under one * or more
> contributor license agreements. See the NOTICE file * distributed with this
> work for additional information * regarding copyright ownership. The ASF
> licenses this file * to you under the Apache License, Version 2.0 (the *
> "License"); you may not use this file except in compliance * with the
> License. You may obtain a copy of the License at * *
> http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable
> law or agreed to in writing, software * distributed under the License is
> distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY
> KIND, either express or implied. * See the License for the specific language
> governing permissions and * limitations under the License. */
> create table user_details (id integer, user_name varchar(100), create_date
> date)]
> at
> org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:216)
> 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:116)
> at
> org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)
> at
> org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)
> at
> org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128)
> at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307)
> at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193)
> at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106)
> at org.apache.maven.cli.MavenCli.execute(MavenCli.java:862)
> at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:286)
> at org.apache.maven.cli.MavenCli.main(MavenCli.java:197)
> 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:606)
> at
> org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
> at
> org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
> at
> org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)
> at
> org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
> Caused by: org.apache.maven.plugin.MojoExecutionException: object name
> already exists: USER_DETAILS in statement [ /** * Licensed to the Apache
> Software Foundation (ASF) under one * or more contributor license agreements.
> See the NOTICE file * distributed with this work for additional information
> * regarding copyright ownership. The ASF licenses this file * to you under
> the Apache License, Version 2.0 (the * "License"); you may not use this file
> except in compliance * with the License. You may obtain a copy of the
> License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required
> by applicable law or agreed to in writing, software * distributed under the
> License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR
> CONDITIONS OF ANY KIND, either express or implied. * See the License for the
> specific language governing permissions and * limitations under the License.
> */
> create table user_details (id integer, user_name varchar(100), create_date
> date)]
> at org.codehaus.mojo.sql.SqlExecMojo.execute(SqlExecMojo.java:681)
> at
> org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134)
> at
> org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:208)
> ... 20 more
> Caused by: java.sql.SQLSyntaxErrorException: object name already exists:
> USER_DETAILS in statement [ /** * Licensed to the Apache Software Foundation
> (ASF) under one * or more contributor license agreements. See the NOTICE
> file * distributed with this work for additional information * regarding
> copyright ownership. The ASF licenses this file * to you under the Apache
> License, Version 2.0 (the * "License"); you may not use this file except in
> compliance * with the License. You may obtain a copy of the License at * *
> http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable
> law or agreed to in writing, software * distributed under the License is
> distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY
> KIND, either express or implied. * See the License for the specific language
> governing permissions and * limitations under the License. */
> create table user_details (id integer, user_name varchar(100), create_date
> date)]
> at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
> at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
> at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
> at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
> at org.codehaus.mojo.sql.SqlExecMojo.execSQL(SqlExecMojo.java:1056)
> at
> org.codehaus.mojo.sql.SqlExecMojo.runStatements(SqlExecMojo.java:1018)
> at org.codehaus.mojo.sql.SqlExecMojo.access$200(SqlExecMojo.java:68)
> at
> org.codehaus.mojo.sql.SqlExecMojo$Transaction.runTransaction(SqlExecMojo.java:1252)
> at
> org.codehaus.mojo.sql.SqlExecMojo$Transaction.access$100(SqlExecMojo.java:1199)
> at org.codehaus.mojo.sql.SqlExecMojo.execute(SqlExecMojo.java:647)
> ... 22 more
> Caused by: org.hsqldb.HsqlException: object name already exists: USER_DETAILS
> at org.hsqldb.error.Error.error(Unknown Source)
> at org.hsqldb.error.Error.error(Unknown Source)
> at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
> at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
> at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
> at org.hsqldb.StatementSchema.getResult(Unknown Source)
> at org.hsqldb.StatementSchema.execute(Unknown Source)
> at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
> at org.hsqldb.Session.executeDirectStatement(Unknown Source)
> at org.hsqldb.Session.execute(Unknown Source)
> ... 30 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
> ```
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
