Гость
Войти | Профиль | Очистить
Целевая тема:
Создать новую тему:
Автор:
Действия ...
Форумы / Java [игнор отключен] [закрыт для гостей] / mysql JDBC+JBOSS / 7 сообщений из 7, страница 1 из 1
07.09.2007, 13:46:06
    #34784346
GerdaS
GerdaS
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
mysql JDBC+JBOSS
работает всё боле мение стабильно, во время conn = pool.getConnection(); в:
Код: plaintext
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
 public   class  Test {

    DataSource pool;

     private   static   final  Logger LOG = Logger.getLogger("Test");
     public  DBReversiAdmin(){

        LOG.debug("Test start");
        Context env =  null ;
       // LOG.debug("Context env = null");
         try {

            env = (Context)  new  InitialContext().lookup("java:comp/env");
          //  LOG.debug("env ok");
            pool = (DataSource) env.lookup("jdbc/ReversiDB");
           // LOG.debug("pool ok");

             if (pool ==  null ){
                LOG.error("jdbc/ReversiDB is an unknown DataSource");
            }

        }  catch  (NamingException nex){

            nex.printStackTrace();
            LOG.error("error: ");
        }
    }
  public  String getApponent(String clientId){
        LOG.info("Apponent start: "+clientId);
        String apponentId =  null ;
        Connection conn = null ;
        Statement stmt =  null ;
        ResultSet rs =  null ;
        ResultSetMetaData md =  null ;
        String sqlSelect = "SELECT firstClientId , secondClientId FROM reversi.ControllerGame WHERE " +
                "secondClientId=\""+clientId+"\" or firstClientId=\""+clientId+"\";";
        //LOG.debug(sqlSelect);
         try {

             try {
                LOG.debug("conn start");
                conn = pool.getConnection();
                LOG.debug("conn ");
                stmt = conn.createStatement();
                LOG.debug(" stmt");
                rs = stmt.executeQuery(sqlSelect);
                LOG.debug(" rs");
               // md = rs.getMetaData();
                LOG.debug("rs: "+rs.next());
                 if ((rs.getString( 1 ).equals(clientId))){

                     if (!rs.getString( 2 ).equals("0")){                         
                         apponentId = rs.getString( 2 );
                    }
                }  else {
                     if (!rs.getString( 1 ).equals("0")){ 
                        apponentId = rs.getString( 1 );
                    }
                }
        } finally {
                stmt.close();
                conn.close();
            }
        } catch (SQLException ex){
            LOG.error("error");
            ex.printStackTrace();
        }
        LOG.info("getApponent stop");
         return  apponentId;
    }
}

вылетает портянка:
Код: plaintext
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
 2007 - 09 - 07   13 : 30 : 20 , 111  WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable
  while  attempting to get a  new  connection:  null 
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.mysql.jd
bc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.lang.NullPointerException

STACKTRACE:

java.lang.NullPointerException
        at com.mysql.jdbc.Connection.checkTransactionIsolationLevel(Connection.java: 1956 )
        at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java: 3807 )
        at com.mysql.jdbc.Connection.createNewIO(Connection.java: 2585 )
        at com.mysql.jdbc.Connection.<init>(Connection.java: 1485 )
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java: 266 )
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(Lo
calManagedConnectionFactory.java: 169 )
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListen
er(InternalManagedConnectionPool.java: 539 )
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManag
edConnectionPool.java: 228 )
        at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossMa
nagedConnectionPool.java: 417 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectio
nManager2.java: 324 )
        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionMana
