File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes ORA-01019: unable to allocate memory in the user side Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "ORA-01019: unable to allocate memory in the user side" Watch "ORA-01019: unable to allocate memory in the user side" New topic

ORA-01019: unable to allocate memory in the user side

Anil Deshpande
Ranch Hand

Joined: Jan 13, 2008
Posts: 119
i have installed Windows Vista, and working on Oracle 10 g Express Edition. I have written the progam to test my jdbc connection. but it is throwing the sql exception. I know it's the problem with the Oracle not java. The solution in the oracle is that to increase the buffer size of the heap. I tried that by going to odbc connection in administrative tools. Initially it was 64kb, I increased it to 128kb. But it's Not helping. I am giving the complete code.Tables have been created properly. I am able to query them in Oracle.

I googled and tried to find out the solution through Oracle data base forums. But no where the proper solution to increase the buffer size has been provided.
Please help me.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestDataBaseConnection {

* @param args
public static void main(String[] args)
// TODO Auto-generated method stub
Connection con=DriverManager.getConnection("jdbcdbc:anil","scott","tiger");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from users");

System.out.println(" "+rs.getString(1)+"\t"+rs.getString(2));

}catch(ClassNotFoundException cnf)
catch(SQLException sql)



java.sql.SQLException: [Microsoft][ODBC driver for Oracle][Oracle]ORA-01019: unable to allocate memory in the user side

Anil Deshpande
SCJP 1.5, SCWCD 1.5
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

Oracle specific question not related to JDBC, so moving it to that forum...

[OCA 8 Book] [Blog]
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46397
Don't know, but when I googled I found this and this. Don't know whether they help you, but have a look at them.
Jelle Klap

Joined: Mar 10, 2008
Posts: 1951

Quick question, why are you using a JDBC-ODBC bridge instead of directly using the JDBC driver provided by Oracle?

Build a man a fire, and he'll be warm for a day. Set a man on fire, and he'll be warm for the rest of his life.
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

I installed Oracle XE database on my PC running Windows XP.
I used the Oracle JDBC driver in order to connect to the database from my java code.
The XE database default installation sets up the HR sample schema.
The database connection URL I use is:

jdbc racle:thin:hr/hr@//localhost:1521/XE

Good Luck,

[edit]Disable Smilies. CR[/edit]
[ August 25, 2008: Message edited by: Campbell Ritchie ]
I agree. Here's the link:
subject: ORA-01019: unable to allocate memory in the user side
jQuery in Action, 3rd edition