Hello NG. Evironment: Windows XP Home jdk 1.4.2_06-b03 JBOSS 3.2.3
Statemant: Yes, I have read different threads found by Google at these question, but none of this threads fixed the problem to the end, so I try it again and hope to find an answer this time. Question: I don't want to change all the callers of the DefaultDS to an other DS, like MSSqlDS. (Even this seems to be more difficult or impossible, because of hard coded DefaultDS in the source code I found in different Postings). What I want to do is, to configure JBOSS to use an other Database than Hypersonic, concrete MSSQL, to use as DefaultsDS. Therefore I follow the following descriptions: - Create a new database, user, password as discripted in http://docs.jboss.org/jbossas/getting_started/v4/html/db.html - Copy required libs - Test the connection settings using Squirrel - I create none system tables or something like this, because I don't find an description for this. - Copy the mssql-ds.xml to %JBOSS_HOME%\server\all\deploy and %JBOSS_HOME%\server\default\deploy as descripted in http://www.jboss.org/wiki/Wiki.jsp?page=ConfigJBossMQDB - Change the connection-setting to the current MSSQL and set the jndi name to DefaultDS | <datasources> | <local-tx-datasource> | <jndi-name>DefaultDS</jndi-name> | <connection-url>jdbc:microsoft:sqlserver://protagonist:1433;DatabaseName=jboss;sendStringParametersAsUnicode=false;selectMethod=cursor</connection-url> | <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class> | <user-name>jboss</user-name> | <password>password</password> | <min-pool-size>5</min-pool-size> | <max-pool-size>20</max-pool-size> | <idle-timeout-minutes>0</idle-timeout-minutes> | <track-statements>true</track-statements> | </local-tx-datasource> | </datasources> | - I additionally copy the mssql-xa-ds.xml (optional ??) to the same directoy with the following content | <datasources> | <xa-datasource> | <jndi-name>MSSQLXADS</jndi-name> | <xa-datasource-class>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</xa-datasource-class> | <xa-datasource-property name="ServerName">protagonistsub</xa-datasource-property> | <xa-datasource-property name="DatabaseName">jboss</xa-datasource-property> | <xa-datasource-property name="SelectMethod">cursor</xa-datasource-property> | <!-- not sure if these should be here--> | <user-name>jboss</user-name> | <password>password</password> | </xa-datasource> | | </datasources> | - I copy the file mssql-jdbc2-service.xml to the _same directories_\jms without making any changes to the file. - I delete, as descripes, the hybersonic files. - I make no changes to the login-config.xml, because the descripted changes did not match my login-config.xml and the description above refer at JBOSS 3.2.4+ and I only use 3.2.3. - I remove any deployments and clean the tmp directory. - Starting the JBOSS I get the following error message: | 2005-12-23 08:35:10,640 URLDeploymentScanner ERROR: MBeanException: Exception in MBean operation 'checkIncompleteDeployments()' | Cause: Incomplete Deployment listing: | Packages waiting for a deployer: | <none> | Incompletely deployed packages: | <none> | MBeans waiting for classes: | <none> | MBeans waiting for other MBeans: | [ObjectName: jboss.mq:service=InvocationLayer,type=HTTP | state: CONFIGURED | I Depend On: jboss.mq:service=Invoker | jboss.web:service=WebServer | | Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic | state: CONFIGURED | I Depend On: jboss.mq:service=DestinationManager | jboss.mq:service=SecurityManager | | Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic | state: CONFIGURED | I Depend On: jboss.mq:service=DestinationManager | jboss.mq:service=SecurityManager | | Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic | state: CONFIGURED | I Depend On: jboss.mq:service=DestinationManager | jboss.mq:service=SecurityManager | | Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=testQueue | state: CONFIGURED | I Depend On: jboss.mq:service=DestinationManager | jboss.mq:service=SecurityManager | | Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=A | state: CONFIGURED | I Depend On: jboss.mq:service=DestinationManager | | Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=B | state: CONFIGURED | I Depend On: jboss.mq:service=DestinationManager | | Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=C | state: CONFIGURED | I Depend On: jboss.mq:service=DestinationManager | | Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=D | state: CONFIGURED | I Depend On: jboss.mq:service=DestinationManager | | Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=ex | state: CONFIGURED | I Depend On: jboss.mq:service=DestinationManager | | Depends On Me: , ObjectName: jboss.mq:service=Invoker | state: CONFIGURED | I Depend On: jboss.mq:service=TracingInterceptor | | Depends On Me: jboss.mq:service=InvocationLayer,type=HTTP | jboss.mq:service=InvocationLayer,type=JVM | jboss.mq:service=InvocationLayer,type=OIL | jboss.mq:service=InvocationLayer,type=OIL2 | jboss.mq:service=InvocationLayer,type=RMI | jboss.mq:service=InvocationLayer,type=UIL2 | , ObjectName: jboss.mq:service=TracingInterceptor | state: CONFIGURED | I Depend On: jboss.mq:service=SecurityManager | | Depends On Me: jboss.mq:service=Invoker | , ObjectName: jboss.mq:service=SecurityManager | state: CONFIGURED | I Depend On: jboss.mq:service=DestinationManager | | Depends On Me: jboss.mq.destination:service=Topic,name=testTopic | jboss.mq.destination:service=Topic,name=securedTopic | jboss.mq.destination:service=Topic,name=testDurableTopic | jboss.mq.destination:service=Queue,name=testQueue | jboss.mq:service=TracingInterceptor | jboss.mq.destination:service=Queue,name=DLQ | , ObjectName: jboss.mq.destination:service=Queue,name=DLQ | state: CONFIGURED | I Depend On: jboss.mq:service=DestinationManager | jboss.mq:service=SecurityManager | | Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=JVM | state: CONFIGURED | I Depend On: jboss.mq:service=Invoker | | Depends On Me: , ObjectName: jboss.mq:service=DestinationManager | state: CONFIGURED | I Depend On: jboss.mq:service=MessageCache | jboss.mq:service=PersistenceManager | jboss.mq:service=StateManager | | Depends On Me: jboss.mq.destination:service=Topic,name=testTopic | jboss.mq.destination:service=Topic,name=securedTopic | jboss.mq.destination:service=Topic,name=testDurableTopic | jboss.mq.destination:service=Queue,name=testQueue | jboss.mq.destination:service=Queue,name=A | jboss.mq.destination:service=Queue,name=B | jboss.mq.destination:service=Queue,name=C | jboss.mq.destination:service=Queue,name=D | jboss.mq.destination:service=Queue,name=ex | jboss.mq:service=SecurityManager | jboss.mq.destination:service=Queue,name=DLQ | , ObjectName: jboss.mq:service=PersistenceManager | state: CONFIGURED | I Depend On: jboss.jca:service=LocalTxCM,name=MSSQLDS | | Depends On Me: jboss.mq:service=DestinationManager | , ObjectName: jboss.mq:service=InvocationLayer,type=OIL | state: CONFIGURED | I Depend On: jboss.mq:service=Invoker | | Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL2 | state: CONFIGURED | I Depend On: jboss.mq:service=Invoker | | Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=RMI | state: CONFIGURED | I Depend On: jboss.mq:service=Invoker | | Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL2 | state: CONFIGURED | I Depend On: jboss.mq:service=Invoker | | Depends On Me: ] | Actual I'm not sure, where the changes in the mssql-xa-ds.xml are good for, but separe from this, there seams to be something wrong and I'm not in the position the find out, what's going wrong. Please help. TIA Holger View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3914119#3914119 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3914119 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