ger.java: 301 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionM
anager2.java: 379 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateCon
nection(BaseConnectionManager2.java: 812 )
        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java: 88 )
        at com.bcc.game.reversi.admin.DBReversiAdmin.getApponent(DBReversiAdmin.java: 105 )
        at com.bcc.game.reversi.admin.DBReversiAdmin.sendClient(DBReversiAdmin.java: 169 )
        at com.bcc.game.reversi.ServiceInstance.runStatusReady(ServiceInstance.java: 434 )
        at com.bcc.game.reversi.ServiceInstance.processMessage(ServiceInstance.java: 109 )
        at sun.reflect.NativeMethodAccessorImpl.invoke0( Native  Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39 )
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25 )
        at java.lang.reflect.Method.invoke(Method.java: 324 )
        at org.apache.xmlrpc.Invoker.execute(Invoker.java: 168 )
        at org.apache.xmlrpc.XmlRpcWorker.invokeHandler(XmlRpcWorker.java: 123 )
        at org.apache.xmlrpc.XmlRpcWorker.execute(XmlRpcWorker.java: 185 )
        at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java: 151 )
        at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java: 128 )
        at com.bcc.game.reversi.ServiceReversiInstance.doPost(ServiceReversiInstance.java: 65 )
        at javax.servlet.http.HttpServlet.service(HttpServlet.java: 717 )
        at javax.servlet.http.HttpServlet.service(HttpServlet.java: 810 )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 2 
 52 )
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java: 96 )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 2 
 02 )
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 213 )
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 178 )
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java: 17 
 5 )
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java: 74 )
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126 )
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105 )
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 107 )
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 148 )
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 869 )
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11Ba
seProtocol.java: 664 )
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java: 527 )
        at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java: 112 )
        at java.lang.Thread.run(Thread.java: 534 )


** END NESTED EXCEPTION **



Last packet sent to the server was  5  ms ago.)
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(Lo
calManagedConnectionFactory.java: 177 )
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListen
er(InternalManagedConnectionPool.java: 539 )
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManag
edConnectionPool.java: 228 )
        at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossMa
nagedConnectionPool.java: 417 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectio
nManager2.java: 324 )
        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionMana
ger.java: 301 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionM
anager2.java: 379 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateCon
nection(BaseConnectionManager2.java: 812 )
        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java: 88 )
        at com.bcc.game.reversi.admin.DBReversiAdmin.getApponent(DBReversiAdmin.java: 105 )
        at com.bcc.game.reversi.admin.DBReversiAdmin.sendClient(DBReversiAdmin.java: 169 )
        at com.bcc.game.reversi.ServiceInstance.runStatusReady(ServiceInstance.java: 434 )
        at com.bcc.game.reversi.ServiceInstance.processMessage(ServiceInstance.java: 109 )
        at sun.reflect.NativeMethodAccessorImpl.invoke0( Native  Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39 )
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25 )
        at java.lang.reflect.Method.invoke(Method.java: 324 )
        at org.apache.xmlrpc.Invoker.execute(Invoker.java: 168 )
        at org.apache.xmlrpc.XmlRpcWorker.invokeHandler(XmlRpcWorker.java: 123 )
        at org.apache.xmlrpc.XmlRpcWorker.execute(XmlRpcWorker.java: 185 )
        at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java: 151 )
        at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java: 128 )
        at com.bcc.game.reversi.ServiceReversiInstance.doPost(ServiceReversiInstance.java: 65 )
        at javax.servlet.http.HttpServlet.service(HttpServlet.java: 717 )
        at javax.servlet.http.HttpServlet.service(HttpServlet.java: 810 )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 2 
 52 )
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java: 96 )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 2 
 02 )
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 213 )
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 178 )
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java: 17 
 5 )
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java: 74 )
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126 )
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105 )
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 107 )
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 148 )
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 869 )
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11Ba
seProtocol.java: 664 )
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java: 527 )
        at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java: 112 )
        at java.lang.Thread.run(Thread.java: 534 )
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exceptio
n:

** BEGIN NESTED EXCEPTION **

java.lang.NullPointerException

STACKTRACE:

java.lang.NullPointerException
        at com.mysql.jdbc.Connection.checkTransactionIsolationLevel(Connection.java: 1956 )
        at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java: 3807 )
        at com.mysql.jdbc.Connection.createNewIO(Connection.java: 2585 )
        at com.mysql.jdbc.Connection.<init>(Connection.java: 1485 )
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java: 266 )
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(Lo
calManagedConnectionFactory.java: 169 )
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListen
er(InternalManagedConnectionPool.java: 539 )
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManag
edConnectionPool.java: 228 )
        at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossMa
