Stack Overflow
Stack Overflow

Questions tagged [sql-maven-plugin]

The sql-maven-plugin is used to execute SQL statements during a Maven build. Use this tag for questions specific about the usage of this plugin.

The sql-maven-plugin is used to execute SQL statements against a database during a Maven build.

32 questions
1
vote
1 answer

How to force sql-maven-plugin to ignore failling sqls

I have a build which copies schema from test environment (creates sqls) and executes (using sql-maven-plugin) those sql on local-database. The problem is some views, stored procedures are broken on test environment. I need to ignore broken sqls…
plancys
  • 3,833
  • 2
  • 19
  • 26
1
vote
1 answer

Import problem "hibernate_sequence" table with Generation.type

So I'm trying to use a sql-maven-plugin to import my backup database. I used annotation @GeneratedValue(strategy = GenerationType.TABLE ) on my Entities, so my backup database has hibernate_sequence table with it. How to avoid this error, but still…
Mihkel L.
  • 1,543
  • 1
  • 27
  • 42
0
votes
1 answer

sql-maven-plugin create function

I am using hsqldb and an embedded jetty instance (via) maven for testing locally. The application will use a mysql database on production. I will need to call mysql's UNHEX() for a particular query. How can I create a wrapper for hsqldb that would…
vikash dat
  • 1,494
  • 2
  • 19
  • 37
0
votes
0 answers

mvn deploy failed with permission denied error

mvn deploy just worked fine until I used following piece in my pom file org.codehaus.mojo sql-maven-plugin Error: Permission denied while uploading artifacts to…
Koti
  • 1
0
votes
0 answers

MySql-Maven-Plugin : java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

I am using maven-sql-plugin for writing test classes, here I am setting username, password, drivername, source file location and url along with it I also added GRANT query in plug-in, but still getting ACCESS-DENIED error. Here is my…
Sat
  • 3,520
  • 9
  • 39
  • 66
0
votes
1 answer

Overriding Table names for Arquillian Tests + sql-maven-plugin

In our projects we are using entities from an inhouse library (we are using including them as a JAR). The class itself looks something like this (can't paste the real code here). @Table(name = "X_MY_ENTITY") public class MyEntity{ //columns... } In…
Patrick Zinner
  • 356
  • 4
  • 17
0
votes
1 answer

PL/SQL script in sql-maven-plugin throws invalid SQL statement

I am trying to update my materialized view using sql-maven-plugin but its says Caused by: java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement ORA-06512: at line 2 Query : begin EXECUTE IMMEDIATE…
Umar Sid
  • 1,317
  • 1
  • 17
  • 24
0
votes
1 answer

sql-maven-plugin escaping single quotes in sqlCommand

I have maven based project and I try to use sql-maven-plugin in order to setup/tear-down DB for system tests. I put in sqlCommand element: CALL SOME_STORED_PROC('SYSTEST') however, maven build fails on this SQL with the followig…
aviad
  • 8,229
  • 9
  • 50
  • 98
0
votes
1 answer

Maven project runs sql-maven-plugin executions from dependency

How can I configure my Maven pom.xml and/or sql-maven-plugin so that the unit test related DB executions I've specified in my dependency, lib.example.jdbc, don't get executed when building the pom.xml of my project com.example.project? Currently…
nofunatall
  • 561
  • 6
  • 20
0
votes
1 answer

using ingres driver with sql maven plugin

I want to use celerio to generate code from our database. Celerio uses the sql-maven-plugin to connect to the database. But i cannot resolve the dependency for the ingres driver. that's how i set up my database connection in the pom.xml of my…
Martin Frank
  • 3,445
  • 1
  • 27
  • 47
0
votes
1 answer

property not working properly while using sql-maven-plugin

I am using sql-maven-plugin to perform a simple DB testcase. Firstly , I am inserting 2 rows of data into a table(note: I am truncating the table manually before doing this) Then I am running a select query to check if those 2 rows are inserted. To…
user7998880
0
votes
1 answer

Maven SQL plugin execution order

I am facing some problem in ordering the sql execution. We have one sql script file for each table under one directory. Ex: There is user.sql and role.sql in the directory c:\SqlScripts. We are using the sql maven plugin to execute these sql files.…
Julia
  • 671
  • 1
  • 5
  • 4
0
votes
0 answers

Maven SQL Plugin not handling BLOB data correctly

I'm new to pom files and new to stackoverflow. As part of our Integration Test process I'm dropping and recreating mysql databases on each run in order to ensure clean known reference data as a starting point. This is being done via pom files which…
S Scott
  • 1
  • 1
0
votes
0 answers

Sql Maven Plugin - includesfile

I have a project where we are trying to execute a number (circa 100) of Oracle PL/SQL files. Each file contains a stored procedure. The procedures must be applied to the database in a set order. The stored procedures are supplied to us by a DBA team…
maverickCoder
  • 1
  • 2
0
votes
0 answers

why the sql maven plugin is not execute when the jetty server is deployed

I work with a project in Eclipse with Mysql, SpringFramework, Maven and Jetty. I run the server with the goal: jetty:run Part of the pom.xml is: …
mlozdev
  • 137
  • 1
  • 4
  • 12
1
2
3