 Help for Java Stored Procedure [message #133042] |
Wed, 17 August 2005 08:13 |
Abhinav Nigam
Messages: 49
Registered: August 2004
|
Member |
|
|
We use MS SQL Server 2000 Analysis services to build the cube. so our database is an Oracle DB & our cubes are in MS SQL Server 2000. We want to automate the process so that the DBAs dont need to process the cubes manually everyday.
to achieve this we need to have some mechanism to pass a message from Oracle to MS SQL Server 2000 to process the cubes. The only common denominator is our sweet heart Java. So I made a small JDBC class that connects to MS SQL Server 2000. MS SQL Server 2000 Data Transformation System (DTS), using DTS we can build packages that can process the cube. The package can be encapsulated in a job. MS SQL server provides a Stored Procedure called sp_start_job that can be used to fire a job.
What my Java class does is that it just inserts a row into a table. On that table we have a trigger that fires the sp_start_job procedure. the stored procedure runs the package & the cube is processed. The java class is perfect.
Now we need some mechanism to so that we can encorporate this Java class into PL/SQL. We loaded this class into Oracle database using the loadjava command. We made a function (a java stored procedure) and that can be run from PL/SQL like any other function.
But when we invoke the Java stored procedure, the loaded class cannot find the JDBC driver. So in some way we have to tell Oracle that you pick MS driver..........
The java class terminates giving this exception
com/microsoft/jdbc/sqlserver/SQLServerDriver
What can be done???
Regards
Abhinav
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
