JBoss - Error while checking if table aleady exists

[cmargulhano]

Hi,

I am having a problem with my deployment using JBOSS3.2.3 with tomcat compatible server using win 2000 OS and SqlServer 2000. I am trying to deploy an EJB and they are all resulting with the same error.
I am also a begginer for JBOSS and have really no idea.

Thanks,
Claudio

JBoss Error:

Cause: Incomplete Deployment listing:
Packages waiting for a deployer:

Incompletely deployed packages:

MBeans waiting for classes:

MBeans waiting for other MBeans:
[ObjectName: jboss.j2ee:jndiName=Enterprise1,service=EJB
state: FAILED
I Depend On:
Depends On Me: org.jboss.deployment.DeploymentException: Error while checking if table aleady exists; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache.)]

[aloubyansky]

This is the driver who threw the exception, not the JBoss. So, the problem is with the system setup.
Some snippets from SQL Server docs:

"To use insensitive scrollable cursors, and perform client-side sorting of
some DatabaseMetaData ResultSets, all code bases must have access to
temporary files. If access to temporary files is not available, the driver
may throw an exception indicating that it is unable to set up a static
cursor cache.

For JDK 1.1 environments, access to "current working directory" must be
granted.

For Java 2 environments, access to the temporary directory specified by the
VM configuration must be granted.

The following is an example of permissions being granted for the C:\TEMP
directory:

// permissions granted to all domains
grant {
// Permission to create and delete temporary files.
// Adjust the temporary directory for your environment.
permission java.io.FilePermission "C:\\TEMP\\-", "read,write,delete";
}; "

[cmargulhano]

Hi Alex,

I modified the file "C:\java\JBuilderX\jdk1.4\jre\lib\security\java.policy" inserting the permissions that you talked about. But does not work yet.
Is this the correct file?

Thank you.

Regards,
Claudio

[aloubyansky]

Actually we have server.policy file that by default grants all permissions.
Is the user on behalf of which you run JBoss able to execute DDL using the driver (outside JBoss)?

[cmargulhano]

Yes. The user on behalf of which we run Jboss is able to excute DDL using the driver.
Is this problem can be regarded with integration of JBuilder 10 and JBoss 3.2.3?
Thanks,
Claudio

[aloubyansky]

Frankly, I don't know. Maybe there is some other cause. This is what I found in the net.