com.genexus.db.driver.GXDBMSas400 Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of gxclassR Show documentation
Core classes for the runtime used by Java and Android apps generated with GeneXus
There is a newer version: 4.7.3
package com.genexus.db.driver;

import java.lang.reflect.Method;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;

import com.genexus.CommonUtil;

public class GXDBMSas400 implements GXDBMS
{	
	private boolean useCharInDate = true;
	private DataSource dataSource;
	public void setDataSource(DataSource dataSource)
	{
		this.dataSource = dataSource;
		useCharInDate = !dataSource.getAS400DateType().equalsIgnoreCase("Date");
	}

	public boolean isAlive(GXConnection con)
	{
		try
		{
			serverDateTime(con);
		}
		catch (SQLException e)
		{	
			return false;
		}

		return true;
	}

	public ResultSet executeQuery(PreparedStatement stmt, boolean hold) throws SQLException
	{
		return stmt.executeQuery();
	}

	public int executeUpdate(PreparedStatement stmt) throws SQLException
	{
		return stmt.executeUpdate();
	}

	public boolean execute(PreparedStatement stmt) throws SQLException
	{
		return stmt.execute();
	}

	public int[] executeBatch(Statement stmt) throws SQLException
	{
		return stmt.executeBatch();
	}

	public boolean DataTruncation(SQLException e)
	{
		return (e.getErrorCode() == 01004 );
	}

	public boolean ReferentialIntegrity(SQLException e)
	{
		return false;
	}

	public boolean EndOfFile(SQLException e)
	{
		return (e.getErrorCode() == 100);
	}
	public boolean DuplicateKeyValue(SQLException e)
	{
		return (e.getErrorCode() == -803);
	}
	public boolean ObjectLocked(SQLException e)
	{
		return (e.getErrorCode() == -913);
	}
	public boolean ObjectNotFound(SQLException e)
 	{
		// Porque est� el -913 ac�? Esto implica que si hago el LOCK TABLE no cancele si est� en uso...
		// Por ahora lo dejo porque es bastante inofensivo (el error da despues), pero habria que
		// ver porque est�.
		return (e.getErrorCode() == -204 || MaskedDatabaseAlreadyExists(e) || e.getErrorCode() == -913 || e.getErrorCode() == 7905);
	}
	public java.util.Date nullDate()
	{
		return CommonUtil.ymdhmsToT_noYL(1, 1, 1, 0, 0, 0);
	}

	public boolean MaskedFileNotFound(SQLException e)
	{
		return (e.getErrorCode() == -204);
	}	

	public boolean MaskedDatabaseAlreadyExists(SQLException e)
	{
		return (e.getErrorCode() == -601);
	}	
	
	public boolean useDateTimeInDate()
	{
		return false;
	}

	public boolean useCharInDate()
	{
		return useCharInDate;
	}

	private static String ibmDrivers = "com.ibm.";
	private boolean inReorg = false;
	private String dbName = "";

	public void setDatabaseName(String dbName)
	{
		this.dbName = dbName;
	}
	public String getDatabaseName()
	{
		return this.dbName;
	}	
	public void setInReorg()
	{
		inReorg = true;		
	}

	public void setConnectionProperties(java.util.Properties props)
	{
		if	(dataSource.jdbcDriver.startsWith(ibmDrivers))
		{
			//Si el string de conexion no dice nada del date format se lo pongo en iso
			if (dataSource.jdbcUrl.indexOf("date format") == -1)
			{
				props.put("date format", "iso");
			}
			props.put("naming", "system");
			props.put("extended dynamic", "true");
			props.put("package", dataSource.getAS400Package());
			//props.put("package cache", "true");

			if	(com.genexus.ApplicationContext.getInstance().getReorganization())
			//if	(inReorg)
			{
				props.put("libraries", "*LIBL " +  dataSource.jdbcAS400Lib);
//				props.put("libraries", dbName);
//				System.out.println(" LIB " + dbName);
			}
			else
			{
				// Esto es para que no de el error de 'libraries not added to the list'
				if	(dataSource.jdbcAS400Lib.indexOf(dbName) >= 0)
				{
					props.put("libraries", "*LIBL " + dataSource.jdbcAS400Lib);
				}
				else
				{
					props.put("libraries", dbName + " " + "*LIBL " + dataSource.jdbcAS400Lib);
				}
			}

		}
	}

