mysql « oracle « Java Database Q&A





1. What is the equivalent of Oracle’s REF CURSOR in MySQL when using JDBC?    stackoverflow.com

In Oracle I can declare a reference cursor...

TYPE t_spool IS REF CURSOR RETURN spool%ROWTYPE;
...and use it to pass a cursor as the return value...
FUNCTION end_spool
    RETURN t_spool
  ...

2. Regular expressions in JDBC    stackoverflow.com

I have a java-application using JDBC for database interaction. I want to do a search based on a series of regular-expressions, however the application should be generic, we do not know ...

3. Customer management / What database is recommend?    stackoverflow.com

My workmate and I are trainees and we got an exercise to realize a project. We have decided us to create a customer management in Java. Now we have to choose ...

4. Comparing RDBM's with a Java application    stackoverflow.com

I am buiding an application in Java that connects to a variety of databases, MySQL, Oracle, Firebird and a few others. The user (me) can select a test for that connection ...

5. Nodes/Server/Internet data syncing    stackoverflow.com

For the last four years I have been trying and I have been thinking ways to do the next: I have data in various java clients (without database for sake of simplicity ...

6. DdlUtils: defering insertion    stackoverflow.com

in order to migrate a db from oracle to mysql i am using ddlutils. Migrating the schema works for my purposes, but inserting the data fails due to missing rows. The ...

7. java Connection Pooling from Oracle    stackoverflow.com

I'm trying to make a connection pool following this link: http://192.9.162.55/developer/onlineTraining/Programming/JDCBook/conpool.html I don't understand something: Somewhere in the class JDCConnectionDriver implements Driver you can find this method:

public static final String ...

8. JDBC Connection pooling    stackoverflow.com

Currently Im looking for a library which provide connection pooling for JDBC. My application is a real-time one. So the connection pooling should support high concurrency. And I also want it ...

9. which database to use oracle, SQLServer2000 or MySQl    stackoverflow.com

I am new to java, and also reading the JDBC stuff, I have the executable(installer) for three of the databases, Oracle 10G, MSSql-2000, MySQL. I wanted to ask which one of these ...





10. MySQL vs ORACLE and JDBC    coderanch.com

All, I've seen a lot of posts regarding mySQL. I've heard some things about mySQL and it all sounds good. I'm currently using Personal ORACLE on my notebook to do some development. This thing is a total memory hog! I have 512M of RAM on this baby (my notebook). Unfortunately, P. Oracle can eat up more than half of it. I ...

11. Converting a JDBC app from MySQL to Oracle 9    coderanch.com

hi if u have installed oracle properly & if u r using thin client .. then u need to put classes12.jar in ur claspath .. & run this program ... if it runs properly displaying all the metadata .. then everything is fn .. see how they have connecte to oracle u have to use change host & databasename & enter ...

12. [Best practice] From Oracle to MySQL    coderanch.com

Hey there, We are building a Struts webapp for a client that will use a MySQL database. The webapp will only do getMethods (selects). The main database were all the info is, is an Oracle DB and so somehow the necessary data will have to go from the Oracle to the MySQL DB. As the budget is rather limited, I would ...

13. mySQL, MS access, Oracle ...spec question    coderanch.com

guys, Say I have to create a database with the following spec: 500 users, 30 simultaneous connections, All information in the db will be text and will not exceed 200Mb What db should I use? Ive been using MS for a while and it worked great, however, I learned that mySQL is much more robust and FREE. As per Oracle ...

14. mysql or oracle 10g Express    coderanch.com

we are creating a web application and going to host that onto a customized operating system which has mysql embedded in it we are yet to decide whether to go for that or oracle 10g Express Edition which is also free . if anybody can tell me just the differences between them i will be thankful

15. how to use JDBC with mySQL and oracle    coderanch.com

16. mysql to oracle    coderanch.com





17. Difference between MySql and Oracle    coderanch.com

20. Deploying Java Desktop application with database (MySQL, ORACLE, other...)    java-forums.org

I'm going to developed a java application that will use a database which will be running in a local windows computer. I want to make this installation program distributable so that any user who does not know anything about java or data bases should be able to run it in his system with just a click. The user should not be ...

21. MySQL Blob to Oracle BLOB Conversion    forums.oracle.com

Issue a SELECT statement on the MySQL blob. Get a reference to the input stream of that blob. Issue an INSERT statement on the Oracle blob. Populate it with empty_blob(). Then issue a SELECT FOR UPDATE. Get a reference to the output stream of that blob. Pipe the bytes between the two blobs using standard java.io classes (e.g., InputStream#read() and OutputStream#write()). ...

22. Deploying Java Desktop application with database (MySQL, ORACLE, other...)    forums.oracle.com

I'm going to developed a java application that will use a database which will be running in a local windows computer. I want to make this installation program distributable so that any user who doesn't know anything about java or data bases should be able to run it with just a click. The user should not be forced to install a ...