Styjun

As a DM, how to avoid unconscious metagaming when dealing with a high AC character?

Is a public company able to check out who owns its shares in very detailed format?

How do I define this subset using mathematical notation?

Nested-Loop-Join: How many comparisons and how many pages-accesses?

How to determine port and starboard on a rotating wheel space station?

Deep Learning based time series forecasting

Equivalent definitions of total angular momentum

Behavior of the zero and negative/sign flags on classic instruction sets

Why is "dark" an adverb in this sentence?

Extract an attribute value from XML

Why is dry soil hydrophobic? Bad gardener paradox

Ragged justification of captions depending on odd/even page

What is the English equivalent of 干物女 (dried fish woman)?

Does Google Maps take into account hills/inclines for route times?

Crab Nebula short story from 1960s or '70s

Is it rude to tell recruiters I would only change jobs for a better salary?

How can I legally visit the United States Minor Outlying Islands in the Pacific?

Alternatives to using writing paper for writing practice

How to fit a linear model in the Bayesian way in Mathematica?

Why hasn't the U.S. government paid war reparations to any country it attacked?

Does entangle require vegetation?

Confused about 誘われて (Sasowarete)

Will it hurt my career to work as a graphic designer in a startup for beauty and skin care?

Book or series about stones and a magician named Gwydion

DataJpaTest does not create schema

Why Spring Boot 2.0 application does not run schema.sql?spring hibernate .. H2 database - schema not foundSpring Boot. @DataJpaTest H2 embedded database create schemaSpring Boot with in memory database failsDoes a finally block always get executed in Java?Create ArrayList from arrayHow can I create an executable JAR with dependencies using Maven?Creating a memory leak with JavaMake schema created by Spring JDBC the default schemaSpring Boot auto-generated data source with EmbeddedDatabase Derby leads to “Schema '<schema-name>' does not exist”How to add the mode=mysql to embedded H2 DB in Spring Boot 1.4.1 for @DataJpaTest?Spring Boot @DataJpaTest without ddl generationGetting SQL Syntax Error when loading schema.sql file in Spring BootSpring Boot: Setting Hibernate naming strategy with @DataJpaTest and Flyway

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

2

I have a moderate size project using Spring Boot, and I am trying to create my first DataJpaTest with embedded H2, but I am getting the following exception:

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "drop table project.project.driver if exists" via JDBC Statemen
Caused by: org.h2.jdbc.JdbcSQLException: Schema "PROJECT" not found; SQL statement:

I have tried this and using a schema.sql, also this and using a test.properties in test/resources, and this other answer. But nothing worked. I am really baffled; this is the first time I face an issue in Spring Boot that I am not able to figure it out.

My entity classes are defined as:

@Entity
@Table(name = "table_name", schema = "project", catalog = "project")
@Lombok.Data
public class TableNameEntity 

Any suggestion of how to force Hibernate to create the schema in H2?

java hibernate spring-boot spring-data-jpa h2

share|improve this question

asked Mar 26 at 6:31

RaynieryRayniery

84811 gold badge88 silver badges1515 bronze badges

add a comment | 

2

I have a moderate size project using Spring Boot, and I am trying to create my first DataJpaTest with embedded H2, but I am getting the following exception:

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "drop table project.project.driver if exists" via JDBC Statemen
Caused by: org.h2.jdbc.JdbcSQLException: Schema "PROJECT" not found; SQL statement:

I have tried this and using a schema.sql, also this and using a test.properties in test/resources, and this other answer. But nothing worked. I am really baffled; this is the first time I face an issue in Spring Boot that I am not able to figure it out.

My entity classes are defined as:

@Entity
@Table(name = "table_name", schema = "project", catalog = "project")
@Lombok.Data
public class TableNameEntity 

Any suggestion of how to force Hibernate to create the schema in H2?

java hibernate spring-boot spring-data-jpa h2

share|improve this question

asked Mar 26 at 6:31

RaynieryRayniery

84811 gold badge88 silver badges1515 bronze badges

add a comment | 

I have a moderate size project using Spring Boot, and I am trying to create my first DataJpaTest with embedded H2, but I am getting the following exception:

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "drop table project.project.driver if exists" via JDBC Statemen
Caused by: org.h2.jdbc.JdbcSQLException: Schema "PROJECT" not found; SQL statement:

I have tried this and using a schema.sql, also this and using a test.properties in test/resources, and this other answer. But nothing worked. I am really baffled; this is the first time I face an issue in Spring Boot that I am not able to figure it out.

