【求助】jconnect5.5中脚本的倒入
我看jconnect5.5的配置说明....(英文的看不太懂)上明说要配置环境变量在/etc/profile里
exprot JDBC_HOME=/opt/sybase/jConnect-5_5
export CLASSPATH=$JDBC/classes/jconn2.jar:$JDBC/classes
当然java虚拟机也是必备的.......................
然后还需要安装一些存储过程,和表,直接倒入脚本..........................在$JDBC_HOME/classes中用
java IsqlApp -U user -P password -S jdbc:sybase:Tds:hostname:port -I $JDBC_HOME/sp/sql_server12.5.sql -c go
但是倒入的时候出现错误如下:
changing the value of "allow updates to system tables" does not increase the amount of memory Adaptive servers uses.
sql错误:sqlstate:010P4 .............
An outputparameter was received and ignored...
这个错误在脚本的倒入中每个存储过程创建时执行
exec sp_procxmode '存储过程名' ,'anymode'
都有..
请高手指点迷津,非常感谢.!!!!!!!!!
这个帖子在java区中我也帖了.由于两方面都有涉及,还有心情着急,希望斑竹不要删帖.谢谢..
在执行脚本中出现的错误（其中之一，共30个存储过程，应该都有这个错误）：
exec sp_procxmode 'sp_jdbc_jar_for_class', 'anymode'
Unexpected exception : SqlState: 010P4 java.sql.SQLWarning: 010P4: An output parameter was received and ignored., ErrorCode: 0
在脚本执行完出现的错误：Configuration option changed. The SQL Server need not be rebooted since the option is dynamic.
Changing the value of 'allow updates to system tables' does not increase the amount of memory Adaptive Server uses.
Unexpected exception : SqlState: 010P4 java.sql.SQLWarning: 010P4: An output parameter was received and ignored., ErrorCode: 0
executing:
set quoted_identifier off
<P>权限不足，要用sa .</P><P>或: isql -Usa -P < ***.sql</P>
页:
[1]