when we create table directly from java in ms access,"Null" occurs

Question

when i create table directly from java in ms access,"Null" occurs.What is meant by this

xenteros · Answer 1 · 2016-09-26T14:19:46.757

0

It means that there was an Exception thrown:

net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.6 null

Which is caused by an infinite loop - StackOverflow. You have to change the heap size. This can be done by running your application with:

java -Xmx1g myprogram

You can increase the value (1g is 1GB, 14g will be 14GB) as you wish as long as you have enough memory available.

Also, you can add ;memory = false to the end of the url with which you connect to the db.

edited Sep 26 '16 at 14:19

answered Sep 26 '16 at 13:40

xenteros

would you please guide me in a simple way because i am new in java so i am not getting properly what you are saying – Mcolo Sep 26 '16 at 13:52
What IDE do you use? It looks like you want to process to much data at once. – xenteros Sep 26 '16 at 13:52
I can't navigate on it, but you have to find the run configuration and add system variable -Xmx1g – xenteros Sep 26 '16 at 13:53
what's this Xmx1g? – Mcolo Sep 26 '16 at 13:54
Variable which will tell your JVM to allocate more memory for the heap. – xenteros Sep 26 '16 at 13:55
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/124220/discussion-between-mcolo-and-xenteros). – Mcolo Sep 26 '16 at 13:55

score -1 · Answer 2 · answered Sep 26 '16 at 19:48

-1

You can counter this by using this with your code

DriverManager.getConnection("jdbc:ucanaccess://D:Database.accdb memory=false");

and then go to your ms access database file and open it and go to Database Tool and Click to Compact and repair option.

answered Sep 26 '16 at 19:48

Abdullah Nasir

1

You are missing the semi-colon (`;`) before `memory`. – Gord Thompson Sep 27 '16 at 00:13

2 Answers2