derby Flashcards
Name of derby library
derby.jar
How to add library to project in Intelij idea?
ProjectStructure->libraries->add
What to you need to start working with db?
Database driver
How to get db driver?
call method Class.forName with name of driver
What is name of default derby db driver?
EmbeddedDriver (org.apache.derby.jdbc.EmbeddedDriver)
What is the class to help to get connection?
Driver manager
What does driver manager need to get db connection?
connection url
How does standards connection URL form looks like?
jdbc:derby:[propertyList]
Which does URL parameter allow to create db?
create=true
How does query look like in jdbc?
Statement
Where can I get Statement?
from connection
Which do class allows to put parameters in query?
PreparedStatement
How can I avoid error during creating already existing db?
check table name in db metadata
