Hello Dan, The client software provides both embedded and remote connections. Let's first agree if I need to make modifications in the following Ofbiz configuration before proceeding.
I tried the embedded connection with URL = 'jdbc:derby:ofbiz;create=true' the connection succeeds but it only showing schemas 'APP' and 'SQLJ' and no mention to "ofbiz'. I also tried the remote connection with default port 1527 exposed by docker and have the URL 'jdbc:derby://localhost:1527/ofbiz;create=true' and heree's the error message I'm getting: DBMS: Apache Derby (ver. 10.16.1.1 - (1901046)) Case sensitivity: plain=upper, delimited=exact Driver: Apache Derby Embedded JDBC Driver (ver. 10.16.1.1 - (1901046), JDBC4.2) A communications error has been detected: Connection reset. Regards, Emad <datasource name="localderby" helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO" schema-name="OFBIZ" field-type-name="derby" check-on-start="true" add-missing-on-start="true" use-pk-constraint-names="false" use-indices-unique="false" alias-view-columns="false" use-order-by-nulls="true" offset-style="fetch"> <read-data reader-name="tenant"/> <read-data reader-name="seed"/> <read-data reader-name="seed-initial"/> <read-data reader-name="demo"/> <read-data reader-name="ext"/> <read-data reader-name="ext-test"/> <read-data reader-name="ext-demo"/> <!-- beware use-indices-unique="false" is needed because of Derby bug with null values in a unique index --> <inline-jdbc jdbc-driver="org.apache.derby.jdbc.EmbeddedDriver" jdbc-uri="jdbc:derby:ofbiz;create=true" jdbc-username="ofbiz" jdbc-password-lookup="derby-ofbiz" isolation-level="ReadCommitted" pool-minsize="2" pool-maxsize="250" test-on-borrow="true" pool-jdbc-test-stmt="values 1" soft-min-evictable-idle-time-millis="600000" time-between-eviction-runs-millis="600000"/> <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/DerbyDataSource" isolation-level="ReadCommitted"/> --> </datasource> On Tue, May 28, 2024 at 5:37 PM Daniel Watford <[email protected]> wrote: > Hi Emad, > > How does the client software establish a connection to Derby? > > Assuming it is a TCP port, then you should be able to > expose/publish/forward those ports from the docker container to the host > system. > > Dan. > > On Tue, 28 May 2024 at 15:29, Emad Radwan <[email protected]> wrote: > > > Hello Comunity, > > > > I have a fresh Ofbiz installation using the latest build on Docker and I > > want want to view the default database using a client like Jetbrains > tools > > - or others as I think they're similar - but I need some guidance for > how. > > to expose in Docker. > > > > Reegards, > > Emad > > > > > -- > Daniel Watford >
