Also, my jdbc driver does not connect on the existence of the jar file alone. You must install a other libs that the jar connects to. My JDBC driver connect through the same libs that the odbc driver connects through. So even though an app sees the jar and its jdbc driver implementation, it may require other items to be installed properly. That is why testing in the command line is useful, because the command line will usually give an error from the driver like "can't find so and so library" or whatever. This also gives you the ammo you need when you go to witango support, and you tell them it works in these other environments.
Robert.
On Wednesday, July 9, 2003, at 11:12 AM, Dale Graham wrote:
Hmm. Well, I now have about 5 copies of the driver (every app seems to want them in a different place), and I just now put one in /Library/Java/Extensions and restarted the Studio. No dice, same "Io" error.
I am using the same URL as worked with JTransit. I never had any documentation from Oracle on this, I'll go see if it is humanly possible to FIND it on their site. (NOT my favorite site to look for things...)
But I really like your idea of testing it via command line, rather than in the Studio.
On Wednesday, July 9, 2003, at 09:03 AM, Robert Garcia wrote:
If you are using 10.2.6, you shouldn't have to mess with the classpath at all.
There are two issues to getting JDBC to working right. First get OS X to see the driver correctly. The best way to do this is take the jdbc driver and put it in the /library/java/extensions/ folder. For my DBMS, it is a single file named "pbjdbc.jar".
The second issue is the connection url and classpath. This should be in the documentation from Oracle, or in the readme from the driver. They must follow the exact syntax your driver requires. Unfortunately, the URL is implemented differently by each DBMS and is not very standard.
Your JDBC driver should have some type of command line test app to compile and run to test a connection. Test your connection to make sure it is setup correctly before attempting to use the studio.
If I had oracle, I could give you exact instructions, but I don't, so these are my instructions on how I got my DBMS to work.
Robert.
On Wednesday, July 9, 2003, at 05:07 AM, Dale Graham wrote:
Mac OS X, 10.2.6, Studio version 5.0.9, Oracle
I can see JDBC in the workspace, and I can add a JDBC datasource, but I get an "Io" error when I attempt to connect...
I have a CLASSPATH set up for the place where the Oracle JDBC driver is located
I am using Oracle's thin client (which I successfully use in connecting using SQL Grinder)
I think I am off on syntax somewhere... here's what my jdbc.ini file looks like (where server name and ports have been changed for security reasons)
I have also tried DriverClass com.oracle.jdbc.Driver but that didn't work, either
<DataSources> <DataSource ID="demodb"> <DSN>demodb</DSN> <DriverClass>oracle.jdbc.driver.OracleDriver</DriverClass> <URL>jdbc:oracle:thin://www.oracleserver.com:9999/demodb</URL> <Properties> <Property ID="server"> <Name>server</Name> <Value> www.oracleserver.com </Value> </Property> <Property ID="port"> <Name>port</Name> <Value>9999</Value> </Property> </Properties> </DataSource> </DataSources>
_____________________________________________________________________ ___
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
--
Robert Garcia President - BigHead Technology CTO - eventpix.com 2781 N Carlmont Pl Simi Valley, Ca 93065 ph: 805.522.8577 - cell: 805.501.1390 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
______________________________________________________________________ __
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
_______________________________________________________________________ _
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
--
Robert Garcia President - BigHead Technology CTO - eventpix.com 2781 N Carlmont Pl Simi Valley, Ca 93065 ph: 805.522.8577 - cell: 805.501.1390 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
