JDBC ์—ฐ๊ฒฐ

JDBC ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์•ก์„ธ์Šค ์˜ต์…˜์„ ์ง€์ •ํ•ฉ๋‹ˆ๋‹ค.

JDBC ์˜ˆ์ œ

JDBC ๋“œ๋ผ์ด๋ฒ„ ํด๋ž˜์Šค๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ LibreOffice์—์„œ JDBC ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ์—ฐ๊ฒฐํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๋“œ๋ผ์ด๋ฒ„ ํด๋ž˜์Šค๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ œ์กฐ์—…์ฒด์—์„œ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค. JDBC ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์˜ ๋‘ ๊ฐ€์ง€ ์˜ˆ์ œ๋Š” Oracle๊ณผ MySQL์ž…๋‹ˆ๋‹ค.

์ฐธ๊ณ  ์•„์ด์ฝ˜

The driver classes must be added to LibreOffice in - LibreOffice - Advanced.


Oracle ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค

JDBC ๋“œ๋ผ์ด๋ฒ„๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ Solaris ๋˜๋Š” Linux์—์„œ Oracle ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ์•ก์„ธ์Šคํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. Windows์—์„œ ์ด ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ์•ก์„ธ์Šคํ•˜๋ ค๋ฉด ODBC ๋“œ๋ผ์ด๋ฒ„๊ฐ€ ํ•„์š”ํ•ฉ๋‹ˆ๋‹ค.

๋ฐ์ดํ„ฐ ์›๋ณธ URL ์ƒ์ž์— Oracle ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„œ๋ฒ„์˜ ์œ„์น˜๋ฅผ ์ž…๋ ฅํ•ฉ๋‹ˆ๋‹ค. URL ๊ตฌ๋ฌธ์€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์œ ํ˜•์— ๋”ฐ๋ผ ๋‹ฌ๋ผ์ง‘๋‹ˆ๋‹ค. ์ž์„ธํ•œ ๋‚ด์šฉ์€ JDBC ๋“œ๋ผ์ด๋ฒ„์™€ ํ•จ๊ป˜ ์ œ๊ณต๋œ ์„ค๋ช…์„œ๋ฅผ ์ฐธ์กฐํ•˜์‹ญ์‹œ์˜ค.

Oracle ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์˜ ๊ฒฝ์šฐ URL ๊ตฌ๋ฌธ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค.

oracle:thin:@hostname:port:database_name

MySQL ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค

MySQL ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์šฉ ๋“œ๋ผ์ด๋ฒ„๋Š” MySQL ์›น ์‚ฌ์ดํŠธ์—์„œ ์–ป์„ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

MySQL ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ตฌ๋ฌธ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค.

mysql://hostname:port/database_name

๋ฐ์ดํ„ฐ ์›๋ณธ URL

Enter the URL for the database. For example, for the MySQL JDBC driver, enter "mysql://<Servername>/<name of the database>". For more information on the JDBC driver, consult the documentation that came with the driver.

JDBC ๋“œ๋ผ์ด๋ฒ„ ํด๋ž˜์Šค

JDBC ๋“œ๋ผ์ด๋ฒ„ ์ด๋ฆ„์„ ์ž…๋ ฅํ•ฉ๋‹ˆ๋‹ค.

๊ฒฝ๊ณ  ์•„์ด์ฝ˜

Before you can use a JDBC driver, you need to add its class path. Choose - LibreOffice - Advanced, and click the Class Path button. After you add the path information, restart LibreOffice.


ํ…Œ์ŠคํŠธ ํด๋ž˜์Šค

ํ˜„์žฌ ์„ค์ •์„ ์‚ฌ์šฉํ•˜์—ฌ ์—ฐ๊ฒฐ์„ ํ…Œ์ŠคํŠธํ•ฉ๋‹ˆ๋‹ค.

์ธ์ฆ

๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋งˆ๋ฒ•์‚ฌ

Please support us!