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

Frequently Asked Questions

How do I repair a corrupt database?

Mckoi SQL Database - Frequently Asked Questions (FAQ)
A database may be repaired by using the conglomerate repair tool. The conglomerate repair tool is used with the following command (from the distribution directory); java -cp mckoidb.jar com.mckoi.tools.DBConglomerateRepairTool -path [path to data files]

Will it corrupt my database?

Auto Close Idle - FAQ
No. ACI will simulate closing the application as any user does, by clicking on the close button on the upper right of the application's window. It will never terminate the task which usually leads to data loss or corruption. In the case of Navision, it will click Cancel at every pop window as well.

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.

Where do I get JDBC drivers for the AS/400's database?

jGuru: Java400 FAQ Home Page
The native driver and a version of the Toolbox for Java, which includes the type 4 driver, comes with OS/400. One can also purchase or get an evaluation...

U16) I am getting a database corrupt error message, what do I do.?

WinFactor Frequently asked questions
It depends on which database is corrupt. If it is the wf30main.mdb, they just get an update from our updates page. That will replace the local copy of wf30main.mdb which will fix the corruption. If the error says the corrupt database is wf30data.mdb, you have a little more work to do. This means your main datafile is corrupt. 99% of the time it can be repaired with no data loss. If the repair process fails, you should be prepared to restore this file from your nightly backup.

What is JDBC?

SQL Developer - FAQ
JDBC (Java DataBase Connectivity) technology is an API that provides cross-database connectivity to a wide range of SQL databases and access to other tabular data sources, such as spreadsheets or flat files. With a JDBC technology-enabled driver, you can connect all corporate data even in a heterogeneous environment. Today all major databases provide JDBC drivers for access.

How do I configure HA-JDBC to notify me when a database is deactivated?

Frequently Asked Questions
Use your logging facility. HA-JDBC generates an ERROR level log message when it automatically deactivates a database. If you use Log4J, configure an SMTP appender for the "net.sf.hajdbc" logger. The database element may contain any number of property elements. HA-JDBC will pass these properties through to the Driver.connect(String url, Properties info) method of the underlying JDBC driver. e.g. <cluster id="..." balancer="..." default-sync="..."> <database id="..

How can I connect from a servlet via JDBC to an Oracle database as sysdba ?

The Oracle (tm) Users' Co-operative FAQ - Index
This section has been set up in response to a request for information about such utilities, freeware, shareware and expensiveware as TOAD, SQL*XL, Patrol, Spotlight, etc. The pages referenced will follow a standard format, allowing users to make their personal comments about the good, bad, or indifferent points about such tools. No anonymous postings will be accepted.

How does the Java Database Connectivity (JDBC) work?

The JDBC is used whenever a Java application should communicate with a relational database for which a JDBC driver exists. JDBC is part of the Java platform standard; all visible classes and interfaces used in the JDBC are placed in package Java DriverManager. Manages a list of database drivers. Matches connection requests from the java application with the proper database driver using communication subprotocol.

How do I load a database driver with JDBC 4.0 / Java 6?

jGuru: JDBC FAQ Home Page
Provided the JAR file containing the driver is properly configured, just place the JAR file in the classpath. That's it. No need to manually load the class... For loading and registering a driver you should use Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"), but I have used JdbcOdbcDriver j=new JdbcOdbcDriver() and I still get a connection. Why is this so?... Using Class.forName will create and initialize an instance of the class you pass in as a paramter. So using Class.

Are all the required JDBC drivers to establish connectivity to my database part of the JDK?

Frequently Asked Questions about JDBC
No. There aren't any JDBC technology-enabled drivers bundled with the JDK 1.1.x or Java 2 Platform releases other than the JDBC-ODBC Bridge. So, developers need to get a driver and install it before they can connect to a database. We are considering bundling JDBC technology- enabled drivers in the future.

What is a database?

Mary and Jeff Bell Library -- Distance Learning FAQ
A database is a collection of data organized especially for rapid search and retrieval (as by a computer). [Merrian-Webster's Online Dictionary] Some specific examples of databases accessed through the Bell Library include Academic Search Premier, ArticleFirst, PsycINFO, and TOPICsearch, which can be found on the library's Databases Web page.

How can HA-JDBC be leveraged to improve database-driven HTTP Session failover?

Frequently Asked Questions
Several session replication methods are described in an article posted to TheServerSide.com. Figure 7 illustrates the database persistence approach. When describing the disadvantages of this approach, the article fails to mention that the session database is a single point of failure in this design. HTTP sessions will survive the failure of an application server node, but failure of the session database spells doom for the application.

How can I use the JDBC API to access a desktop database like Microsoft Access over the network?

Frequently Asked Questions about JDBC
Most desktop databases currently require a JDBC solution that uses ODBC underneath. This is because the vendors of these database products haven't implemented all-Java JDBC drivers. The best approach is to use a commercial JDBC driver that supports ODBC and the database you want to use. See the JDBC drivers page for a list of available JDBC drivers. The JDBC-ODBC bridge from Sun's Java Software does not provide network access to desktop databases by itself.

My download is corrupt! What can I do?

Telstra BigPond Broadband - File Downloads- FAQ
This problem generally occurs when a transfer from the file server is incomplete, or something corrupts the file while or during download. Most often, it is an incomplete file and it can be fixed by simply downloading the file again. To check to make sure the file is complete, you will need to check the file size. Right click on the file using Explorer and check the size - you'll need to look at the number in brackets where it is listed in bytes.

Can leaders go corrupt?

The Orion Sector: Featured Games : Master of Orion 3 : The O...
Leaders can become moles, go corrupt, be bribed... you name it. They are a serious danger as well as your helpers.

A.1 What is CORRUPT?

Anti-globalism and arguments against modernity in favor of h...
Corrupt, Inc. is a civilization watchdog built on the premise that when humans form a mental image of the world that does not correspond to reality, they become corrupt and destroy themselves. Our goal is to look for this cognitive dissonance and to point it out with research, intelligence reports, pranks and political activism. We believe in a better human future by embracing reality and not silly bureaucratic, academic or emotional abstractions.

When I extract uuencode binaries, the resulting decoded files are often corrupt. What's wrong?

MT-NW Manual: Frequently Asked Questions
Are you using StuffIt Expander with DSEE as your uudecode helper? Try uuUndo instead -- it does a better job with some of the uuencode formats commonly found on Usenet. Stuffit Expander can also get confused by the way that MT-NewsWatcher uniquifies file names to avoid duplicates (e.g. it will call a file NicePicture-1.gif). Stuffit sometimes thinks that the numerals on the end of the file name indicate that this is a multipart Stuffit archive.

top] I'm using the JDBC/ODBC bridge. Why should I try Jackcess?

Jackcess - Frequently Asked Questions
Speed - We had an app that used the ODBC bridge to write data to an Access database. When we switched it over to use Jackcess, it was 5 times faster.

How do I search a database?

Texas Cancer Information - Frequently Asked Questions
In most cases, you will click on the database you wish to search (physicians, hospitals, etc.). You will then be taken to a page containing a form. Fill out the form by selecting the Texas Region in which you are interested (Texas, county, etc.). If you have chosen a region other than Texas, select the number or name of your region or county from the associated drop down list or enter the city, name, or zip code as appropriate in the associated text box (Dallas, 77030, Jones, etc.).
More Questions >>

© Copyright 2007-2012 QueryCAT
About • Webmasters • Contact