Engineering Full Stack Apps with Java and JavaScript
Here we will list down the sample connection urls used in the jdbc examples at javajee.com.
Driver Download Url
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
Driver names include ojdbc5.jar for java 5, ojdbc6.jar for java 6 etc.
Sample Connection String for Oracle XE
jdbc:oracle:thin:@localhost:1521:XE
Note:
To use the standard JDBC4.0 java.sql.SQLXML interface with JDBC 11.2.0.3, you need to use xdb6.jar (instead of xdb.jar) from the 11.2.0.3 distribution.
Driver Download Procedure:
Sample connection String for MySQL
jdbc:mysql://localhost:3307/testdb
Known Issues with MySQL Drivers
Driver Download Url
http://www.microsoft.com/en-
us/download/details.aspx? displaylang=en&id=11774
Driver name is sqljdbc4.jar
Sample connection String for MS SQL Server
jdbc:sqlserver://localhost:1433;databaseName=hiberdb
Important Note
Urls and driver issues mentioned here are based on the time of updating the details for a particular driver/database. If you find any change of url/behaviour, please do let us know.
Comments
i have download the ojdbc6
i have download the ojdbc6.jar file. now what should i do ? please explain the procedure. thank
Please refer to the notes
Please refer to the notes from beginning @ http://javajee.com/java-database-connectivity-jdbc-book and try running the programs having the jar in classpath.