Helping a client setup jdbc to oracle on mac os x. I have setup jdbc
many times on my workstations, mac and windows, but having a problem
here.
Running Mac OS X server 10.4.4, and verified that the java
preferences are set to use JAVA 1.4.2, not 1.5.0.
Default JAVA witango.ini settings, and startup script settings.
ojdbc14.jar, is in the /library/java/extensions folder, as I always do.
I can connect to oracle, using this jar, in extensions, using latest
sql grinder, AND witango dev studio 5.5 using this jdbc.ini:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd" >
<JDBCINI Version="0x00010000">
<DataSources>
<DataSource ID="MYDSN">
<DSN> MYDSN </DSN>
<DriverClass>oracle.jdbc.OracleDriver</DriverClass>
<URL>jdbc:oracle:thin:@server.domain.com:1521:SOMEID</URL>
<Properties />
</DataSource>
</DataSources>
</JDBCINI>
I changed the values above, but it works in Witango dev studio, on
the SAME machine. On the server, I get this:
[11533] 2006-05-30 14:17:40 START INFO Java Virtual Machine:
Enabled
[11533] 2006-05-30 14:17:40 START INFO Meta Object Service:
Not available on the Lite Edition of the Server
[11533] 2006-05-30 14:17:40 START INFO JavaScript-C 1.5 pre-
release 6a 2004-06-09
[11533] 2006-05-30 14:17:40 START INFO Web Service: Disabled
[11533] 2006-05-30 14:17:40 START INFO ODBC Interface: Enabled
[11533] 2006-05-30 14:17:40 START WARNING JDBC Interface: Disabled
[11533] 2006-05-30 14:17:40 START ERROR
[oracle.jdbc.OracleDriver]
When I change the jdbc.ini on the server to this:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd" >
<JDBCINI Version="0x00010000">
<DataSources />
</JDBCINI>
Then I get this in the witangoevents.log:
[11543] 2006-05-30 14:18:29 START INFO Java Virtual Machine:
Enabled
[11543] 2006-05-30 14:18:29 START INFO Meta Object Service:
Not available on the Lite Edition of the Server
[11543] 2006-05-30 14:18:29 START INFO JavaScript-C 1.5 pre-
release 6a 2004-06-09
[11543] 2006-05-30 14:18:29 START INFO Web Service: Disabled
[11543] 2006-05-30 14:18:29 START INFO ODBC Interface: Enabled
[11543] 2006-05-30 14:18:30 START INFO JDBC Interface: Enabled
[11543] 2006-05-30 14:18:31 START INFO Oracle Call Interface
(OCI): Enabled
LIke I said, I know the JDBC setup is right, and working, since I can
connect with the dev studio. Does anyone know how to get a better
error out of witango than this?:
[11533] 2006-05-30 14:17:40 START ERROR
[oracle.jdbc.OracleDriver]
Sounds like its not finder the class, but its in the extensions
folder, and everything else finds it.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
