king

javap -verbose Test

minor version: 0
major version: 50

- major version
    48: java 1.4.2
    49: java 5
    50: java 6

javap -verbose Test | find "version"

출처 : http://devbada.tistory.com/58

드라이버별 JDBC Connection 연결 설정

{
   

▶ DB2 JDBC 드라이버 버전 별 접속 방법 및 필요 JAR

• 요거 땀시 하루종일 웹서핑 한거 생각하면 정말 ㅠ_ㅠ
• V8 이전의 드라이버를 DB2 JDBC DRIVER라 하고, 그 이후에 새롭게 추가된 JDBC Driver 를 Universal JDBC Driver 고 합니다.
• V8 이상에서는 Universal JDBC Driver를 사용하기를 권장하고 있습니다.

▶ 데이터베이스에 접근하기 위해서 사용하는 JDBC 드라이버에 따라서 JDBC URL 이 달라집니다.

• Class Files [DB2 Client 를 설치하면 JAVA 폴더에 존재]
  • - db2java.zip : DB2 JDBC Type 2 and Type 3 Driver
  • - db2jcc.jar : Universal Type 2 and Type 4 Driver
• License jar Files(Universal Type 2 and Type 4 Driver를 사용할 때 필요 : db2jcc.jar)
  • - db2jcc_license_cu.jar : for connecting DB2 v8 for LUW
  • - db2jcc_license_cisuz.jar : for connecting DB2 for iSeries and z/OS
• JDBC Drvier class name
  • - DB2 JDBC Type 2 Driver : COM.ibm.db2.jdbc.app.DB2Driver
  • - DB2 JDBC Type 3 Driver : COM.ibm.db2.jdbc.net.DB2Driver
  • - Universal JDBC Type 2 Driver : com.ibm.db2.jcc.DB2Driver
  • - Universal JDBC Type 4 Driver : com.ibm.db2.jcc.DB2Driver
• JDBC URL name
  • - DB2 JDBC Type 2 Driver : jdbc:db2:db_name
  • - DB2 JDBC Type 3 Driver : jdbc:db2://host_name:port_name/db_name
  • - Universal JDBC Type 2 Driver : jdbc:db2:sample
  • - Universal JDBC Type 4 Driver : jdbc:db2://host_name:port_name/db_name
• Windows DB2 사용시 주의점
  • JDBC Type4를 사용했을경우 SUN JDK 사용시, IBM CodeSet으로 자동변환이 안되기 때문에 DATABASE생성시 UTF-8코드로 생성해주어야 합니다.
  • p.s. IBM에서 DB2 사용시 JDBC Type2를 권장한다고 합니다..

}

A List of JDBC Drivers

If you need to access a database with Java, you need a driver.
This is a list of the drivers available, what database they can access, who makes it, and how to contact them.

IBM DB2
jdbc:db2://<HOST>:<PORT>/<DB>
COM.ibm.db2.jdbc.app.DB2Driver

JDBC-ODBC Bridge
jdbc:odbc:<DB>
sun.jdbc.odbc.JdbcOdbcDriver

Microsoft SQL Server
jdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT>
weblogic.jdbc.mssqlserver4.Driver

Oracle Thin
jdbc:oracle:thin:@<HOST>:<PORT>:<SID>
oracle.jdbc.driver.OracleDriver

Informix Dynamic Server
jdbc:informix-sqli://<HOST>:<PORT>/<DB>:INFORMIXSERVER=<SERVER_NAME>
com.informix.jdbc.IfxDriver

Microsoft SQL Server (JTurbo Driver)
jdbc:JTurbo://<HOST>:<PORT>/<DB>
com.ashna.jturbo.driver.Driver

Microsoft SQL Server (Sprinta Driver)
jdbc:inetdae:<HOST>:<PORT>?database=<DB>
com.inet.tds.TdsDriver

Microsoft SQL Server 2000 (Microsoft Driver)
jdbc:microsoft:sqlserver://<HOST>:<PORT>[;DatabaseName=<DB>]
com.microsoft.sqlserver.jdbc.SQLServerDriver

MySQL (MM.MySQL Driver)
jdbc:mysql://<HOST>:<PORT>/<DB>
org.gjt.mm.mysql.Driver

Oracle OCI 8i
jdbc:oracle:oci8:@<SID>
oracle.jdbc.driver.OracleDriver

Oracle OCI 9i
jdbc:oracle:oci:@<SID>
oracle.jdbc.driver.OracleDriver

PostgreSQL (v6.5 and earlier)
jdbc:postgresql://<HOST>:<PORT>/<DB>
postgresql.Driver

PostgreSQL (v7.0 and later)
jdbc:postgresql://<HOST>:<PORT>/<DB>
org.postgresql.Driver

Sybase (jConnect 4.2 and earlier)
jdbc:sybase:Tds:<HOST>:<PORT>
com.sybase.jdbc.SybDriver

Sybase (jConnect 5.2)
jdbc:sybase:Tds:<HOST>:<PORT>
com.sybase.jdbc2.jdbc.SybDriver

To test your driver once it's installed, try the following code:

{
  Class.forName("Driver name");
  Connection con = DriverManager.getConnenction("jdbcurl","username","password");
  //other manipulation using jdbc commands
}
catch(Exception e)
{
}

com.sybase.jdbc3.jdbc.SybSQLException: The optimizer could not find a unique index which it could use to scan table 'DBName.dbo.test_table2' for cursor 'jconnect_implicit_3'.

 at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
 at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
 at com.sybase.jdbc3.tds.Tds.getResultSetResult(Unknown Source)
 at com.sybase.jdbc3.tds.TdsCursor.open(Unknown Source)
 at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
 at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)

=> CREATE INDEX indexa ON DBName.dbo.test_table2(id)

-- original test table
CREATE TABLE MARINER.dbo.test_table2(id int identity , title char(25) NULL, contents varchar(25) NULL)

18:16:44  [INSERT - 0 row(s), 0.000 secs]  1) [Error Code: 584, SQL State: S1000]  Explicit value specified for identity field in table 'MARINER.dbo.test_table2' when 'SET IDENTITY_INSERT' is OFF.
. 2) [Error Code: 1913, SQL State: 42S11]  There is already an index on table 'test_table2' named 'indexa'
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec  [0 successful, 0 warnings, 1 errors]

=>
SET IDENTITY_INSERT MARINER.dbo.test_table2 ON
INSERT INTO MARINER.dbo.test_table2(id, title, contents) VALUES (6, 'a', 'b')
SET IDENTITY_INSERT MARINER.dbo.test_table2 OFF


ref) http://blog.sqlauthority.com/2007/03/28/sql-server-fix-error-8101-an-explicit-value-for-the-identity-column-in-table-can-only-be-specified-when-a-column-list-is-used-and-identity_insert-is-on/