1. How can I generically detect if a database is 'empty' from Java    stackoverflow.com

Can anyone suggest a good way of detecting if a database is empty from Java (needs to support at least Microsoft SQL Server, Derby and Oracle)? By empty I mean in the ...

2. What options are available for connecting to a Microsoft SQL Server database from an Oracle database?    stackoverflow.com

At the moment I pull data from remote MS SQL Server databases using custom-built JDBC connectors. This works fine but doesn't feel like the way to do it. I feel I should ...

3. copying oracle to sqlserver 2005 jdbc    stackoverflow.com

Is there any way of copying a database from oracle to sqlserver 2005? Thanks

4. How do I figure out if a column size is in bytes or characters from the column metadata?    stackoverflow.com

I am working on some software that has to create dummy entries in various databases (Oracle, DB2, SQLServer) temporarily. Every column in the the row is filled with random data. The ...

5. SQL LIKE Performance with only the wildcard (%) as a value    stackoverflow.com

I am wondering what the performance of a query would be like using the LIKE keyword and the wildcard as the value compared to having no where clause at all. Consider a ...

6. How to get the list of java processes along with their PID(process id) that are running on UAT server under a specfic account?    stackoverflow.com

Problem:

Reason:

step ...

7. JDBC Code Change From SQL Server to Oracle    stackoverflow.com

In the JDBC code, I have the following that is working with SQL Server:

CallableStatement stmt = connection.prepareCall("{ call getName() }");

ResultSet rs = stmt.executeQuery();