nagedConnectionPool.java: 417 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectio
nManager2.java: 324 )
        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionMana
ger.java: 301 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionM
anager2.java: 379 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateCon
nection(BaseConnectionManager2.java: 812 )
        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java: 88 )
        at com.bcc.game.reversi.admin.DBReversiAdmin.getApponent(DBReversiAdmin.java: 105 )
        at com.bcc.game.reversi.admin.DBReversiAdmin.sendClient(DBReversiAdmin.java: 169 )
        at com.bcc.game.reversi.ServiceInstance.runStatusReady(ServiceInstance.java: 434 )
        at com.bcc.game.reversi.ServiceInstance.processMessage(ServiceInstance.java: 109 )
        at sun.reflect.NativeMethodAccessorImpl.invoke0( Native  Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39 )
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25 )
        at java.lang.reflect.Method.invoke(Method.java: 324 )
        at org.apache.xmlrpc.Invoker.execute(Invoker.java: 168 )
        at org.apache.xmlrpc.XmlRpcWorker.invokeHandler(XmlRpcWorker.java: 123 )
        at org.apache.xmlrpc.XmlRpcWorker.execute(XmlRpcWorker.java: 185 )
        at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java: 151 )
        at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java: 128 )
        at com.bcc.game.reversi.ServiceReversiInstance.doPost(ServiceReversiInstance.java: 65 )
        at javax.servlet.http.HttpServlet.service(HttpServlet.java: 717 )
        at javax.servlet.http.HttpServlet.service(HttpServlet.java: 810 )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 2 
 52 )
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java: 96 )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 2 
 02 )
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 213 )
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 178 )
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java: 17 
 5 )
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java: 74 )
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126 )
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105 )
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 107 )
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 148 )
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 869 )
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11Ba
seProtocol.java: 664 )
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java: 527 )
        at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java: 112 )
        at java.lang.Thread.run(Thread.java: 534 )


** END NESTED EXCEPTION **



Last packet sent to the server was  5  ms ago.
        at com.mysql.jdbc.Connection.createNewIO(Connection.java: 2643 )
        at com.mysql.jdbc.Connection.<init>(Connection.java: 1485 )
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java: 266 )
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(Lo
calManagedConnectionFactory.java: 169 )
        ...  42  more
 2007 - 09 - 07   13 : 30 : 20 , 116  ERROR [STDERR] java.lang.NullPointerException
 2007 - 09 - 07   13 : 30 : 20 , 117  ERROR [STDERR]  at com.bcc.game.reversi.admin.DBReversiAdmin.getApponent(DBRevers
iAdmin.java: 125 )
 2007 - 09 - 07   13 : 30 : 20 , 117  ERROR [STDERR]  at com.bcc.game.reversi.admin.DBReversiAdmin.sendClient(DBReversi
Admin.java: 169 )
 2007 - 09 - 07   13 : 30 : 20 , 117  ERROR [STDERR]  at com.bcc.game.reversi.ServiceInstance.runStatusReady(ServiceIns
tance.java: 434 )
 2007 - 09 - 07   13 : 30 : 20 , 117  ERROR [STDERR]  at com.bcc.game.reversi.ServiceInstance.processMessage(ServiceIns
tance.java: 109 )
 2007 - 09 - 07   13 : 30 : 20 , 117  ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke0( Native  Method)
:


До этого этот же метод отрабатывается корректно. Что я делаю не так ??
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
07.09.2007, 13:53:42
    #34784381
Kachalov
Kachalov
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
mysql JDBC+JBOSS
авторThrowable while attempting to get a new connection: null
- пул вернул "мертвое" соединение (MySQL следит за неиспользуемыми соединениями и закрывает их по достижении времени заданного в настройках). Решается настройками пула типа connectiontimeout, и т. п. в зависимости от того что за пул.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
07.09.2007, 14:05:41
    #34784436
