Speedment is a Stream ORM Java Toolkit and Runtime
People
Repo info
Activity
balsundar
@balsundar
One basic doubt, i just configured speedment, connected to my postgresql db, and once i click on Generate option i got the necessary files, but i cannot find any files related to the ORM mapping or DML statements like Query to access the tables data and insert into table data like that, plz dont ignore even if it is a entry lvl query, Tnx
I ead in the document " Once the files are generated, you are ready to write your first Java Stream query." where i can write those... dont ignore as a tooo basic query
Per-Åke Minborg
@minborg
Hi again. We are only able to give advice on Speedment itself.
balsundar
@balsundar
Yes i read the Speedment document only, to write the first Java Stream query., where to do that? Thanks
tried moving version numbers around but cant get it to work
Per-Åke Minborg
@minborg
ok. We will take a look at it and get back.
Thanks
kriegster108
@kriegster108
Thankyou Sir!
Julia Gustafsson
@julgus
Hi @kriegster108, I cannot replicate the issue you are describing. May I ask you what settings you used in the initializer?
kriegster108
@kriegster108
used defaults @julgus
Dependency 'com.speedment.enterprise.connectors:oracle-connector:3.2.6' not found
Dependency 'com.speedment.enterprise.hazelcast:hazelcast-runtime:3.2.6' not found
kriegster108
@kriegster108
Weird, I see it in the repo itself, not sure why maven doesnt see it
kriegster108
@kriegster108
when I plug in 3.1.12, it seems to not complain
as the version # for these depdencies
Julia Gustafsson
@julgus
Still confused as to why this might be. On my end both dependencies are found without any issues using v. 3.2.6. Could your try using the latest released version - 3.2.10?
ANKUR PRAMANIK
@ankurpramanik
I am new to Speedment, I just created a spring boot application and using speedment:tool I connected to database. My application is working. Now in real world there are different database name in same structure like (development database name as student_dev, Production database name like student_prod) So How can I connect different database after deploying the application as war in tomcat?
And another problem I am facing with MS SQL server that, speedment tool window is not opening
_
Per-Åke Minborg
@minborg
In the speedment builder, you can set the dbms name. You can easilly pickup the name using system properties in your app.
Mark Schrijver
@ractoc
I'm currently working on a search page,. which presents me qith some issues on how best to build that in Speedment, as the entire where clause is dynamic
I have a fleet table, and a registration table.
the fleet has a start date
now, when a start date has been provided, I need to filter on this start date. If no start date has been provided, I don't need this filter
if the boolean registered is set to true, I need to link in the second table to check of the user has registered. If the boolean is set to false, this doesn't need to happen
in all cases, I only need to return a list of Fleet object
CUrrently, I have a few of the search params in there
but I'm not sure I'm doing it right, and I'm not sure how to dynamically link in that second table
Here, params.getStart() is an optional start date, params.getEnd() is an optional end date, params.isOwner() is a boolean and params.getTypes() is an optional array.
if the param is set, it needs to be filtered, if it is not present, no filter is needed
for the second table, I can easily setup a filter which opens a second stream to the other table and then to a matchAny, but I'm not sure that's the best way to go abou ti
Per-Åke Minborg
@minborg
Is the code available in a pblic repository where it might be easier for me to have a look at it?
starting at line 45I put all the filters inside IF statements, so the filters onlly get added whenrequired
this works great for simple filters on the main table
I'm just not sure what thebestway would be to link in those other two tables
I'm currently reusing the service method I already have in place, starting from line 59
but that means those methods getRegistration and getInvitation get called once per record found
which might not work so well when the table gets bigger
Per-Åke Minborg
@minborg
Hi Mark. This is the classical N+1 select problem.
As you point out, the solution does not scale that well. Why not create a join and add in the simple predicates as the table, respectively (e.g. START_DATE_TIME)?
Mark Schrijver
@ractoc
so effectively I would then be creating a select statemet joining three tables, but restricting the actual selected fields to the one table I need....
and with the distinct keyword, I could then exclude any duplicates?