#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.

#DATABASE CONFIGURATION
DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://localhost/$DB$?characterEncoding=utf8
User=root
Password=
#Java server port
ServerPort=17178

# PoolType=Hikari
# DriverShortName=oracle 
# --- 1. PROPIEDADES FILTRADAS DEL POOL (Estabilidad) ---
# Usamos CamelCase, prefijo pool.hikari.
pool.hikari.MaximumPoolSize=2
# pool.hikari.MinimumIdle=1
# pool.hikari.MaxLifetime=1750000
# pool.hikari.ConnectionTimeout=40000
# pool.hikari.LeakDetectionThreshold=60000
# pool.hikari.RegisterMbeans=true

#example of MS SQL Server configuration:
#DriverClass=net.sourceforge.jtds.jdbc.Driver
#JdbcUrl=jdbc:jtds:sqlserver://<server address>/<database>

#example of postegres configuration:
#JdbcUrl=jdbc:postgresql://localhost/test
#DriverClass=org.postgresql.Driver

#SQL COMMANDS
sql.create_table=CREATE TABLE IF NOT EXISTS animals (\
     id INTEGER PRIMARY KEY AUTO_INCREMENT,\
     name CHAR(30) NOT NULL,\
     image BLOB)
sql.insert_animal=INSERT INTO animals VALUES (null, ?,?)
sql.select_animal=SELECT name, image, id FROM animals WHERE id = ?;
sql.create_table=CREATE TABLE article (col1 numeric(10,4) ,col2 text);
sql.select=select * from article
sql.insert=INSERT INTO article VALUES(?, ?)