Aqui les dejo una lista de las posibles cadenas de conexion a una BD dependiendo del DBA y el driver que usen para manipular este, espero que les sirva
IBM DB2jdbc:db2://<HOST>:<PORT>/<DB>COM.ibm.db2.jdbc.app.DB2Driver
JDBC-ODBC Bridgejdbc:odbc:<DB>sun.jdbc.odbc.JdbcOdbcDriver
Microsoft SQL Serverjdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT>weblogic.jdbc.mssqlserver4.Driver
Oracle Thinjdbc:oracle:thin:@<HOST>:<PORT>:<SID>oracle.jdbc.driver.OracleDriver
PointBase Embedded Serverjdbc:pointbase://embedded[:<PORT>]/<DB>com.pointbase.jdbc.jdbcUniversalDriver
Cloudscapejdbc:cloudscape:<DB>COM.cloudscape.core.JDBCDriver
Cloudscape RMIjdbc:rmi://<HOST>:<PORT>/jdbc:cloudscape:<DB>RmiJdbc.RJDriver
Firebird (JCA/JDBC Driver)jdbc:firebirdsql:[//<HOST>[:<PORT>]/]<DB>org.firebirdsql.jdbc.FBDriver
IDS Serverjdbc:ids://<HOST>:<PORT>/conn?dsn='<ODBC_DSN_NAME>'ids.sql.IDSDriver
Informix Dynamic Serverjdbc:informix-sqli://<HOST>:<PORT>/<DB>:INFORMIXSERVER=<SERVER_NAME>com.informix.jdbc.IfxDriver
InstantDB (v3.13 and earlier)jdbc:idb:<DB>jdbc.idbDriver
InstantDB (v3.14 and later)jdbc:idb:<DB>org.enhydra.instantdb.jdbc.idbDriver
Interbase (InterClient Driver)jdbc:interbase://<HOST>/<DB>interbase.interclient.Driver
Hypersonic SQL (v1.2 and earlier)jdbc:HypersonicSQL:<DB>hSql.hDriver
Hypersonic SQL (v1.3 and later)jdbc:HypersonicSQL:<DB>org.hsql.jdbcDriver
Microsoft SQL Server (JTurbo Driver)jdbc:JTurbo://<HOST>:<PORT>/<DB>com.ashna.jturbo.driver.Driver
Microsoft SQL Server (Sprinta Driver)jdbc:inetdae:<HOST>:<PORT>?database=<DB>com.inet.tds.TdsDriver
Microsoft SQL Server 2000 (Microsoft Driver)jdbc:microsoft:sqlserver://<HOST>:<PORT>[;DatabaseName=<DB>]com.microsoft.jdbc.sqlserver.SQLServerDriver
MySQL (MM.MySQL Driver)jdbc:mysql://<HOST>:<PORT>/<DB>org.gjt.mm.mysql.Driver
Oracle OCI 8ijdbc:oracle:oci8:@<SID>oracle.jdbc.driver.OracleDriver
Oracle OCI 9ijdbc:oracle:oci:@<SID>oracle.jdbc.driver.OracleDriver
PostgreSQL (v6.5 and earlier)jdbc:postgresql://<HOST>:<PORT>/<DB>postgresql.Driver
PostgreSQL (v7.0 and later)jdbc:postgresql://<HOST>:<PORT>/<DB>org.postgresql.Driver
Sybase (jConnect 4.2 and earlier)jdbc:sybase:Tds:<HOST>:<PORT>com.sybase.jdbc.SybDriver
Sybase (jConnect 5.2)jdbc:sybase:Tds:<HOST>:<PORT>com.sybase.jdbc2.jdbc.SybDriver
//para probar el driver, trata el siguiente código:
Class.forName("Driver name"); Connection con = DriverManager.getConnenction("jdbcurl","username","password");
Comentarios Recientes
30 weeks 1 day ago
30 weeks 3 days ago
37 weeks 3 days ago
38 weeks 2 days ago
39 weeks 2 days ago
39 weeks 2 days ago
39 weeks 3 days ago
39 weeks 3 days ago
39 weeks 3 days ago
40 weeks 8 hours ago