Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Per-Åke Minborg
    @minborg
    However, there is more to be done. If you run the query many times, I expect the difference to be much smaller.
    solangepaz
    @solangepaz
    I got those values by executing the query 10 times and calculated the mean value. I thought the same problem did not replicate with an in-memory database.
    Per-Åke Minborg
    @minborg
    Apparently, there is still some overhead that remains in the Speedment code. Since the in memory DB is much faster, the Speedment overhead becomes more apperent relatively speaking.
    mainakmandal
    @mainakmandal
    Hi Speedment team, we have a scenario where db tables have approx 50000 records and the front end web application needs a bulk CRUD operations against these tables for approx 40000 records. We are thinking to use Speedment ORM for performance improvement for such bul CRUD operations but reluctant about the performance issue as we believe generally ORMS suffer performance issues for caching such huge number of records. Will Speedment work properly with such scenarios ?
    Per-Åke Minborg
    @minborg
    @mainakmandal I think definitely yes, Speedment would be able to handle terabytes of data because data is stored off-heap. Let me know how it works out for you guys.
    Anush B M
    @BMAnush
    Hi...encountered into Speedment recently...would like to try it out....having trouble getting started....once I am done generating the entities....how do I run them as a spring boot application and how to I trigger them as an API?
    Documentation jumps too fast from basic to advanced....finding it hard to get the connectivity....
    Per-Åke Minborg
    @minborg
    @BMAnush Hi! There is a Spring Boot plugin you can activate that will generate a lot of connetivity code for you. Have you read the Wiki? https://github.com/speedment/speedment/wiki/Tutorial:-Speedment-Spring-Boot-Integration
    The Wiki is for “manual” integration whereas the plugin generates code automatically.
    Let me know if that helps you back on track again!
    Anush B M
    @BMAnush
    Thank you @minborg ....I shall take a look at that tutorial.....I believe this should help out in getting started....
    Per-Åke Minborg
    @minborg
    @BMAnush Great to hear!
    Arnab Samanta
    @arnab192
    is there any way to convert join<Tuple4> object to join<Tuple3> . I need it as join object.
    Per-Åke Minborg
    @minborg
    I think the easiest way to get a Tuple3 from 4 joined tables is to provide a custom constructor in the .build() method. For example build((a, b, c, d) -> Tuples.of(b, c, d)) if you only want b, c, and d and not a.
    Arnab Samanta
    @arnab192
    Thanks @minborg . this is the solution I was looking for. I have another query - is there any way to construct join query dynamically? that mean sometimes I am using 3 entity sometimes I am using 4 entity to join . I need to construct that query dynamically.
    Per-Åke Minborg
    @minborg
    Sure. That can be done easily. If they both return Tuple3 for example, you can treat them in the same code branch.
    After an if statement for example.
    Arnab Samanta
    @arnab192
    Hi @minborg , I am unable to insert a json type column data in postgres.
    same speedment class working with postgres 10 version but it is not working postgres 12
    Per-Åke Minborg
    @minborg
    ok. Do you have a stack trace? Maybe 12 does more validation than 10?
    Also, would it be possible to show the code that does the insert?
    Arnab Samanta
    @arnab192
    @minborg please look into log trace.
    Per-Åke Minborg
    @minborg
    @arnab192 A work-around is to use a parameter stringtype=unspecified in the JDBC connection URL/options
    Per-Åke Minborg
    @minborg
    I have opened a new issue for this speedment/speedment#761 Thanks for reporting this.
    Per-Åke Minborg
    @minborg
    Yes
    Done. I have removed any non-java/speedment specifics
    Arnab Samanta
    @arnab192
    thanks
    Benjamin Evrard
    @bevrard
    Hello :) I've a question about the speedment-entreprise-maven-plugin. Is it a specific maven repository? because Intellij can't find this package from com.speedment.entreprise. Thanks in advance
    Per-Åke Minborg
    @minborg
    You need to setup the repositories too. You get this setting automatic if you use the speedment initializtier http://speedment.com/initializer
      <repositories>
            <repository>
                <id>speedment-enterprise</id>
                <name>Speedment Enterprise Repositories</name>
                <url>https://repo.speedment.com/nexus/content/repositories/releases/</url>
            </repository>
        </repositories>
    
        <pluginRepositories>
            <pluginRepository>
                <id>speedment-enterprise</id>
                <name>Speedment Enterprise Repositories</name>
                <url>https://repo.speedment.com/nexus/content/repositories/releases/</url>
            </pluginRepository>
        </pluginRepositories>
    `
    Benjamin Evrard
    @bevrard
    Indeed it was missing :-) then I get:
     Failed to retrieve plugin descriptor for com.speedment.enterprise:speedment-enterprise-maven-plugin:3.1.17:
    Per-Åke Minborg
    @minborg
    ok. Let me check that.
    Are you using a proxy?
    Per-Åke Minborg
    @minborg
    in your settings.xml?
    Benjamin Evrard
    @bevrard
    Here is my settings.xml:
    <?xml version="1.0" encoding="UTF-8"?>
    <settings xmlns="http://maven.apache.org/POM/4.0.0"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://maven.apache.org/POM/4.0.0
               http://maven.apache.org/xsd/settings-1.0.0.xsd">
    
        <localRepository>c:/j/r</localRepository>
    
    
    
        <mirrors>
    
    
             <mirror>
              <id>nexus</id>
              <name>UK Central</name>
              <url>http://uk.maven.org/maven2</url>
              <mirrorOf>central</mirrorOf>
            </mirror>
    
            <mirror>
              <id>speed</id>
              <name>UK Central</name>
              <url>https://repo.speedment.com/nexus/content/repositories/releases/</url>
              <mirrorOf>central</mirrorOf>
            </mirror>
    
        </mirrors>    
    
        <profiles>
    
            <profile>
                <id>nexus</id>
                <repositories>
                    <repository>
                        <id>central</id>
                        <url>http://uk.maven.org/maven2</url>
                        <releases>
                            <enabled>true</enabled>
                        </releases>
                        <snapshots>
                            <enabled>true</enabled>
                        </snapshots>
                    </repository>
                </repositories>
                <pluginRepositories>
                    <pluginRepository>
                        <id>central</id>
                        <url>http://uk.maven.org/maven2</url>
                        <releases>
                            <enabled>true</enabled>
                        </releases>
                        <snapshots>
                            <enabled>true</enabled>
                        </snapshots>
                    </pluginRepository>
                </pluginRepositories>
            </profile>
    
            <profile>
                <id>speed</id>
                <repositories>
                    <repository>
                        <id>central</id>
                        <url>https://repo.speedment.com/nexus/content/repositories/releases/</url>
                        <releases>
                            <enabled>true</enabled>
                        </releases>
                        <snapshots>
                            <enabled>true</enabled>
                        </snapshots>
                    </repository>
                </repositories>
                <pluginRepositories>
                    <pluginRepository>
                        <id>central</id>
                        <url>https://repo.speedment.com/nexus/content/repositories/releases/</url>
                        <releases>
                            <enabled>true</enabled>
                        </releases>
                        <snapshots>
                            <enabled>true</enabled>
                        </snapshots>
                    </pluginRepository>
                </pluginRepositories>
            </profile>
    
        </profiles>
    
        <activeProfiles>
            <!-- Make the profile active all the time -->
            <activeProfile>nexus</activeProfile>
            <activeProfile>speed</activeProfile>
    
        </activeProfiles>
    
    
    </settings>
    For me there is no proxy settings
    I'm doing: mvn -U clean install and then mvn speedment:tool
    Per-Åke Minborg
    @minborg
    ok. And you are not behind a firewall that restricts your access in any way?
    Benjamin Evrard
    @bevrard
    It's a company laptop, but I'm not connected to the vpn, so I think that I should not be behind a proxy?
    Benjamin Evrard
    @bevrard
    It finally works
    I add to add the dependency in the pom.xml
    <dependency>
                <groupId>com.speedment.enterprise</groupId>
                <artifactId>speedment-enterprise-maven-plugin</artifactId>
                <version>3.1.17</version>
            </dependency>
    Benjamin Evrard
    @bevrard
    The spring-plugin generates only "GET" method? there is nothing for PUT and POST?
    Per-Åke Minborg
    @minborg
    Great that it works! The spring plugin only generates GET methods but there are many features of the GET method such as filtering, order , skip and limit
    Benjamin Evrard
    @bevrard
    Thanks for your feedback :) speedment is a great tool! (do you plan to add post and put for rest?)
    Per-Åke Minborg
    @minborg
    It is on the to-do list
    Mark Schrijver
    @ractoc
    I'm trying to get the StringToEnumTypeMapper to work. I have a table with an item_type column. This is a string column, which I want to map to an enum in my Java code.
    To do this, I setup the StringToEnumTypeMapper in my pom where I generate the json and the code:
    <plugin>
    <groupId>com.speedment</groupId>
    <artifactId>speedment-maven-plugin</artifactId>
    <version>${speedment.version}</version>
    <dependencies>
    <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>${mysql.version}</version>
    </dependency>
    </dependencies>
    <configuration>
    <dbmsPassword>**</dbmsPassword>
    <configFile>${project.basedir}/src/main/resources/json/speedment.json</configFile>
    <packageLocation>target/generated-sources/java</packageLocation>
    </configuration>
    <executions>
    <execution>
    <id>Add ItemType typeMapper</id>
    <phase>generate-sources</phase>
    <goals>
    <goal>edit</goal>
    </goals>
    <configuration>
    <set>typeMapper:com.speedment.plugins.enums.StringToEnumTypeMapper</set>
    <what>column</what>
    <where>name:item_type</where>
    </configuration>
    </execution>
    <execution>
    <id>Add ItemType enumConstants</id>
    <phase>generate-sources</phase>
    <goals>
    <goal>edit</goal>
    </goals>
    <configuration>
    <set>enumConstants:BOARDGAMES</set>
    <what>column</what>
    <where>name:item_type</where>
    </configuration>
    </execution>
    <execution>
    <id>Generate code for Mysql</id>
    <phase>generate-sources</phase>
    <goals>
    <goal>generate</goal>
    </goals>
    </execution>
    </executions>
    </plugin>
    When I run this code, I keep getting the error:
    com.speedment.generator.translator.exception.SpeedmentTranslatorException: Could not find appropriate database type for column 'ColumnImpl {"databaseType": "java.lang.String", "nullable": true, "name": "item_type", "id": "item_type", "ordinalPosition": 4, "typeMapper": "com.speedment.plugins.enums.StringToEnumTypeMapper", "enumConstants": "BOARDGAMES"}'.
    I have the dependency containing the StringToEnumTypeMapper in my dependencies: