Hi, I'm running sqlanywhere 12 on a Linux, Fedora core 16, 64bit machine. I have applied the latest EBF for Linux 32/64. (build 3519) I'm able to run the server, and connect to my database, but I have two problems:

  1. When ever i try to run dbisql or scjview i get the following: "Invalid maximum heap size: -Xmx0m" Could not create the Java Virtual Machine

  2. I can not load the SQLAnywhere Client libraries. phpinfo() gives me this error in the SQLAnywhere support area. I have loaded php-5.3.2_sqlanywhere.so as a PHP extension in my php.ini file, and created an sqlanywhere.ini file in the /etc/php.d directory.

Any advice would be greatly appreciated.

Tom.

asked 27 Mar '12, 14:54

tomb's gravatar image

tomb
81339
accept rate: 0%

edited 27 Mar '12, 16:27

Graham%20Hurst's gravatar image

Graham Hurst
2.7k11843


For #2 it seems that your SQLAnywhere environment is not setup correctly that's why the SQLAnywhere PHP driver cannot load the SQLAnywhere libraries. You did not specify if you are trying to run PHP from the command line or from Apache. In either case, you need to make sure that you have setup your SQLAnywhere environment by sourcing either sa_config.sh or sa_config.csh scripts located in your SQLAnywhere bin32 or bin64 directory.

permanent link

answered 28 Mar '12, 09:51

Mohammed%20Abouzour's gravatar image

Mohammed Abo...
97178
accept rate: 37%

The problem was from Apache, and you are correct. I've solved this problem by sourcing the sa_config.sh file from "/etc/sysconfig/httpd" Now when apache starts, i can see it sources the file, and loads the client libraries! Thanks again.

(28 Mar '12, 10:05) tomb

For #1, it seems that the native (non-Java) launchers for dbisql and scjview are not providing the correct default heap memory in the JVM command line, due the issue Phil describes. You can use the -batch option (eg. dbisql -batch) to generate a script file (.sh on Linux or .bat on Windows) with the same commands that the native launcher would use. As a workaround for launching dbisql or scjview directly, you could edit the generated script file to give a more appropriate -Xmx value to the Java VM, eg. -Xmx1g.

permanent link

answered 27 Mar '12, 16:06

Graham%20Hurst's gravatar image

Graham Hurst
2.7k11843
accept rate: 29%

edited 27 Mar '12, 18:51

The first issue was fixed as CR 694479 and will be included in 12.0.1 build 3539. I don't know when that is expected to be released (hopefully soon).

The problem is with how we handle the 3.0 kernel. We were doing a kernel version check (because the API changed) when calculating your system memory that assumed the kernel version would never proceed past 2. Sadly, the only workaround (other than what Graham suggested, which won't work for the server) is to remove memory from your system.

Have a look at this question for more details.

permanent link

answered 27 Mar '12, 16:20

Phil%20Mitchell's gravatar image

Phil Mitchell
1.9k1831
accept rate: 27%

edited 28 Mar '12, 00:01

Ok, thanks. I will use other tools until the new EBF is available.

(28 Mar '12, 09:12) tomb

Please note that 12.0.1 build 3723 for Linux was posted on Friday (May the 4th be with you).

(07 May '12, 10:36) Phil Mitchell
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×128
×105
×78
×68

question asked: 27 Mar '12, 14:54

question was seen: 7,892 times

last updated: 07 May '12, 10:36