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 ... |
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 ... |
Is there any way of copying a database from oracle to sqlserver 2005? Thanks
|
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 ... |
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 ... |
Problem:
A jar file was failed to deploy on a UAT server.
Reason:
Because when we are trying to rename it,it is showing
"cannot rename the file it is been used by another user".
step ... |
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())
{
...
|
|
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 ... |
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 ... |
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 ...
|
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 ... |
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 ... |
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 ... |
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 ... |
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 + "}"); ...
|
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 ... |
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 ... |
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 ... |
|
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 ... |
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 ... |
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'," + "' ... |
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 ... |
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, ... |
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 ... |
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, ... |
|
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 ... |
|
|
|
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 ... |
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 ... |
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. |
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 |
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 ... |
|
|
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 ... |
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 ... |
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 ... |