Is anybody there?
please some help on this, where to start etc.,
steps using this links "https://speedment.com/hazelcast-initializer#" works , but speedment support java files like "com.speedment.common.annotation.GeneratedCode" under com folder not getting generated
any help much appreciated.
Hi Team, I have downloaded a project from initializer & I am getting below error while loading the dependencies by maven in IntelliJ IDE
Could not transfer artifact com.speedment.enterprise.connectors:sqlserver-connector:pom:3.2.6 from/to speedment-enterprise (https://repo.speedment.com/nexus/content/repositories/releases/): Transfer failed for https://repo.speedment.com/nexus/content/repositories/releases/com/speedment/enterprise/connectors/sqlserver-connector/3.2.6/sqlserver-connector-3.2.6.pom 500 Server Error
Could not transfer artifact com.speedment.enterprise.connectors:sqlserver-connector:pom:3.2.6 from/to speedment-enterprise (https://repo.speedment.com/nexus/content/repositories/releases/): Transfer failed for https://repo.speedment.com/nexus/content/repositories/releases/com/speedment/enterprise/connectors/sqlserver-connector/3.2.6/sqlserver-connector-3.2.6.pom 500 Server Error
I have also tried on command line & getting below error
[ERROR] No plugin found for prefix 'speedment' in the current project and in the plugin groups [org.apache.maven.plugins, org.codehaus.mojo] available from the repositories [local (/home/sugandhasapra/.m2/repository), speedment-enterprise (https://repo.speedment.com/nexus/content/repositories/releases/), central (https://repo.maven.apache.org/maven2)] -> [Help 1]
[ERROR] No plugin found for prefix 'speedment' in the current project and in the plugin groups [org.apache.maven.plugins, org.codehaus.mojo] available from the repositories [local (/home/sugandhasapra/.m2/repository), speedment-enterprise (https://repo.speedment.com/nexus/content/repositories/releases/), central (https://repo.maven.apache.org/maven2)] -> [Help 1]
Am i missing anything here ?
Hi Team, I am trying out speement for my curiosity and testing it's amazingness to try it out in future projects. I have just setup a sample application using the tutorial page title
and in title
I ran the query and strangely I'm getting two queries in the output.
Can someone help why two queries are being made while it should be ideally 1 query as it is there in the tutorial.
and in title
I ran the query and strangely I'm getting two queries in the output.
2021-09-26T20:34:32.576Z INFO [main] (#APPLICATION_BUILDER) - Speedment (Open Source) version 3.2.6 by Speedment, Inc. Specification version 3.2 (Channing), License: Apache-2.0
2021-09-26T20:34:32.586Z INFO [main] (#APPLICATION_BUILDER) - Java Virtual Machine Specification 11 by Oracle Corporation. Implementation Java Platform API Specification 11.0.9 by Oracle Corporation
2021-09-26T20:34:32.594Z INFO [main] (#APPLICATION_BUILDER) - Available processors: 8, Max Memory: 4,211,081,216 bytes
Loading classcom.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
2021-09-26T20:34:34.546Z INFO [main] (#APPLICATION_BUILDER) - MySQL, 8.0.23, MySQL Connector/J mysql-connector-java-8.0.18 (Revision: fef2894d751d47223192b706977b4a5bc41e6be4), JDBC version 4.2
2021-09-26T20:34:34.770Z DEBUG [main] (#STREAM) - SELECT COUNT(*) FROM (SELECTfilm_id,title,description,release_year,language_id,original_language_id,rental_duration,rental_rate,length,replacement_cost,rating,special_features,last_updateFROMsakila.filmWHERE (rating= ? COLLATE utf8_bin)) AS A, values:[PG-13]
There are 223 PG-13 films in the DBCan someone help why two queries are being made while it should be ideally 1 query as it is there in the tutorial.
The idea is that we only want to return a single “long” and not all the fields.
As it turns out, it does not affect execution time significantly and consequently that optimization was not made.
And does it support batch operations? I just checked it doesn't I guess but this would be helpful for background batch jobs https://www.google.com/url?sa=t&source=web&rct=j&url=https://github.com/speedment/speedment/issues/539&ved=2ahUKEwjI2YDQ_6bzAhV08HMBHYM0BzcQFnoECAMQAQ&usg=AOvVaw03BXf6IFoU2iLLRlgi3sZZ
Stored procedures don't seem to be that much of an important feature unless the project requires high performance
Just tried a simple speedment example with MySQL 8 using Speedment OSS. My table has BIGINT type for Primary key and the generated code (in <table>SqlAdapter.java) is failing to compile as getBigInteger(int) is not a method available in java.sql.ResultSet. I used the speedment initializer to generate the project POM. Any pointers.. thanks.
4 replies
In using the JoinComponent to get a join object and then subsequently streaming it, it is unclear where you specify operations like limit(), skip(), count(), sum() so they will execute in the database as part of the generated SQL query. Doing this on the join object seems like they will execute on the client side once all tuples (based on JoinComponent) are fetched? Are the same optimizations (for limit, skip, count etc) that are done for single-table streaming also done for join object?
In general, it is not specified exactly how queries are optimized and where they are executed. Depending on the join pipeline, operations may infact be executed on the database side. The best way to see is turing on logging for stream operations. Then you will see exactly how queries are rendered.
Limit, for example, is tricky do do with joins in the generall case.