Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Mark Schrijver
    @ractoc
    chaning that in the code didn't fix it though
    I have since changed my search criteria a bit to work around this problem so I don't need the outer join anymore
    this works well enough for now, and sees to speed up the query as well
    Per-Åke Minborg
    @minborg
    Great @ractoc !
    minhphuc
    @ngminhphuc

    hi, I'm generate code from mysql database to REST but when runing Spring Boot, I got message: Whitelabel Error Page
    This application has no explicit mapping for /error, so you are seeing this as a fallback.

    Thu Feb 25 16:17:09 ICT 2021
    There was an unexpected error (type=Not Found, status=404).
    No message available

    Per-Åke Minborg
    @minborg
    Which URL do you access initially?
    http://ip:port/appname/table (generated Rest Controller)
    Per-Åke Minborg
    @minborg
    Which mappings do you see in the Spring logs when you start you appliation?
    minhphuc
    @ngminhphuc
    2021-02-25 16:16:48.396 INFO 13920 --- [ main]
    com.ngminhphuc.destinymatcher.Main : Starting Main on dev-w19 with PID 13920 (E:\projects\2021\4.destinymatcher\target\classes started by minhphuc in E:\projects\2021\4.destinymatcher)
    2021-02-25 16:16:48.401 INFO 13920 --- [ main] com.ngminhphuc.destinymatcher.Main : No active profile set, falling back to default profiles: default
    2021-02-25 16:16:50.032 INFO 13920 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8000 (http)
    2021-02-25 16:16:50.049 INFO 13920 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat]
    2021-02-25 16:16:50.049 INFO 13920 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.27]
    2021-02-25 16:16:50.296 INFO 13920 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
    2021-02-25 16:16:50.297 INFO 13920 --- [ main] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 1818 ms
    2021-02-25 16:16:50.606 INFO 13920 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor'
    2021-02-25 16:16:50.919 INFO 13920 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8000 (http) with context path ''
    2021-02-25 16:16:50.927 INFO 13920 --- [ main] com.ngminhphuc.destinymatcher.Main : Started Main in 3.159 seconds (JVM running for 4.483)
    2021-02-25 16:17:08.961 INFO 13920 --- [nio-8000-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet'
    2021-02-25 16:17:08.962 INFO 13920 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
    2021-02-25 16:17:08.973 INFO 13920 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 11 ms
    Per-Åke Minborg
    @minborg
    looks like your appname/table end points are not deployed.
    Make sure your main app is in a package that has the controllers etc as a sub-package as the classpath scanner will otherwise not pick them up.
    minhphuc
    @ngminhphuc
    ok, thanks Minborg
    minhphuc
    @ngminhphuc
    hi Minborg, can you give sample of application.properties for connect mysql from another server, I've search some atrribute likes: jdbc.username=xxxx
    jdbc.password=xxxx
    url=jdbc:mysql://ip:port/dbname
    but it return error: Caused by: java.sql.SQLException: Access denied for user ....
    minhphuc
    @ngminhphuc
    how to get swagger documentation from generated REST code, maybe this feature is removed
    Per-Åke Minborg
    @minborg
    This is described in the manual
    654968949
    @654968949
    Hello, I don't want to generate the entire database, I want to use "Speedment" to generate a separate table, what do I do?
    Is anybody there?
    654968949
    @654968949
    hello!
    Per-Åke Minborg
    @minborg
    Hi there. You can just disable all other tables in the GUI or you could edit the JSON file and remove the unwanted tables.
    654968949
    @654968949
    Thanks. In fact, what I want to ask is, during the development process, I only changed one field of a table in the database, do I also need to use The GUI generate all the table data of the whole database?
    Per-Åke Minborg
    @minborg
    No. There is a special Maven target for that.
    Per-Åke Minborg
    @minborg
    654968949
    @654968949
    what is the speacil Maven target ? ^-^ My database has a large number of tables, but I have only changed a few fields, I do not want to generate all of them, which is time-consuming.Is there any way?
    654968949
    @654968949
    OK,Thank you very much!
    Per-Åke Minborg
    @minborg
    NP. I hope this fixes your problem!
    mohan610
    @mohan610
    Hello
    Per-Åke Minborg
    @minborg
    @mohan610 Hi there. What’s up?
    shebuappukuttan
    @shebuappukuttan
    morning, iam trying a sample pilot project use .net client to connect hazelcast cache which inturn loads connects to db
    please some help on this, where to start etc.,
    shebuappukuttan
    @shebuappukuttan
    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.
    Per-Åke Minborg
    @minborg
    Not sure I understand the problem. What happens when you press the “generate” button?
    Sugandha Sapra
    @XI1354-sugandhasapra
    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
    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]
    Am i missing anything here ?
    Per-Åke Minborg
    @minborg
    We will take a look at it @XI1354-sugandhasapra
    mohdsalmanshaikh63
    @mohdsalmanshaikh63
    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.
    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 DB
    Can someone help why two queries are being made while it should be ideally 1 query as it is there in the tutorial.
    Per-Åke Minborg
    @minborg
    I only see one query @mohdsalmanshaikh63 ? That query consist of two selects, perhaps that is your question?
    mohdsalmanshaikh63
    @mohdsalmanshaikh63
    Yes @minborg why is the subquery used instead of just select count(*) from.... ?
    Per-Åke Minborg
    @minborg
    This is due to an internal simplification in Speedment. The database will be able to “unroll” this abstraction in almost all cases.
    The idea is that we only want to return a single “long” and not all the fields.
    mohdsalmanshaikh63
    @mohdsalmanshaikh63
    I mean select count (*) from films where condition should be ideally used not two selects. I tried doing same count on other tables/entities and the result was same.
    Per-Åke Minborg
    @minborg
    The result will be same.
    As it turns out, it does not affect execution time significantly and consequently that optimization was not made.