JavaNewb 10 1 1 5. I’ve also noticed some random changes in the standalone. You’re either missing -jar in which case the -cp will be ignored! I could obviously have just elected to define the datasource directly in the XML file however, the GUIs option to test the connection is nice. The definition of the datasource resulted in further changes in file EAP
|Date Added:||21 October 2004|
|File Size:||57.58 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Apparently the JDBC driver in JBoss has to be installed as net.sourceforge.jtds.jdbc.drivre “module” in the server which is unfortunate as it decreases my options in terms of scripting and cannot be captured in source control.
First one is folder “libs” which nef.sourceforge.jtds.jdbc.driver external libraries. The JBoss server is a piece of excrement as attested by the fact that if you decided to comment out a section in the standalone. However, I am not sure one has to go all the way there and whether the directory net.sourceforge.jtds.jdbc.driver is not just a convention to ensure segregation of modules.
JavaNewb 10 1 1 5. How to install jTDS?
There is an answer in SO that asserts that it’s possible to define datasources in a standard container-agnostic way, but when I tried to implement that solution I failed. You just need to make sure that the jtds jar file is in your classpath. If you’re new to Java, I’d strongly recommend that you learn the basics including the classpath before you start doing any JDBC work.
jTDS JDBC Driver
Sign up or log in Sign up using Google. I added the dependency in my ivy. Quite how you do this will depend on your application type. If you are using command line: You’re either missing -jar in which case the -cp will be ignored!
Jon Skeet k The driver name sybasejtds is entirely arbitrary and is basically what’s going to appear in the JBoss AEP administration GUI typically at port when one tries to create a new datasource.
Configuring a SQL Server database
The remaining levels are taken from the package structure inside the driver’s JAR all the way to the sub-package where the JDBC driver class is defined. Furthermore, net.sourceforge.jtds.jdbc.driger my particular case, the database I was trying to connect to was a Sybase ASE 15 or 16, am not sure at the moment so the exotic factor is high. It means exactly what it says. Main If you are using Eclipse: Email Required, but never shown.
Tomasz Nurkiewicz k 53 Second place is your classpath, where you load. If you are using Eclipse: