aspose file tools*
The moose likes JBoss/WildFly and the fly likes How to integrate SQL server with JBOSS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "How to integrate SQL server with JBOSS" Watch "How to integrate SQL server with JBOSS" New topic
Author

How to integrate SQL server with JBOSS

Ramesh Shanmugam
Ranch Hand

Joined: Sep 13, 2004
Posts: 132
Hi all,

I have JBOSS in my system. I struggle to configure SQL server with the JBOSS. pls anyone help me out regarding this issue.

Thanks in advance,
Ramesh


Ramesh Shanmugam - SCJP 1.5
norman richards
Author
Ranch Hand

Joined: Jul 21, 2003
Posts: 367
Add your jdbc driver to the your server lib directory. (this requires a restart, sadly)

Copy docs/examples/jca/mssql-ds.xml into your deploy directory and edit the host name, database name, username and password.

Done.
norman richards
Author
Ranch Hand

Joined: Jul 21, 2003
Posts: 367
Oh, I should add that datasource configuration is covered in chapter 4 of the book.
hxd han
Greenhorn

Joined: Apr 24, 2005
Posts: 2
I also want to know how to change default datasource to my datasource.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Originally posted by hxd han:
I also want to know how to change default datasource to my datasource.


Edit the default datasource so it points to your database.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to integrate SQL server with JBOSS