Installing Servoy App Server: Catalog and Schema?

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

Installing Servoy App Server: Catalog and Schema?

Postby Bernd.N » Mon Feb 20, 2017 2:29 pm

I am currently trying to install my first Servoy application server, closely following the docs from this source:
https://wiki.servoy.com/display/Serv7/Installing+the+Application+Server

I first installed Postgres 7.4.11 and the latest Java 8u121 on the target server.
Then I downloaded the Servoy App Server installation package and started it.

I choosed the third option stating that I already installed postgres separately.

Now I got stuck on the two fields Catalog and Schema in the window below.
What am I supposed to put in there?
servoy_catalog_schema.png
servoy_catalog_schema.png (22.2 KiB) Viewed 3672 times
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 544
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: Installing Servoy App Server: Catalog and Schema?

Postby ROCLASI » Mon Feb 20, 2017 4:04 pm

Hi Bernd,

Bernd.N wrote:I first installed Postgres 7.4.11...

:shock:


Okay, now you're scaring me.
PostgreSQL 7.4.11 was released on January 9, 2006. I assume you are talking about PostgreSQL 9.4.11. ;)

Bernd.N wrote:Now I got stuck on the two fields Catalog and Schema in the window below.
What am I supposed to put in there?

You can put in <none> in both fields if you didn't setup your own schema.
Also your server URL should include the database name, i.e.; jdbc:postgresql://localhost:5432/myDatabase.

Hope this helps.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Installing Servoy App Server: Catalog and Schema?

Postby Bernd.N » Mon Feb 20, 2017 4:12 pm

Yes, you are right, it is certainly 9.4.11, I mixed it up with Servoy :?
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 544
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: Installing Servoy App Server: Catalog and Schema?

Postby ROCLASI » Mon Feb 20, 2017 4:12 pm

Oh wait, you are talking about the installer, not the servoy-admin pages (reading is hard!) :oops:
You can simply leave them empty and no need to add the database name/
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Installing Servoy App Server: Catalog and Schema?

Postby Bernd.N » Tue Feb 21, 2017 6:20 pm

Yes that is also my experience.
When adding a database name at the end of the URL, like bob in our case, the servoy.properties file will contain
server.0.URL=jdbc\:postgresql\://localhost\:5432/bob/servoy_repository
instead of the proper
server.0.URL=jdbc\:postgresql\://localhost\:5432/servoy_repository

Then the proper creation of the repository will certainly fail.
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 544
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 6 guests