Bonjour,
Dans le cadre de mes cours je cherche à me connecter à une base de donnée Informix j'ai donc récupéré le jar informix-sqli et voici mon code :
package paqIHM;
import java.sql.*;
public class ConnectIFX {
static String connURL;
Connection conn;
Statement stmt;
//**********************************************/
public void connectToDBServer(String connect)
{
try
{
/*enregistrer le informix-jdbc driver*/
Class.forName("com.informix.jdbc.IfxDriver").newInstance();
/*se connecter au serveur base de données*/
conn = DriverManager.getConnection(connect);
stmt = conn.createStatement();
String requete = "SELECT toto.tata FROM toto where toto.titi = **********";
ResultSet rs = stmt.executeQuery (requete);
while (rs.next())
{
System.out.print(rs.next());
}
Mais lorsque je le lance il me renvoi cette erreur :
IWAV0048I Java Bean paqIHM.ConnectIFX started with null constructor
java.sql.SQLException: Database not selected yet.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:348)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3000)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3310)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2263)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2183)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1310)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1283)
at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:219)
at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:815)
at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:146)
at paqIHM.ConnectIFX.connectToDBServer(ConnectIFX.java:39)
at paqIHM.ConnectIFX.<init>(ConnectIFX.java:21)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.eclipse.ve.internal.java.vce.launcher.remotevm.JavaBeansLauncher.main(JavaBeansLauncher.java:86)
Database not selected yet....Driver Failed
Je ne sais pas trop ou désigner la BDD à attaquer...