Ao executar o Class.forname ocorre um erro!
Eu fiz uma classe para conectar ao banco de dados dos PostgreSQL 8.3.
Eu estou usando o Eclipse Galileo
Eu coloquei no WebContent\WEB-INF\lib:
os jars:
postresql-8.3.606.jdbc2ee.jar
postresql-8.4.701.jdbc3.jar
postresql-8.4.701.jdbc4.jar
jars do JSTL
Os comandos existentes na classe são os seguintes:
--> Class.forName("org.postgresql.Driver");
--> String nomeUsr = "postgres"
--> String senhaUsr = "postgres"
--> conex = DriverManager.getConnection("jdbc:postgresql://localhost:5432/BDVendas", nomeUsr, senhaUsr);
--> return conex;
Ao executar a linha do Class.forName, ele apresenta um erro, não conseguindo finalizá-la com sucesso.
Apresentando um nome CLASS FILE EDITOR e WebAppLoader.
Que o recurso exigido não está anexado.
Se deseja Anexar o recurso.
Eu imaginei que faltasse algum classe para o acesso ao postgresql, mas como eu inseri as classes de jdbc e não funcionou.... Eu não tenho em mente um outra expectativa ...
Alguém pode me auxiliar por gentileza?
Desde já agradeço,
Régis O Santos.
Eu estou usando o Eclipse Galileo
Eu coloquei no WebContent\WEB-INF\lib:
os jars:
postresql-8.3.606.jdbc2ee.jar
postresql-8.4.701.jdbc3.jar
postresql-8.4.701.jdbc4.jar
jars do JSTL
Os comandos existentes na classe são os seguintes:
--> Class.forName("org.postgresql.Driver");
--> String nomeUsr = "postgres"
--> String senhaUsr = "postgres"
--> conex = DriverManager.getConnection("jdbc:postgresql://localhost:5432/BDVendas", nomeUsr, senhaUsr);
--> return conex;
Ao executar a linha do Class.forName, ele apresenta um erro, não conseguindo finalizá-la com sucesso.
Apresentando um nome CLASS FILE EDITOR e WebAppLoader.
Que o recurso exigido não está anexado.
Se deseja Anexar o recurso.
Eu imaginei que faltasse algum classe para o acesso ao postgresql, mas como eu inseri as classes de jdbc e não funcionou.... Eu não tenho em mente um outra expectativa ...
Alguém pode me auxiliar por gentileza?
Desde já agradeço,
Régis O Santos.
Régis Santos
Curtidas 0
Respostas
Dyego Carmo
13/09/2010
Opa !
Preciso do stack trace completo do erro aqui !
dica: o banco de dados está no ar ?
dica: o banco de dados está no ar ?
GOSTEI 0
Régis Santos
13/09/2010
15/09/2010 08:29:23 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Arquivos de programas\Java\jre1.5.0_11\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:/Arquivos de programas/Java/jre1.5.0_11/bin/client;C:/Arquivos de programas/Java/jre1.5.0_11/bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32\WBEM;C:\Arquivos de programas\SDK\bin
15/09/2010 08:29:24 org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:SistemaVendas' did not find a matching property.
15/09/2010 08:29:24 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8081
15/09/2010 08:29:24 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 2068 ms
15/09/2010 08:29:24 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
15/09/2010 08:29:24 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.29
15/09/2010 08:29:27 com.sun.faces.config.ConfigureListener contextInitialized
INFO: Initializing Mojarra (1.2_12-b01-FCS) for context '/SistemaVendas'
15/09/2010 08:29:29 org.apache.myfaces.webapp.StartupServletContextListener dispatchInitializationEvent
INFO: Checking for plugins:org.apache.myfaces.FACES_INIT_PLUGINS
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.PRETTY_HTML' found, using default value true
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.ALLOW_JAVASCRIPT' found, using default value true
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.RENDER_CLEAR_JAVASCRIPT_FOR_BUTTON' found, using default value false
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.RENDER_HIDDEN_FIELDS_FOR_LINK_PARAMS' found, using default value false
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.SAVE_FORM_SUBMIT_LINK_IE' found, using default value false
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.READONLY_AS_DISABLED_FOR_SELECTS' found, using default value true
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.RENDER_VIEWSTATE_ID' found, using default value true
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.STRICT_XHTML_LINKS' found, using default value true
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getLongInitParameter
INFO: No context init parameter 'org.apache.myfaces.CONFIG_REFRESH_PERIOD' found, using default value 2
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.VIEWSTATE_JAVASCRIPT' found, using default value false
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig createAndInitializeMyFacesConfig
INFO: Tomahawk jar not available. Autoscrolling, DetectJavascript, AddResourceClass and CheckExtensionsFilter are disabled now.
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig createAndInitializeMyFacesConfig
INFO: Starting up Tomahawk on the RI-JSF-Implementation.
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig createAndInitializeMyFacesConfig
INFO: Starting up Tomahawk on the MyFaces-JSF-Implementation
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig createAndInitializeMyFacesConfig
SEVERE: Both MyFaces and the RI are on your classpath. Please make sure to use only one of the two JSF-implementations.
15/09/2010 08:29:30 org.apache.myfaces.config.FacesConfigurator feedStandardConfig
INFO: Reading standard config META-INF/standard-faces-config.xml
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator feedWebAppConfig
INFO: Reading config /WEB-INF/faces-config.xml
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: Starting up MyFaces-package : myfaces-api in version : 1.2.9 from path : file:/C:/Documents%20and%20Settings/Eu%20Regis/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/SistemaVendas/WEB-INF/lib/myfaces-api-1.2.9.jar
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: Starting up MyFaces-package : myfaces-impl in version : 1.2.9 from path : file:/C:/Documents%20and%20Settings/Eu%20Regis/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/SistemaVendas/WEB-INF/lib/myfaces-impl-1.2.9.jar
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : tomahawk not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : tomahawk12 not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : tomahawk-sandbox not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : tomahawk-sandbox12 not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : tomahawk-sandbox15 not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : myfaces-orchestra-core not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : myfaces-orchestra-core12 not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : trinidad-api not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : trinidad-impl not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : tobago not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : commons-el not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : jsp-api not found.
15/09/2010 08:29:31 org.apache.myfaces.shared_impl.util.LocaleUtils toLocale
WARNING: Locale name in faces-config.xml null or empty, setting locale to default locale : pt_BR
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator handleSerialFactory
INFO: Serialization provider : class org.apache.myfaces.shared_impl.util.serial.DefaultSerialFactory
15/09/2010 08:29:32 org.apache.myfaces.webapp.AbstractFacesInitializer initFaces
INFO: ServletContext 'C:\Documents and Settings\Eu Regis\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\SistemaVendas\' initialized.
15/09/2010 08:29:32 org.apache.myfaces.webapp.StartupServletContextListener dispatchInitializationEvent
INFO: Checking for plugins:org.apache.myfaces.FACES_INIT_PLUGINS
15/09/2010 08:29:32 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8081
15/09/2010 08:29:33 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
15/09/2010 08:29:33 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/141 config=null
15/09/2010 08:29:33 org.apache.catalina.startup.Catalina start
INFO: Server startup in 8711 ms
Acima é o CONSOLE DO TomCat no momento do erro!
O erro não é capturado pelo Try ...catch. Ele já cai aqui, conforme abaixo:
Ao tentar executar o comando Class.forName( "org.postgresql.Driver") é apresentado
uma tela informando Class File Editor com as seguintes informações:
The source attachement does not contain for the web file WebAppClassLoader.class
You can change the source attachment by Change Attached bellow.
Changed Attached Source(botão de comando).
Source not Found
É mostrando um longo texto:
// Compiled from WebappClassLoader.java (version 1.5 : 49.0, super bit)
public class org.apache.catalina.loader.WebappClassLoader extends java.net.URLClassLoader implements org.apache.catalina.loader.Reloader, org.apache.catalina.Lifecycle {
// Field descriptor #516 Lorg/apache/juli/logging/Log;
protected static org.apache.juli.logging.Log log;
// Field descriptor #518 Ljava/util/List;
// Signature: Ljava/util/List<Ljava/lang/String;>;
private static final java.util.List JVM_THREAD_GROUP_NAMES;
// Field descriptor #522 Z
public static final boolean ENABLE_CLEAR_REFERENCES;
// Field descriptor #524 [Ljava/lang/String;
protected static final java.lang.String[] triggers;
// Field descriptor #524 [Ljava/lang/String;
protected static final java.lang.String[] packageTriggers;
// Field descriptor #527 Lorg/apache/catalina/util/StringManager;
protected static final org.apache.catalina.util.StringManager sm;
// Field descriptor #522 Z
boolean antiJARLocking;
// Field descriptor #530 Ljavax/naming/directory/DirContext;
protected javax.naming.directory.DirContext resources;
// Field descriptor #532 Ljava/util/HashMap;
protected java.util.HashMap resourceEntries;
// Field descriptor #532 Ljava/util/HashMap;
// Signature: Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/String;>;
protected java.util.HashMap notFoundResources;
// Field descriptor #522 Z
protected boolean delegate;
// Field descriptor #537 J
protected long lastJarAccessed;
// Field descriptor #524 [Ljava/lang/String;
protected java.lang.String[] repositories;
// Field descriptor #540 [Ljava/net/URL;
protected java.net.URL[] repositoryURLs;
// Field descriptor #542 [Ljava/io/File;
protected java.io.File[] files;
// Field descriptor #544 [Ljava/util/jar/JarFile;
protected java.util.jar.JarFile[] jarFiles;
// Field descriptor #542 [Ljava/io/File;
protected java.io.File[] jarRealFiles;
// Field descriptor #547 Ljava/lang/String;
protected java.lang.String jarPath;
// Field descriptor #524 [Ljava/lang/String;
protected java.lang.String[] jarNames;
// Field descriptor #550 [J
protected long[] lastModifiedDates;
// Field descriptor #524 [Ljava/lang/String;
protected java.lang.String[] paths;
// Field descriptor #553 Ljava/util/ArrayList;
protected java.util.ArrayList permissionList;
// Field descriptor #555 Ljava/io/File;
protected java.io.File loaderDir;
// Field descriptor #547 Ljava/lang/String;
protected java.lang.String canonicalLoaderDir;
// Field descriptor #532 Ljava/util/HashMap;
protected java.util.HashMap loaderPC;
// Field descriptor #559 Ljava/lang/SecurityManager;
protected java.lang.SecurityManager securityManager;
// Field descriptor #561 Ljava/lang/ClassLoader;
protected java.lang.ClassLoader parent;
// Field descriptor #561 Ljava/lang/ClassLoader;
protected java.lang.ClassLoader system;
// Field descriptor #522 Z
protected boolean started;
// Field descriptor #522 Z
protected boolean hasExternalRepositories;
// Field descriptor #522 Z
protected boolean searchExternalFirst;
// Field descriptor #522 Z
protected boolean needConvert;
// Field descriptor #568 Ljava/security/Permission;
protected java.security.Permission allPermission;
// Field descriptor #522 Z
private boolean clearReferencesStopThreads;
// Field descriptor #522 Z
private boolean clearReferencesStopTimerThreads;
// Field descriptor #522 Z
private boolean clearReferencesThreadLocals;
// Field descriptor #522 Z
private boolean clearReferencesLogFactoryRelease;
// Field descriptor #547 Ljava/lang/String;
private java.lang.String contextName;
// Method descriptor #575 ()V
// Stack: 4, Locals: 1
public WebappClassLoader();
0 aload_0 [this]
1 iconst_0
2 anewarray java.net.URL [1]
5 invokespecial java.net.URLClassLoader(java.net.URL[]) [2]
8 aload_0 [this]
9 iconst_0
10 putfield org.apache.catalina.loader.WebappClassLoader.antiJARLocking : boolean [3]
13 aload_0 [this]
14 aconst_null
15 putfield org.apache.catalina.loader.WebappClassLoader.resources : javax.naming.directory.DirContext [4]
18 aload_0 [this]
19 new java.util.HashMap [5]
22 dup
23 invokespecial java.util.HashMap() [6]
26 putfield org.apache.catalina.loader.WebappClassLoader.resourceEntries : java.util.HashMap [7]
29 aload_0 [this]
30 new org.apache.catalina.loader.WebappClassLoader$1 [8]
33 dup
34 aload_0 [this]
35 invokespecial org.apache.catalina.loader.WebappClassLoader$1(org.apache.catalina.loader.WebappClassLoader) [9]
38 putfield org.apache.catalina.loader.WebappClassLoader.notFoundResources : java.util.HashMap [10]
41 aload_0 [this]
42 iconst_0
43 putfield org.apache.catalina.loader.WebappClassLoader.delegate : boolean [11]
46 aload_0 [this]
47 lconst_0
48 putfield org.apache.catalina.loader.WebappClassLoader.lastJarAccessed : long [12]
51 aload_0 [this]
52 iconst_0
53 anewarray java.lang.String [13]
56 putfield org.apache.catalina.loader.WebappClassLoader.repositories : java.lang.String[] [14]
59 aload_0 [this]
60 aconst_null
61 putfield org.apache.catalina.loader.WebappClassLoader.repositoryURLs : java.net.URL[] [15]
64 aload_0 [this]
65 iconst_0
66 anewarray java.io.File [16]
69 putfield org.apache.catalina.loader.WebappClassLoader.files : java.io.File[] [17]
72 aload_0 [this]
73 iconst_0
74 anewarray java.util.jar.JarFile [18]
77 putfield org.apache.catalina.loader.WebappClassLoader.jarFiles : java.util.jar.JarFile[] [19]
80 aload_0 [this]
81 iconst_0
82 anewarray java.io.File [16]
85 putfield org.apache.catalina.loader.WebappClassLoader.jarRealFiles : java.io.File[] [20]
88 aload_0 [this]
89 aconst_null
90 putfield org.apache.catalina.loader.WebappClassLoader.jarPath : java.lang.String [21]
93 aload_0 [this]
94 iconst_0
95 anewarray java.lang.String [13]
98 putfield org.apache.catalina.loader.WebappClassLoader.jarNames : java.lang.String[] [22]
101 aload_0 [this]
102 iconst_0
103 newarray long [11]
105 putfield org.apache.catalina.loader.WebappClassLoader.lastModifiedDates : long[] [23]
108 aload_0 [this]
109 iconst_0
110 anewarray java.lang.String [13]
113 putfield org.apache.catalina.loader.WebappClassLoader.paths : java.lang.String[] [24]
116 aload_0 [this]
117 new java.util.ArrayList [25]
120 dup
121 invokespecial java.util.ArrayList() [26]
124 putfield org.apache.catalina.loader.WebappClassLoader.permissionList : java.util.ArrayList [27]
127 aload_0 [this]
128 aconst_null
129 putfield org.apache.catalina.loader.WebappClassLoader.loaderDir : java.io.File [28]
132 aload_0 [this]
133 aconst_null
134 putfield org.apache.catalina.loader.WebappClassLoader.canonicalLoaderDir : java.lang.String [29]
137 aload_0 [this]
138 new java.util.HashMap [5]
141 dup
142 invokespecial java.util.HashMap() [6]
145 putfield org.apache.catalina.loader.WebappClassLoader.loaderPC : java.util.HashMap [30]
148 aload_0 [this]
149 aconst_null
150 putfield org.apache.catalina.loader.WebappClassLoader.securityManager : java.lang.SecurityManager [31]
153 aload_0 [this]
154 aconst_null
155 putfield org.apache.catalina.loader.WebappClassLoader.parent : java.lang.ClassLoader [32]
158 aload_0 [this]
159 aconst_null
160 putfield org.apache.catalina.loader.WebappClassLoader.system : java.lang.ClassLoader [33]
163 aload_0 [this]
164 iconst_0
165 putfield org.apache.catalina.loader.WebappClassLoader.started : boolean [34]
168 aload_0 [this]
169 iconst_0
170 putfield org.apache.catalina.loader.WebappClassLoader.hasExternalRepositories : boolean [35]
173 aload_0 [this]
174 iconst_0
175 putfield org.apache.catalina.loader.WebappClassLoader.searchExternalFirst : boolean [36]
178 aload_0 [this]
179 iconst_0
180 putfield org.apache.catalina.loader.WebappClassLoader.needConvert : boolean [37]
183 aload_0 [this]
No momento que eu executei este código o
banco de dados Nâo estava ABERTO!
Obrigado pela atenção.
Régis.
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Arquivos de programas\Java\jre1.5.0_11\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:/Arquivos de programas/Java/jre1.5.0_11/bin/client;C:/Arquivos de programas/Java/jre1.5.0_11/bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32\WBEM;C:\Arquivos de programas\SDK\bin
15/09/2010 08:29:24 org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:SistemaVendas' did not find a matching property.
15/09/2010 08:29:24 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8081
15/09/2010 08:29:24 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 2068 ms
15/09/2010 08:29:24 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
15/09/2010 08:29:24 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.29
15/09/2010 08:29:27 com.sun.faces.config.ConfigureListener contextInitialized
INFO: Initializing Mojarra (1.2_12-b01-FCS) for context '/SistemaVendas'
15/09/2010 08:29:29 org.apache.myfaces.webapp.StartupServletContextListener dispatchInitializationEvent
INFO: Checking for plugins:org.apache.myfaces.FACES_INIT_PLUGINS
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.PRETTY_HTML' found, using default value true
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.ALLOW_JAVASCRIPT' found, using default value true
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.RENDER_CLEAR_JAVASCRIPT_FOR_BUTTON' found, using default value false
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.RENDER_HIDDEN_FIELDS_FOR_LINK_PARAMS' found, using default value false
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.SAVE_FORM_SUBMIT_LINK_IE' found, using default value false
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.READONLY_AS_DISABLED_FOR_SELECTS' found, using default value true
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.RENDER_VIEWSTATE_ID' found, using default value true
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.STRICT_XHTML_LINKS' found, using default value true
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getLongInitParameter
INFO: No context init parameter 'org.apache.myfaces.CONFIG_REFRESH_PERIOD' found, using default value 2
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig getBooleanInitParameter
INFO: No context init parameter 'org.apache.myfaces.VIEWSTATE_JAVASCRIPT' found, using default value false
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig createAndInitializeMyFacesConfig
INFO: Tomahawk jar not available. Autoscrolling, DetectJavascript, AddResourceClass and CheckExtensionsFilter are disabled now.
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig createAndInitializeMyFacesConfig
INFO: Starting up Tomahawk on the RI-JSF-Implementation.
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig createAndInitializeMyFacesConfig
INFO: Starting up Tomahawk on the MyFaces-JSF-Implementation
15/09/2010 08:29:30 org.apache.myfaces.shared_impl.config.MyfacesConfig createAndInitializeMyFacesConfig
SEVERE: Both MyFaces and the RI are on your classpath. Please make sure to use only one of the two JSF-implementations.
15/09/2010 08:29:30 org.apache.myfaces.config.FacesConfigurator feedStandardConfig
INFO: Reading standard config META-INF/standard-faces-config.xml
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator feedWebAppConfig
INFO: Reading config /WEB-INF/faces-config.xml
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: Starting up MyFaces-package : myfaces-api in version : 1.2.9 from path : file:/C:/Documents%20and%20Settings/Eu%20Regis/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/SistemaVendas/WEB-INF/lib/myfaces-api-1.2.9.jar
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: Starting up MyFaces-package : myfaces-impl in version : 1.2.9 from path : file:/C:/Documents%20and%20Settings/Eu%20Regis/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/SistemaVendas/WEB-INF/lib/myfaces-impl-1.2.9.jar
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : tomahawk not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : tomahawk12 not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : tomahawk-sandbox not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : tomahawk-sandbox12 not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : tomahawk-sandbox15 not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : myfaces-orchestra-core not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : myfaces-orchestra-core12 not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : trinidad-api not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : trinidad-impl not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : tobago not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : commons-el not found.
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator startLib
INFO: MyFaces-package : jsp-api not found.
15/09/2010 08:29:31 org.apache.myfaces.shared_impl.util.LocaleUtils toLocale
WARNING: Locale name in faces-config.xml null or empty, setting locale to default locale : pt_BR
15/09/2010 08:29:31 org.apache.myfaces.config.FacesConfigurator handleSerialFactory
INFO: Serialization provider : class org.apache.myfaces.shared_impl.util.serial.DefaultSerialFactory
15/09/2010 08:29:32 org.apache.myfaces.webapp.AbstractFacesInitializer initFaces
INFO: ServletContext 'C:\Documents and Settings\Eu Regis\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\SistemaVendas\' initialized.
15/09/2010 08:29:32 org.apache.myfaces.webapp.StartupServletContextListener dispatchInitializationEvent
INFO: Checking for plugins:org.apache.myfaces.FACES_INIT_PLUGINS
15/09/2010 08:29:32 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8081
15/09/2010 08:29:33 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
15/09/2010 08:29:33 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/141 config=null
15/09/2010 08:29:33 org.apache.catalina.startup.Catalina start
INFO: Server startup in 8711 ms
Acima é o CONSOLE DO TomCat no momento do erro!
O erro não é capturado pelo Try ...catch. Ele já cai aqui, conforme abaixo:
Ao tentar executar o comando Class.forName( "org.postgresql.Driver") é apresentado
uma tela informando Class File Editor com as seguintes informações:
The source attachement does not contain for the web file WebAppClassLoader.class
You can change the source attachment by Change Attached bellow.
Changed Attached Source(botão de comando).
Source not Found
É mostrando um longo texto:
// Compiled from WebappClassLoader.java (version 1.5 : 49.0, super bit)
public class org.apache.catalina.loader.WebappClassLoader extends java.net.URLClassLoader implements org.apache.catalina.loader.Reloader, org.apache.catalina.Lifecycle {
// Field descriptor #516 Lorg/apache/juli/logging/Log;
protected static org.apache.juli.logging.Log log;
// Field descriptor #518 Ljava/util/List;
// Signature: Ljava/util/List<Ljava/lang/String;>;
private static final java.util.List JVM_THREAD_GROUP_NAMES;
// Field descriptor #522 Z
public static final boolean ENABLE_CLEAR_REFERENCES;
// Field descriptor #524 [Ljava/lang/String;
protected static final java.lang.String[] triggers;
// Field descriptor #524 [Ljava/lang/String;
protected static final java.lang.String[] packageTriggers;
// Field descriptor #527 Lorg/apache/catalina/util/StringManager;
protected static final org.apache.catalina.util.StringManager sm;
// Field descriptor #522 Z
boolean antiJARLocking;
// Field descriptor #530 Ljavax/naming/directory/DirContext;
protected javax.naming.directory.DirContext resources;
// Field descriptor #532 Ljava/util/HashMap;
protected java.util.HashMap resourceEntries;
// Field descriptor #532 Ljava/util/HashMap;
// Signature: Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/String;>;
protected java.util.HashMap notFoundResources;
// Field descriptor #522 Z
protected boolean delegate;
// Field descriptor #537 J
protected long lastJarAccessed;
// Field descriptor #524 [Ljava/lang/String;
protected java.lang.String[] repositories;
// Field descriptor #540 [Ljava/net/URL;
protected java.net.URL[] repositoryURLs;
// Field descriptor #542 [Ljava/io/File;
protected java.io.File[] files;
// Field descriptor #544 [Ljava/util/jar/JarFile;
protected java.util.jar.JarFile[] jarFiles;
// Field descriptor #542 [Ljava/io/File;
protected java.io.File[] jarRealFiles;
// Field descriptor #547 Ljava/lang/String;
protected java.lang.String jarPath;
// Field descriptor #524 [Ljava/lang/String;
protected java.lang.String[] jarNames;
// Field descriptor #550 [J
protected long[] lastModifiedDates;
// Field descriptor #524 [Ljava/lang/String;
protected java.lang.String[] paths;
// Field descriptor #553 Ljava/util/ArrayList;
protected java.util.ArrayList permissionList;
// Field descriptor #555 Ljava/io/File;
protected java.io.File loaderDir;
// Field descriptor #547 Ljava/lang/String;
protected java.lang.String canonicalLoaderDir;
// Field descriptor #532 Ljava/util/HashMap;
protected java.util.HashMap loaderPC;
// Field descriptor #559 Ljava/lang/SecurityManager;
protected java.lang.SecurityManager securityManager;
// Field descriptor #561 Ljava/lang/ClassLoader;
protected java.lang.ClassLoader parent;
// Field descriptor #561 Ljava/lang/ClassLoader;
protected java.lang.ClassLoader system;
// Field descriptor #522 Z
protected boolean started;
// Field descriptor #522 Z
protected boolean hasExternalRepositories;
// Field descriptor #522 Z
protected boolean searchExternalFirst;
// Field descriptor #522 Z
protected boolean needConvert;
// Field descriptor #568 Ljava/security/Permission;
protected java.security.Permission allPermission;
// Field descriptor #522 Z
private boolean clearReferencesStopThreads;
// Field descriptor #522 Z
private boolean clearReferencesStopTimerThreads;
// Field descriptor #522 Z
private boolean clearReferencesThreadLocals;
// Field descriptor #522 Z
private boolean clearReferencesLogFactoryRelease;
// Field descriptor #547 Ljava/lang/String;
private java.lang.String contextName;
// Method descriptor #575 ()V
// Stack: 4, Locals: 1
public WebappClassLoader();
0 aload_0 [this]
1 iconst_0
2 anewarray java.net.URL [1]
5 invokespecial java.net.URLClassLoader(java.net.URL[]) [2]
8 aload_0 [this]
9 iconst_0
10 putfield org.apache.catalina.loader.WebappClassLoader.antiJARLocking : boolean [3]
13 aload_0 [this]
14 aconst_null
15 putfield org.apache.catalina.loader.WebappClassLoader.resources : javax.naming.directory.DirContext [4]
18 aload_0 [this]
19 new java.util.HashMap [5]
22 dup
23 invokespecial java.util.HashMap() [6]
26 putfield org.apache.catalina.loader.WebappClassLoader.resourceEntries : java.util.HashMap [7]
29 aload_0 [this]
30 new org.apache.catalina.loader.WebappClassLoader$1 [8]
33 dup
34 aload_0 [this]
35 invokespecial org.apache.catalina.loader.WebappClassLoader$1(org.apache.catalina.loader.WebappClassLoader) [9]
38 putfield org.apache.catalina.loader.WebappClassLoader.notFoundResources : java.util.HashMap [10]
41 aload_0 [this]
42 iconst_0
43 putfield org.apache.catalina.loader.WebappClassLoader.delegate : boolean [11]
46 aload_0 [this]
47 lconst_0
48 putfield org.apache.catalina.loader.WebappClassLoader.lastJarAccessed : long [12]
51 aload_0 [this]
52 iconst_0
53 anewarray java.lang.String [13]
56 putfield org.apache.catalina.loader.WebappClassLoader.repositories : java.lang.String[] [14]
59 aload_0 [this]
60 aconst_null
61 putfield org.apache.catalina.loader.WebappClassLoader.repositoryURLs : java.net.URL[] [15]
64 aload_0 [this]
65 iconst_0
66 anewarray java.io.File [16]
69 putfield org.apache.catalina.loader.WebappClassLoader.files : java.io.File[] [17]
72 aload_0 [this]
73 iconst_0
74 anewarray java.util.jar.JarFile [18]
77 putfield org.apache.catalina.loader.WebappClassLoader.jarFiles : java.util.jar.JarFile[] [19]
80 aload_0 [this]
81 iconst_0
82 anewarray java.io.File [16]
85 putfield org.apache.catalina.loader.WebappClassLoader.jarRealFiles : java.io.File[] [20]
88 aload_0 [this]
89 aconst_null
90 putfield org.apache.catalina.loader.WebappClassLoader.jarPath : java.lang.String [21]
93 aload_0 [this]
94 iconst_0
95 anewarray java.lang.String [13]
98 putfield org.apache.catalina.loader.WebappClassLoader.jarNames : java.lang.String[] [22]
101 aload_0 [this]
102 iconst_0
103 newarray long [11]
105 putfield org.apache.catalina.loader.WebappClassLoader.lastModifiedDates : long[] [23]
108 aload_0 [this]
109 iconst_0
110 anewarray java.lang.String [13]
113 putfield org.apache.catalina.loader.WebappClassLoader.paths : java.lang.String[] [24]
116 aload_0 [this]
117 new java.util.ArrayList [25]
120 dup
121 invokespecial java.util.ArrayList() [26]
124 putfield org.apache.catalina.loader.WebappClassLoader.permissionList : java.util.ArrayList [27]
127 aload_0 [this]
128 aconst_null
129 putfield org.apache.catalina.loader.WebappClassLoader.loaderDir : java.io.File [28]
132 aload_0 [this]
133 aconst_null
134 putfield org.apache.catalina.loader.WebappClassLoader.canonicalLoaderDir : java.lang.String [29]
137 aload_0 [this]
138 new java.util.HashMap [5]
141 dup
142 invokespecial java.util.HashMap() [6]
145 putfield org.apache.catalina.loader.WebappClassLoader.loaderPC : java.util.HashMap [30]
148 aload_0 [this]
149 aconst_null
150 putfield org.apache.catalina.loader.WebappClassLoader.securityManager : java.lang.SecurityManager [31]
153 aload_0 [this]
154 aconst_null
155 putfield org.apache.catalina.loader.WebappClassLoader.parent : java.lang.ClassLoader [32]
158 aload_0 [this]
159 aconst_null
160 putfield org.apache.catalina.loader.WebappClassLoader.system : java.lang.ClassLoader [33]
163 aload_0 [this]
164 iconst_0
165 putfield org.apache.catalina.loader.WebappClassLoader.started : boolean [34]
168 aload_0 [this]
169 iconst_0
170 putfield org.apache.catalina.loader.WebappClassLoader.hasExternalRepositories : boolean [35]
173 aload_0 [this]
174 iconst_0
175 putfield org.apache.catalina.loader.WebappClassLoader.searchExternalFirst : boolean [36]
178 aload_0 [this]
179 iconst_0
180 putfield org.apache.catalina.loader.WebappClassLoader.needConvert : boolean [37]
183 aload_0 [this]
No momento que eu executei este código o
banco de dados Nâo estava ABERTO!
Obrigado pela atenção.
Régis.
GOSTEI 0
Dyego Carmo
13/09/2010
Procure por TODAS AS VERSOES do JDBC driver do postgresql e apague , depois adicione a ULTIMA VERSAO no diretorio LIB DO TOMCAT e restarte e teste.
GOSTEI 0
Régis Santos
13/09/2010
Eu procurei nas libraries do projeto todos os drivers de jdbc do postgresq e depois apaguei todos eles.
Inseri na pasta lib do TomCat a última versão do jdbc do postgresql 8.4(postgresql-8.4-701.jdbc4.jar),
depois substitui por outro drive do postgresql(postgresql-8.3-606.jdbc2ee.jar), mas em ambos casos o problema persistiu!
A situação da minha lib está como esta especificada a seguir:
Apache Tomcat v6.0
anottations-api.jar
catalina-ant.jar
catalina-ha.jar
catalina-tribes.jar
catalina.jar
el-api.jar
jasper-el.jar
jasper-jdt.jar
jasper.jar
jsp-api.jar
postgresql-8.4-701.jdbc4.jar
servlet-api.jar
tomcat-coyote.jar
tomcat-dbcp.jar
tomcat-i8n-es.jar
tomcat-i18n-fr.jar
tomcat-i18n-ja.jar
JRE System
rt.jar
jsse.jar
jce.jar
dnsns.jar
sunjce_provider.jar
sunpkcs11.jar
JSF 1.2)(Apace Myfaces JSF Core -1.1.2.9)
commons-beanutils-1.7.0.jar
commons-codec-1.3.jar
commons-collections-3.2.jar
commons-digester-1.8.jar
commons-dicovery-0.4.jar
commmons-loggin-1.1.jar
myfaces-api-1.2.9.jar
myfaces-impl-1.2.9.jar
Web App Libraries
jsf-api.jar
jsf-impl.jar
jstl.jar
standard.jar
Espero ajudá-lo com estas informações,
muito obrigado.
Régis.
Inseri na pasta lib do TomCat a última versão do jdbc do postgresql 8.4(postgresql-8.4-701.jdbc4.jar),
depois substitui por outro drive do postgresql(postgresql-8.3-606.jdbc2ee.jar), mas em ambos casos o problema persistiu!
A situação da minha lib está como esta especificada a seguir:
Apache Tomcat v6.0
anottations-api.jar
catalina-ant.jar
catalina-ha.jar
catalina-tribes.jar
catalina.jar
el-api.jar
jasper-el.jar
jasper-jdt.jar
jasper.jar
jsp-api.jar
postgresql-8.4-701.jdbc4.jar
servlet-api.jar
tomcat-coyote.jar
tomcat-dbcp.jar
tomcat-i8n-es.jar
tomcat-i18n-fr.jar
tomcat-i18n-ja.jar
JRE System
rt.jar
jsse.jar
jce.jar
dnsns.jar
sunjce_provider.jar
sunpkcs11.jar
JSF 1.2)(Apace Myfaces JSF Core -1.1.2.9)
commons-beanutils-1.7.0.jar
commons-codec-1.3.jar
commons-collections-3.2.jar
commons-digester-1.8.jar
commons-dicovery-0.4.jar
commmons-loggin-1.1.jar
myfaces-api-1.2.9.jar
myfaces-impl-1.2.9.jar
Web App Libraries
jsf-api.jar
jsf-impl.jar
jstl.jar
standard.jar
Espero ajudá-lo com estas informações,
muito obrigado.
Régis.
GOSTEI 0
Dyego Carmo
13/09/2010
JDBC 4.0 não necessita mais do ClassForName... retire esta linha e tente novamente.
GOSTEI 0
Régis Santos
13/09/2010
Eu detectei quando estava apresentando o erro. Ao tentar rodar no modo DEBUG apresentava-se erro na linha onde estava o código Class.forName(...), mas quando executando no modo NORMAL sem depuração alguma, o programa executava normalmente, sem apresentar problema algum ao acessar o banco de dados.
Dyego, muito obrigado pela sua ajuda.
Dyego, muito obrigado pela sua ajuda.
GOSTEI 0