QueryCAT Logo
Search 5,000,000+ questions and answers.

Frequently Asked Questions

Is the SequeLink JDBC Driver 100% Pure Java?

SequeLink JDBC Driver Reference
Yes, the SequeLink JDBC Driver is 100% Pure Java. No additional components need to be installed on your client workstation, other than an implementation of the Java Virtual Machine. For more information about SequeLink Java Edition Client product requirements, refer to the SequeLink Java Edition Client Installation Guide.

What connection string should I use with my JDBC thin driver?

FAQ
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@oracle.students.itee.uq.edu.au:1521:iteeo", "login", "password");

NS211-Can I use the JDBC adaptor with any JDBC driver and Database?

FAQ
The JDBC adaptor was designed to allow use with any JDBC driver (hence any database that has a JDBC driver). However, the adaptor has to be certified with the JDBC driver as there can be some minor differences between drivers especially when it comes to the SQL they support and the metadata information they provide. We have certified the adaptor for Oracle, Sybase, JDataStore, MS SQLServer, Interbase and DB2 UDB.

Can I use the JDBC-ODBC bridge driver in an applet?

jGuru: Applets FAQ
Author: Lennart Jorelid (http://www.jguru.com/guru/viewbio.jsp?EID=15) Question originally posed by John Zukowski PREMIUM (http://www.jguru.com/guru/viewbio.jsp?EID=7 Longer answer: You may create a digitally signed applet using a Certicate to circumvent the security sandbox of the browser. See the Certificate jFAQ.

Which Oracle JDBC driver should I use in applets?

jGuru: Applets FAQ
Author: John Zukowski (http://www.jguru.com/guru/viewbio.jsp?EID=7) Oracle basically has two JDBC drivers: an OCI driver which includes native code and a Thin driver which is 100% Pure Java. Since the OCI driver includes native code, it cannot be used in applets. You must use thin driver. You can get all Oracle JDBC drivers from http://technet.oracle.com/software/tech/java/sqlj_jdbc/software_index.htm.

How do I register a JDBC driver?

SequeLink JDBC Driver Reference
Method 1: Set the Java property sql.drivers using the Java -D option. The sql.drivers property is defined as a colon-separated list of driver class names. For example: intersolv.jdbc.sequelink.SequeLinkDriver: The sql.drivers property can be set like other Java properties, using the -D option. For example: java -Dsql.drivers=intersolv.jdbc.sequelink. Method 2: Set the Java property sql.drivers from within your Java application or applet.

How can test my FreeTDS JDBC Driver?

FreeTDS Frequently Asked Questions
Rajkumar Seth offers the following: static void ftdsjdbc () { try { // use your hostname and port number here String url = "jdbc:freetds:sqlserver://nt1:1433/master"; String login = "sa"; // use your login here String password = "secret"; // use your password here if (false) { //Sybase url = "jdbc:freetds:sybase://unix1:4100/master"; login = "sa"; // use your login here password = "secret"; // use your password here } Class.forName("com.internetcds.jdbc.tds.

Which databases can I access with the SequeLink JDBC Driver?

SequeLink JDBC Driver Reference
All databases supported by SequeLink 4.0, or higher, can be accessed through the SequeLink JDBC Driver. These include: The SequeLink JDBC Driver and SSL classes are packaged in the JAR files slje.jar and crysec.jar, which are located in the directory <installdir>/driver/classes. Copy these JAR files to your Web server and make sure that the JAR files are specified correctly in your HTML code using the codebase and archive tags in the applet tag.

Do I need to purchase the DataDirect JDBC driver also?

Ordering FAQ
No. DataDirect XQuery™ 3.0 provides an XQuery engine as well as XQJ API implementation. DataDirect XQuery™ 3.0 embeds the DataDirect JDBC drivers as part of the product for relational access.

NS404-How do we get and install the JDBC driver for JDataStore?

FAQ
JDataStore is a Pure Java ORDBMS and includes JDBC Type 4 Local and Remote Drivers. A development license for JDataStore is provided on the VisiBroker CD. The installation is fairly easy. You can look at the online guides that come with it. Please note that when you create a JDataStore database, you need to set/associate a transaction manager (TxManager) with it.

NS405-How do we get and install the JDBC driver for Sybase?

FAQ
You will need to get your Sybase jConnect driver from www.sybase.com. (For our testing, we used Sybase ??? and Sybase jConnect 4.1/5.0. One important thing to note is that you need to run a script at the Sybase Database Server, to setup stored procedures which are required by the JDBC Driver when the DatabaseMetaData class is used. This class is used by the Naming Service at startup and if the Database Server is not set up properly, you will face problems.

NS406-How do we get and install the JDBC driver for Oracle?

FAQ
We are using the type 4 JDBC driver from Oracle. You can download this driver from the Oracle website at technet.oracle.com or get it from the Oracle installation CD. Follow the instructions that come with the JDBC driver. It is fairly straight forward. We assume that the Oracle Host Server is 7.3.2 and above.

NS407-How do we get and install the JDBC driver for MSSQL?

FAQ
The JDBC driver which has been certified for VisiBroker Naming Service for MSSQL comes from WebLogic. You can download jdbcKona/MSSQLServer4 Kit 3.1.11 from www.weblogic.com/download.

NS408-How do we get and install the JDBC driver for DB2?

FAQ
JDBC driver for DB2 comes with DB2 Developer Toolkits. Besides JDBC driver for DB2, you need Client Application Enabler to register the database in order to access them via DB2 JDBC driver. Please visit www.software.ibm.com/data/db2/java for further information. VisiBroker Naming Service has been certified for DB2 Universal Database (version 5)

NS409-How do we get and install the JDBC driver for InterBase?

FAQ
You can download the JDBC driver (InterClient) for Interbase from www.interbase.com/downloads/products.html. Or you can install InterClient from JBuilder 3 Enterprise. You need to run InterClient in order to access Interbase via JDBC driver. VisiBroker Naming Service has been certified for Interbase 5.0 via InterClient 1.5

Why can't OpenOffice.org load/find my JDBC driver?

FAQ (Base) - OpenOffice.org Wiki
OpenOffice.org needs to know the path to the class files or the jar files of the JDBC driver. To achieve this, go to the Tools/Options dialog, there choose the page "Java". On this page, press the "Classpath" button, and add your archive or folder to OOo's classpath.

Which soundcards can I use with the kX driver?

FAQ
Currently, kX-compatible soundcards include all EMU10k1 and EMU10k2-based PC soundcards manufactured by Creative Technology Ltd. and/or E-mu Systems Inc., including: The Live! X-Gamer, Live! MP3+, Live! Player 1024, Live! Platinum cards (CT4760) and value cards (CT4780) The Live! X-Gamer 5.1, Live! MP3+ 5.1, Live! Player 5.1, Live! Platinum 5.1, Live! Digital Entertainment 5.1 cards (SB0060, SB0100, SB0102, SB0220, SB0222, SB0103 and SB0105) and Value 5.

Can I use SoundFonts with the kX driver?

FAQ
Yes, your soundcard will continue to function as a SoundFont-compatible device under the kX driver. SoundFonts can be loaded and unloaded via SoundFont-aware applications, or via the kX Mixer's SoundFont control page. Currently only SF2 files are supported, however SF1 (SBK) files can be converted to SF2 files using a freely available utility.

Are there more JDBC drivers available besides the JDBC-ODBC driver that ships with Java?

Frequently Asked Questions (FAQ)
Yes. Most database vendors ship a JDBC driver with their database. We recommend starting with the JDBC driver written by the manufacturer of the database you are using. If the database you are using such as those from Microsoft did not supply a JDBC driver or you have needs that are not met by that driver, you can use a 3rd party driver. The following web page lists many JDBC drivers that are available:
More Questions >>

© Copyright 2007-2012 QueryCAT
About • Webmasters • Contact