GerdaS
GerdaS
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
mysql JDBC+JBOSS
Kachalov авторThrowable while attempting to get a new connection: null
- пул вернул "мертвое" соединение (MySQL следит за неиспользуемыми соединениями и закрывает их по достижении времени заданного в настройках). Решается настройками пула типа connectiontimeout, и т. п. в зависимости от того что за пул.

а зачем он их хранит неиспользуемыми соединения , если корректно потом с ними работать не получается ?
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
07.09.2007, 14:54:40
    #34784641
Kachalov
Kachalov
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
mysql JDBC+JBOSS
GerdaSа зачем он их хранит неиспользуемыми соединения , если корректно потом с ними работать не получается ?
- хранит, потому что логика работы пула связана с предварительным созданием некторого количества соединений, которые в дальнейшем выдаются приложению по мере необходимости.

- то что соединение "мертвое" (закрытое БД) пулу узнать сложно, для этого надо посылать тестовый SQL-запрос (некоторые пулы так поступают).

- либо отрегулируйте настройки пула установив время жизни соединения в пуле меньшим чем время жизни неактивного соединения в MySQL, либо измените настройки MySQL увеличив время жизни соединения (что не есть гуд), либо используйте другой - более "умный" пул.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
07.09.2007, 15:50:49
    #34784898
GerdaS
GerdaS
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
mysql JDBC+JBOSS
Kachalov GerdaSа зачем он их хранит неиспользуемыми соединения , если корректно потом с ними работать не получается ?
- хранит, потому что логика работы пула связана с предварительным созданием некторого количества соединений, которые в дальнейшем выдаются приложению по мере необходимости.

- то что соединение "мертвое" (закрытое БД) пулу узнать сложно, для этого надо посылать тестовый SQL-запрос (некоторые пулы так поступают).

- либо отрегулируйте настройки пула установив время жизни соединения в пуле меньшим чем время жизни неактивного соединения в MySQL, либо измените настройки MySQL увеличив время жизни соединения (что не есть гуд), либо используйте другой - более "умный" пул.
спасибо
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
19.09.2007, 10:51:48
    #34810326
Gog66
Gog66
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
mysql JDBC+JBOSS
GerdaS


Код: plaintext
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
 2007 - 09 - 07   13 : 30 : 20 , 111  WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable
  while  attempting to get a  new  connection:  null 
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.mysql.jd
bc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.lang.NullPointerException

STACKTRACE:

java.lang.NullPointerException
        at com.mysql.jdbc.Connection.checkTransactionIsolationLevel(Connection.java: 1956 )
        at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java: 3807 )
        at com.mysql.jdbc.Connection.createNewIO(Connection.java: 2585 )
        at com.mysql.jdbc.Connection.<init>(Connection.java: 1485 )
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java: 266 )
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(Lo
calManagedConnectionFactory.java: 169 )
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListen
er(InternalManagedConnectionPool.java: 539 )
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManag
edConnectionPool.java: 228 )
        at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossMa
nagedConnectionPool.java: 417 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectio
nManager2.java: 324 )
        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionMana
ger.java: 301 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionM
anager2.java: 379 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateCon
nection(BaseConnectionManager2.java: 812 )
        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java: 88 )
        at com.bcc.game.reversi.admin.DBReversiAdmin.getApponent(DBReversiAdmin.java: 105 )
        at com.bcc.game.reversi.admin.DBReversiAdmin.sendClient(DBReversiAdmin.java: 169 )
        at com.bcc.game.reversi.ServiceInstance.runStatusReady(ServiceInstance.java: 434 )
        at com.bcc.game.reversi.ServiceInstance.processMessage(ServiceInstance.java: 109 )
        at sun.reflect.NativeMethodAccessorImpl.invoke0( Native  Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39 )
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25 )
        at java.lang.reflect.Method.invoke(Method.java: 324 )
        at org.apache.xmlrpc.Invoker.execute(Invoker.java: 168 )
        at org.apache.xmlrpc.XmlRpcWorker.invokeHandler(XmlRpcWorker.java: 123 )
        at org.apache.xmlrpc.XmlRpcWorker.execute(XmlRpcWorker.java: 185 )
        at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java: 151 )
        at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java: 128 )
        at com.bcc.game.reversi.ServiceReversiInstance.doPost(ServiceReversiInstance.java: 65 )
        at javax.servlet.http.HttpServlet.service(HttpServlet.java: 717 )
        at javax.servlet.http.HttpServlet.service(HttpServlet.java: 810 )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 2 
 52 )
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java: 96 )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 2 
 02 )
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 213 )
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 178 )
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java: 17 
 5 )
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java: 74 )
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126 )
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105 )
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 107 )
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 148 )
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 869 )
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11Ba
seProtocol.java: 664 )
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java: 527 )
        at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java: 112 )
        at java.lang.Thread.run(Thread.java: 534 )


