Examples of MysqlDataSource

com.mysql.jdbc.jdbc2.optional.MysqlDataSource
A JNDI DataSource for a Mysql JDBC connection @author Mark Matthews
uk.org.whoami.authme.datasource.MySQLDataSource

Examples of com.mysql.jdbc.jdbc2.optional.MysqlDataSource

      return l_artifact_ids;
  }
  
  public static Artifact getArtifact(long artifact_id)
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      Artifact l_artifact = null;
      
      
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement();  


        
      ResultSet s = l_stat.executeQuery("select artifact_id, group_artifact_id, status_id, category_id, artifact_group_id," +
          " resolution_id, priority, submitted_by, assigned_to, from_unixtime(open_date) as open_date, from_unixtime(close_date) as close_date, " +

View Full Code Here

Examples of com.mysql.jdbc.jdbc2.optional.MysqlDataSource

    m_revision_user_id = mRevisionUserId;
  }
  
  public static LinkedList<CVS_revision> getRevisions(long modul_id, Date begin, Date end)
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      LinkedList<CVS_revision> l_revisions = new LinkedList<CVS_revision>();
      
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement();  


        String str ="select revision_id, revision_modul_id, from_unixtime(revision_date) revision_date, revision_author_name, revision_user_id "+
        " from cvs_revision where revision_modul_id = " + modul_id + " and from_unixtime(revision_date) > '" +df.format(begin) 
        + "' and from_unixtime(revision_date) < '"+ df.format(end) +"' and revision_user_id <> 0";

View Full Code Here

Examples of com.mysql.jdbc.jdbc2.optional.MysqlDataSource

    m_name=name;
  }
  
  public static LinkedList<Long> getGroupArtifactIDsByGroupID(long group_id)
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      LinkedList<Long> l_group_artifact_ids = new LinkedList<Long>();
      
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement();  


        
      ResultSet s = l_stat.executeQuery("select group_artifact_id from artifact_group_list where group_id = " + group_id);

View Full Code Here

Examples of com.mysql.jdbc.jdbc2.optional.MysqlDataSource

  private long group_id = 0;
  private String group_name = null;
  
  public static Hashtable <Long, String> getall_by_id_name()
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      Hashtable <Long, String> l_id_names = new Hashtable<Long, String>();
      
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement();  


        
      ResultSet s = l_stat.executeQuery("select group_id, group_name from groups");

View Full Code Here

Examples of com.mysql.jdbc.jdbc2.optional.MysqlDataSource

  private final static DateFormat df = new SimpleDateFormat("yyyy-MM-dd");


    
    public static LinkedList<Long> getModules (Date i_von, Date i_bis, long i_modul_group_id)
    {
      MysqlDataSource l_ds = DBAccess.ReturnDataSource();
        Connection l_con = null;
        Statement l_stat = null;
        
      LinkedList<Long> modul_ids = new LinkedList<Long>();
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement();  
  
        
      ResultSet s = l_stat.executeQuery("select modul_id from cvs_modul where modul_id in (select distinct(revision_modul_id)  from cvs_revision where from_unixtime(revision_date) > '" + 
          df.format(i_von) + "' and from_unixtime(revision_date) < '" + df.format(i_bis) + "') and modul_group_id = " + i_modul_group_id);

View Full Code Here

Examples of com.mysql.jdbc.jdbc2.optional.MysqlDataSource

    m_body = body;
  }
  
  public static LinkedList<ArtifactMessage> getArtifactMessages(long artifact_id, Date begin, Date end)
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      LinkedList<ArtifactMessage> l_artifacts = new LinkedList<ArtifactMessage>();
      
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement();  


        
      ResultSet s = l_stat.executeQuery("select id, artifact_id, submitted_by, from_unixtime(adddate) as adddate, body from artifact_message where artifact_id = " + artifact_id 
          + " and from_unixtime(adddate) > '"+ df.format(begin) + "' and from_unixtime(adddate) < '" + df.format(end) + "'");

View Full Code Here

Examples of com.mysql.jdbc.jdbc2.optional.MysqlDataSource

    m_submitted_by = submitted_by;
    m_adddate = adddate;
  }
  public static LinkedList<ArtifactMessage> getArtifactMessages(long artifact_id)
  {
    MysqlDataSource l_ds = DBAccess.ReturnDataSource();
      Connection l_con = null;
      Statement l_stat = null;
      LinkedList<ArtifactMessage> l_artifact_ids = new LinkedList<ArtifactMessage>();
      
      try
      {
        l_con = l_ds.getConnection();
      l_stat = l_con.createStatement();  


        
      ResultSet s = l_stat.executeQuery("select id, artifact_id, submitted_by, from_unixtime(adddate) as adddate, body from artifact_message where artifact_id = " + artifact_id);

View Full Code Here

Examples of com.mysql.jdbc.jdbc2.optional.MysqlDataSource

   * due to Reference containing RefAddrs with null content.
   * 
   * @throws Exception if the test fails
   */
  public void testBug16791() throws Exception {
    MysqlDataSource myDs = new MysqlDataSource();
    myDs.setUrl(dbUrl);
    Reference asRef = myDs.getReference();
    System.out.println(asRef);
    
    removeFromRef(asRef, "port");
    removeFromRef(asRef, NonRegisteringDriver.USER_PROPERTY_KEY);
    removeFromRef(asRef, NonRegisteringDriver.PASSWORD_PROPERTY_KEY);

View Full Code Here

Examples of com.mysql.jdbc.jdbc2.optional.MysqlDataSource

    assertEquals("Connect timeout spec'd by URL didn't take", nonDefaultConnectTimeout, configuredConnectTimeout);
    assertFalse("Connect timeout spec'd by URL didn't take", defaultConnectTimeout == configuredConnectTimeout);
  }


  public void testBug42267() throws Exception {
    MysqlDataSource ds = new MysqlDataSource();
    ds.setUrl(dbUrl);
    Connection conn = ds.getConnection();
    String query = "select 1,2,345";
    PreparedStatement ps = conn.prepareStatement(query);
    String psString = ps.toString();
    assertTrue("String representation of wrapped ps should contain query string", psString.endsWith(": " + query));
    ps.close();

View Full Code Here

Examples of com.mysql.jdbc.jdbc2.optional.MysqlDataSource

   * expect them to be.
   * 
   * @throws Exception if the test fails.
   */
  public void testBug19169() throws Exception {
    MysqlDataSource toSerialize = new MysqlDataSource();
    toSerialize.setZeroDateTimeBehavior("convertToNull");
    
    boolean testBooleanFlag = !toSerialize.getAllowLoadLocalInfile();
    toSerialize.setAllowLoadLocalInfile(testBooleanFlag);
    
    int testIntFlag = toSerialize.getBlobSendChunkSize() + 1;
    toSerialize.setBlobSendChunkSize(String.valueOf(testIntFlag));
    
    ByteArrayOutputStream bOut = new ByteArrayOutputStream();
    ObjectOutputStream objOut = new ObjectOutputStream(bOut);
    objOut.writeObject(toSerialize);
    objOut.flush();
    
    ObjectInputStream objIn = new ObjectInputStream(new ByteArrayInputStream(bOut.toByteArray()));
    
    MysqlDataSource thawedDs = (MysqlDataSource)objIn.readObject();
    
    assertEquals("convertToNull", thawedDs.getZeroDateTimeBehavior());
    assertEquals(testBooleanFlag, thawedDs.getAllowLoadLocalInfile());
    assertEquals(testIntFlag, thawedDs.getBlobSendChunkSize());
  }

View Full Code Here

0 1 2 3

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.