How to implement a Documentum method with Java JDBC connector?

I have written a Documentum method using the Java JDBC connector to access an external database. I am using JDK 6.30 64-bit with the SQL JDBC 4.0 connector. The code works fine when I run it locally using Eclipse. I am attempting to move it to the content server to run it as a method, but I keep getting "No suitable driver found" errors. Per the JDBC connector installation instructions, I've installed the SDK and the connector on the content server, put the .jar file into the classpath variable, and I also tried putting the .jar file into the Path variable. I'm assuming it's some type of pathing issue, but I'm not sure where else I need to put a reference.

Any help would be much appreciated.

- Jane

Find more posts tagged with

Documentum

Comments

Haroon_A

Don't you have to create a datasource?

jklawrence

I have not done so. It's just a call to a SQL database.

DCTM_Guru

Not sure if this is applicable, but wen using JDBC connector for Forms Builder, we needed to create JDBC properties file to tell FB which JDBC driver to use.

Haroon_A

Most probably the problem might be the incorrect URL.

put the .jar file into the classpath variable

Which.jar file are you referring to? If your method's jar, you need to put it in $DOCUMENTUM/dba/java_methods directory.

jklawrence

I did put the method's jar file into the java_methods directory. The method kicks off, it just throws an error when trying to connect to the external database.

The JDBC connector instructions say to add the connector jar file, sqljdbc4.jar, to the CLASSPATH variable. I also tried putting the sqljdbc4.jar file into the java_methods directory but that didn't help.

The URL works fine on my local machine and I have not changed it. I followed the same instructions there to implement the connector and everything works fine, so it's got to be something with the JMS and how it accesses the paths or .jars.

Haroon_A

I see, can you try to put your sqljdbc jar under method server lib directory, see if that make any difference?

$DOCUMENTUM/jboss/.../deploly/DmMethod/lib

jklawrence

We are on Dctm 6.7 SP1, so I tried adding it to

C:\Documentum\jboss5.1.0\server\DctmServer_MethodServer\deploy\ServerApps.ear\DmMethods.war\WEB-INF\lib

but no luck, so I tried

C:\Documentum\jboss5.1.0\server\DctmServer_MethodServer\deploy\ServerApps.ear\lib

and that didn't work either.

DCTM_Guru

Is your DCTM install 64bit? Have you tried using 32bit JDK? I have seen other folks using 64bit JRE even with 64bit DCTM.

jklawrence

That was really close, Ahmad, and got me on the right track. The directory that worked was:

C:\Documentum\jboss5.1.0\server\DctmServer_MethodServer\lib

Thanks for all your help.

- Jane

JorgKrause

Hi,

reading through this, it appears that you are using the "old fashion" way of implementing and deploying methods, right?

The recommended way is actually to use module deployment, implementing IDfMethod and IDfModule.

You modify the method_verb in your dm_method to the module name instead of the class name, create a module, add all the dependant jar files as well, and you'll never ever have to bother about where to put the files

In addition, you'll don't have to stop and start the JMS every time you need to deploy a new version of your method, BOF deployment is taking care of this for you!

Neat?

Here are some links that you may find interesting

http://donr7n.wordpress.com/2008/10/20/methods-as-bof-modules/

http://beachstreetblog.wordpress.com/2010/02/01/custom-activities-in-xcp/

In addition, you'll find quite a number of posts here that cover this issue.

Regards

Jørg

jklawrence

Thanks, Joerg, I'll look into that. Do you happen to know if I can bundle a properties file in with the code? I have a properties file that contains various parameters that might change that is read by the method. I generally put that into the java_methods directory with the .jar file so that the code doesn't have to be modified if one of the parameters changes. I don't think I've ever done that with a BOF module. Of course, if it's bundled in that sort of defeats the purpose since I'd have to redeploy the code to make a change anyway . . .

- Jane

JorgKrause

Hi Jane,

I've never done this, but as far as know, you should be able to this, indeed. The entire idea of module deployment is that you bundle whatever you need, and deployment makes sure that everything is downloaded.

Regards

Jørg