Bonjour,
je tente de me connecter à une base Oracle 9.2.0.6 depuis Struts via JDBC.
Dans mon struts-config, voici ce que j'ai défini :
Or, quand j'accède à une action utilisant le datasource, je tombe sur une exception :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12 <data-sources> <data-source type="oracle.jdbc.pool.OracleDataSource"> <set-property property ="driverClass" value="oracle.jdbc.driver.OracleDriver" /> <set-property property ="key" value="ORACLE_BDD" /> <set-property property="description" value="oracle database connection"/> <set-property property="maxCount" value="8"/> <set-property property="minCount" value="2"/> <set-property property="user" value="SYS"/> <set-property property="password" value="*****"/> <set-property property="url" value="jdbc:oracle:thin:@127.0.0.1:1521:SYS"/> </data-source> </data-sources>
Donc à priori l'url n'est pas valide :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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 17:38:09,834 ERROR [[/eConge_struts]] action: Connection.process java.sql.SQLException: L'URL Oracle indiquée n'est pas valide: OracleDataSource.makeURL at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:269) at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:1234) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:184) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:156) at com.deb.struts.actions.DbTestAction.execute(DbTestAction.java:27) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Unknown Source)
jdbc:oracle:thin:@127.0.0.1:1521:SYS
Pourtant je ne vois pas de problème particulier...
Partager