# creating a connection to Oracle 10gR2 **URL:** \ **Category:** Classic Servoy\ **Created:** [May 21, 2007, 7:27pm UTC](https://forum.servoy.com/t/creating-a-connection-to-oracle-10gr2/7539 "2007-05-21T19:27:22Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![slurton](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@slurton](https://forum.servoy.com/u/slurton)\ **Post date:** [May 21, 2007, 7:27pm UTC](https://forum.servoy.com/t/creating-a-connection-to-oracle-10gr2/7539/1 "2007-05-21T19:27:22Z")
I’m evaluating the latest beta release 3.5 b5 but cannot seem to get a connection to an Oracle 10gR2 database. my properties are the following: Server Name: slurton User Name : rome Password : Database Server URL: jdbc:oracle:thin:@localhost:1521:slurton Driver : oracle.jdbc.driver.OracleDriver Catalog: (have no idea what this is?) Schema: Max Active: 10 Max Idle: 5 Validation Type: exception validation I have copied my classes12.zip file to the driver directory under Servoy. It will allow me to create this connect, however when I try to create a new solution it will now list out any of the tables in the schema owned by rome. It all stops here because I can go no further. I notice the activity bar with the green bar going in the lower part of the screen. Do I just need to wait long for the tables to pop up? Help ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [May 21, 2007, 9:42pm UTC](https://forum.servoy.com/t/creating-a-connection-to-oracle-10gr2/7539/2 "2007-05-21T21:42:10Z")
Out of my head: I think classes.zip is for an old Java version. You should search the forum and you will find hints on what the right driver is called (I think it’s ojdbc14.jar). Maybe this helps: [JDBC Drivers | Oracle](http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html) Without the exact right driver all kinds of things can happen with Oracle… ---
**Author:** ![slurton](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@slurton](https://forum.servoy.com/u/slurton)\ **Post date:** [May 22, 2007, 2:08pm UTC](https://forum.servoy.com/t/creating-a-connection-to-oracle-10gr2/7539/3 "2007-05-22T14:08:00Z")
Tried the jdbc file but still didn’t work. However I copied the classes12.jar instead of the classes12.zip and that worked. Thanks p.s. would be nice if they didn’t list out the tables by selecting from the all\_user\_objects view. This view gives me 100 times more than I want. ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [May 22, 2007, 2:20pm UTC](https://forum.servoy.com/t/creating-a-connection-to-oracle-10gr2/7539/4 "2007-05-22T14:20:56Z")
I just checked. There is two drivers from Oracle classes12.jar (1,600,090 bytes) - for use with JDK 1.2 and JDK 1.3 ojdbc14.jar (1,545,954 bytes) - classes for use with JDK 1.4 and 1.5 So your friend is ojdbc14.jar. I would really use that, because later on you get strange issues… > would be nice if they didn’t list out the tables by selecting from the all\_user\_objects view. This view gives me 100 times more than I want. This is not a matter of the driver nor Servoy, but of the access rights the user has. ---
**Author:** ![john.allen](https://avatars.discourse-cdn.com/v4/letter/j/dec6dc/32.png) [@john.allen](https://forum.servoy.com/u/john.allen)\ **Post date:** [May 22, 2007, 5:11pm UTC](https://forum.servoy.com/t/creating-a-connection-to-oracle-10gr2/7539/5 "2007-05-22T17:11:00Z")
Also in your original post you were leaving the ‘schema’ blank. You can filter on that as well I think you’ll find. ---
**Author:** ![slurton](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@slurton](https://forum.servoy.com/u/slurton)\ **Post date:** [May 23, 2007, 4:49pm UTC](https://forum.servoy.com/t/creating-a-connection-to-oracle-10gr2/7539/6 "2007-05-23T16:49:17Z")
No, actually when I put in the name of the schema it says the user does not exist. The only problem with this error message is this is the same user I provide for the username and password. So it will let me log in as rome but will now allow me to set rome for the schema. I know darn well, cause I’m the DBA, that the user exists. ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [May 23, 2007, 4:58pm UTC](https://forum.servoy.com/t/creating-a-connection-to-oracle-10gr2/7539/7 "2007-05-23T16:58:46Z")
And do you have this with classes12 or ojdbc14? We are using schema information without problems, as far as I remember (it’s a customer site). ---
**Author:** ![slurton](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@slurton](https://forum.servoy.com/u/slurton)\ **Post date:** [May 23, 2007, 5:32pm UTC](https://forum.servoy.com/t/creating-a-connection-to-oracle-10gr2/7539/8 "2007-05-23T17:32:26Z")
AHHHHHH!!! It was case sensative. Was putting the schema in lowercase and it should have been uppercase. Stooooooopid me ps Switch to ojdbc14.jar works fine. Thanks ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [May 24, 2007, 5:56am UTC](https://forum.servoy.com/t/creating-a-connection-to-oracle-10gr2/7539/9 "2007-05-24T05:56:49Z")
You are using Oracle, so every detail matters ![:)]( "Smile")