** END NESTED EXCEPTION **



Last packet sent to the server was  5  ms ago.)
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(Lo
calManagedConnectionFactory.java: 177 )
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListen
er(InternalManagedConnectionPool.java: 539 )
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManag
edConnectionPool.java: 228 )
        at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossMa
nagedConnectionPool.java: 417 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectio
nManager2.java: 324 )
        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionMana
ger.java: 301 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionM
anager2.java: 379 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateCon
nection(BaseConnectionManager2.java: 812 )
        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java: 88 )
        at com.bcc.game.reversi.admin.DBReversiAdmin.getApponent(DBReversiAdmin.java: 105 )
        at com.bcc.game.reversi.admin.DBReversiAdmin.sendClient(DBReversiAdmin.java: 169 )
        at com.bcc.game.reversi.ServiceInstance.runStatusReady(ServiceInstance.java: 434 )
        at com.bcc.game.reversi.ServiceInstance.processMessage(ServiceInstance.java: 109 )
        at sun.reflect.NativeMethodAccessorImpl.invoke0( Native  Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39 )
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25 )
        at java.lang.reflect.Method.invoke(Method.java: 324 )
        at org.apache.xmlrpc.Invoker.execute(Invoker.java: 168 )
        at org.apache.xmlrpc.XmlRpcWorker.invokeHandler(XmlRpcWorker.java: 123 )
        at org.apache.xmlrpc.XmlRpcWorker.execute(XmlRpcWorker.java: 185 )
        at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java: 151 )
        at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java: 128 )
        at com.bcc.game.reversi.ServiceReversiInstance.doPost(ServiceReversiInstance.java: 65 )
        at javax.servlet.http.HttpServlet.service(HttpServlet.java: 717 )
        at javax.servlet.http.HttpServlet.service(HttpServlet.java: 810 )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 2 
 52 )
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java: 96 )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 2 
 02 )
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 213 )
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 178 )
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java: 17 
 5 )
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java: 74 )
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126 )
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105 )
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 107 )
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 148 )
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 869 )
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11Ba
seProtocol.java: 664 )
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java: 527 )
        at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java: 112 )
        at java.lang.Thread.run(Thread.java: 534 )
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exceptio
n:

** BEGIN NESTED EXCEPTION **

java.lang.NullPointerException

STACKTRACE:

java.lang.NullPointerException
        at com.mysql.jdbc.Connection.checkTransactionIsolationLevel(Connection.java: 1956 )
        at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java: 3807 )
        at com.mysql.jdbc.Connection.createNewIO(Connection.java: 2585 )
        at com.mysql.jdbc.Connection.<init>(Connection.java: 1485 )
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java: 266 )
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(Lo
calManagedConnectionFactory.java: 169 )
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListen
er(InternalManagedConnectionPool.java: 539 )
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManag
edConnectionPool.java: 228 )
        at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossMa
nagedConnectionPool.java: 417 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectio
nManager2.java: 324 )
        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionMana
ger.java: 301 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionM
anager2.java: 379 )
        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateCon
