Home Help Center

Why Is my connection to DB breacking?

PAUL12PAUL12 Member paul munteanOrganization: PersonalProject: Android testing
Hy,

I connect from my Android App to a server and then I trye to insert data in a Oracle 10g DB.
Server console output.
-- 12/11/11 14:09:18:759 demo.Database.library.Server: SQLRequestContext: commit context: [email protected]
Request connection for env 1
-- 12/11/11 14:09:18:884 demo.Database.library.Server: ConnectionPool: returning connection: [email protected] 3/5 remaining
-- 12/11/11 14:09:18:884 demo.Database.library.Server: SQLRequestContext: create new context: [email protected] thread: Thread[Ice.ThreadPool.Server-4,5,main]: connection: [email protected]
Ok.
0 connections are available in cache MYCACHE
8 connections are active
Request connection for env 2
-! 12/11/11 14:09:18:970 demo.Database.library.Server: warning: Ice.ThreadPool.Server-2: ConnectionPool: lost connection to database:
   java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
   
   	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
   	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
   	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
   	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
   	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
   	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
   	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
   	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
   	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
   	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
   	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
   	at library.ConnectionPool.acquire(ConnectionPool.java:72)
   	at library.SQLRequestContext.<init>(SQLRequestContext.java:77)
   	at library.DispatchInterceptorI.dispatch(DispatchInterceptorI.java:21)
   	at Ice.DispatchInterceptor.__dispatch(DispatchInterceptor.java:43)
   	at IceInternal.Incoming.invoke(Incoming.java:159)
   	at Ice.ConnectionI.invokeAll(ConnectionI.java:2357)
   	at Ice.ConnectionI.dispatch(ConnectionI.java:1208)
   	at Ice.ConnectionI.message(ConnectionI.java:1163)
   	at IceInternal.ThreadPool.run(ThreadPool.java:302)
   	at IceInternal.ThreadPool.access$300(ThreadPool.java:12)
   	at IceInternal.ThreadPool$EventHandlerThread.run(ThreadPool.java:643)
   	at java.lang.Thread.run(Unknown Source)
   
-- 12/11/11 14:09:18:971 demo.Database.library.Server: ConnectionPool: establishing new database connection
Ok.
0 connections are available in cache MYCACHE
8 connections are active
Request connection for env 3
Ok.
0 connections are available in cache MYCACHE
8 connections are active
Request connection for env 4
Ok.
0 connections are available in cache MYCACHE
8 connections are active
Request connection for env 5
Ok.
0 connections are available in cache MYCACHE
8 connections are active
-- 12/11/11 14:09:19:341 demo.Database.library.Server: SQLRequestContext: commit context: [email protected]
-- 12/11/11 14:09:19:439 demo.Database.library.Server: ConnectionPool: returning connection: [email protected] 2/5 remaining
-- 12/11/11 14:09:19:439 demo.Database.library.Server: SQLRequestContext: create new context: [email protected] thread: Thread[Ice.ThreadPool.Server-2,5,main]: connection: [email protected]
Request connection for env 1
-! 12/11/11 14:09:19:524 demo.Database.library.Server: warning: Ice.ThreadPool.Server-3: ConnectionPool: lost connection to database:
   java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
   
   	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
   	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
   	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
   	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
   	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
   	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
   	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
   	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
   	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
   	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
   	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
   	at library.ConnectionPool.acquire(ConnectionPool.java:72)
   	at library.SQLRequestContext.<init>(SQLRequestContext.java:77)
   	at library.DispatchInterceptorI.dispatch(DispatchInterceptorI.java:21)
   	at Ice.DispatchInterceptor.__dispatch(DispatchInterceptor.java:43)
   	at IceInternal.Incoming.invoke(Incoming.java:159)
   	at Ice.ConnectionI.invokeAll(ConnectionI.java:2357)
   	at Ice.ConnectionI.dispatch(ConnectionI.java:1208)
   	at Ice.ConnectionI.message(ConnectionI.java:1163)
   	at IceInternal.ThreadPool.run(ThreadPool.java:302)
   	at IceInternal.ThreadPool.access$300(ThreadPool.java:12)
   	at IceInternal.ThreadPool$EventHandlerThread.run(ThreadPool.java:643)
   	at java.lang.Thread.run(Unknown Source)
   
-- 12/11/11 14:09:19:524 demo.Database.library.Server: ConnectionPool: establishing new database connection
Ok.

After some 800 records writen the connection breacks. Every time after 800 +/- 50 entryes the connection is lost.
I use a connection pool manager. What am I doing wrong?
Connection pool manager code is here.
http://www.rgagnon.com/javadetails/java-0545.html

Please help

Comments

  • xdmxdm La Coruña, SpainAdministrators, ZeroC Staff Jose Gutierrez de la ConchaOrganization: ZeroC, Inc.Project: Ice Developer ZeroC Staff
    From the stack trace you posted is clear that this is an SQL syntax error in the query.
       java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
    

    But that isn't an Ice related problem, probably your code doesn't correctly handle exceptions and the error propagates to other parts of your code.
Sign In or Register to comment.