打印

Sybase12.5的自定义函数创建问题[急]

Sybase12.5的自定义函数创建问题[急]

本人想用sybase提供的user-defined function功能创建函数,可是该创建用SQLJ实现,需要有ASE_JAVA功能。怎样打开ASE_JAVA功能。一定需要sybase的license才可以吗?
我实验环境是从sybase网站download 的免费开发版12.5
我如何才能打开ASE_JAVA功能。
有SQLJ开发经验的大虾们,盘赐教。
小弟先谢了。

TOP

是要有 JAVA 选项,要 lisence
不过我可以给你 12.5 的

TOP

能发给我吗。
msn: ldai_82@hotmail.com

TOP

To install ASE Java Option:

Order Number:                953743-112
Feature Name:                ASE_JAVA
Feature Count:                1
Software Version:        12.0
Authorization Code:        1781A63367EA

To install ASE EJB Option:
Order Number:                1025197-35
Feature Name:                ASE_EJB
Feature Count:                1
Software Version:        12.5
Authorization Code:        10AD813E0AA6

TOP

我启动lmgr进行注册了,开始有两个选项ASE  / AseDemo
我试了一遍, sp_configure "enable java",1后,重新启动server还是报Configuration parameter 'enable java' can not be enabled without license 'ASE_JAVA'。
查了一下资料要先启lmgrd -c license.dat文件.但总报
15:04:09 (lmgrd) -----------------------------------------------
15:04:09 (lmgrd)   Please Note:
15:04:09 (lmgrd)
15:04:09 (lmgrd)   This log is intended for debug purposes only.
15:04:09 (lmgrd)   There are many details in licensing policies
15:04:09 (lmgrd)   that are not reported in the information logged
15:04:09 (lmgrd)   here, so if you use this log file for any kind
15:04:09 (lmgrd)   of usage reporting you will generally produce
15:04:09 (lmgrd)   incorrect results.
15:04:09 (lmgrd)
15:04:09 (lmgrd) -----------------------------------------------
15:04:09 (lmgrd)
15:04:09 (lmgrd)
15:04:09 (lmgrd) FLEXlm (v6.1g) started on mail.demo.com (linux) (5/25/2004)
15:04:09 (lmgrd) FLEXlm Copyright 1988-1999, Globetrotter Software, Inc.
15:04:09 (lmgrd) US Patents 5,390,297 and 5,671,412.
15:04:09 (lmgrd) World Wide Web:  http://www.globetrotter.com
15:04:09 (lmgrd) License file(s): /opt/sybase-12.5/SYSAM/licenses/license.dat
15:04:09 (lmgrd) lmgrd tcp-port 29722
15:04:09 (lmgrd) The license daemon has found no vendor daemons to start
15:04:09 (lmgrd)  (There are no DAEMON lines in the license file), lmgrd exiting.

所以,花好月圆兄,能否告之如何是ASE_JAVA的license有效呀。你是怎么启用ASE_JAVA的.
不管怎样,小弟在这儿谢谢你的援手了。
Sybase做得也太紊乱了点。

TOP

刚才把-c写成小写了,换成大写lmgrd -C启动了,但ASE_JAVA还是没有正确打开。
盼众大虾指点迷津:

bash-2.05$ ./lmgrd -C
bash-2.05$ 15:44:04 (lmgrd) -----------------------------------------------
15:44:04 (lmgrd)   Please Note:
15:44:04 (lmgrd)
15:44:04 (lmgrd)   This log is intended for debug purposes only.
15:44:04 (lmgrd)   There are many details in licensing policies
15:44:04 (lmgrd)   that are not reported in the information logged
15:44:04 (lmgrd)   here, so if you use this log file for any kind
15:44:04 (lmgrd)   of usage reporting you will generally produce
15:44:04 (lmgrd)   incorrect results.
15:44:04 (lmgrd)
15:44:04 (lmgrd) -----------------------------------------------
15:44:04 (lmgrd)
15:44:04 (lmgrd)
15:44:04 (lmgrd) FLEXlm (v6.1g) started on mail.demo.com (linux) (5/25/2004)
15:44:04 (lmgrd) FLEXlm Copyright 1988-1999, Globetrotter Software, Inc.
15:44:04 (lmgrd) US Patents 5,390,297 and 5,671,412.
15:44:04 (lmgrd) World Wide Web:  http://www.globetrotter.com
15:44:04 (lmgrd) License file(s): /opt/sybase-12.5/SYSAM/licenses/license.dat
15:44:04 (lmgrd) lmgrd tcp-port 29722
15:44:04 (lmgrd) Starting vendor daemons ...
15:44:04 (lmgrd) Started SYBASE15:44:04 (SYBASE) FLEXlm version 6.1g
15:44:04 (SYBASE) Server started on mail.demo.com for:  ASE_JAVA
(internet tcp_port 41219 pid 4865)
15:45:50 (SYBASE) WARNING: duplicate license file lines:
   INCREMENT ASE_JAVA SYBASE 12.0 permanent 1 1781A63367EA \
        O [...]
15:45:50 (SYBASE) Server started on mail.demo.com for:  ASE_JAVA
15:45:50 (SYBASE) Updating feature ASE_JAVA
15:46:37 (SYBASE) WARNING: duplicate license file lines:
   INCREMENT ASE_JAVA SYBASE 12.0 permanent 1 1781A63367EA \
        O [...]
15:46:37 (SYBASE) Server started on mail.demo.com for:  ASE_JAVA
15:46:37 (SYBASE) ASE_EJB
15:46:37 (SYBASE) Updating feature ASE_JAVA
15:46:49 (SYBASE) UNSUPPORTED: "ASE_SERVER" (PORT_AT_HOST_PLUS   ) sybase@mail.demo.com  (License server does not support this feature (-18,327))
15:46:49 (SYBASE) UNSUPPORTED: "ASE_SBE" (PORT_AT_HOST_PLUS   ) sybase@mail.demo.com  (License server does not support this feature (-18,327))
15:46:49 (SYBASE) UNSUPPORTED: "ASE_DEV" (PORT_AT_HOST_PLUS   ) sybase@mail.demo.com  (License server does not support this feature (-18,327))

TOP

兄弟,你的 sybase 是企业版还是开发版??

TOP

开发版不能用,

TOP

那掺了,从sybase上下载的是免费开发版呀。郁闷

TOP

兄弟,请问怎么在sybase里面写自定义函数?(傻傻的问。)

TOP


感谢一直以来您对我们的支持!
当前时区 GMT+8, 现在时间是 2008-8-29 10:14 京ICP证060528 号

Designed By 17DST