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
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 Without the exact right driver all kinds of things can happen with Oracle…
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.
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.
Also in your original post you were leaving the ‘schema’ blank. You can filter on that as well I think you’ll find.
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.
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).
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
You are using Oracle, so every detail matters ![:)]( "Smile")