My entity classes are defined as:

@Entity
@Table(name = "table_name", schema = "project", catalog = "project")
@Lombok.Data
public class TableNameEntity 

Any suggestion of how to force Hibernate to create the schema in H2?

java hibernate spring-boot spring-data-jpa h2

share|improve this question

asked Mar 26 at 6:31

RaynieryRayniery

84811 gold badge88 silver badges1515 bronze badges

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "drop table project.project.driver if exists" via JDBC Statemen
Caused by: org.h2.jdbc.JdbcSQLException: Schema "PROJECT" not found; SQL statement:

@Entity
@Table(name = "table_name", schema = "project", catalog = "project")
@Lombok.Data
public class TableNameEntity 

share|improve this question

asked Mar 26 at 6:31

RaynieryRayniery

84811 gold badge88 silver badges1515 bronze badges

share|improve this question

asked Mar 26 at 6:31

RaynieryRayniery

84811 gold badge88 silver badges1515 bronze badges

asked Mar 26 at 6:31

RaynieryRayniery

84811 gold badge88 silver badges1515 bronze badges

asked Mar 26 at 6:31

RaynieryRayniery

84811 gold badge88 silver badges1515 bronze badges

1 Answer
1

active

oldest

votes

0

You can pass a sql script which create schema in h2`s url:

jdbc:h2:mem:somedb;DB_CLOSE_DELAY=-1;INIT=RUNSCRIPT FROM 'classpath:create_schema.sql'

And in create_schema.sql would be something like this

CREATE SCHEMA IF NOT EXISTS project;

share|improve this answer

answered Mar 26 at 7:08

mzherdevmzherdev

36211 gold badge33 silver badges1111 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I already try using a schema.sql script as I mentioned on my question. The script got executed, but when I try to use a repository it threw the exception saying that there is not schema named like that.
  
  – Rayniery
  Mar 26 at 22:02
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55351042%2fdatajpatest-does-not-create-schema%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You can pass a sql script which create schema in h2`s url:

jdbc:h2:mem:somedb;DB_CLOSE_DELAY=-1;INIT=RUNSCRIPT FROM 'classpath:create_schema.sql'

And in create_schema.sql would be something like this

CREATE SCHEMA IF NOT EXISTS project;

share|improve this answer

answered Mar 26 at 7:08

mzherdevmzherdev

36211 gold badge33 silver badges1111 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I already try using a schema.sql script as I mentioned on my question. The script got executed, but when I try to use a repository it threw the exception saying that there is not schema named like that.
  
  – Rayniery
  Mar 26 at 22:02
  

  
  
  
  

add a comment | 

0

You can pass a sql script which create schema in h2`s url:

jdbc:h2:mem:somedb;DB_CLOSE_DELAY=-1;INIT=RUNSCRIPT FROM 'classpath:create_schema.sql'

And in create_schema.sql would be something like this

CREATE SCHEMA IF NOT EXISTS project;

share|improve this answer

answered Mar 26 at 7:08

mzherdevmzherdev

36211 gold badge33 silver badges1111 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I already try using a schema.sql script as I mentioned on my question. The script got executed, but when I try to use a repository it threw the exception saying that there is not schema named like that.
  
  – Rayniery
  Mar 26 at 22:02
  

  
  
  
  

add a comment | 

You can pass a sql script which create schema in h2`s url:

jdbc:h2:mem:somedb;DB_CLOSE_DELAY=-1;INIT=RUNSCRIPT FROM 'classpath:create_schema.sql'

And in create_schema.sql would be something like this

CREATE SCHEMA IF NOT EXISTS project;

share|improve this answer

answered Mar 26 at 7:08

mzherdevmzherdev

36211 gold badge33 silver badges1111 bronze badges

jdbc:h2:mem:somedb;DB_CLOSE_DELAY=-1;INIT=RUNSCRIPT FROM 'classpath:create_schema.sql'

CREATE SCHEMA IF NOT EXISTS project;

share|improve this answer

answered Mar 26 at 7:08

mzherdevmzherdev

36211 gold badge33 silver badges1111 bronze badges

answered Mar 26 at 7:08

mzherdevmzherdev

36211 gold badge33 silver badges1111 bronze badges

answered Mar 26 at 7:08

mzherdevmzherdev

36211 gold badge33 silver badges1111 bronze badges