Hello Bagas, In entityengine.xml file, select data source as per your desired database, in your case it is postgres. You have to mention JDBC URI/URL, database name, user name and password to connect to the database.
Example: jdbc-uri="jdbc:postgresql://<URL>/<DBNAME>" jdbc-username="<DB_USERNAME>" jdbc-password="<DB_PASSWORD>" HTH! -- Thanks & Regards Pawan Verma Technical Consultant *HotWax Systems* *Enterprise open source experts* http://www.hotwaxsystems.com On Fri, Dec 13, 2019 at 12:48 PM Bagas Sanjaya <[email protected]> wrote: > So should I also specify DB user name and password in JDBC URI/URL? > > On 12/12/19 22.40, Rishi Solanki wrote: > > Postgres do have example in entityengine.xml. Need to change localhost > from > > IP address with user name and password. > > > > > > Best Regards, > > -- > > Rishi Solanki > > *CTO, Mindpath Technology* > > Intelligent Solutions > > cell: +91-98932-87847 > > http://www.mindpathtech.com > > > > > > On Thu, Dec 12, 2019 at 7:01 PM Bagas Sanjaya <[email protected]> > wrote: > > > >> OK, but I use Postgres instead. > >> > >> So should I specify DB user name and password in connection URL, or > >> should they be skipped? > >> > >> On 12/12/19 19.31, Jacques Le Roux wrote: > >>> You have examples in entityengine.xml, just use the DNS or IP > >>> address.Look for jdbc-uri= in entityengine.xml. You might also change > >>> the port... > >>> > >>> Since OFBiz simply covers the JDBC driver you may refer to > >>> > >>> > >> > https://stackoverflow.com/questions/14657036/how-to-connect-to-a-remote-database-with-jdbc > >>> > >>> > >>> or > >>> > >>> https://vladmihalcea.com/jdbc-driver-connection-url-strings/ > >>> > >>> HTH > >>> > >>> Jacques > >>> > >>> Le 12/12/2019 à 12:48, Bagas Sanjaya a écrit : > >>>> Hello all, > >>>> > >>>> How can I connect my OFBiz instance to remote database instance? > >>>> > >>>> Bagas > >>>> > >> > >> -- > >> An old man doll... just what I always wanted! - Clara > >> > >> -- > >> An old man doll... just what I always wanted! - Clara > >> > > > > -- > An old man doll... just what I always wanted! - Clara >
