태터데스크 관리자

도움말
닫기
적용하기   첫페이지 만들기

태터데스크 메시지

저장하였습니다.

iBatis - #{id} 와 ${id} 차이점


오라클에서 DB2 쿼리 변환 작업 중

오라클의 LEVEL 함수를 DB2용으로 변경하다가 WITH 문을 만나게 되었는데요,

보통 #{id}# 형으로 받아서 처리를 했는데, 자꾸 안되길래 ㅡ_ㅡ 인터넷검색을 통해서 아래와 같이 변경해 보았더니

잘 되더군요.

아흑 -_ㅠ 퇴근할 수 있겠군아 ㅠㅠㅠㅠㅠㅠ


iBatis 에서 #{id}# 와 ${id}$의 차이점

http://k.daum.net/qna/view.html?qid=3yG16

저작자 표시 비영리 변경 금지
신고
크리에이티브 커먼즈 라이선스
Creative Commons License

'FrameWorks > iBatis_myBatis' 카테고리의 다른 글

iBatis - #{id} 와 ${id} 차이점  (0) 2012.08.15
iBatis - Incorrect inline parameter map format  (0) 2011.09.02
iBatis - 실행구조  (0) 2011.09.02

JAVA excute / excuteUpdate / excuteQuery 차이점


생각없이 코딩하다가 ㅡ_ㅡ;;

오류 부딫히면 힘들다는 것을 오늘도 깨닫고 갑니.....

★ excute / excuteUpdate / excuteQuery 차이점

출처 : http://j79sw.tistory.com/216

저작자 표시 비영리 변경 금지
신고
크리에이티브 커먼즈 라이선스
Creative Commons License

JAVA - JDBC, Supported Database, JDBC Drivers, and Deployment Containers


Supported Databases, JDBC Drivers, and Deployment Containers

NetBeans Visual Web Pack 5.5 is tested on the following databases and drivers:

Oracle driver tested on the Oracle database:

Driver Location

Oracle Database 10g Release 2 JDBC Drivers

Driver Versions

Oracle Database 10g Release 2 (10.2.0.2)

Driver JAR File

ojdbc14.jar

Driver Classnames

oracle.jdbc.driver.OracleDriver

URL Formats

jdbc:oracle:thin:@//hostname:port/database

Example URL

jdbc:oracle:thin:@//localhost:1521/ora9i

Microsoft driver tested on the SQL Server database:

Driver Location

Microsoft SQL Server 2005 JDBC Driver 1.1

Driver Version

Microsoft SQL Server 2005 JDBC Driver 1.1
sqljdbc_1.1.1501.101_enu.tar.gz

Driver JAR File

sqljdbc.jar

Driver Classname

com.microsoft.sqlserver.jdbc.SQLServerDriver

URL Format

jdbc:sqlserver://hostname:1433;databaseName=database;selectMethod=cursor

Example URL

jdbc:sqlserver://localhost:1433;databaseName=travel;selectMethod=cursor

IBM drivers tested with the DB2 database:

Driver Location

DB2 Personal Developer's Edition: Redistributable JDBC Type 4 Driver (requires registration)

Driver Version

Redistributable DB2 JDBC Type 4 driver v8 fixpack 11 
db2_jdbc_t4_fp11.zip

Driver JAR Files

Type 4

· db2jcc.jar

· 2jcc_license_cu.jar

Driver Classname

com.ibm.db2.jcc.DB2Driver

URL Format (Type 4) 

jdbc:db2://hostname:port/database

Example URL

jdbc:db2://localhost:50002/sample

Note: The IBM drivers support both Type 2 (native) and Type 4 (pure Java). To force the drivers to run in Type 4, add a property: driverType = 4 when connecting to the database.

MySQL drivers tested with the MySQL database:

Driver Location

Download Connector/J 5.0.3 (tar.gz)
Download Connector/J 5.0.3 (zip)

Driver Version

MySQL?? Connector/J 5.0.3

Driver JAR Files

mysql-connector-java-5.0.3-bin.jar

Driver Classname

org.gjt.mm.mysql.Driver

URL Format

jdbc:mysql://hostname:port/database
jdbc:mysql://
hostname/database

Example URL

jdbc:mysql://localhost:3306/sample
jdbc:mysql://localhost/sample

DataDirect drivers tested with Oracle, SQL Server, DB2 and Sybase databases:

Driver Location

DataDirect Connect for JDBC, Release 3.6 Service Pack 1

Driver Versions

DataDirect Connect for JDBC - 3.6
DataDirect Connect for JDBC - 3.6.07

Driver .jar Files

DataDirect Driver .jar Files

· base.jar

· util.jar

· spy.jar

· resource.jar

· oracle.jar

· sybase.jar

· sqlserver.jar

· db2.jar

· informix.jar

Driver Classnames

DataDirect Driver Classes

· com.ddtek.jdbc.oracle.OracleDriver

· com.ddtek.jdbc.sqlserver.SQLServerDriver

· com.ddtek.jdbc.db2.DB2Driver

· com.ddtek.jdbc.sybase.SybaseDriver

URL Formats

DataDirect URL Formats

· jdbc:datadirect:oracle://server_name[:portNumber];SID=database

· jdbc:datadirect:sqlserver://server_name[:portNumber];databaseName=database

· jdbc:datadirect:db2://server_name[:portNumber]databaseName=database

· jdbc:datadirect:sybase://server_name[:portNumber

Example URLs

jdbc:datadirect:oracle://localhost;SID=ora9i
jdbc:datadirect:sqlserver://localhost:1433;DatabaseName=travel;SelectMethod=cursor
jdbc:datadirect:db2://localhost:50002;databaseName=sample

출처 : http://netbeans.org/community/releases/55/vwp-release-notes.html

저작자 표시 비영리 변경 금지
신고
크리에이티브 커먼즈 라이선스
Creative Commons License
|  1  |  ···  |  39  |  40  |  41  |  42  |  43  |  44  |  45  |  ···  |  79  |


티스토리 툴바