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