SQL Server Sürücüsün Module Olarak Eklenmesi

[jbosspath]\modules\com\microsoft\sqlserver\jdbc\main

<module xmlns="urn:jboss:module:1.0" name="com.microsoft.sqlserver.jdbc">
  <resources>
    <resource-root path="sqljdbc4.jar">
  </resource-root></resources>
  <dependencies>
    <module name="javax.api"></module>
	<module name="javax.transaction.api"></module>
	<module name="javax.servlet.api" optional="true"></module>
  </dependencies>
</module>

SQL Server Driver'ının Konfügürasyona Eklenmesi

jboss path\standalone\configuration\standalone.xml

<driver name="sqlserver" module="com.microsoft.sqlserver.jdbc">
	<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
</driver>

Veritabanı İçin DataSource Tanımı Eklenmesi

<datasource jndi-name="java:jboss/datasources/testdb" pool-name="testdb" enabled="true" jta="true" use-java-context="true" use-ccm="true">
	<connection-url>
		jdbc:sqlserver://ip:port;databaseName=testdb
	</connection-url>
	<driver>
		sqlserver
	</driver>
	<pool>
		<min-pool-size>1</min-pool-size>
		<max-pool-size>10</max-pool-size>
	</pool>
	<security>
		<user-name>root</user-name>
		<password>XXX</password>
	</security>
</datasource>

String dataSourceJndiName="java:jboss/datasources/testdb";
Context initialContext=new InitialContext();
DataSource dataSource=(DataSource)initialContext.lookup(dataSourceJndiName);
Connection connection = dataSource.getConnection();
// Connection alindi

 
rs=pstm.executeQuery();
rowset = new CachedRowSetImpl();
rowset.populate(rs);

ResultSet rs=pstm.executeQuery();
RowSetFactory rowSetFactory = RowSetProvider.newFactory();
CachedRowSet rowset=rowSetFactory.createCachedRowSet();
rowset.populate(rs);

import java.sql.*;
public class Test {
	public static void main(String[] args) throws Exception {
		Connection conn=null;
		try {
			conn = DriverManager.getConnection("jdbc:h2:~/test", "sa", "");
			System.out.println("connected");
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			if(conn!=null) {
				conn.close();	
			}
		}
	}
}

Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:h2:~/test
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at com.test.h2.Test.main(Test.java:7)

Eğer Caused by: java.lang.IllegalStateException: The file is locked: nio:C:/Users/../test.mv.db [1.4.199/7] gibi bir hata alırsanız bu dosyayı silip tekrar çalıştırın.

java -cp h2-1.4.199.jar org.h2.tools.Shell

[Enter]   jdbc:h2:~/test
URL       jdbc:h2:~/test2
[Enter]   org.h2.Driver
Driver
[Enter]   sa
User      test2
Password
Type the same password again to confirm database creation.
Password
Connected
Commands are caaûse insensitive; SQL statements end with ';'
help or ?      Display this help
list           Toggle result list / stack trace mode
maxwidth       Set maximum column width (default is 100)
autocommit     Enable or disable autocommit
history        Show the last 20 statements
quit or exit   Close the connection and exit

DROP TABLE IF EXISTS TEST;
CREATE TABLE TEST(ID INT PRIMARY KEY,
   NAME VARCHAR(255));
INSERT INTO TEST VALUES(1, 'Hello');
INSERT INTO TEST VALUES(2, 'World');
SELECT * FROM TEST ORDER BY ID;
UPDATE TEST SET NAME='Hi' WHERE ID=1;
DELETE FROM TEST WHERE ID=2;