Re: Cayenne and Spring?

2018-01-09 Thread Fredrik Widengren
ice return types. It's easy to do and > that way your JSON API design won't change with your DB design. > > Cheers, > - hugi > > > > On 9 Jan 2018, at 20:51, Fredrik Widengren > wrote: > > > > Thanks for your help! > > > > Below you can se

Re: Cayenne and Spring?

2018-01-09 Thread Fredrik Widengren
I'm using Maven. Pom.xml is attached. /Fredrik 2018-01-09 22:11 GMT+01:00 Emerson Castañeda : > What building tool are you using. > > May you include project configuration file (pom.xml, build.gradle, etc) ? > > On Tue, Jan 9, 2018 at 3:51 PM, Fredrik Widengren < > f

Re: Cayenne and Spring?

2018-01-09 Thread Fredrik Widengren
T+01:00 Andrus Adamchik : > To clarify, I realize you are using Spring, but Spring is many things. So > maybe you can post here the relevant code (of a REST endpoint?), so that we > can advise on serialization. > > Andrus > > > > On Jan 9, 2018, at 10:04 AM, Andrus Adamchik

Re: Cayenne and Spring?

2018-01-08 Thread Fredrik Widengren
Do you have the Jackson libraries included in your project? They are > normally needed for JSON serialization/deserialization. > > On Mon, Jan 8, 2018 at 4:52 PM, Fredrik Widengren < > fredrik.wideng...@gmail.com> wrote: > >> Hello, >> >> I'm tes

Cayenne and Spring?

2018-01-08 Thread Fredrik Widengren
Hello, I'm testing to setup Cayenne with Spring Boot. I have created a simple REST service. Spring is working fine with a Hello World example from Spring.io. When I try to send back my cayenne objects that I have generated from the Cayenne modeller, I get an exception that it can’t find a JSON se

Re: Re-engineering DB fails to load stored procedures 4.0M3

2017-08-01 Thread Fredrik Widengren
n either use M4 or later if you > can, or manually create required procedures. > > [1] https://issues.apache.org/jira/browse/CAY-2128 > > On Fri, Jul 28, 2017 at 7:38 PM, Fredrik Widengren > wrote: >> Hello, >> >> I'm trying to re-engineer a db with

Re-engineering DB fails to load stored procedures 4.0M3

2017-07-28 Thread Fredrik Widengren
Hello, I'm trying to re-engineer a db with the modeller. I'm using 4.0M3. I have had issues with it before but have usually been successful at last, but now I just can't get it right. It works fine with the 4.0 beta release, but I'm using the legacy naming class since before. That one is not avail

Re: How to setup cayenne for tables with meaningful pk

2016-06-16 Thread Fredrik Widengren
n/resources/cbe-inserting.map.xml > > > You can download the two XML files and load it up in Cayenne Modeler to > take a look. You need to make sure your meaningful PK is mapped as a Java > attribute and set the value before calling commitChanges(). And to second > what Ari said,

How to setup cayenne for tables with meaningful pk

2016-06-11 Thread Fredrik Widengren
Hello I'm kind of new to Cayenne. So sorry if the question bordering to the obvious. I'm trying find out how I can create records where the db does not auto generate pk. First I got an error where Cayenne complained on that the AUTO_PK table was missing. After creating that, I can create records,

Re: StoredProcedures and Cayenne

2016-04-24 Thread Fredrik Widengren
gt; > Thanks for more info. Trying to find time to setup a test env with your > exact procedure. > > > >>> CALL StoreDepartments(id_store); > > > > I asked before, but I don't see you mentioning it anywhere. > 'StoreDepartments'

Re: StoredProcedures and Cayenne

2016-04-21 Thread Fredrik Widengren
ect 2016-04-20 6:10 GMT+02:00 Fredrik Widengren : > Hello Andrus, > Thanks for trying to help out. I'm using MariaDB > (10.1.12-MariaDB-1~trusty), (org.mariadb.jdbc.Driver, JAR file > mariadb-java-client-1.2.0.jar). > > I can check Cayenne version 4.0.M3 also. > > /Fred

Re: StoredProcedures and Cayenne

2016-04-19 Thread Fredrik Widengren
> > Wondering what version of MySQL you are using? And can you also post the > contents of "StoreDepartments" procedure? Perhaps I'll be able to reproduce. > > Also would it be possible for you to try it with Cayenne 4.0.M3? > > Andrus > > > > On

Fwd: StoredProcedures and Cayenne

2016-04-14 Thread Fredrik Widengren
Reposting my question, just in case. -- Forwarded message -- From: Fredrik Widengren Date: 2016-04-14 22:17 GMT+02:00 Subject: StoredProcedures and Cayenne To: user@cayenne.apache.org Hello, I'm trying to launch a stored procedure which is returning rows with a numb

StoredProcedures and Cayenne

2016-04-14 Thread Fredrik Widengren
Hello, I'm trying to launch a stored procedure which is returning rows with a number of columns. I try to follow the documentation but don't understand why I get these errors. As you can see, the text "After query" is not printed in the log. Which I then assume mean that something goes wrong in

StoredProcedures not working

2016-03-15 Thread Fredrik Widengren
Hello, Has anyone experience of this issue? I'm executing a stored procedure from via cayenne. I have succeeded with another one, which is workign correctly. That one does nto return any data. However, when I try to run this procedure I get the error below. It seam like it does not find the proce