ReSQL.ru
     
powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Мобильная версия    Контакт    Правила    FAQ    Помощь
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр
Форумы / Java [игнор отключен] [закрыт для гостей] / mysql JDBC+JBOSS
7 сообщений из 7, страница 1 из 1
mysql JDBC+JBOSS
    #34784346
GerdaS
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
GerdaS
Гость
работает всё боле мение стабильно, во время 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:46:06
| Ответить | Цитировать | Написать  
mysql JDBC+JBOSS
    #34784381
Kachalov
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Kachalov
Участник
авторThrowable while attempting to get a new connection: null
- пул вернул "мертвое" соединение (MySQL следит за неиспользуемыми соединениями и закрывает их по достижении времени заданного в настройках). Решается настройками пула типа connectiontimeout, и т. п. в зависимости от того что за пул.
...
Рейтинг: 0 / 0
07.09.2007, 13:53:42
| Ответить | Цитировать | Написать  
mysql JDBC+JBOSS
    #34784436
GerdaS
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
GerdaS
Гость
Kachalov авторThrowable while attempting to get a new connection: null
- пул вернул "мертвое" соединение (MySQL следит за неиспользуемыми соединениями и закрывает их по достижении времени заданного в настройках). Решается настройками пула типа connectiontimeout, и т. п. в зависимости от того что за пул.

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

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

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

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

- либо отрегулируйте настройки пула установив время жизни соединения в пуле меньшим чем время жизни неактивного соединения в MySQL, либо измените настройки MySQL увеличив время жизни соединения (что не есть гуд), либо используйте другой - более "умный" пул.
спасибо
...
Рейтинг: 0 / 0
07.09.2007, 15:50:49
| Ответить | Цитировать | Написать  
mysql JDBC+JBOSS
    #34810326
Gog66
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Gog66
Гость
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, 10:51:48
| Ответить | Цитировать | Написать  
mysql JDBC+JBOSS
    #34812677
грсв из пда
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
грсв из пда
Гость
герда, а чево ты не хибернейт используешь? или тебе чисто поучиться?
...
Рейтинг: 0 / 0
19.09.2007, 20:38:39
| Ответить | Цитировать | Написать  
7 сообщений из 7, страница 1 из 1
Форумы / Java [игнор отключен] [закрыт для гостей] / mysql JDBC+JBOSS
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
Польз. соглашение   Полит. конфиден.  
NoSQL.ru       Кролег: Проекты, Новости, Чат       РЕД ФОРУМ       Фотоальбом: Участники, Встречи
Закрыть
start [/forum/search_topic.php?author=Mapk13&author_mode=last_posts&do_search=1]:
 0ms
get settings:
 18ms
get forum list:
 28ms
get settings:
 12ms
get forum list:
 19ms
check forum access:
 6ms
check topic access:
 6ms
track hit:
 79ms
get topic data:
 22ms
get forum data:
 5ms
get page messages:
 127ms
get tp. blocked users:
 3ms
others: 737ms
total:  1062ms
созд. / загр.: 1062ms
x
x
Закрыть


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