db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ян Программист <webautoma...@gmail.com>
Subject VTI tables
Date Mon, 19 Apr 2010 10:17:10 GMT
I had some bugs while trying to configure network server for Derby

ij> connect 'jdbc:derby:repository;create=true';
ОШИБКА JAVA: java.lang.ExceptionInInitializerError

Under a tryout to create a transaction I had such exception:



Exception in thread "main" java.sql.SQLException: DERBY SQL error: SQLCODE:
-1, SQLSTATE: XJ040, SQLERRMC: Не удалось запустить базу данных
'repository'; смотрите информацию в следующем исключении.::SQLSTATE:
XSTB0Сгенерировано исключение при прекращении транзакции.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at TransactionEvaluation.main(TransactionEvaluation.java:11)
Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error:
SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Не удалось запустить базу данных
'repository'; смотрите информацию в следующем исключении.::SQLSTATE:
XSTB0Сгенерировано исключение при прекращении транзакции.
at org.apache.derby.client.am.Connection.completeSqlca(Unknown Source)
at
org.apache.derby.client.net.NetConnectionReply.parseRdbAccessFailed(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown
Source)
at org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown
Source)
at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown
Source)
at org.apache.derby.client.net.NetConnection.flowUSRIDONLconnect(Unknown
Source)
at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)
at
org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown
Source)
... 4 more


It looked like database didn't existed. But after next tryout had this:

$ ./ij
#
# A fatal error has been detected by the Java Runtime Environment:
#
#  SIGBUS (0x7) at pc=0x00007fbc1e0ed53f, pid=3918, tid=140445921134864
#
# JRE version: 6.0_15-b03
# Java VM: Java HotSpot(TM) 64-Bit Server VM (14.1-b02 mixed mode, sharing
linux-amd64 )
# Problematic frame:
# C  [libc.so.6+0x8153f]  memset+0x49f
#
# An error report file with more information is saved as:
# /tmp/hs_err_pid3918.log
Ошибка сегментирования

derby.log reported that Derby unable to write into log

After reboot I tried one more time and got this:

524288
Exception in thread "main" java.sql.SQLNonTransientConnectionException:
Обнаружена ошибка сетевого протокола, и соединение
прервано: затребованная
команда не реализована сервером либо обнаружила
связанное с реализацией
условие, для которого нет сообщения, связанного с
реализацией
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.execute(Unknown Source)
at TransactionEvaluation.main(TransactionEvaluation.java:19)
Caused by: org.apache.derby.client.am.DisconnectException: Обнаружена ошибка
сетевого протокола, и соединение прервано: затребованная
команда не
реализована сервером либо обнаружила связанное с
реализацией условие, для
которого нет сообщения, связанного с реализацией
at org.apache.derby.client.net.NetConnectionReply.parseCMDCHKRM(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.parseExecuteError(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown Source)
at org.apache.derby.client.net.StatementReply.readExecute(Unknown Source)
at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.readExecute(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.executeX(Unknown Source)
... 2 more

The number "524288" was a select count(*) from a table

And after processing some SQL I got following error:

ij> create table trans_set
> (
> id integer,
> description varchar(10)
> );
ij(CONNECTION1)> create table trans_set_1
> (
> id integer,
> description varchar(10)
> );
ОШИБКА XBCA0: Невозможно создать новый объект с ключом
Container(0, 16) в
кэше ContainerCache. Объект уже существует в кэше.

John

Mime
View raw message