Maryam Moazeni wrote:
> Hi,
>
> What is the difference between this
>
> "jdbc:derby://localhost:1527/"
>
> AND
>
> "jdbc:derby:net://localhost:1527/" ??
"jdbc:derby://localhost:1527/" is the connection URL syntax used by the
derby network client driver (derbyclient.jar). Summary info is at:
http://db.apache.org/derby/docs/10.1/adminguide/cadminappsclient.html
"jdbc:derby:net://localhost:1527/" is the connection URL for the IBM DB2
Universal driver (db2jcc.jar). Summary info is at:
http://db.apache.org/derby/docs/10.1/adminguide/cadminapps810777.html
There are a couple other syntax differences between the two that I have
gotten tripped up on before. For example, with the db2jcc.jar driver,
there's a colon after the dbname and a semicolon at the end:
'jdbc:derby:net://localhost:1527/bookstore:user=app;password=app;'
The embedded and the derby network client drivers both have a semicolon
after the db name and nothing at the end:
Derby network client driver:
'jdbc:derby://localhost:1527/bookstore;user=app;password=app'
Embedded driver:
'jdbc:derby:bookstore;user=app;password=app'
I hope this helps.
regards,
-jean
|