Subject | Re: [Firebird-Java] Re: Problem while inserting data through stored procedure |
---|---|
Author | Carsten Schäfer |
Post date | 2003-08-22T08:03:08Z |
Hi,
at one of our costumers i get the same error from time to time.
Client & Server are also on the same machine.
It's not reproducable, with other costumers there are no problems.
But after that error the driver throws exceptions for every transaction
i start.
Mostly i get the following two errors together, the first one is from
an rmi connection between two java services that are running on the
same machine: java.rmi.ConnectException: Connection refused to host:
localhost; nested exception is: java.net.ConnectException: Connection
timed out: connect at
sun.rmi.transport.tcp.TCPEndpoint.newSocket(Unknown Source) at
sun.rmi.transport.tcp.TCPChannel.createConnection(Unknown Source) at
sun.rmi.transport.tcp.TCPChannel.newConnection(Unknown Source) at
sun.rmi.server.UnicastRef.newCall(Unknown Source) at
sun.rmi.registry.RegistryImpl_Stub.lookup(Unknown Source) at
java.rmi.Naming.lookup(Unknown Source)
java.sql.SQLException: ResourceException:
org.firebirdsql.jca.FBResourceException: Unable to complete network
request to host "". Reason: Unable to complete network request to host
"". at
org.firebirdsql.jdbc.FBConnection.ensureInTransaction(FBConnection.java:1003
)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:77)
Then there are no more network errors but i get the following one for
every transaction: java.sql.SQLException: ResourceException:
org.firebirdsql.jca.FBResourceException: local transaction active:
can't begin another Reason: local transaction active: can't begin
another at
org.firebirdsql.jdbc.FBConnection.ensureInTransaction(FBConnection.java:1003
)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:77)
at
org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:243)
mfg
Carsten
---- Original Message ----
From: raghoos_2000
To: Firebird-Java@yahoogroups.com
Sent: Friday, August 22, 2003 3:44 AM
Subject: [Firebird-Java] Re: Problem while inserting data through
stored procedure
at one of our costumers i get the same error from time to time.
Client & Server are also on the same machine.
It's not reproducable, with other costumers there are no problems.
But after that error the driver throws exceptions for every transaction
i start.
Mostly i get the following two errors together, the first one is from
an rmi connection between two java services that are running on the
same machine: java.rmi.ConnectException: Connection refused to host:
localhost; nested exception is: java.net.ConnectException: Connection
timed out: connect at
sun.rmi.transport.tcp.TCPEndpoint.newSocket(Unknown Source) at
sun.rmi.transport.tcp.TCPChannel.createConnection(Unknown Source) at
sun.rmi.transport.tcp.TCPChannel.newConnection(Unknown Source) at
sun.rmi.server.UnicastRef.newCall(Unknown Source) at
sun.rmi.registry.RegistryImpl_Stub.lookup(Unknown Source) at
java.rmi.Naming.lookup(Unknown Source)
java.sql.SQLException: ResourceException:
org.firebirdsql.jca.FBResourceException: Unable to complete network
request to host "". Reason: Unable to complete network request to host
"". at
org.firebirdsql.jdbc.FBConnection.ensureInTransaction(FBConnection.java:1003
)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:77)
Then there are no more network errors but i get the following one for
every transaction: java.sql.SQLException: ResourceException:
org.firebirdsql.jca.FBResourceException: local transaction active:
can't begin another Reason: local transaction active: can't begin
another at
org.firebirdsql.jdbc.FBConnection.ensureInTransaction(FBConnection.java:1003
)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:77)
at
org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:243)
mfg
Carsten
---- Original Message ----
From: raghoos_2000
To: Firebird-Java@yahoogroups.com
Sent: Friday, August 22, 2003 3:44 AM
Subject: [Firebird-Java] Re: Problem while inserting data through
stored procedure
>> Hi,
>>
>>> org.firebirdsql.jdbc.FBSQLException: GDS Exception. Error reading
>>> data from the connection.Unable to rollback
>>>
>>> java.sql.SQLException: ResourceException:
>>> org.firebirdsql.jca.FBResourceException: Unable to complete network
>>> request to host "".
>>
>> Are you sure that there was no network failure during excution? It
>> seems that the socket was broken.
>>
>> If you're sure and can reproduce this failure, it would be great if
>> you can post a test case for this issue.
>>
>> Best regards,
>> Roman Rokytskyy
>
> Hi Roman,
> I am sure that there was no network failure,client and
> server is on same machine.
> Regards,
> Ragavendra.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.