This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
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
Author

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

Anil Deshpande
Ranch Hand

Joined: Jan 13, 2008
Posts: 119
Hi,
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
try
{
System.out.println(0);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("anil");
Connection con=DriverManager.getConnection("jdbcdbc:anil","scott","tiger");
System.out.println(1);
Statement st=con.createStatement();
System.out.println(2);
ResultSet rs=st.executeQuery("select * from users");
System.out.println(3);

while(rs.next())
{
System.out.println(" "+rs.getString(1)+"\t"+rs.getString(2));
}

}catch(ClassNotFoundException cnf)
{
System.out.println(cnf);
}
catch(SQLException sql)
{
System.out.println(sql);
}

}
}


THE EXCEPTION BEING THROWN IS

0
anil
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: 3704
    
    5

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


My Blog: Down Home Country Coding with Scott Selikoff
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38441
    
  23
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
Bartender

Joined: Mar 10, 2008
Posts: 1761
    
    7

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: 1131

Anil,
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,
Avi.

[edit]Disable Smilies. CR[/edit]
[ August 25, 2008: Message edited by: Campbell Ritchie ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-01019: unable to allocate memory in the user side