| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.oracle -> Re: Oracle to SQL Server using JDBC
FOR ANYONE WITH THE SAME PROBLEM
After 2 days, I've finally been able to solve the problem. As I've
said in an earlier post, the error was happenening sometimes on load of
the driver. It said it couldn't resolve many of the classes within the
jar. This is the command I did to solve that
loadjava -user sys/password_at_system2 -resolve jtds-0.8.1.jar --I found this from metalink user
I then had to run the following PL SQL Commands:
BEGIN
dbms_java.grant_permission('userName', 'SYS:java.net.SocketPermission',
'ServerName', 'resolve');
END;
BEGIN
dbms_java.grant_permission('userName', 'SYS:java.net.SocketPermission',
'000.000.000.000:1433', 'connect,resolve');
END;
It now works beautifully!!!
Received on Wed Mar 02 2005 - 13:03:52 CST
 |
 |