Topic: [SOLVED] Oracle Connectivity
[SOLVED] Oracle Connectivity
Is it possible to connect to a Oracle 91 db with thispackage? It is unclear whether you want to drop the jar file into the drivers dir or add the classpath somehow. Any help appreciated
Oracle is still one of the untested db-vendors (I actually know that some of the developers have managed to get a hole through, but it's not documented yet, we're working on it right now though!).
As far as I know Oracly is fully JDBC-compliant so the logical answer would be yes, it is possible to connect.
You need to add the driver jar-file to the drivers-folder and then use the startup.cmd (or .sh depending on your OS) for starting DataCleaner. Please let us know if it works out. If not I would be most interested in any problems you might have and try and fix them!
As far as I know Oracly is fully JDBC-compliant so the logical answer would be yes, it is possible to connect.
You need to add the driver jar-file to the drivers-folder and then use the startup.cmd (or .sh depending on your OS) for starting DataCleaner. Please let us know if it works out. If not I would be most interested in any problems you might have and try and fix them!
I have tried dropping ojdbc14.jar into the drivers folder and used the cmd file to start up. I select 'sun.jdbc.odbc.JdbcOdbcDriver', configure my DSN, user, password, and schema pattern. (I am assuming this means the name of the schema I intend to point at) and get an error of 'Could not open connection! Error: java.sql.SQLException: [Oracle][ODBC]Driver not capable.'
Thanks for your assistance!
Thanks for your assistance!
I wouldn't expect you to use the ODBC-driver that you're using. This is for accessing your database through Suns JDBC-to-ODBC bridge. Instead I would say that it's better if you use the Oracle driver:
oracle.jdbc.driver.OracleDriver
Reading from Oracles website, this is the template for a connection string:
jdbc:oracle:thin:@host:port:sid
I'm downloading Oracle Express edition now so I can test this myself, but that may take while :)
oracle.jdbc.driver.OracleDriver
Reading from Oracles website, this is the template for a connection string:
jdbc:oracle:thin:@host:port:sid
I'm downloading Oracle Express edition now so I can test this myself, but that may take while :)
That did the trick! Problem solved. I will let you know how it goes after I have time to poke around a bit...
Thanks again!
Thanks again!
One thought:
When I point the tool at a large schema, there is a very long pause, presumably as the tool tries to touch the schema and return the initial list of tables. Is there a way to set a table pattern to restrict the number of tables it hits?
When I point the tool at a large schema, there is a very long pause, presumably as the tool tries to touch the schema and return the initial list of tables. Is there a way to set a table pattern to restrict the number of tables it hits?
There actually is that option at the API (core) level, but we haven't made any user interface for it yet, but I'll add it to our ticket system so look for it in future versions :)
Log in by clicking the login link at the top of the screen
Go back to forum.
