What file do i download from where to get openbase supported and I assume I installed it then in servoy/drivers/.
I downloaded OpnbaseJDBC.jar and placed it in drivers/ but Openbase doesn’t show as a choice in the DB Servers
I assume what you are saying is that you don’t see it in the Auto Setup Server list.
To use Openbase with Servoy follow the steps below:
- Place OpenBase.jar in your drivers folder, make sure Servoy is closed
- launch servoy and go to Application preferences, DB server tab
- Click New
- in the Driver pulldown choose: com.openbase.jdbc.ObDriver
- fill in a servername of choice (this is the named connection within servoy, how you name it doesnt really matter)
- fill in the username and password of the connection
- in the URL field fill in the following:
jdbc:openbase://localhost:20223/dbname
replace localhost (if necessary) with ip or hostname of database server
replace dbname with the name of the database you want to connect to
When you press OK the connection will be tested.
We will add OpenBase to the Auto Setup Server pulldown as soon as possible
Odysseus:
What file do i download from where to get openbase supported and I assume I installed it then in servoy/drivers/.I downloaded OpnbaseJDBC.jar and placed it in drivers/ but Openbase doesn’t show as a choice in the DB Servers
For what matter do you prefer OpenBase over FireBird (wich is already pre-installed)?
I have a CRM soft based on OpenBase, that is not supported on Win. Since the openbase structure is totally open I want to try to make a Windows client. (while waiting for iAnywhere to be included as default database).
Where do I download the OpenBase.jar or OpenBaseJDBC.jar file to install in the Servoy/drivers folder?
I would like to test out Servoy with OpenBase.
Click on downloads on the Openbase website. It’s listed directly on the first page as: OpenBase JDBC2.0 Driver Client
Thank you
I am trying to test Servoy on an OpenBase backend. I am having trouble getting Servoy to connect to any database hosted by OpenBase.
I have downloaded their JDBC driver (OpenBaseJDBC.jar v3.0) from their website. In installed it in the drivers folder of Servoy. Launched up Servoy went to the DB Server area to add a database. When I clicked OK I always get the same error:
java.sql.SQLException: Can not connect to the openexec at ‘localhost:20223’
Does anyone know what I am doing wrong?
OpenBase 8.0.4
Servoy Developer
Version R2 2.1.2-build 315
Java version 1.4.2-38 (Mac OS X)
raymanj:
I am trying to test Servoy on an OpenBase backend. I am having trouble getting Servoy to connect to any database hosted by OpenBase.I have downloaded their JDBC driver (OpenBaseJDBC.jar v3.0) from their website. In installed it in the drivers folder of Servoy. Launched up Servoy went to the DB Server area to add a database. When I clicked OK I always get the same error:
java.sql.SQLException: Can not connect to the openexec at ‘localhost:20223’
Does anyone know what I am doing wrong?
OpenBase 8.0.4
Servoy Developer
Version R2 2.1.2-build 315
Java version 1.4.2-38 (Mac OS X)
I am still having trouble connecting to an OpenBase backend and Servoy. Could anyone give me some advice regarding this.
Is openbase running?
Is it running on your local/servoy server/developer machine?
Is the port the correct one?
IT2BE:
Is openbase running?
Is it running on your local/servoy server/developer machine?
Is the port the correct one?
I am running the demo version of OpenBase on my Servoy developer machine.
I ran a port scan for lovcalhost and port 20223 was open
Openbase is running and I have a few databases running by it.
I always get the same error when trying to add a database connection in DBServers section. “No able to connect”
do you have security setting set correctly? can you connect with other sql tools that use JDBC like aqua data studio?
jaleman:
do you have security setting set correctly? can you connect with other sql tools that use JDBC like aqua data studio?
Well it looks like I am having more trouble than I thought. I finally got Servoy to except a new database connection in the DBServer list, but one problem. The icon of the database listed in the DBServer list is lighter than the rest. Also when I go to create a new form the server connection is not listed in any of the Using Server lists.
I tried Aqua Data Studio and I am able to connect but I always get an error. “Connection Failed. Your login and password are not valid.”
I checked users and logins. They were set to admin and no password. I even shabged them, to avail.
I ran another program that uses OpenBase for its database (DayLite) and it worked fine at accessing OpenBase.
My settings I used were:
URL: jdbc:openbase://localhost/Company
Driver: com.openbase.jdbc.ObDriver
Location: /Library/Java/Extensions/OpenBaseJDBC.jar
Do you also get this behaviour after restarting Servoy?
jaleman:
Do you also get this behaviour after restarting Servoy?
Yes, even after a restart of Servoy.
I finally got Servoy to connect to OpenBase. What I had to do was put 127.0.0.1 for localhost and no port afterwords. I also got Aqua Data Studio to connect the same way.
Once I corrected this in Servoy the DB icon in the DBServer List returned to the normal dark icon color, not light version.
No problems with Aqua Studio, but still some problems with Servoy.
Once I place the fields on the form and veiw it in browse mode I get an error:
"Cannot work without primaryKey on table ‘tablename’ "
Now I checked the database in OpenBase for primary keys and they all have them. They were auto set to “_rowid”.
I also checked the tables in DataProvider of Servoy, they did not list any of the primary key columns, _rowid. A matter of fact, no column that begun with an underscore was shown. Does Servoy have a problem showing column names that begin with underscores?
Settings:
URL: jdbc:openbase://127.0.0.1/WOMovies
Driver: com.openbase.jdbc.ObDriver
Location: /Library/Java/Extensions/OpenBaseJDBC.jar
It appears that the _columns are something openbase specific. If you look with aquadatastudio you will see they can’t see the _columns either. If you connect to the (better designed) customers example you will see that servoy can work with it.
jaleman:
It appears that the _columns are something openbase specific. If you look with aquadatastudio you will see they can’t see the _columns either.
I noticed something very strange the last time I created a form to one of the tables with the pk name starting with an underscore. The “_rowid” columns started to appear in the field listings to add to the form. This allowed me to create forms based off this database. The stranger part is that not all tables would do this. Some would show “_rowid” and other would not. The ones that did not display _rowid would produce an error. Stating the missing primary keys.
Another weird part to this is every table in this database has three columns that start with an underscore. Some tables will appear with the _rowid column in Servoy but none of the other columns (beginning with underscores) will show up in Servoy.
jaleman:
If you connect to the (better designed) customers example you will see that servoy can work with it.
What is this better designed customers example, you are talking about? Is it the current crm in Servoy? If so should be looking in dataprovider section and inspecting the column names?
Thanks for the replies
I’d recommend contacting Openbase with specific openbase questions. We don’t know why all of a sudden _columns would appear or not. Servoy simply uses the JDBC standard to ask for the available columns and what the PK is, no rocket science or trickery involved. The Customers example i was referring to is the one that the latest openbase version installs by default as a demo database.