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.

Yes. You can use any relational database that is accessible by JDBC and satisfies the SPECjAppServer2004 Run and Reporting Rules.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start manual transaction mode because there are cloned connections. This seems to be a problem with the Microsoft Type 4 JDBC Driver and concurrent statements/transactions/resultsets on the same database conntection. To solve this you need to add ;SelectMethod=cursor to the end of your dburl string.

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

Yes! For SQL 2000, please see our SQL 2000 page to order this optional service for only $35 additional per year. You must have some working knowledge of SQL Server 2000. We will not provide you with Enterprise Manager or any other means to connect to your database. You must have your own Microsoft SQL 2000 Enterprise Manager software from Microsoft. There is very limited support for SQL Server 2000. If you just want to use it because you heard it is better, please remain with Microsoft Access.

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.

The following settings in the configuration file should be modifed as follows (we assume you use jdbc driver from weblogic):

You need to add "setenv EPC_DISABLED TRUE" to your Oracle startup script or profile. This is a problem in the server. How can I see all my tables? SQL> select table_name from tabs; or SQL> select table_name from user_tables; (tabs is actually a public synonym for user_tables).

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.

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.

I created a new DNN host user account. Why do I get the following error message when logging into ML/DNN admin site with the new DNN host user account? "Either you are not currently logged in, or you do not have access to this content." You need an AspDotNetStorefront customer account. To fix this problem, log in as the new host user and browse to Host > AspDotNetStorefront Install. Scroll down the page and click on the ?Create customer? link. I created a new DNN admin user account.

Object database are tightly coupled with the applications that they serve, and are not generally considered to be client/server databases. Typically, the objects that they manage can only be deserialized and used by the programming language that created them. While object graphs like DOM trees can be persisted in object databases, the number of objects that are produced for a a large collection of XML documents can become a serious performance and resource bottleneck.

Mckoi SQL Database is an SQL (Structured Query Language) Database management system written for the JavaTM platform. Mckoi SQL Database is optimized to run as a client/server database server for multiple clients, however it can also be embedded in an application as a stand-alone database. It is highly multi-threaded and features an extendable object-oriented engine. Mckoi SQL Database started as an internal project and has since evolved from its inception in 1998.

Yes, kind of. We use a subset of SQL. You'll find most of your favorite commands are there. If you ever need to test a command, please try it on the client. It's a quick way to test things out. BACK

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.

jTDS offers full support for all JDBC 3.0 features: forward-only and scrollable/updateable result sets, batch updates, prepared and callable statements, unlimited number of statements per connection, complete database and result set meta data, and a DataSource implementation (which also implements ConnectionPoolDataSource and XADataSource). Features such as generated keys retrieval, named stored procedure parameters, and save points are also implemented.

You can ALTER the table just after creation using the sqlmeta attribute createSQL, for example: class SomeObject(SQLObject): class sqlmeta: createSQL = { 'mysql' : 'ALTER TABLE some_object ENGINE InnoDB' } # your columns here Maybe you want to specify the charset too? No problem: class SomeObject(SQLObject): class sqlmeta: createSQL = { 'mysql' : [ 'ALTER TABLE some_object ENGINE InnoDB', '''ALTER TABLE some_object CHARACTER SET utf8 COLLATE utf8_estonian_ci'''] }