java.sql.SQLException: No suitable driver
Jon
19 de Febrero del 2008
Hola, estoy trabajando ahora con bases de datos, y tengo un problema al crear el objeto Connection, evidentemente no puedo hacer ninguna operacion con la bbdd porque no se me conecta a ella.
He estado leyendo en foros, y he encontrado a mucha gente con este error, pero no he visto muchas soluciones, si alguien me puede ayudar se lo agradeceria muxisimo, un saludo.
La excepcion es la siguiente ...
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]------- Next action: TTPruebaJDBC_1201175894919.Java1
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::peekContext()
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::onEvent() finished. Current element is : Java1
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::onEvent() current element is: Java1 onEvent() will be called
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]>>>>>>> Enter action: TTPruebaJDBC_1201175894919.Java1
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] INFO system.tss-generated.TTPruebaJDBC : [6][TTPruebaJDBC]###URLconnection: jdbc:timesten:direct:dsn=ttprueba##
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] INFO system.tss-generated.TTPruebaJDBC : [6][TTPruebaJDBC]###UserNameconnection: Jon##
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] INFO system.tss-generated.TTPruebaJDBC : [6][TTPruebaJDBC]###Passwordconnection: ##
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] ERROR system.tss-generated.TTPruebaJDBC : [6]Throwable caught: java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.jnetx.generated.TTPruebaJDBC_1201175894919.Java1Action.getConnection(Java1Action.java:103)
at com.jnetx.generated.TTPruebaJDBC_1201175894919.Java1Action.processEvent(Java1Action.java:37)
at com.jnetx.generated.TTPruebaJDBC_1201175894919.TTPruebaJDBCAbstractAction.syncOnEvent(TTPruebaJDBCAbstractAction.java:50)
at com.jnetx.generated.TTPruebaJDBC_1201175894919.TTPruebaJDBCJava1AbstractAction.onEvent(TTPruebaJDBCJava1AbstractAction.java:15)
at com.jnetx.tss.sm.TssSmAction.onEvent(TssSmAction.java:49)
at com.jnetx.sm.impl.AbstractSmSession.elementOnEvent(AbstractSmSession.java:669)
at com.jnetx.sm.impl.SmStackedSession.doOnEvent(SmStackedSession.java:131)
at com.jnetx.sm.impl.AbstractSmSession.onEvent(AbstractSmSession.java:425)
at com.jnetx.tss.sm.SmSbbBase.processEvent(SmSbbBase.java:203)
at com.jnetx.generated.TTPruebaJDBC_1201175894919.TTPruebaJDBCSbb.onCallEventTypeOriginatingServiceCode(TTPruebaJDBCSbb.java:97)
at p1203415269031$.TTPruebaJDBCSbbComponentInfo$2.invoke(TTPruebaJDBCSbbComponentInfo.java:224)
at com.jnetx.slee.standalone.container.DefaultSbbObjectHelper.invokeEventHandler(DefaultSbbObjectHelper.java:111)
at p1203415269031$.TTPruebaJDBCSbbSbbObjectStub.invokeEventHandler(TTPruebaJDBCSbbComponentInfo.java:524)
at com.jnetx.slee.core.container.SbbComponentContainerBase.methodInvokeEventHandler(SbbComponentContainerBase.java:257)
at com.jnetx.slee.core.container.SbbContainerInterceptorSupportHelper.interceptInvokeEventHandler(SbbContainerInterceptorSupportHelper.java:178)
at com.jnetx.slee.core.container.SbbComponentContainerBase.invokeEventHandler(SbbComponentContainerBase.java:190)
at com.jnetx.slee.core.container.SbbEntityBase.onEvent(SbbEntityBase.java:211)
at com.jnetx.slee.core.container.SbbEntityBase.onEvent(SbbEntityBase.java:205)
at com.jnetx.slee.standalone.er.DefaultDispatcherStrategy.defaultDeliverToAttached(DefaultDispatcherStrategy.java:250)
at com.jnetx.slee.standalone.er.DefaultDispatcherStrategy.deliverToAttached(DefaultDispatcherStrategy.java:149)
at com.jnetx.slee.standalone.er.DefaultDispatcherStrategy.doRouteEvent(DefaultDispatcherStrategy.java:108)
at com.jnetx.slee.standalone.er.DefaultDispatcherStrategy.routeEvent(DefaultDispatcherStrategy.java:97)
at com.jnetx.slee.standalone.er.EventRouterDispatcher.processEvent(EventRouterDispatcher.java:161)
at com.jnetx.slee.standalone.er.EventRouterEngineImpl.doRun(EventRouterEngineImpl.java:108)
at com.jnetx.slee.standalone.er.EventRouterEngine.run(EventRouterEngine.java:97)
at java.lang.Thread.run(Thread.java:595)
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]<<<<<<< Exit action: TTPruebaJDBC_1201175894919.Java1
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]------- Next action: null
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::peekContext()
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::onEvent() finished. Current element is : <current element is null>
2008-02-19 11:01:47,796 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::peekContext()
2008-02-19 11:01:47,796 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::popContext()
2008-02-19 11:01:47,796 [Router-Engine-Thread-3] ERROR system.tss-generated.TTPruebaJDBC : [6]Unexpected output while processing event [event name = com.jnetx.se.cc.ra.mpcc.events.ReportNotificationEvent.ORIGINATING_SERVICE_CODE[1]] [event = ReportNotificationEvent{legs=[{ResourceActivity:id=3000001}], info=CallNotificationInfo{callAppInfo=CallAppInfo{callAppAdditionalAddress=null, callAppAlertingMechanism=-1, callAppBearerService=-1, callAppGenericInfo=null, networkAccessType=-1, callAppOriginalDestinationAddress=null, callAppPartyCategory=0, callAppPresentationAddress=SignalingAddress{ plan = _P_ADDRESS_PLAN_E164, addrString = 700, name = 20103, presentation = _P_ADDRESS_PRESENTATION_ALLOWED, screening = _P_ADDRESS_SCREENING_NETWORK, subAddressString = *}, callAppRedirectingAddress=null, callAppTeleService=-1, callHighProbabilityCompletion=-1}, callEventInfo=CallEventInfo{callEventTime=Tue Feb 19 11:01:47 CET 2008, callEventType=5, callMonitorMode=0, additionalCallEventInfo=CallAdditionalEventInfo{calledAddress=SignalingAddress{ plan = _P_ADDRESS_PLAN_E164, addrString = 600, name = 0211, presentation = _P_ADDRESS_PRESENTATION_UNDEFINED, screening = _P_ADDRESS_SCREENING_UNDEFINED, subAddressString = *}, collectedAddress=null, forwardAddress=null, originatingReleaseCause=0, originatingServiceCode=CallServiceCode{serviceCodeValue= , serviceCodeType=1}, callEventType=5, terminatingReleaseCause=0, terminatingServiceCode=null, additionalInfo=[SERVICE_KEY=40] [APPLICATION_CONTEXT=[B@b9f649] [EVENT_TYPE_BCSM=2] [TCAP_ORIGINATION_TRANSACTION_ID=[B@26cb0f] [CALLED_PARTY_NUMBER=[0=2] [1=1] [2=1] [3=600] ] [CALLING_PARTY_NUMBER=[0=2] [1=0] [2=1] [3=0] [4=3] [5=700] ] [CALLING_PARTY_CATEGORY=[0=0] ] [MSC_ADDRESS=[0=0] [1=0] [2=] ] [SCCP_CALLING_PARTY_ADDRESS=[0=1] [1=1] [2=146] [3=[B@79ff89] [4=4] [5=[B@177a8c0] [6=0] [7=7] [8=2] [9=0] ] [SCCP_CALLED_PARTY_ADDRESS=[0=1] [1=1] [2=147] [3=[B@e7ee9f] [4=4] [5=[B@e31cad] [6=0] [7=7] [8=2] [9=0] ] }}, callReportScope=CallNotificationReportScope{destinationAddress=SignalingAddress{ plan = _P_ADDRESS_PLAN_E164, addrString = 600, name = 0211, presentation = _P_ADDRESS_PRESENTATION_UNDEFINED, screening = _P_ADDRESS_SCREENING_UNDEFINED, subAddressString = *}, originatingAddress=SignalingAddress{ plan = _P_ADDRESS_PLAN_E164, addrString = 700, name = 20103, presentation = _P_ADDRESS_PRESENTATION_ALLOWED, screening = _P_ADDRESS_SCREENING_NETWORK, subAddressString = *}}}, assignmentId=824415495}] [current element name = TTPruebaJDBC_1201175894919.<current context is null>]
2008-02-19 11:01:47,796 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSess
He estado leyendo en foros, y he encontrado a mucha gente con este error, pero no he visto muchas soluciones, si alguien me puede ayudar se lo agradeceria muxisimo, un saludo.
La excepcion es la siguiente ...
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]------- Next action: TTPruebaJDBC_1201175894919.Java1
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::peekContext()
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::onEvent() finished. Current element is : Java1
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::onEvent() current element is: Java1 onEvent() will be called
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]>>>>>>> Enter action: TTPruebaJDBC_1201175894919.Java1
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] INFO system.tss-generated.TTPruebaJDBC : [6][TTPruebaJDBC]###URLconnection: jdbc:timesten:direct:dsn=ttprueba##
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] INFO system.tss-generated.TTPruebaJDBC : [6][TTPruebaJDBC]###UserNameconnection: Jon##
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] INFO system.tss-generated.TTPruebaJDBC : [6][TTPruebaJDBC]###Passwordconnection: ##
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] ERROR system.tss-generated.TTPruebaJDBC : [6]Throwable caught: java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.jnetx.generated.TTPruebaJDBC_1201175894919.Java1Action.getConnection(Java1Action.java:103)
at com.jnetx.generated.TTPruebaJDBC_1201175894919.Java1Action.processEvent(Java1Action.java:37)
at com.jnetx.generated.TTPruebaJDBC_1201175894919.TTPruebaJDBCAbstractAction.syncOnEvent(TTPruebaJDBCAbstractAction.java:50)
at com.jnetx.generated.TTPruebaJDBC_1201175894919.TTPruebaJDBCJava1AbstractAction.onEvent(TTPruebaJDBCJava1AbstractAction.java:15)
at com.jnetx.tss.sm.TssSmAction.onEvent(TssSmAction.java:49)
at com.jnetx.sm.impl.AbstractSmSession.elementOnEvent(AbstractSmSession.java:669)
at com.jnetx.sm.impl.SmStackedSession.doOnEvent(SmStackedSession.java:131)
at com.jnetx.sm.impl.AbstractSmSession.onEvent(AbstractSmSession.java:425)
at com.jnetx.tss.sm.SmSbbBase.processEvent(SmSbbBase.java:203)
at com.jnetx.generated.TTPruebaJDBC_1201175894919.TTPruebaJDBCSbb.onCallEventTypeOriginatingServiceCode(TTPruebaJDBCSbb.java:97)
at p1203415269031$.TTPruebaJDBCSbbComponentInfo$2.invoke(TTPruebaJDBCSbbComponentInfo.java:224)
at com.jnetx.slee.standalone.container.DefaultSbbObjectHelper.invokeEventHandler(DefaultSbbObjectHelper.java:111)
at p1203415269031$.TTPruebaJDBCSbbSbbObjectStub.invokeEventHandler(TTPruebaJDBCSbbComponentInfo.java:524)
at com.jnetx.slee.core.container.SbbComponentContainerBase.methodInvokeEventHandler(SbbComponentContainerBase.java:257)
at com.jnetx.slee.core.container.SbbContainerInterceptorSupportHelper.interceptInvokeEventHandler(SbbContainerInterceptorSupportHelper.java:178)
at com.jnetx.slee.core.container.SbbComponentContainerBase.invokeEventHandler(SbbComponentContainerBase.java:190)
at com.jnetx.slee.core.container.SbbEntityBase.onEvent(SbbEntityBase.java:211)
at com.jnetx.slee.core.container.SbbEntityBase.onEvent(SbbEntityBase.java:205)
at com.jnetx.slee.standalone.er.DefaultDispatcherStrategy.defaultDeliverToAttached(DefaultDispatcherStrategy.java:250)
at com.jnetx.slee.standalone.er.DefaultDispatcherStrategy.deliverToAttached(DefaultDispatcherStrategy.java:149)
at com.jnetx.slee.standalone.er.DefaultDispatcherStrategy.doRouteEvent(DefaultDispatcherStrategy.java:108)
at com.jnetx.slee.standalone.er.DefaultDispatcherStrategy.routeEvent(DefaultDispatcherStrategy.java:97)
at com.jnetx.slee.standalone.er.EventRouterDispatcher.processEvent(EventRouterDispatcher.java:161)
at com.jnetx.slee.standalone.er.EventRouterEngineImpl.doRun(EventRouterEngineImpl.java:108)
at com.jnetx.slee.standalone.er.EventRouterEngine.run(EventRouterEngine.java:97)
at java.lang.Thread.run(Thread.java:595)
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]<<<<<<< Exit action: TTPruebaJDBC_1201175894919.Java1
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]------- Next action: null
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::peekContext()
2008-02-19 11:01:47,781 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::onEvent() finished. Current element is : <current element is null>
2008-02-19 11:01:47,796 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::peekContext()
2008-02-19 11:01:47,796 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSession::popContext()
2008-02-19 11:01:47,796 [Router-Engine-Thread-3] ERROR system.tss-generated.TTPruebaJDBC : [6]Unexpected output while processing event [event name = com.jnetx.se.cc.ra.mpcc.events.ReportNotificationEvent.ORIGINATING_SERVICE_CODE[1]] [event = ReportNotificationEvent{legs=[{ResourceActivity:id=3000001}], info=CallNotificationInfo{callAppInfo=CallAppInfo{callAppAdditionalAddress=null, callAppAlertingMechanism=-1, callAppBearerService=-1, callAppGenericInfo=null, networkAccessType=-1, callAppOriginalDestinationAddress=null, callAppPartyCategory=0, callAppPresentationAddress=SignalingAddress{ plan = _P_ADDRESS_PLAN_E164, addrString = 700, name = 20103, presentation = _P_ADDRESS_PRESENTATION_ALLOWED, screening = _P_ADDRESS_SCREENING_NETWORK, subAddressString = *}, callAppRedirectingAddress=null, callAppTeleService=-1, callHighProbabilityCompletion=-1}, callEventInfo=CallEventInfo{callEventTime=Tue Feb 19 11:01:47 CET 2008, callEventType=5, callMonitorMode=0, additionalCallEventInfo=CallAdditionalEventInfo{calledAddress=SignalingAddress{ plan = _P_ADDRESS_PLAN_E164, addrString = 600, name = 0211, presentation = _P_ADDRESS_PRESENTATION_UNDEFINED, screening = _P_ADDRESS_SCREENING_UNDEFINED, subAddressString = *}, collectedAddress=null, forwardAddress=null, originatingReleaseCause=0, originatingServiceCode=CallServiceCode{serviceCodeValue= , serviceCodeType=1}, callEventType=5, terminatingReleaseCause=0, terminatingServiceCode=null, additionalInfo=[SERVICE_KEY=40] [APPLICATION_CONTEXT=[B@b9f649] [EVENT_TYPE_BCSM=2] [TCAP_ORIGINATION_TRANSACTION_ID=[B@26cb0f] [CALLED_PARTY_NUMBER=[0=2] [1=1] [2=1] [3=600] ] [CALLING_PARTY_NUMBER=[0=2] [1=0] [2=1] [3=0] [4=3] [5=700] ] [CALLING_PARTY_CATEGORY=[0=0] ] [MSC_ADDRESS=[0=0] [1=0] [2=] ] [SCCP_CALLING_PARTY_ADDRESS=[0=1] [1=1] [2=146] [3=[B@79ff89] [4=4] [5=[B@177a8c0] [6=0] [7=7] [8=2] [9=0] ] [SCCP_CALLED_PARTY_ADDRESS=[0=1] [1=1] [2=147] [3=[B@e7ee9f] [4=4] [5=[B@e31cad] [6=0] [7=7] [8=2] [9=0] ] }}, callReportScope=CallNotificationReportScope{destinationAddress=SignalingAddress{ plan = _P_ADDRESS_PLAN_E164, addrString = 600, name = 0211, presentation = _P_ADDRESS_PRESENTATION_UNDEFINED, screening = _P_ADDRESS_SCREENING_UNDEFINED, subAddressString = *}, originatingAddress=SignalingAddress{ plan = _P_ADDRESS_PLAN_E164, addrString = 700, name = 20103, presentation = _P_ADDRESS_PRESENTATION_ALLOWED, screening = _P_ADDRESS_SCREENING_NETWORK, subAddressString = *}}}, assignmentId=824415495}] [current element name = TTPruebaJDBC_1201175894919.<current context is null>]
2008-02-19 11:01:47,796 [Router-Engine-Thread-3] DEBUG system.tss-generated.TTPruebaJDBC : [6]TssSmSess