	public void onConnection(GXConnection con) throws SQLException
	{
		/* Al momento de realizar la conexi�n con el AS/400 es necesario ejecutar 
		   en forma inmediata las sentencias "CREATE TABLE QTEMP/GX (C CHAR)" y 
		   "INSERT INTO QTEMP/GX (C) VALUES ('1')". Esta tabla es temporaria y 
		   �nica por conexi�n (caracter�sticas de la biblioteca QTEMP del AS/400). 
		
		try
		{
			Statement s1 = con.createStatement();
			s1.executeUpdate("CREATE TABLE QTEMP/GX (C CHAR)");
			s1.close();

			Statement s2 = con.createStatement();
			s2.executeUpdate("INSERT INTO QTEMP/GX (C) VALUES ('1')");
			s2.close();
		}
		catch (SQLException e)
		{
		}
		*/
	}

	private static boolean serverTimeProcedureCreated = false;	
	public java.util.Date serverDateTime(GXConnection con) throws SQLException
	{
		boolean uncommitedChanges = con.getUncommitedChanges();

		try
		{
			if	(!serverTimeProcedureCreated)
			{
				Statement stmt = con.createStatement();

				try
				{
					stmt.executeUpdate("CREATE PROCEDURE QWCCVTDT (IN CHAR(10), IN CHAR(17), IN CHAR(10), INOUT CHAR(17), INOUT CHARACTER(1)) (EXTERNAL NAME QSYS/QWCCVTDT GENERAL)");
				}
				catch (SQLException sqlException)
				{
					// Ignoro cualquier error. Si me tenia que dar, me va a dar un error en alguno de
					// los siguientes.
				}
				finally 
				{
					// Esto lo hago tanto si da error como no, dado que no tiene sentido volver a hacerlo.
					serverTimeProcedureCreated = true;
					if	(stmt != null)
					{
						try
						{
							stmt.close();
						}
						catch (SQLException e)
						{
						}
					}
				}
			}

			CallableStatement cstmt = con.getCallableStatement("_serverDT", "CALL QWCCVTDT (?,?,?,?,?)");

		    cstmt.registerOutParameter( 4 , Types.CHAR);
		    cstmt.registerOutParameter( 5 , Types.CHAR);

			cstmt.setString(1, "*CURRENT");
			cstmt.setString(2, " ");
			cstmt.setString(3, "*YYMD");
			cstmt.setString(4, "");
			cstmt.setString(5, "");

			cstmt.execute();

			if	(!uncommitedChanges)
			{
				con.setCommitedChanges();
			}

			String result = cstmt.getString(4);
			// Indico que la sentencia no esta en uso
			// Esto antes se hacia automaticamente en el execute del GXCallableStatement 
			// pero desde el 20/04/05 no se hace m�s alli
			((GXCallableStatement)cstmt).setNotInUse(); 
			
			return CommonUtil.ymdhmsToT_noYL(result);
		}
		catch (SQLException e)
		{							 
			con.setError();
			throw e;
		}
	}
	
	public String serverVersion(GXConnection con) throws SQLException
	{
		return "";		
	}	
	
	public String connectionPhysicalId(GXConnection con)
	{
		try
		{
			Class c = Class.forName("com.ibm.as400.access.AS400JDBCConnection");
			Method m = c.getMethod("getServerJobIdentifier", (Class[])null);
			return (String)m.invoke(con.getJDBCConnection(), (Object[])null);
		}
		catch(Exception e)
		{
			System.out.println(e);
			return "";
		}
	}	

	public boolean getSupportsAutocommit()
	{
		return true;
	}								   

	public void commit(Connection con) throws SQLException
	{
		con.commit();
	}

	public void rollback(Connection con) throws SQLException
	{
		con.rollback();
	}
	
	public boolean useReadOnlyConnections()
	{
		return false;
	}

	public boolean ignoreConnectionError(SQLException e)
	{
		return false;
//		return (GXSQLCODE == 1301);
	}
        
        public boolean rePrepareStatement(SQLException e)
        {
            return false;
        }

	public boolean getSupportsQueryTimeout()
	{
		return true;
	}

	public boolean useStreamsInNullLongVarchar()
	{
		return false;
	}

	public boolean useStreamsInLongVarchar()
	{
		return false;
	}
	
	public int getId()
	{
		return DBMS_AS400;
	}
        public int getLockRetryCount(int lockRetryCount, int waitRecord){
          return lockRetryCount;
        }
		
	public boolean connectionClosed(SQLException e)
	{
		return (e.getSQLState() == "08S01");
	}	
}