Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    simba920529
    @simba920529
    when i don't check enabled then?
    And I'm going to develop crud system with java springboot speedment backend.
    Per-Åke Minborg
    @minborg
    I will check if I get hold of @dekmm who is the expert on this.
    simba920529
    @simba920529
    I need a lot of GET and POST request.Could i use hyperstream?
    Hyperstream is useful just for readonly?
    And could i generate code for specific table?
    Mislav Miličević
    @dekmm
    Hi @simba920529 could you send me some screenshots of the settings you're setting in the tool (REST settings in particular). It would be really helpful in this situation :)
    simba920529
    @simba920529
    And could i customize my rest api and develop on it?
    Per-Åke Minborg
    @minborg
    Hyperstream can read a snapshot of the database and is then ultrafast for querying. You can take snapshots often (say each minute).
    simba920529
    @simba920529
    So just for GET request?
    image.png
    here is
    Mislav Miličević
    @dekmm
    Thank you very much. I'll try to recreate your problem locally and get back to you ASAP.
    simba920529
    @simba920529
    Thank you
    simba920529
    @simba920529
    Hyperstream Datastore is only for readonly?
    Could i update database with datastore?
    Per-Åke Minborg
    @minborg
    You can update the database when you run datastore, but changes are only seen in datastore upon reload.
    simba920529
    @simba920529
    Could you show me sample?
    simba920529
    @simba920529
    What is the method that can commit datastore changes to db?
    Per-Åke Minborg
    @minborg
    Changes are always made to the database directly. So persist() for example, writes data to the database. These changes can later be picked up by datastore using reload()
    simba920529
    @simba920529
    I'm using Mysql for speedment.
    I need a lot of concurrent request so what is the best solution for load balancing with speedment?
    simba920529
    @simba920529
    How could i implement in speedment for ORDER BY RAND()?
    simba920529
    @simba920529
    I think default value setting in db is not working on speedment
    Per-Åke Minborg
    @minborg
    You can use any load balancer if you, for example, deploy your speedment app with a web server.
    I think ORDER BY RAND() is one of the corner cases that is difficult to do with Speedment. You need to do SQL in such cases.
    Read more on how to use default values in the DB here: https://speedment.github.io/speedment-doc/crud.html#selecting-fields-to-persist
    Reddington12
    @Reddington12
    I am following Tutorial: Build a Social Network and I got a problem connecting to database via speedment:tool. Could someone please explain what could be the error by this stacktrace?
    java.util.concurrent.CompletionException: com.speedment.runtime.core.exception.SpeedmentException: Unable to get connection using url "jdbc:mysql://127.0.0.1:3306/?useUnicode=true&characterEncoding=UTF-8&useServerPrepStmts=true&zeroDateTimeBehavior=convertToNull&useSSL=false&nullNamePatternMatchesAll=true&useLegacyDatetimeCode=true", user = "root", password = "**".
    at java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:273)
    at java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:280)
    at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1629)
    at java.util.concurrent.CompletableFuture$AsyncRun.exec(CompletableFuture.java:1618)
    at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
    at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
    at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692)
    at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)
    Caused by: com.speedment.runtime.core.exception.SpeedmentException: Unable to get connection using url "jdbc:mysql://127.0.0.1:3306/?useUnicode=true&characterEncoding=UTF-8&useServerPrepStmts=true&zeroDateTimeBehavior=convertToNull&useSSL=false&nullNamePatternMatchesAll=true&useLegacyDatetimeCode=true", user = "root", password = "**".
    at com.speedment.runtime.core.internal.component.ConnectionPoolComponentImpl.newConnection(ConnectionPoolComponentImpl.java:123)
    at com.speedment.runtime.core.internal.component.ConnectionPoolComponentImpl.getConnection(ConnectionPoolComponentImpl.java:95)
    at com.speedment.runtime.core.internal.component.ConnectionPoolComponentImpl.getConnection(ConnectionPoolComponentImpl.java:79)
    at com.speedment.runtime.core.internal.db.AbstractDbmsMetadataHandler.getConnection(AbstractDbmsMetadataHandler.java:779)
    at com.speedment.runtime.core.internal.db.AbstractDbmsMetadataHandler.lambda$readSchemaMetadata$4(AbstractDbmsMetadataHandler.java:171)
    at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1626)
    ... 5 more
    Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:545)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1606)
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:633)
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:347)
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:219)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:247)
    at com.speedment.runtime.core.internal.component.ConnectionPoolComponentImpl.newConnection(ConnectionPoolComponentImpl.java:116)
    ... 10 more
    ........
    I use the same password as when i login to mariadb as root so I dont see why it is a problem?
    Per-Åke Minborg
    @minborg
    According to Access denied for user 'root'@'localhost' (using password: NO) you are not providing any password.
    That is weard since you say you do.
    vishnukrazybee
    @vishnukrazybee
    alter table user modify column updated_on TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6);
    alter table user modify column created_on TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) ; => but when i try to update or insert data into table using speed orm the updated and createdon columns are null
    vishnukrazybee
    @vishnukrazybee
    @minborg can u please help with the query
    Per-Åke Minborg
    @minborg
    @vishnukrazybee You have to “exclude” the fields during update. Read more here: https://speedment.github.io/speedment-doc/crud.html#selecting-fields-to-update
    Reddington12
    @Reddington12

    According to Access denied for user 'root'@'localhost' (using password: NO) you are not providing any password.

    I realized that the information I gave you did not help. I did not have any password for root but I have changed and set a password for root and still the same error. So I tried to run it on terminal and it said. ool failed: A required class was missing while executing com.speedment:speedment-maven-plugin:3.0.2:tool: javafx/beans/property/ObjectProperty.

    Does this mean I need to change somethinh from the project i cloned from your tutorial?
    Per-Åke Minborg
    @minborg
    @Reddington12 It appears that you are running a Java 8 version that does not include JavaFX. Use Oracle JDK 8 which includes JavaFX or use Java11 and JavaFX will be pulled in as an externa dependency.
    Reddington12
    @Reddington12
    Should I add something after changing the build path på java11 because I still get the same error but this time before it even opens the speedment window
    Reddington12
    @Reddington12
    Also get this;
    [INFO] The expected .json-file '/Users/m/Desktop/Server/SocialPhotoNetworkServer/src/main/json/speedment.json' does not exist.
    [INFO] The expected .json-file '/Users/m/Desktop/Server/SocialPhotoNetworkServer/src/main/json/speedment.json' does not exist.
    Per-Åke Minborg
    @minborg
    Have you used the Speedment initializer to set up your project? More often than not, it reduces problems like this: https://speedment.com/download/
    Reddington12
    @Reddington12
    No I havent. Should I put the files in the same map as the server project?
    Per-Åke Minborg
    @minborg
    you should replace your current pom.xml file with the one from the initializer (save your old for reference)
    Reddington12
    @Reddington12
    It looks a lot better now
    But I get this errors now
    • Unable to get connection using url "jdbc:oracle:thin:@127.0.0.1:1521:orcl", user = "root", password = "**".
      java.sql.SQLRecoverableException: IO-fel: The Network Adapter could not establish the connection
    Let me know if that helps!