Deploying to Remote Deployment Server

Hi there!

I've developed the first part of my Inventory Control system using Java Studio Creator 2 Update 1. I use a MSSQL 2000 database.

I now need to deploy it to our Linux server running Tomcat 5. I got the help files and try to deploy it but it gives this error: SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

I tried to setup the JDNI through the Administration of Tomcat... but how do I KNOW that it's setup correctly for creator to see this JDNI? I also tried to view the Log but couldn't find it... Hmmm.. :)

So now I set up Sun Application Server 9 on another Server, but when I set it up through creator2, it's there, but it shows it as STOPPED, although I can see on the server that it IS running. I then installed Sun Application Server 8.2 on another Server and it gives the same problem.... Hmmm...

Does anyone know what to do... please - I need to get this going?

Thanks SO much!

Marthinus

[996 byte] By [mpraath] at [2007-11-26 11:37:22]
# 1

Hi!

For Tomcat try to look at this:

http://forum.sun.com/jive/thread.jspa?forumID=123&threadID=101183

Maybe it will helpful.

For Application Server, I think, the reason could be in your firewall. Do You have one? If yes, try to disable it and look what will happen. If all will be OK, try to setup your firewall.

Thanks,

Roman.

Grif at 2007-7-7 11:36:04 > top of Java-index,Development Tools,Java Tools...
# 2

Thanks SO Much for this. This article helped me a LOT. I've been struggling for SO long. Thanks and may Jesus bless you :) I'm just SO happy that it works now.

I only had to copy the ms*.jar (3) files to the common\lib\ of Tomcat 5. Then I had to restart (VERY IMPORTANT) the server and then it worked.

Also make sure the URL is something like: jdbc:microsoft:sqlserver://10.0.0.7:1433;DatabaseName=HealthCare;SelectMethod=c ursor

And the driver must be something like:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Thanks a MILLION!

mpraath at 2007-7-7 11:36:04 > top of Java-index,Development Tools,Java Tools...