nection(BaseConnectionManager2.java: 812 )
        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java: 88 )
        at com.bcc.game.reversi.admin.DBReversiAdmin.getApponent(DBReversiAdmin.java: 105 )
        at com.bcc.game.reversi.admin.DBReversiAdmin.sendClient(DBReversiAdmin.java: 169 )
        at com.bcc.game.reversi.ServiceInstance.runStatusReady(ServiceInstance.java: 434 )
        at com.bcc.game.reversi.ServiceInstance.processMessage(ServiceInstance.java: 109 )
        at sun.reflect.NativeMethodAccessorImpl.invoke0( Native  Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39 )
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25 )
        at java.lang.reflect.Method.invoke(Method.java: 324 )
        at org.apache.xmlrpc.Invoker.execute(Invoker.java: 168 )
        at org.apache.xmlrpc.XmlRpcWorker.invokeHandler(XmlRpcWorker.java: 123 )
        at org.apache.xmlrpc.XmlRpcWorker.execute(XmlRpcWorker.java: 185 )
        at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java: 151 )
        at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java: 128 )
        at com.bcc.game.reversi.ServiceReversiInstance.doPost(ServiceReversiInstance.java: 65 )
        at javax.servlet.http.HttpServlet.service(HttpServlet.java: 717 )
        at javax.servlet.http.HttpServlet.service(HttpServlet.java: 810 )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 2 
 52 )
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java: 96 )
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 2 
 02 )
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 173 )
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 213 )
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 178 )
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java: 17 
 5 )
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java: 74 )
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 126 )
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105 )
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 107 )
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 148 )
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 869 )
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11Ba
seProtocol.java: 664 )
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java: 527 )
        at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java: 112 )
        at java.lang.Thread.run(Thread.java: 534 )


** END NESTED EXCEPTION **



Last packet sent to the server was  5  ms ago.
        at com.mysql.jdbc.Connection.createNewIO(Connection.java: 2643 )
        at com.mysql.jdbc.Connection.<init>(Connection.java: 1485 )
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java: 266 )
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(Lo
calManagedConnectionFactory.java: 169 )
        ...  42  more
 2007 - 09 - 07   13 : 30 : 20 , 116  ERROR [STDERR] java.lang.NullPointerException
 2007 - 09 - 07   13 : 30 : 20 , 117  ERROR [STDERR]  at com.bcc.game.reversi.admin.DBReversiAdmin.getApponent(DBRevers
iAdmin.java: 125 )
 2007 - 09 - 07   13 : 30 : 20 , 117  ERROR [STDERR]  at com.bcc.game.reversi.admin.DBReversiAdmin.sendClient(DBReversi
Admin.java: 169 )
 2007 - 09 - 07   13 : 30 : 20 , 117  ERROR [STDERR]  at com.bcc.game.reversi.ServiceInstance.runStatusReady(ServiceIns
tance.java: 434 )
 2007 - 09 - 07   13 : 30 : 20 , 117  ERROR [STDERR]  at com.bcc.game.reversi.ServiceInstance.processMessage(ServiceIns
tance.java: 109 )
 2007 - 09 - 07   13 : 30 : 20 , 117  ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke0( Native  Method)
:


До этого этот же метод отрабатывается корректно. Что я делаю не так ??

а почему такая хрень может быть при первом запуске ?
Диплою xml описывающий БД , потом war который будет юзать эту Бд , и превеД , при первом обращении вываливается такое же. Или если jboss перезапустить
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
19.09.2007, 20:38:39
    #34812677
грсв из пда
грсв из пда
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
mysql JDBC+JBOSS
герда, а чево ты не хибернейт используешь? или тебе чисто поучиться?
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
Форумы / Java [игнор отключен] [закрыт для гостей] / mysql JDBC+JBOSS / 7 сообщений из 7, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
Польз. соглашение  
Полит. конфиден.  
созд. / загр.: 479ms
Закрыть
start [/forum/topic.php?fid=59&mobile=1&tid=2144567]:
 0ms
get settings:
 9ms
get forum list:
 19ms
check forum access:
 6ms
check topic access:
 6ms
track hit:
 44ms
get topic data:
 14ms
get forum data:
 4ms
get page messages:
 50ms
get tp. blocked users:
 2ms
others: 325ms
total:  479ms
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]