if(rs != null)
{

  while(rs.next())
  {

   ...

8. The best database for a C++ and java applications    stackoverflow.com

Hi I am making an ATM console application in C++. I am planning to use a database, my friend suggested to use files. However, I want to use a database like ...

9. Storing result set for later fetch    stackoverflow.com

I have some queries that run for a quite long (20-30 minutes). If a lot of queries are started simultaneously, connection pool is drained quickly. Is it possible to wrap the ...

10. Are there any DBMS-specific SQL client Java libraries out there (not necessarily JDBC related nor compliant)    stackoverflow.com

This is the scenario:

• I need to replace MySQL, Oracle and SQL Server sql clients with Java code
• I need to run sql script files with DBMS-specific statements from that Java code
• I've been ...

11. Oracle to SQL server communication - JDBC vs ODBC    stackoverflow.com

Just looking for people's opinion regarding communication between an Oracle 10G database running on Unix and a SQL Server database running on Windows. I have a requirement to write a batch ...

12. Using PL/SQL to invoke a java method that uses JDBC to connect to a SQL server database    stackoverflow.com

I would like to be able to connect an Oracle database with a SQL server database. I am aware of DG4ODBC and HSODBC but i cant use those drivers for several ...

13. connecting to multiple databases using different jdbc drivers    stackoverflow.com

I have a requirement to write a daemon based java process (Not web based) that will connect to an Oracle 10G database, read some data from it and then connect to ...

14. faster way for moving large amounts data in oracle to external database    stackoverflow.com

I have a java program that compares and moves data from a local Oracle database to an external MS SQL data base hosted by an online vendor. Currently the program ...

15. What is the equivalent of Oracle’s REF CURSOR in MS-SQL when using JDBC?    stackoverflow.com

In Oracle I can declare a reference cursor. but MS-SQL I don't know.

private Connection conn;
private CallableStatement stmt; 
private OracleResultSet rset; 
stmt = conn.prepareCall("{ ? = call " + call + "}"); ...

16. Java double and Oracle float into SQL Server numeric    stackoverflow.com

I'm working on a SQL Server database and need to make sure the numeric types are large enough for the data. There are two sources: Java double and Oracle float(126). The SQL Server ...

17. nvarchar & varchar with Oracle & SQLServer    stackoverflow.com

I need to upload some data from an Oracle table to a SQL Server table. The data will be uploaded to the SQL server using a Java processing utilising JDBC ...

18. Oracle or SQL Server?    coderanch.com

Oracle has a clever concurrency model and better sequence generation features than SQL server. PL / SQL is a richer programming language than Microsofts T-SQL equivalent - although both are extendable using COM or dynamically linked libraries, aswell as command line evocation. Oracle's major fault is that it comes with a complex and expensive licensing model, and to use it properly ...

19. Migrating Oracle to SQL Server    coderanch.com

20. Copying BLOB from SQL Server 2000 to Oracle 8    coderanch.com

i havent done this on SQL Server, only Oracle, but basically to get a BLOB you need to open a stream to it, so use the resultSet's getBlob() method into a java.sql.Blob, then use the Blob's getBinaryStream and read from it into a buffer. Then perform the reverse - there is a catch however. If you're updating an existing row, the ...

21. Oracle vs SQL Server with J2EE    coderanch.com

I wouldn't say there are much differences in the JDBC driver regarding performance (talking about pure JDBC driver). The biggest difference should happen in the DB itself. For Oracle there exists also an OCI driver (native) which can be called from java. This driver increases performance immens. The other thing is also which machine are you running your db. Oracle needs ...

22. Sql Server and Oracle - date    coderanch.com

I am using a string for the date. Here is the statement using newDate: PreparedStatement statementInsertDate = conn.prepareStatement( "INSERT INTO tca_master " + "(instidq, instid, instcd, source_id," + "source_cd, dpmask, fyt, lyt, iname," + "univ_dpmask, dinstid, dinstcd, tastatus," + "last_mod_user, last_mod_date)" + "VALUES " + "('73', 'MIAMI', 'CAE'," + "'002463 ',' '," + "' ', '200402', '200206', 'ELOM UNIVERSITY'," + "' ...

23. Using Java How to find a List of tablespaces in a database(Oracle,DB2,MSSQL)    coderanch.com

Bala, If I am not mistaken, different DBMS's define "tablespace" in different ways. In any case, as far as I know, there is nothing in the JDBC API that will return the "tablespace" names. Of-course, you can get the table names via the "getTables()" method of the "java.sql.DatabaseMetaData" interface. If you really want the "tablespace" names, then I think you will ...

24. sql server to oracle(sql plus)    coderanch.com

hi all i have forwarded a small piece of sql server code...i want an equivalent of this in oracle.. iam a bit confused with using "case" and "joins" please help to solve it out ... also provide me links where i can learn the same the code piece is as follows: SELECT DISTINCT rd.RD_Resdtlid,rh.rs_resid,rd.RD_AccNo,Rh.RS_Title,rd.RD_ownerstaff,pub.PU_PubName,rd.Flowid,elm.Location_Name, CASE WHEN rd.rd_resuseStatus <> 'A' THEN isnull(emp.EMP_FIRSTNAME, ...

25. Connecting natively to db2,MSSql,oracle, and access    coderanch.com

You only connect to the database using ODBC if you use the Type-1 driver also known as the jdbc-odbc bridge. Types 2 and 3 are a mixture (you can search the forum for a more complete definition), but Type-4 drivers are Java libraries usually developped by the database vendor which allows Java code to talk directly to the database ie no ...

26. OutOfMemory just in Mysql, not in Oracle or SqlServer    coderanch.com

Hi everyone, i developing an application that downloads information of different databases and create plain text with that information. Each 200,000 records, i going to the text plain and write the contents of a StringBuffer, and create a new one to continue record information in it. In Oracle, my code work fine, with a table of 5,600,000 records, but in mysql, ...

27. Is sql statements in oracle and sql server are same?    coderanch.com

28. SQL Server vs Oracle    coderanch.com

i had worked on oracle and sqlserver 7.both are having advantages of its own.I had make some workaround in writing programs while using sqlserver where i had to get the rownumber ,sequence (theres an option in sqlserver IDENTITY) for some purpose. i would say i'll go for oracle rather than sqlserver.as said by other friends,it depends on one's comfortability and size ...

29. connecting to db - Oracle vs MS SQL    coderanch.com

30. Query of Oracle to SQL Server    coderanch.com

31. Oracle 9i and SQL Server 2000 why the difference???    coderanch.com

32. Is there a way that my app support SQLServer and Oracle?    coderanch.com

Originally posted by Steve McLeod: Try Hibernate. It takes care of these SQL portability issues for you. It's a great library for DB interaction from Java. Not all issues, there are times stored procedures and/or hand-written queries are optimal in large enough systems. As great as hiberate/jdo frameworks are, they often decrease performance compared to JDBC. To answer Carlos's original question ...

33. can oracle and sql server be installed in win98 and run good? another:how connect -?    coderanch.com

I too run MySql 3.23 on both my Win98 Machine & my Win200 machine....easy to use, simple to set up & work like a charm. MySql also doesnt put much of a drain on the machine's memory......Oracle on the other hand is a nightmare.....I have it on a WinNT machine that came with 8ai & it runs fine....BUT.....I downloaded the new ...

34. Oracle and SQLServer 2005    coderanch.com

Hi all, Till now, I have only been writing queries for Oracle database. Now I am planning to start writin queries for SQLServer 2005 database and I was wondering if the queries syntax would be same. Also if there is a good tutorial for SQLServer2005, Can someone please post a link here? Thanks.

35. Using JDBC to connect to Oracle, MySQL, Postgres, db2, MS SQL Server ?    dbforums.com

Dear all, I am a new comer in JDBC user, so it is so kind if anyone help me how to use JDBC to connect to Database Server such as: Oracle, MySQL, Postgres, db2, MS SQL Server ? Could you write a specific code for each type of Database Server ? Thanks a lot N.A.T

36. MS SQL2005 to Oracle DB    forums.oracle.com

Hello, I'm actually an ASP.Net C# programmer, but I recently had a project that requires me to convert an existing JSP program's database from MS SQL 2005 to Oracle. Now I need to asses if i can convert this one alone, but it seems that I'm still confused on which file to modify. These are the platform used by the original ...

37. utility class to convert ms sql to oracle queries    forums.oracle.com

38. Migrating a table with BLOB field from SQL-Server to Oracle.    forums.oracle.com

39. Need help converting connection string from Oracle to MS SQL 2000    forums.oracle.com

1st let me say I am completely new to JAVA and I need some help..... Below is what I currently have that's written in JAVA to connect to Oracle, but I need to change it to connect to MS SQL. It was written years ago by someone else but since they are gone, I've been tasked with moving it to a ...

40. Retrieve Image from SQL Server and Store in Oracle    forums.oracle.com

Hi All I want to retrieve the image stored in sql server as a image type and store that image to oracle as a BLOB type. I tried to retrive the image from sqlserver using getBytes and when storing to Oracle i have to type cast the byte array to BLOB then only it will be inserted please tell how to ...

41. Join ResultSet fra Oracle and MS SQL?    forums.oracle.com

I currently looking for documentation on how to JOIN ResultSet fra two different databases? Currently, we use a Oracle DB for some information, and MS SQL for some other type of information which is related to each other. Don't ask why, this is a program for some client. I'm having a hard time to find information on how to combine two ...