Using Oracle Database with JPOS framework

[Abdulrahman Ashraf Abu-Hamadi]

First of all , can i use Spring Data JPA with JPOS framework ?

Second How can i use OracleDB with JPOS ?

[Alejandro Revilla]

> First of all , can i use Spring Data JPA with JPOS framework ?

Sure, why not?

> Second How can i use OracleDB with JPOS ?

That's a question for Spring Data JPA.

--

@apr

On Tue, Sep 27, 2022 at 12:41 PM Abdulrahman Ashraf Abu-Hamadi <abdelrhman...@gmail.com> wrote:

First of all , can i use Spring Data JPA with JPOS framework ?

Second How can i use OracleDB with JPOS ?

--
--
jPOS is licensed under AGPL - free for community usage for your open-source project. Licenses are also available for commercial usage. Please support jPOS, contact: sa...@jpos.org
---
You received this message because you are subscribed to the Google Groups "jPOS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jpos-users+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/8154f2c2-6117-4027-ab27-2beacd908f8bn%40googlegroups.com.

[Abdulrahman Ashraf Abu-Hamadi]

I think i can not use spring data jpa because i want to handle the connection pooling & close the statement & the connection by myself

On Wed, Sep 28, 2022, 3:08 AM Alejandro Revilla <a...@jpos.org> wrote:

> First of all , can i use Spring Data JPA with JPOS framework ?
Sure, why not?

> Second How can i use OracleDB with JPOS ?
That's a question for Spring Data JPA.

--

@apr

On Tue, Sep 27, 2022 at 12:41 PM Abdulrahman Ashraf Abu-Hamadi <abdelrhman...@gmail.com> wrote:

First of all , can i use Spring Data JPA with JPOS framework ?

Second How can i use OracleDB with JPOS ?

--
--
jPOS is licensed under AGPL - free for community usage for your open-source project. Licenses are also available for commercial usage. Please support jPOS, contact: sa...@jpos.org
---
You received this message because you are subscribed to the Google Groups "jPOS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jpos-users+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/8154f2c2-6117-4027-ab27-2beacd908f8bn%40googlegroups.com.

--
--
jPOS is licensed under AGPL - free for community usage for your open-source project. Licenses are also available for commercial usage. Please support jPOS, contact: sa...@jpos.org
---
You received this message because you are subscribed to the Google Groups "jPOS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jpos-users+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/CAAgSK%3Dk-WRy_W%2BZLkK7X7XEfJXVdwJY6_YQq4k4qnPy%2BX-s4BQ%40mail.gmail.com.

[Victor Salaman]

You can do all that from within jPOS. There really is no limit to what you can do. 

Yes, you can use Spring Data JPA from jPOS, in fact we do it every day, with automatic wiring of Spring Boot resources inside any jPOS managed entity.

and yes, you can handle transaction demarcation yourself, although it's better if you use Spring's @Transactional annotations and let Spring automatically handle it, but you can also do your own demarcation if desired.

/V

 

To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/CAOCb55%3Dg%2BTQWAyaBN4%3DGFByuu8yOCaW3xMD2DG6jeY_faPe-vA%40mail.gmail.com.

[Alejandro Revilla]

Then you can use jPOS-EE db module. You'll need a 'db-oracle' module, very similar to 'db-mysql' and 'db-postgres'. We have one for our products, and it's super simple to create, you just need to set Hibernate's dialect, and the appropriate Oracle JDBC driver.

--

@apr

To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/CAOCb55%3Dg%2BTQWAyaBN4%3DGFByuu8yOCaW3xMD2DG6jeY_faPe-vA%40mail.gmail.com.

[Abdulrahman Ashraf Abu-Hamadi]

Am not using the db-module in JPOS , should i ? 

As this project is a softpos & million of transactions must be managed effectivelly , so should i use it ? What it will help in ?

You received this message because you are subscribed to a topic in the Google Groups "jPOS Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/jpos-users/HsOzaFuOWI0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to jpos-users+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/CAAgSK%3D%3D__MdghVA8pk91DE6FgefKRPy1Gh8rjV7Hk5xvKx1Ddw%40mail.gmail.com.

[Abdulrahman Ashraf Abu-Hamadi]

And what if i wanna roll back all the changes happened in all the previous participants and un-saving any saved records in the db ?

To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/CALK1Syzx0m_Hh7USY9kLZO2%3D077LgsKzRc_qkCgoQxqT4AWrYQ%40mail.gmail.com.

[Abdulrahman Ashraf Abu-Hamadi]

Plus am taking advantage of HikariCP "Connection Pooling"

So how can i use the spring data jpa , connection pooling requires low level management while data jpa is a high level one

[Victor Salaman]

Spring Data JPA is just an abstraction to simplify data access by exposing your data through a set of patterns (e.g. Repository, Managed transactions, etc). Underneath it's just accessing JPA, and through a JPA provider, your data (Oracle).

jPOS db module: Code -> Hibernate -> Database 

jPOS using JPA through EntityManager: Code -> JPA -> JPA provider (e.g. Hibernate) -> Database

jPOS using Spring Data JPA -> Code -> Spring Data repository -> JPA provider -> Database

Your connection pool can be used irrespective of your choice in data access as the connection pool hooks to the JPA provider and not the data access layer.

You can choose whether to have a single transaction with Open/Close transaction participants or you can open a connection when you need it. ...and now the threat of a housing market bubble. The reason for a lot of us not doing the Open/Close transactional strategy is because if your "business transaction" takes 30 seconds, that's 30 seconds where you are tying a connection pool connection, and your resources might become exhausted.

I would recommend you not to use Spring, and use the db module instead until you have a clear grasp of JPA, its transaction management and how the jPOS transaction manager works. As I said before, jPOS is limitless - it's up to you what you can do with it.

/V

[Mapfunde Venon]

Yes it's possible, i have done some implementations of JPOS with Spring and different databases.

Venon Mapfunde(PMP,Msc Software Engineering,Bsc Computer Science & Mathematics)
Tel:+263 775 091 262
Email:taka...@gmail.com
Skype: venon.mapfunde

On Tue, 27 Sept 2022 at 17:41, Abdulrahman Ashraf Abu-Hamadi <abdelrhman...@gmail.com> wrote:

First of all , can i use Spring Data JPA with JPOS framework ?

Second How can i use OracleDB with JPOS ?

--

[Abdulrahman Ashraf Abu-Hamadi]

I almost got you 👍🏻 but is there any reference or a project where i can solid my information plus from your opinion what is the best design ?

--

--
jPOS is licensed under AGPL - free for community usage for your open-source project. Licenses are also available for commercial usage. Please support jPOS, contact: sa...@jpos.org
---
You received this message because you are subscribed to the Google Groups "jPOS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jpos-users+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/CALK1Syzub3kDyREBHWLjpuSy9myqZgRjsDYJcRUh%3D%3DQVmH%3DgJQ%40mail.gmail.com.

[Abdulrahman Ashraf Abu-Hamadi]

Any links to these projects if you can i would appreciate it 🤝🏻

To view this discussion on the web visit https://groups.google.com/d/msgid/jpos-users/CAB4JUJ0T2%3Dqic9QKibkKQRWPb_eCOBm-Pj4ifLSF0fVF%3DiKddA%40mail.gmail.com.