framework/playframework
How to connect to MS-SQL
sigmak
2012. 3. 15. 02:03
성공한 케이스
프로젝트명이 myFirstApp 라고 하면
1) ~\myFirstApp\ 폴더에 lib 폴더를 추가
2) ~\myFirstApp\lib 폴더에 jtds 드라이버 파일 추가
예)~\myFirstApp\lib\jtds-1.2.5.jar
3)~\myFirstApp\conf 폴더의 application.conf 파일에 아래 내용을 추가 (대략 30라인 쯤에 추가하면 될 거임)
# If you need a full JDBC configuration use the following :
db.default.driver="net.sourceforge.jtds.jdbc.Driver"
db.default.url="jdbc:jtds:sqlserver://127.0.0.1:1444/db명;"
db.default.user=sa
db.default.pass=패스워드
아래는 참고용 ..
-----------------------------------------------------------------------------------
출처 :
http://groups.google.com/group/play-framework/msg/6747bd6c8dbcb743?pli=1
jTDS works well too.http://jtds.sourceforge.net/
Example:
db.driver=net.sourceforge.jtds.jdbc.Driver
db.url="jdbc:jtds:sqlserver://127.0.0.1:1433/mydb;appName=PlayDEV;"
---------------------------------------------------------------------------------
또는
출처 :
http://stackoverflow.com/questions/9211967/playframework-mssql-database-error
May be useful for someone,looking for MSSQL along with play.
First download jtds
copy jtds jar file to
play-1.2.3\framework\lib
as well as your application lib folder
restart play
In your application.conf
# If you need a full JDBC configuration use the following :
db.url="jdbc:jtds:sqlserver://localhost:1433/testDB;instance=SQL2008"
db.driver=net.sourceforge.jtds.jdbc.Driver
db.user=sa
db.pass=sa
Start Playing :)