streamx-co/fluentjpa

Fluent API for writing typesafe SQL queries in Java for JPA.

fluentjpa's Issues

Error when comping code with Java 9+ modular system

I am using Java 11 to write a desktop application that uses hibernation as JPA provider.

When I try to compile the code I get this error:
Modules jpa.notations and fluent.jpa export package co.streamx.fluent.JPA.spi to module java.persistence
my `module-info.java' file:

module org.sarc.ekrima.geany {
    requires javafx.fxml;
    requires javafx.controls;
    requires simplefx;
    requires java.persistence;
    requires com.h2database;
    requires java.sql;
    requires org.hibernate.orm.core;
    requires jpa.notations;
    requires fluent.jpa;
    requires sql.grammar;
    requires jdk.xml.dom;
    requires javafx.swing;
    requires io.nayuki.qrcodegen;
    requires io.github.classgraph;
    exports org.sarc.ekrima.geany.ui to simplefx;
    opens org.sarc.ekrima.geany.ui to javafx.fxml;
    exports org.sarc.ekrima.geany.backend.entities to org.hibernate.orm.core;
    exports org.sarc.ekrima.geany;
}

The error is caused by 2 lines:

    requires jpa.notations;
    requires fluent.jpa;

Secondary packaging

I don't want to write FROM and SELECT every time. Can we packaging FluentJPA.SQL again. Only pass the WHERE condition and return a complete SQL statement

Licensing

For example, if you are running FluentJPA on your server, to provide a SaaS services, you would have to give away all of your source code.

I think this does not hold, since your specific software is not meant to be used by a user over a network. Pls. double check. Also read the page you refer to:

https://www.gnu.org/licenses/why-affero-gpl.html

Which links to:
https://www.gnu.org/philosophy/who-does-that-server-really-serve.html

itext is an interesting example of an APGL library, where the AGPL approach for dual licensing seems to work. Maybe their approach works out since the (end) user gets the PDF and generating PDFs is an explicit function of the including software. So there is user interaction for the purpose of generating the PDF.

I recommend to release the basic product simply under Apache and make money with addons, support and training. Even GPL is too restrictive and hinders adoption.

Sorry to bring this up as first issue. But I wouldn't make the effort, if I didn't see any potential here ;)

Support @PrimaryKeyJoinColumn in inheritance mapping

Provide support for the second case described in https://thoughts-on-java.org/hibernate-tip-difference-between-joincolumn-and-primarykeyjoincolumn/

Is it open source?

Can I just copy paste and use it in company

Support of Generics

I'm trying to implement a query with generic type in a base repository.

public List<T> getByName(String name) {
    FluentQuery query = FluentJPA.SQL((T animal) -> {
        SELECT(animal);
        FROM(animal);
    });

    Stream<?> stream = query.createQuery(getEntityManager()).getResultStream();
    return stream.map(x -> (T) x)
            .collect(Collectors.toList());
}

But instead of the concrete @entity type the @MappedSuperclass is used.

org.springframework.dao.InvalidDataAccessApiUsageException: Cannot calculate table reference from: class com.github.tomschi.fluentjpa.genericissue.AbstractAnimal; nested exception is java.lang.IllegalStateException: Cannot calculate table reference from: class com.github.tomschi.fluentjpa.genericissue.AbstractAnimal

Full example: https://github.com/Tomschi/fluentjpa-issues

Is this an issue?

Unable to import subQuery() method

After going through the FluentJPA Implementation on DZone. I was able to import all the statements like FluentJPA, FluentSQL, But I was unable to import subQuery into my program we have installed only fluent-jpa

So we need to import another maven package to access subQuery method??

How to resolve this issue??