tag:blogger.com,1999:blog-1608705335066798875.post2935752007679127889..comments2024-03-28T10:35:56.987+01:00Comments on IoC : Ulises Fasoli's blog: Spring boot and spring data jpa tutorial - A sample application using spring 4.0 spring boot and JPA (part 2/2)Ulises Fasolihttp://www.blogger.com/profile/18263942972377086645noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-1608705335066798875.post-31487027542740275022016-10-08T00:11:59.454+02:002016-10-08T00:11:59.454+02:00Hi,
I'm a noob but let me figure out. I'm...Hi,<br /><br />I'm a noob but let me figure out. I'm basically trying to build an app that takes in URL and generate a report on the given URL's.<br /><br />Thank you for your response.<br /><br />Nirupanirupa borichahttps://www.blogger.com/profile/12375370262259045987noreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-79081853926068081072016-10-07T10:27:56.616+02:002016-10-07T10:27:56.616+02:00Hi,
This is an old project I wrote specifically fo...Hi,<br />This is an old project I wrote specifically for 1 use case in my previous company.<br />I'm pretty sure it will not run in the current state, however you can get the code and adapt it to make it work.<br />Basically you use the config.properties to tell the program the "left" and "right" files to compare as well as the output folder, this will the use the diff library to generate a HTML diff report; hope this helps<br /><br />UlisesUlises Fasolihttps://www.blogger.com/profile/18263942972377086645noreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-23138239493564998542016-10-05T18:37:04.290+02:002016-10-05T18:37:04.290+02:00Hi, I have a question regarding your github reposi...Hi, I have a question regarding your github repository. Can you please give steps to run batch-diff-generator project? <br /><br />Thanks,<br />Nirupanirupa borichahttps://www.blogger.com/profile/12375370262259045987noreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-87796641618469734782016-03-11T23:57:47.237+01:002016-03-11T23:57:47.237+01:00Hi!
I have tested your sample project to use HSQL...Hi!<br /><br />I have tested your sample project to use HSQLDB filesystem database and your properties, and the same problem happens. No database (.data file) is created.<br /><br />I have read that this is imposible to work because in the SpringBoot code the use of memory databases is hardcoded:<br /><br />http://stackoverflow.com/questions/32398935/spring-boot-does-not-use-hsqldbs-file-based-database-when-configured-to-do-so<br /><br />I will try the solution proposed there and will tell you.<br /><br />Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-8376614933083431272016-03-10T21:05:17.679+01:002016-03-10T21:05:17.679+01:00Hi,
the project is hosted in Bitbucket, because i...Hi,<br /><br />the project is hosted in Bitbucket, because it's still private. I'd like to finish a stable version and clean the code before making it public (I will, in the near future, maybe it can be usefull for others).<br /><br />Can I add you to my contacts in Google plus or something like that? I will send you a link so that you can check the code (or even send you the code in a zip file, there is no problem at all).<br /><br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-91581936888205914282016-03-10T13:33:13.751+01:002016-03-10T13:33:13.751+01:00Hi, could you put your code on github or something...Hi, could you put your code on github or something so I can take a look?<br /><br />Ulises Fasolihttps://www.blogger.com/profile/18263942972377086645noreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-76697437485984298962016-03-09T22:35:37.379+01:002016-03-09T22:35:37.379+01:00Hi,
thank you for your answer. I have tested your...Hi,<br /><br />thank you for your answer. I have tested your properties (and removed mine first) but the database is not created in the file system.<br /><br />I mean, some files are created:<br /><br />- test.properties (some properties for the db)<br />- test.log (the last queries executed)<br />- test.script (a file containing the queries that will "restore" your database when the system is restarted).<br /><br />If I modify the .script file and start the app, the "database" is modified too. This means that this script is loaded in memory, and thus the database is actually stored in memory.<br /><br />No test.data file (the real binary file, the database in the filesystem) appears.<br /><br />(You can have a look at this in case it clarifies: http://www.hsqldb.org/doc/1.8/guide/apc.html)<br /><br />Maybe I'm doing something wrong. Did you manage to get the "your_db_name".data file? I hope you did, so I can learn how to do it :-)<br /><br />Once more, thanks for your help!<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-35884541244511520322016-03-09T11:32:46.164+01:002016-03-09T11:32:46.164+01:00Hi,
yes I've managed to successfully create a...Hi, <br />yes I've managed to successfully create a file database.<br />this are the values I've used in the application.properties file<br /><br />spring.datasource.url=jdbc:hsqldb:file:${project.basedir}/db/mydb;shutdown=true<br />spring.datasource.username=SA<br />spring.datasource.password=<br />spring.jpa.database=HSQL<br /><br />with ${project.basedir} being filtered by maven<br /><br />Ulises<br />Ulises Fasolihttps://www.blogger.com/profile/18263942972377086645noreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-60325311579440249002016-03-09T01:06:59.525+01:002016-03-09T01:06:59.525+01:00Hi!
Thank you for your post, great job. I'd l...Hi!<br /><br />Thank you for your post, great job. I'd like to ask you something. Did you manage to create the database using the file system? (I mean, no tables in memory).<br /><br />I'm asking because when I set my application.properties to use jdbc:hsqldb:file:PATH, some files are created (log, properties...) but no .data file appears.<br /><br />I have used HSQLDB in other projects and usually there is a binary file (the real database), having all the info.<br /><br />But file databases dont seem to work with Spring Boot. Even if I open my database using a SQL client (such as Squirrel), no tables appear.<br /><br />Any idea?<br /><br />Thank you very much in advance!<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-18469579466396060162016-01-02T14:14:50.093+01:002016-01-02T14:14:50.093+01:00Hi,
No I'm not using JooQ in this tutorial.
O...Hi,<br />No I'm not using JooQ in this tutorial. <br />Only JPA/HibernateUlises Fasolihttps://www.blogger.com/profile/18263942972377086645noreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-43665336594567444572016-01-02T07:38:00.394+01:002016-01-02T07:38:00.394+01:00The code generation from the database... you were ...The code generation from the database... you were referring to JOOQ, right? Kevin Tanhttps://www.blogger.com/profile/17955726120786666649noreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-20371962587103635362014-10-31T08:59:10.186+01:002014-10-31T08:59:10.186+01:00Hi , thanks for the comment!
Regarding the xml tag...Hi , thanks for the comment!<br />Regarding the xml tags being wrong it has something to do with the highlighter plugin that removes camel casing, I don't know why..Ulises Fasolihttps://www.blogger.com/profile/18263942972377086645noreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-11267199515024749282014-10-30T21:27:36.029+01:002014-10-30T21:27:36.029+01:00Sorry, I was referring to your part one of this su...Sorry, I was referring to your part one of this subject...<br /><br />cheers, <br />AchimAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-22622427255750194272014-10-30T21:26:26.323+01:002014-10-30T21:26:26.323+01:00Hi Ulises,
thx for this tutorial. Really.
But I...Hi Ulises, <br />thx for this tutorial. Really. <br /><br />But I want to point out that in the mvn quotes "groupId" is written as "groupid" which causes mvn to fail. <br /><br />cheers, <br />AchimAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-73726282353781750362014-02-17T16:57:51.816+01:002014-02-17T16:57:51.816+01:00Hi it would seem hibernate is not picking up Workf...Hi it would seem hibernate is not picking up WorkflowVariableInstance as a JPA/Hibernate entity.<br />Is your class properly annotated with @Entity?<br /><br />Ulises Fasolihttps://www.blogger.com/profile/18263942972377086645noreply@blogger.comtag:blogger.com,1999:blog-1608705335066798875.post-28110697308968591942014-02-17T00:21:53.855+01:002014-02-17T00:21:53.855+01:00I tried to use @Query annotation:
@Repository
pub...I tried to use @Query annotation:<br /><br />@Repository<br />public interface WorkflowVariableInstanceRepository extends JpaRepository {<br /> @Query("SELECT v FROM WorkflowVariableInstance v WHERE v.workflowVariableId = :workflowVariableId AND v.workflowInstanceId = :workflowInstanceId")<br /> WorkflowVariableInstance findByCustomParams(@Param("workflowVariableId") Long workflowVariableId,<br /> @Param("workflowInstanceId") Long workflowInstanceId);<br /><br />}<br /><br />but I get:<br /><br />org.hibernate.hql.internal.ast.QuerySyntaxException: WorkflowVariableInstance is not mappedAnonymoushttps://www.blogger.com/profile/04037708045012639897noreply@blogger.com