Problem in petclinic tutorial // schema name incorrect

[Angel Manuel Barrera Lugo <an...@sisorg.com.mx>]

Hello,

I'm doing the petclinic-extenden tutorial, at the beginning all runs
normally but after the the step 5 "Refactoring the app - making it your own"
making all the changes in the files and in Dom.xml we're getting this error:

Caused by: java.sql.SQLException: schema name incorrect: PETCLINIC in
statement [CREATE TABLE petclinic."Pet"

even i had done the persistence change in pet
@javax.jdo.annotations.PersistenceCapable(
        identityType=IdentityType.DATASTORE,
        schema = "petclinic",
        table = "Pet"
)

But still nothing.

Re: Problem in petclinic tutorial // schema name incorrect

[Dan Haywood <da...@haywood-associates.co.uk>]

If you are using MySQL, then I think that it does not automatically create
the schemas; as Stephen says, you may need to create them manually.

if you check out the solution to step 5 (
https://github.com/johandoornenbal/petclinic_mynewcode/tree/tutorial02),
does that work or not?





On 9 March 2016 at 17:04, Stephen Cameron <st...@gmail.com>
wrote:

> does the petclinic schema exist in the database?
>
> you'll have to create it and give the user that you connect with the rights
> to modify it. I've not done the tutorial, so just a suggestion.
>
> On Thu, Mar 10, 2016 at 2:53 AM, Angel Manuel Barrera Lugo <
> angel.barrera@sisorg.com.mx> wrote:
>
> > Hello,
> >
> > I'm doing the petclinic-extenden tutorial, at the beginning all runs
> > normally but after the the step 5 "Refactoring the app - making it your
> > own"
> > making all the changes in the files and in Dom.xml we're getting this
> > error:
> >
> > Caused by: java.sql.SQLException: schema name incorrect: PETCLINIC in
> > statement [CREATE TABLE petclinic."Pet"
> >
> > even i had done the persistence change in pet
> > @javax.jdo.annotations.PersistenceCapable(
> >         identityType=IdentityType.DATASTORE,
> >         schema = "petclinic",
> >         table = "Pet"
> > )
> >
> > But still nothing.
> >
> >
> >
>

Re: Problem in petclinic tutorial // schema name incorrect

[Stephen Cameron <st...@gmail.com>]

does the petclinic schema exist in the database?

you'll have to create it and give the user that you connect with the rights
to modify it. I've not done the tutorial, so just a suggestion.

On Thu, Mar 10, 2016 at 2:53 AM, Angel Manuel Barrera Lugo <
angel.barrera@sisorg.com.mx> wrote:

> Hello,
>
> I'm doing the petclinic-extenden tutorial, at the beginning all runs
> normally but after the the step 5 "Refactoring the app - making it your
> own"
> making all the changes in the files and in Dom.xml we're getting this
> error:
>
> Caused by: java.sql.SQLException: schema name incorrect: PETCLINIC in
> statement [CREATE TABLE petclinic."Pet"
>
> even i had done the persistence change in pet
> @javax.jdo.annotations.PersistenceCapable(
>         identityType=IdentityType.DATASTORE,
>         schema = "petclinic",
>         table = "Pet"
> )
>
> But still nothing.
>
>
>