草庐IT

mysql_connection

全部标签

java - 无法创建 PoolableConnectionFactory(Io 异常 : The Network Adapter could not establish the connection)

您好,我在spring应用程序中遇到了上述异常,我正在尝试连接到集群Oracle数据库,但即使我尝试连接到单个实例仍然有相同的异常。bean定义如下:完整的堆栈跟踪是:2012-02-1313:18:45,0841375[main]INFOorg.hibernate.connection.ConnectionProviderFactory-Initializingconnectionprovider:org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider2012-02-1313:18:45,2071498

java - 提供的 java.sql.Connection 对象为空

我正在尝试将jrxml文件导出为pdf,但出现此错误:WARNquery.JRJdbcQueryExecuter-Thesuppliedjava.sql.Connectionobjectisnull.我只得到一个空白的pdf文件..这是我导出为PDF的方法:publicvoidprintReport(ActionEventevent)throwsJRException,IOException{StringreportPath=FacesContext.getCurrentInstance().getExternalContext().getRealPath("/test.jrxml")

java - 如何将 Jdbc4Connection 转换为 PGConnection?

我想像这样使用postgresCopyManager:CopyManagercp=((PGConnection)dataSource.getConnection()).getCopyAPI();当我使用spring-boot时,数据源是org.apache.tomcat.jdbc.pool.DataSource,因此连接是Jdbc4Connection。问题:转换抛出以下错误:java.lang.ClassCastException:com.sun.proxy.$Proxy55cannotbecasttoorg.postgresql.PGConnection此外,当我尝试转换为Jdbc

java - Tomcat : HikariCP issue when deploying two applications with DB connection

我试图在同一个tomcat7实例上部署两个WAR文件(app1.war和app2.war)。我收到此错误:UnabletoregisterMBean[HikariDataSource(HikariPool-0)]withkey'dataSource';nestedexceptionisjavax.management.InstanceAlreadyExistsException:com.zaxxer.hikari:name=dataSource,type=HikariDataSource如果我在tomcat上只部署了一个应用程序,我就不会出现这个错误。有办法解决这个问题吗?

java - JAVA和MYSQL如何删除一条记录(字符串)

我可以成功删除一个整数,但是当我尝试将其设为STRING时,它说“where子句中的未知列itemtodelete但我的ITEMTODELETE是在数据库中声明的字符串而不是整数它不删除字符串多少?下面是我的代码:privatevoidDeleteButtonActionPerformed(java.awt.event.ActionEventevt){intdel=(prompt):if(del==JOptionPane.YES_OPTION){DelCurRec();}}publicvoidDelCurRec(){Stringid=field.getText();StringSQL=

javax.mail.MessagingException : Could not connect to SMTP host?

以下是我发送邮件的代码:importjava.util.Properties;importjavax.mail.Authenticator;importjavax.mail.Message;importjavax.mail.Message.RecipientType;importjavax.mail.MessagingException;importjavax.mail.PasswordAuthentication;importjavax.mail.Session;importjavax.mail.Transport;importjavax.mail.internet.Internet

java.net.SocketException : Network is unreachable: connect 异常

我正在尝试使用此方法从Web服务器下载xml文本文件:staticvoiddownload(Stringurl,StringfileName)throwsIOException{FileWriterxmlWriter;xmlWriter=newFileWriter(fileName);System.out.println("URLtodownloadis:"+url);//hereExceptionisthrown/////////////////////////////////BufferedReaderinputTxtReader=newBufferedReader(newBuff

java - ClassNotFoundException : com. mysql.jdbc.Driver。用于 Web 应用程序的 JDBC MySQL 驱动程序

这个问题在这里已经有了答案:HowtoinstallJDBCdriverinEclipsewebprojectwithoutfacingjava.lang.ClassNotFoundexception(13个答案)关闭7年前。所以我有一个MySQLJDBC驱动程序的.jar文件,它在我的库源文件夹下,我有以下代码:publicstaticConnectiongetConnection()throwsSQLException{Connectionconn=null;try{Class.forName("com.mysql.jdbc.Driver").newInstance();Strin

java - 从 2.6 升级到 3.7 时出现 BIRT JDBCException "Cannot load JDBC Driver class: com.mysql.jdbc.Driver"

我正尝试在我的Tomcat服务器上升级我的birt-viewer的版本,但我似乎在加载JDBC驱动程序时遇到错误:exception.error(1time(s))detail:org.eclipse.birt.report.engine.api.EngineException:Anexceptionoccurredduringprocessing.Pleaseseethefollowingmessagefordetails:Cannotopentheconnectionforthedriver:org.eclipse.birt.report.data.oda.jdbc.org.ecl

java - PreparedStatement 的 "close"与 Connection 的关系?

Javadoc说PreparedStatement的.close()说它..ReleasesthisStatementobject'sdatabaseandJDBCresourcesimmediatelyinsteadofwaitingforthistohappenwhenitisautomaticallyclosed.Itisgenerallygoodpracticetoreleaseresourcesassoonasyouarefinishedwiththemtoavoidtyingupdatabaseresources.CallingthemethodcloseonaStatem