Migrate to OracleXE

Classic Servoy
1

I have a Servoy solution working in iAnywhere and want to move to OracleXE. I installed the Oracle JDBC driver and have connected (in the Servoy DB Servers dialog) to the server “XE” the default Oracle SID for my database. I have no repository and am requesting advice on how to create one in OracleXE.

2

Hi Jay,

Export your solutions (so you can reimport into your new repository).

Create an empty database.
Repoint your servoy_repository data connection to your new database. You may want to keep the old connection, just rename it to get it out of the way and create a new connection for your new repository – just make sure use the same name as before.

Restart servoy
Servoy will ask to create a new repository when it sees your new empty database on the servoy_repository connection.

Reimport your solutions.

Hope this helps,

3

Thanks. The key information you gave me is to use the Oracle DB name “XE”, which is the only database you apparently can have in OracleXE, only they don’t seem to call it a database, and you can’t create it - it’s already there. So where I had two databases in iAnywhere, (the servoy_repository and my own data) I could only have one in Oracle.

I had several other hurdles, including not being able to use Port 8080 to connect Servoy client. 8080 has been appropriated by Oracle. Getting ODBC working was quite a project, too. As has been posted on other threads here, the file mfc71.dll, which is requited to set up an ODBC dsn, is not installed with XEClient, so it has to be copied over from the server system.

4

why ODBC?
You can use the oracle jdbc jars, just by copying from the oraclexe installation directories to the servoy\lib directory. I copied ojdbc14.jar, odncj14_g.jar, oracle_ice.jar and orai18n.jar for so far I can remember.

In the Servoy training we also changed the 8080 port of the servoy webserver to 8081 to avoid these problems. see the Servoy server documentation.

Jan Willem

5

jw teunisse:
why ODBC?
…
Jan Willem

We have an application written in C++ (maintained by others) that needs to have access to our database, and it has ODBC built in already. I don’t know how much work it would be to change the app to work with jdbc.

6

Can’t you use ODBC and JDBC together? Should be possible…

Using Servoy it is easy/easiest to work with JDBC drivers.
Simply follow the instructions of Jan Willem, set up the server connection in the Servoy preferences and it should work.